SQL for Database Construction What is an SQL virtual table that is constructed from other tables? A relation Just another table Query results A view A relation Just another table Query results A view 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 The SQL statement to create a view is: INSERT VIEW SELECT VIEW MAKE VIEW CREATE VIEW INSERT VIEW SELECT VIEW MAKE VIEW CREATE VIEW ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What SQL structure is used to limit column values of a table? None of these The LIMIT constraint The CHECK constraint The VALUE constraint None of these The LIMIT constraint The CHECK constraint The VALUE constraint 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
SQL for Database Construction A view that contains a computed column can be easily updated. False True False True ANSWER DOWNLOAD EXAMIANS APP