SQL for Database Construction Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain: ORDER BY FROM GROUP BY WHERE ORDER BY FROM GROUP BY WHERE ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction For what purposes are views used? To hide rows only To hide columns only All of these To hide complicated SQL statements only To hide rows only To hide columns only All of these To hide complicated SQL statements only ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Views can be used to show the results of computed columns. False True False True ANSWER DOWNLOAD EXAMIANS APP
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 What is not an advantage of stored procedures? Code sharing Greater security SQL can be optimized Increased network traffic Code sharing Greater security SQL can be optimized Increased network traffic ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A SQL view is a virtual table that is constructed from other tables or views. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS