SQL for Database Construction SQL statements can be embedded in triggers, stored procedures, and program code. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL ALTER statement can be used to: add rows to the table. change the table data. delete rows from the table. change the table structure. add rows to the table. change the table data. delete rows from the table. change the table structure. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A ________ is a program that performs some common action on database data and that is stored in the database. stored procedure trigger pseudofile None of these stored procedure trigger pseudofile None of these ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction SQL has a JOIN ON syntax that can be used to create inner joins and outer joins. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is not an advantage of stored procedures? Code sharing Increased network traffic SQL can be optimized Greater security Code sharing Increased network traffic SQL can be optimized Greater security ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction SQL Server does not support the BEFORE trigger. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS