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 Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain: FROM GROUP BY WHERE ORDER BY FROM GROUP BY WHERE ORDER BY ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction What is an SQL virtual table that is constructed from other tables? Just another table A relation A view Query results Just another table A relation A view Query results ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction The SQL statement to create a view is: SELECT VIEW CREATE VIEW MAKE VIEW INSERT VIEW SELECT VIEW CREATE VIEW MAKE VIEW INSERT VIEW ANSWER DOWNLOAD EXAMIANS APP
SQL for Database Construction When a foreign key column is created without a corresponding foreign key constraint, we have created a "casual relationship" between the two tables. False True False True 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. pseudofile trigger stored procedure None of these pseudofile trigger stored procedure None of these ANSWER DOWNLOAD EXAMIANS APP