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 A view that contains a computed column can be easily updated. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Three types of triggers are: BEFORE, AFTER and EXCEPTION. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction When a foreign key column is created without a corresponding foreign key constraint, we have created a "casual relationship" between the two tables. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL ALTER statement can be used to: change the table data. delete rows from the table. change the table structure. add rows to the table. change the table data. delete rows from the table. change the table structure. add rows to the table. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL command to create a table is: MAKE TABLE ALTER TABLE DEFINE TABLE CREATE TABLE MAKE TABLE ALTER TABLE DEFINE TABLE CREATE TABLE ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS