SQL for Database Construction To update an SQL view, the DBMS must be able to associate the column(s) to be updated with: a particular column in a particular underlying table. a particular row in a particular underlying table. None of these a particular column in a particular row. a particular column in a particular underlying table. a particular row in a particular underlying table. None of these a particular column in a particular row. 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 A updatable view has its own data. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What SQL structure is used to limit column values of a table? The CHECK constraint The VALUE constraint The LIMIT constraint None of these The CHECK constraint The VALUE constraint The LIMIT constraint None of these ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL statement to create a view is: INSERT VIEW MAKE VIEW SELECT VIEW CREATE VIEW INSERT VIEW MAKE VIEW SELECT VIEW CREATE VIEW ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is an SQL virtual table that is constructed from other tables? Just another table A relation A view Query results Just another table A relation A view Query results ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS