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. True False True False 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 Which of the following is NOT a type of SQL constraint? FOREIGN KEY UNIQUE ALTERNATE KEY PRIMARY KEY FOREIGN KEY UNIQUE ALTERNATE KEY PRIMARY KEY ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A updatable view has its own data. 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 What SQL structure is used to limit column values of a table? The CHECK constraint The LIMIT constraint The VALUE constraint None of these The CHECK constraint The LIMIT constraint The VALUE constraint None of these ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS