SQL for Database Construction Which of the following is NOT a type of SQL constraint? UNIQUE ALTERNATE KEY FOREIGN KEY PRIMARY KEY UNIQUE ALTERNATE KEY FOREIGN KEY PRIMARY KEY ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A view that contains a computed column can be easily updated. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction When using the SQL INSERT statement: rows can be inserted into a table only one at a time only. rows can be modified according to criteria only. rows can either be inserted into a table one at a time or in groups. rows cannot be copied in mass from one table to another only. rows can be inserted into a table only one at a time only. rows can be modified according to criteria only. rows can either be inserted into a table one at a time or in groups. rows cannot be copied in mass from one table to another only. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL command to create a table is: DEFINE TABLE MAKE TABLE CREATE TABLE ALTER TABLE DEFINE TABLE MAKE TABLE CREATE TABLE ALTER TABLE 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 A ________ is a stored program that is attached to a table or a view. embedded SELECT statement trigger None of these pseudofile embedded SELECT statement trigger None of these pseudofile ANSWER DOWNLOAD EXAMIANS APP