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