SQL for Database Construction Standard SQL-92 views are constructed from SQL SELECT statements that do not contain the GROUP BY clause. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is not an advantage of stored procedures? Increased network traffic Greater security SQL can be optimized Code sharing Increased network traffic Greater security SQL can be optimized Code sharing ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Common types of SQL CHECK constraints include range checks and limiting columns values. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction SQL Server does not support the BEFORE trigger. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A benefit of using a stored procedure is that it can be distributed to client computers. True False True False 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