SQL for Database Construction If any required (NOT NULL) columns are missing from the view, the view cannot be used for inserting new data. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is an SQL virtual table that is constructed from other tables? Just another table Query results A relation A view Just another table Query results A relation A view ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What SQL structure is used to limit column values of a table? The LIMIT constraint The CHECK constraint None of these The VALUE constraint The LIMIT constraint The CHECK constraint None of these The VALUE constraint ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL ALTER statement can be used to: change the table data. change the table structure. delete rows from the table. add rows to the table. change the table data. change the table structure. delete rows from the table. add rows to the table. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction SQL statements can be embedded in triggers, stored procedures, and program code. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Which of the following is an SQL trigger supported by Oracle? AFTER BEFORE INSTEAD OF All of these AFTER BEFORE INSTEAD OF All of these ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS