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 A ________ is a stored program that is attached to a table or a view. pseudofile trigger embedded SELECT statement None of these pseudofile trigger embedded SELECT statement None of these 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 Which is NOT one of the most common types of SQL CHECK constraints? System date Lists of values Range checks Comparing one column value to another within the same table System date Lists of values Range checks Comparing one column value to another within the same table ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A reason for using an SQL view to hide columns is: to prevent the display of sensitive data only. None of these to accomplish both of the above. to simplify a result only. to prevent the display of sensitive data only. None of these to accomplish both of the above. to simplify a result only. ANSWER DOWNLOAD EXAMIANS APP