SQL for Database Construction For what purposes are views used? To hide rows only All of these To hide columns only To hide complicated SQL statements only To hide rows only All of these To hide columns only To hide complicated SQL statements only 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 an advantage of placing computations in SQL views? To ensure that the results are consistent. None of these To save users from having to write an expression. To accomplish both of the above. To ensure that the results are consistent. None of these To save users from having to write an expression. To accomplish both of the above. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain: GROUP BY ORDER BY FROM WHERE GROUP BY ORDER BY FROM WHERE ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL DELETE statement is used to delete both the table structure and table data. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Three types of triggers are: BEFORE, AFTER and EXCEPTION. False True False True ANSWER DOWNLOAD EXAMIANS APP