SQL for Database Construction A ________ is a stored program that is attached to a table or a view. embedded SELECT statement pseudofile trigger None of these embedded SELECT statement pseudofile trigger None of these 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 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 A SQL view is a virtual table that is constructed from other tables or views. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction To update an SQL view, the DBMS must be able to associate the column(s) to be updated with: None of these a particular row in a particular underlying table. a particular column in a particular row. a particular column in a particular underlying table. None of these a particular row in a particular underlying table. a particular column in a particular row. a particular column in a particular underlying table. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What SQL structure is used to limit column values of a table? The VALUE constraint None of these The LIMIT constraint The CHECK constraint The VALUE constraint None of these The LIMIT constraint The CHECK constraint ANSWER DOWNLOAD EXAMIANS APP