SQL for Database Construction For what purposes are views used? To hide columns only 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 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 What is an advantage of placing computations in SQL views? To ensure that the results are consistent. To save users from having to write an expression. None of these To accomplish both of the above. To ensure that the results are consistent. To save users from having to write an expression. None of these To accomplish both of the above. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL ALTER statement can be used to: change the table data. change the table structure. add rows to the table. delete rows from the table. change the table data. change the table structure. add rows to the table. delete rows from the table. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The DROP TABLE statement: works whether or not referential integrity constraints would be violated. deletes the table structure along with the table data. is not an SQL statement. deletes the table structure only. works whether or not referential integrity constraints would be violated. deletes the table structure along with the table data. is not an SQL statement. deletes the table structure only. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Which is NOT one of the most common types of SQL CHECK constraints? Range checks Comparing one column value to another within the same table System date Lists of values Range checks Comparing one column value to another within the same table System date Lists of values ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS