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 The SQL ALTER statement can be used to: 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. delete rows from the table. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction SQL Server does not support the BEFORE trigger. 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? Comparing one column value to another within the same table System date Range checks Lists of values Comparing one column value to another within the same table System date Range checks Lists of values ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Which of the following is NOT a type of SQL constraint? FOREIGN KEY ALTERNATE KEY PRIMARY KEY UNIQUE FOREIGN KEY ALTERNATE KEY PRIMARY KEY UNIQUE ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction SQL views can be used to hide: columns and rows only. both of the above can be hidden by an SQL view. None of these complicated SQL syntax only. columns and rows only. both of the above can be hidden by an SQL view. None of these complicated SQL syntax only. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS