SQL for Database Construction What SQL structure is used to limit column values of a table? The VALUE constraint The CHECK constraint The LIMIT constraint None of these The VALUE constraint The CHECK constraint The LIMIT constraint None of these ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is an SQL virtual table that is constructed from other tables? Query results A relation Just another table A view Query results A relation Just another table A view ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Which of the following is NOT a type of SQL constraint? UNIQUE FOREIGN KEY PRIMARY KEY ALTERNATE KEY UNIQUE FOREIGN KEY PRIMARY KEY ALTERNATE KEY 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 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 SQL statements can be embedded in triggers, stored procedures, and program code. True False True False ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS