Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain: FROM ORDER BY WHERE GROUP BY TRUE ANSWER : ? YOUR ANSWER : ?
SQL statements can be embedded in triggers, stored procedures, and program code. False True TRUE ANSWER : ? YOUR ANSWER : ?
A SQL view is a virtual table that is constructed from other tables or views. False True TRUE ANSWER : ? YOUR ANSWER : ?
The SQL statement to create a view is: CREATE VIEW SELECT VIEW INSERT VIEW MAKE VIEW TRUE ANSWER : ? YOUR ANSWER : ?
When a foreign key column is created without a corresponding foreign key constraint, we have created a "casual relationship" between the two tables. True False TRUE ANSWER : ? YOUR ANSWER : ?
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 TRUE ANSWER : ? YOUR ANSWER : ?
Standard SQL-92 views are constructed from SQL SELECT statements that do not contain the GROUP BY clause. True False TRUE ANSWER : ? YOUR ANSWER : ?
When using the SQL INSERT statement: rows can either be inserted into a table one at a time or in groups. rows cannot be copied in mass from one table to another only. rows can be modified according to criteria only. rows can be inserted into a table only one at a time only. TRUE ANSWER : ? YOUR ANSWER : ?
The SQL DELETE statement is used to delete both the table structure and table data. False True TRUE ANSWER : ? YOUR ANSWER : ?
A stored procedure is a program that performs some common action on database data and is stored in the database. True False TRUE ANSWER : ? YOUR ANSWER : ?