SQL for Database Construction What SQL structure is used to limit column values of a table? The LIMIT constraint None of these The VALUE constraint The CHECK constraint The LIMIT constraint None of these The VALUE constraint The CHECK constraint ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL ALTER statement can be used to: change the table structure. change the table data. delete rows from the table. add rows to the table. change the table structure. change the table data. delete rows from the table. add rows to the table. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Views can be used to show the results of computed columns. True False True False 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 The SQL MAKE TABLE command is used to construct tables, define columns, define column constraints and create relationships. 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
EXAMIANS