SQL for Database Construction What is an advantage of placing computations in SQL views? To ensure that the results are consistent. To accomplish both of the above. None of these To save users from having to write an expression. To ensure that the results are consistent. To accomplish both of the above. None of these To save users from having to write an expression. 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 A SQL view is a virtual table that is constructed from other tables or views. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction For what purposes are views used? To hide complicated SQL statements only All of these To hide rows only To hide columns only To hide complicated SQL statements only All of these To hide rows only To hide columns only 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
SQL for Database Construction SQL views can be used to hide: complicated SQL syntax only. columns and rows only. None of these both of the above can be hidden by an SQL view. complicated SQL syntax only. columns and rows only. None of these both of the above can be hidden by an SQL view. ANSWER DOWNLOAD EXAMIANS APP