SQL for Database Construction What is an SQL virtual table that is constructed from other tables? Just another table A relation Query results A view Just another table A relation Query results A view ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is not an advantage of stored procedures? Increased network traffic Code sharing Greater security SQL can be optimized Increased network traffic Code sharing Greater security SQL can be optimized ANSWER DOWNLOAD EXAMIANS APP
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 There are three SQL data modification operations: insert, modify and delete. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL CHECK constraint is fully defined by the SQL-92 standard, and is consistently implemented by all DBMS vendors. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Which of the following is NOT a type of SQL constraint? ALTERNATE KEY UNIQUE FOREIGN KEY PRIMARY KEY ALTERNATE KEY UNIQUE FOREIGN KEY PRIMARY KEY ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS