SQL for Database Construction The SQL command to create a table is: ALTER TABLE CREATE TABLE DEFINE TABLE MAKE TABLE ALTER TABLE CREATE TABLE DEFINE TABLE MAKE TABLE ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The DROP TABLE statement: deletes the table structure only. deletes the table structure along with the table data. works whether or not referential integrity constraints would be violated. is not an SQL statement. deletes the table structure only. deletes the table structure along with the table data. works whether or not referential integrity constraints would be violated. is not an SQL statement. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction To update an SQL view, the DBMS must be able to associate the column(s) to be updated with: a particular column in a particular row. None of these a particular column in a particular underlying table. a particular row in a particular underlying table. a particular column in a particular row. None of these a particular column in a particular underlying table. a particular row in a particular underlying table. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is an advantage of placing computations in SQL views? To save users from having to write an expression. To ensure that the results are consistent. None of these To accomplish both of the above. To save users from having to write an expression. To ensure that the results are consistent. None of these To accomplish both of the above. 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 columns only To hide rows only To hide complicated SQL statements only All of these To hide columns only To hide rows 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
EXAMIANS