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 A reason for using an SQL view to hide columns is: None of these to prevent the display of sensitive data only. to simplify a result only. to accomplish both of the above. None of these to prevent the display of sensitive data only. to simplify a result only. to accomplish both of the above. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction When using the SQL INSERT statement: rows cannot be copied in mass from one table to another only. rows can be inserted into a table only one at a time only. rows can be modified according to criteria only. rows can either be inserted into a table one at a time or in groups. rows cannot be copied in mass from one table to another only. rows can be inserted into a table only one at a time only. rows can be modified according to criteria only. rows can either be inserted into a table one at a time or in groups. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL CHECK constraint is fully defined by the SQL-92 standard, and is consistently implemented by all DBMS vendors. True False True False 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 What is an SQL virtual table that is constructed from other tables? A view A relation Query results Just another table A view A relation Query results Just another table ANSWER DOWNLOAD EXAMIANS APP