Question 1 :
The SQL statement used to create a view is CREATE VIEW.
Question 2 :
The SQL MAKE TABLE command is used to construct tables, define columns, define column constraints and create relationships.
Question 3 :
SQL has a JOIN ON syntax that can be used to create inner joins and outer joins.
Question 4 :
Standard SQL-92 views are constructed from SQL SELECT statements that do not contain the GROUP BY clause.
Question 5 :
The SQL CHECK constraint is fully defined by the SQL-92 standard, and is consistently implemented by all DBMS vendors.
Question 6 :
SQL Server does not support the BEFORE trigger.
Question 7 :
A updatable view has its own data.
Question 8 :
The SQL DELETE statement is used to delete both the table structure and table data.
Question 9 :
Common types of SQL CHECK constraints include range checks and limiting columns values.
Question 10 :
If any required (NOT NULL) columns are missing from the view, the view cannot be used for inserting new data.
Question 11 :
When a foreign key column is created without a corresponding foreign key constraint, we have created a "casual relationship" between the two tables.
Question 12 :
Views can be used to show the results of computed columns.
Question 13 :
A benefit of using a stored procedure is that it can be distributed to client computers.
Question 14 :
A trigger is a stored program that is attached to a database.
Question 15 :
A stored procedure is a program that performs some common action on database data and is stored in the database.
Question 16 :
A SQL view is a virtual table that is constructed from other tables or views.
Question 17 :
There are three SQL data modification operations: insert, modify and delete.
Question 18 :
SQL statements can be embedded in triggers, stored procedures, and program code.
Question 19 :
A view that contains a computed column can be easily updated.
Question 20 :
Three types of triggers are: BEFORE, AFTER and EXCEPTION.