SQL for Database Construction Which is NOT one of the most common types of SQL CHECK constraints? Lists of values Comparing one column value to another within the same table Range checks System date Lists of values Comparing one column value to another within the same table Range checks System date ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Which of the following is an SQL trigger supported by Oracle? All of these INSTEAD OF BEFORE AFTER All of these INSTEAD OF BEFORE AFTER ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain: GROUP BY ORDER BY WHERE FROM GROUP BY ORDER BY WHERE FROM ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A reason for using an SQL view to hide columns is: None of these to prevent the display of sensitive data only. to simplify a result only. to accomplish both of the above. None of these to prevent the display of sensitive data only. to simplify a result only. to accomplish both of the above. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL DELETE statement is used to delete both the table structure and table data. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL command to create a table is: DEFINE TABLE MAKE TABLE ALTER TABLE CREATE TABLE DEFINE TABLE MAKE TABLE ALTER TABLE CREATE TABLE ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS