SQL for Database Construction For what purposes are views used? All of these To hide complicated SQL statements only To hide rows only To hide columns only All of these To hide complicated SQL statements only To hide rows only To hide columns only ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is not an advantage of stored procedures? Greater security SQL can be optimized Increased network traffic Code sharing Greater security SQL can be optimized Increased network traffic Code sharing ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL statement to create a view is: SELECT VIEW MAKE VIEW INSERT VIEW CREATE VIEW SELECT VIEW MAKE VIEW INSERT VIEW CREATE VIEW ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A trigger is a stored program that is attached to a database. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A ________ is a stored program that is attached to a table or a view. embedded SELECT statement trigger None of these pseudofile embedded SELECT statement trigger None of these pseudofile 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. 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 ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS