SQL for Database Construction Standard SQL-92 views are constructed from SQL SELECT statements that do not contain the GROUP BY clause. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL statement used to create a view is CREATE VIEW. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A ________ is a program that performs some common action on database data and that is stored in the database. pseudofile None of these trigger stored procedure pseudofile None of these trigger stored procedure 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: None of these a particular column in a particular row. a particular column in a particular underlying table. a particular row in a particular underlying table. None of these a particular column in a particular row. a particular column in a particular underlying table. a particular row in a particular underlying table. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction There are three SQL data modification operations: insert, modify and delete. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Which of the following is an SQL trigger supported by Oracle? AFTER INSTEAD OF All of these BEFORE AFTER INSTEAD OF All of these BEFORE ANSWER DOWNLOAD EXAMIANS APP