SQL for Database Construction What is an SQL virtual table that is constructed from other tables? A relation Just another table A view Query results A relation Just another table A view Query results 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
SQL for Database Construction The DROP TABLE statement: deletes the table structure only. deletes the table structure along with the table data. works whether or not referential integrity constraints would be violated. is not an SQL statement. deletes the table structure only. deletes the table structure along with the table data. works whether or not referential integrity constraints would be violated. is not an SQL statement. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction If any required (NOT NULL) columns are missing from the view, the view cannot be used for inserting new 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 command to create a table is: ALTER TABLE CREATE TABLE MAKE TABLE DEFINE TABLE ALTER TABLE CREATE TABLE MAKE TABLE DEFINE TABLE ANSWER DOWNLOAD EXAMIANS APP