SQL for Database Construction Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain: WHERE FROM GROUP BY ORDER BY WHERE FROM GROUP BY ORDER BY ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL command to create a table is: ALTER TABLE CREATE TABLE DEFINE TABLE MAKE TABLE ALTER TABLE CREATE TABLE DEFINE TABLE MAKE TABLE ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A updatable view has its own data. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL ALTER statement can be used to: 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. add rows to the table. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is an advantage of placing computations in SQL views? To accomplish both of the above. To ensure that the results are consistent. None of these To save users from having to write an expression. To accomplish both of the above. To ensure that the results are consistent. None of these To save users from having to write an expression. 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