SQL for Database Construction A ________ is a program that performs some common action on database data and that is stored in the database. trigger pseudofile stored procedure None of these trigger pseudofile stored procedure None of these ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction For what purposes are views used? To hide complicated SQL statements only To hide rows only All of these To hide columns only To hide complicated SQL statements only To hide rows only All of these To hide columns only ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A ________ is a stored program that is attached to a table or a view. pseudofile None of these trigger embedded SELECT statement pseudofile None of these trigger embedded SELECT statement 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 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 SQL has a JOIN ON syntax that can be used to create inner joins and outer joins. False True False True ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS