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
SQL for Database Construction A view that contains a computed column can be easily updated. True False True False 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. True False True False ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A ________ is a program that performs some common action on database data and that is stored in the database. None of these pseudofile trigger stored procedure None of these pseudofile trigger stored procedure ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction A ________ is a stored program that is attached to a table or a view. trigger pseudofile None of these embedded SELECT statement trigger pseudofile None of these embedded SELECT statement ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction Which of the following is NOT a type of SQL constraint? UNIQUE FOREIGN KEY ALTERNATE KEY PRIMARY KEY UNIQUE FOREIGN KEY ALTERNATE KEY PRIMARY KEY ANSWER DOWNLOAD EXAMIANS APP
EXAMIANS