SQL for Database Construction What is an SQL virtual table that is constructed from other tables? A relation Query results Just another table A view A relation Query results Just another table A view 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 reason for using an SQL view to hide columns is: to prevent the display of sensitive data only. to accomplish both of the above. None of these to simplify a result only. to prevent the display of sensitive data only. to accomplish both of the above. None of these to simplify a result only. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction SQL views can be used to hide: both of the above can be hidden by an SQL view. complicated SQL syntax only. None of these columns and rows only. both of the above can be hidden by an SQL view. complicated SQL syntax only. None of these columns and rows only. ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Common types of SQL CHECK constraints include range checks and limiting columns values. False True False True ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction SQL has a JOIN ON syntax that can be used to create inner joins and outer joins. True False True False ANSWER DOWNLOAD EXAMIANS APP