SQL for Database Construction What is an SQL virtual table that is constructed from other tables? Just another table Query results A view A relation Just another table Query results A view A relation ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A ________ is a stored program that is attached to a table or a view. None of these pseudofile trigger embedded SELECT statement None of these pseudofile trigger embedded SELECT statement 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
SQL for Database Construction A reason for using an SQL view to hide columns is: to simplify a result only. to accomplish both of the above. to prevent the display of sensitive data only. None of these to simplify a result only. to accomplish both of the above. to prevent the display of sensitive data only. None of these ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction For what purposes are views used? 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 To hide complicated SQL statements only All of these ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction SQL Server does not support the BEFORE trigger. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS