SQL for Database Construction Standard SQL-92 views are constructed from SQL SELECT statements that do not contain the GROUP BY clause. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL DELETE statement is used to delete both the table structure and table data. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain: WHERE ORDER BY FROM GROUP BY WHERE ORDER BY FROM GROUP BY ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is an advantage of placing computations in SQL views? To save users from having to write an expression. None of these To accomplish both of the above. To ensure that the results are consistent. To save users from having to write an expression. None of these To accomplish both of the above. To ensure that the results are consistent. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL ALTER statement can be used to: add rows to the table. change the table structure. delete rows from the table. change the table data. add rows to the table. change the table structure. delete rows from the table. change the table data. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL statement to create a view is: INSERT VIEW CREATE VIEW MAKE VIEW SELECT VIEW INSERT VIEW CREATE VIEW MAKE VIEW SELECT VIEW ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS