SQL for Database Construction For what purposes are views used? To hide complicated SQL statements only All of these To hide columns only To hide rows only To hide complicated SQL statements only All of these To hide columns only To hide rows only 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 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 The SQL MAKE TABLE command is used to construct tables, define columns, define column constraints and create relationships. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL ALTER statement can be used to: delete rows from the table. add rows to the table. change the table data. change the table structure. delete rows from the table. add rows to the table. change the table data. change the table structure. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL command to create a table is: MAKE TABLE DEFINE TABLE ALTER TABLE CREATE TABLE MAKE TABLE DEFINE TABLE ALTER TABLE CREATE TABLE ANSWER DOWNLOAD EXAMIANS APP