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
SQL for Database Construction A ________ is a program that performs some common action on database data and that is stored in the database. stored procedure trigger pseudofile None of these stored procedure trigger pseudofile None of these ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL CHECK constraint is fully defined by the SQL-92 standard, and is consistently implemented by all DBMS vendors. False True False True 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 Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain: ORDER BY GROUP BY FROM WHERE ORDER BY GROUP BY FROM WHERE ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL DELETE statement is used to delete both the table structure and table data. True False True False ANSWER DOWNLOAD EXAMIANS APP