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