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 Three types of triggers are: BEFORE, AFTER and EXCEPTION. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Which is NOT one of the most common types of SQL CHECK constraints? Range checks System date Comparing one column value to another within the same table Lists of values Range checks System date Comparing one column value to another within the same table Lists of values ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The DROP TABLE statement: works whether or not referential integrity constraints would be violated. is not an SQL statement. deletes the table structure along with the table data. deletes the table structure only. works whether or not referential integrity constraints would be violated. is not an SQL statement. deletes the table structure along with the table data. deletes the table structure only. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Which of the following is an SQL trigger supported by Oracle? INSTEAD OF All of these AFTER BEFORE INSTEAD OF All of these AFTER BEFORE ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A stored procedure is a program that performs some common action on database data and is stored in the database. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS