SQL for Database Construction Which is NOT one of the most common types of SQL CHECK constraints? Comparing one column value to another within the same table Range checks System date Lists of values Comparing one column value to another within the same table Range checks System date Lists of values ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL ALTER statement can be used to: change the table structure. delete rows from the table. add rows to the table. change the table data. change the table structure. delete rows from the table. add rows to the table. change the table data. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Common types of SQL CHECK constraints include range checks and limiting columns values. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Which of the following is NOT a type of SQL constraint? UNIQUE ALTERNATE KEY PRIMARY KEY FOREIGN KEY UNIQUE ALTERNATE KEY PRIMARY KEY FOREIGN KEY ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction SQL Server does not support the BEFORE trigger. 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. True False True False ANSWER DOWNLOAD EXAMIANS APP