SQL for Database Construction A ________ is a program that performs some common action on database data and that is stored in the database. trigger stored procedure pseudofile None of these trigger stored procedure pseudofile None of these ANSWER DOWNLOAD EXAMIANS APP
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 reason for using an SQL view to hide columns is: to simplify a result only. None of these to accomplish both of the above. to prevent the display of sensitive data only. to simplify a result only. None of these to accomplish both of the above. to prevent the display of sensitive data only. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL statement to create a view is: INSERT VIEW CREATE VIEW SELECT VIEW MAKE VIEW INSERT VIEW CREATE VIEW SELECT VIEW MAKE VIEW 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 Standard SQL-92 views are constructed from SQL SELECT statements that do not contain the GROUP BY clause. False True False True ANSWER DOWNLOAD EXAMIANS APP