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 A ________ is a stored program that is attached to a table or a view. embedded SELECT statement None of these trigger pseudofile embedded SELECT statement None of these trigger pseudofile ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL statement to create a view is: CREATE VIEW SELECT VIEW MAKE VIEW INSERT VIEW CREATE VIEW SELECT VIEW MAKE VIEW INSERT VIEW 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 is NOT one of the most common types of SQL CHECK constraints? Lists of values 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 ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction SQL has a JOIN ON syntax that can be used to create inner joins and outer joins. False True False True ANSWER DOWNLOAD EXAMIANS APP