SQL for Database Construction What is an advantage of placing computations in SQL views? To save users from having to write an expression. To accomplish both of the above. To ensure that the results are consistent. None of these To save users from having to write an expression. To accomplish both of the above. To ensure that the results are consistent. None of these ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A ________ is a stored program that is attached to a table or a view. pseudofile trigger None of these embedded SELECT statement pseudofile trigger None of these embedded SELECT statement ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is an SQL virtual table that is constructed from other tables? A view Query results Just another table A relation A view Query results Just another table A relation ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL ALTER statement can be used to: delete rows from the table. 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. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Which of the following is NOT a type of SQL constraint? UNIQUE PRIMARY KEY FOREIGN KEY ALTERNATE KEY UNIQUE PRIMARY KEY FOREIGN KEY ALTERNATE KEY ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction There are three SQL data modification operations: insert, modify and delete. False True False True ANSWER DOWNLOAD EXAMIANS APP