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 What is an SQL virtual table that is constructed from other tables? Query results A view Just another table A relation Query results A view Just another table A relation ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Standard SQL-92 views are constructed from SQL SELECT statements that do not contain the GROUP BY clause. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A trigger is a stored program that is attached to a database. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction SQL views can be used to hide: None of these both of the above can be hidden by an SQL view. columns and rows only. complicated SQL syntax only. None of these both of the above can be hidden by an SQL view. columns and rows only. complicated SQL syntax only. 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
EXAMIANS