SQL for Database Construction Which is NOT one of the most common types of SQL CHECK constraints? System date Lists of values 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 ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A trigger is a stored program that is attached to a database. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction There are three SQL data modification operations: insert, modify and delete. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL ALTER statement can be used to: add rows to the table. delete rows from the table. change the table structure. change the table data. add rows to the table. delete rows from the table. change the table structure. change the table data. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A reason for using an SQL view to hide columns is: to simplify a result only. to accomplish both of the above. None of these to prevent the display of sensitive data only. to simplify a result only. to accomplish both of the above. None of these to prevent the display of sensitive data only. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A stored procedure is a program that performs some common action on database data and is stored in the database. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS