SQL for Database Construction What is an SQL virtual table that is constructed from other tables? A view A relation Just another table Query results A view A relation Just another table Query results 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 Views can be used to show the results of computed columns. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A stored procedure is a program that performs some common action on database data and is stored in the database. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A benefit of using a stored procedure is that it can be distributed to client computers. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is not an advantage of stored procedures? Greater security Code sharing SQL can be optimized Increased network traffic Greater security Code sharing SQL can be optimized Increased network traffic ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS