SQL for Database Construction SQL statements can be embedded in triggers, stored procedures, and program code. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Which is NOT one of the most common types of SQL CHECK constraints? Comparing one column value to another within the same table Range checks System date Lists of values Comparing one column value to another within the same table Range checks System date Lists of values ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Three types of triggers are: BEFORE, AFTER and EXCEPTION. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is not an advantage of stored procedures? Greater security SQL can be optimized Code sharing Increased network traffic Greater security SQL can be optimized Code sharing Increased network traffic ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction SQL Server does not support the BEFORE trigger. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL ALTER statement can be used to: change the table data. delete rows from the table. add rows to the table. change the table structure. change the table data. delete rows from the table. add rows to the table. change the table structure. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS