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 For what purposes are views used? To hide rows only To hide complicated SQL statements only All of these To hide columns only To hide rows only To hide complicated SQL statements only All of these To hide columns only ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL ALTER statement can be used to: change the table data. add rows to the table. change the table structure. delete rows from the table. change the table data. add rows to the table. change the table structure. delete rows from the table. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What SQL structure is used to limit column values of a table? The VALUE constraint The LIMIT constraint The CHECK constraint None of these The VALUE constraint The LIMIT constraint The CHECK constraint None of these ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A view that contains a computed column can be easily updated. 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 Greater security SQL can be optimized Code sharing Increased network traffic Greater security SQL can be optimized ANSWER DOWNLOAD EXAMIANS APP