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 There are three SQL data modification operations: insert, modify and delete. True False True False 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
SQL for Database Construction The SQL statement used to create a view is CREATE VIEW. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction SQL views can be used to hide: None of these both of the above can be hidden by an SQL view. columns and rows only. complicated SQL syntax only. None of these both of the above can be hidden by an SQL view. columns and rows only. complicated SQL syntax only. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is an advantage of placing computations in SQL views? 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. To save users from having to write an expression. ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS