Question 1 of 25
Hints left: 3
Q1
Which of the following is an SQL trigger supported by Oracle?
Q2
What SQL structure is used to limit column values of a table?
Q3
Common types of SQL CHECK constraints include range checks and limiting columns values.
Q4
Which of the following is NOT a type of SQL constraint?
Q5
SQL Server does not support the BEFORE trigger.
Q6
What is an SQL virtual table that is constructed from other tables?
Q7
SQL views can be used to hide:
Q8
What is not an advantage of stored procedures?
Q9
When using the SQL INSERT statement:
Q10
The SQL MAKE TABLE command is used to construct tables, define columns, define column constraints and create relationships.
Q11
The SQL DELETE statement is used to delete both the table structure and table data.
Q12
The SQL statement to create a view is:
Q13
Standard SQL-92 views are constructed from SQL SELECT statements that do not contain the GROUP BY clause.
Q14
What is an advantage of placing computations in SQL views?
Q15
The SQL CHECK constraint is fully defined by the SQL-92 standard, and is consistently implemented by all DBMS vendors.
Q16
The SQL ALTER statement can be used to:
Q17
Views constructed from SQL SELECT statements that conform to the SQL-92 standard may not contain:
Q18
To update an SQL view, the DBMS must be able to associate the column(s) to be updated with:
Q19
Which is NOT one of the most common types of SQL CHECK constraints?
Q20
For what purposes are views used?
Q21
SQL has a JOIN ON syntax that can be used to create inner joins and outer joins.
Q22
A reason for using an SQL view to hide columns is:
Q23
A ________ is a program that performs some common action on database data and that is stored in the database.
Q24
A updatable view has its own data.
Q25
The SQL statement used to create a view is CREATE VIEW.