Question 1

The DELETE operation can be performed through a complex view that contains an arithmetic operation._________________________​

Accepted Answer

A) True 
 B)False

Question 2

Which of the following statements about performing DML operations on complex views is correct?​

Accepted Answer

A)  ​Values cannot be inserted into columns containing date data. 
B)  ​Values cannot be inserted into columns that are based on arithmetic expressions. 
C)  ​Values cannot be inserted into columns containing an ORDER BY clause. 
D)  ​both b and c 
A)  ​Values cannot be inserted into columns containing date data. 
B)  ​Values cannot be inserted into columns that are based on arithmetic expressions. 
C)  ​Values cannot be inserted into columns containing an ORDER BY clause. 
D)  ​both b and c

Question 3

​A(n)____________________ table is a table that does not contain the primary key being used by a complex view to uniquely identify each row displayed by the view.

Accepted Answer

non key-pr

Question 4

Which of the following statements about views is incorrect?​

Accepted Answer

A)  ​Views assist users who do not have the training to issue complex SQL inquiries. 
B)  ​Views restrict users' access to sensitive data. 
C)  ​Views are database objects that actually store data. 
D)  ​A view can be referenced in a SELECT...FROM statement,just like any table. 
A)  ​Views assist users who do not have the training to issue complex SQL inquiries. 
B)  ​Views restrict users' access to sensitive data. 
C)  ​Views are database objects that actually store data. 
D)  ​A view can be referenced in a SELECT...FROM statement,just like any table.

Question 5

A view name must be enclosed in single quotation marks if it is referenced in the FROM clause of a SELECT statement.​

Accepted Answer

A) True 
 B)False

Question 6

The type of view that actually replicates data is called a(n)____ view.​

Accepted Answer

A)  ​simple 
B)  ​complex 
C)  ​inline 
D)  ​materialized 
A)  ​simple 
B)  ​complex 
C)  ​inline 
D)  ​materialized

Question 7

​A view can be created to simplify issuing complex SQL queries.

Accepted Answer

A) True 
 B)False

Question 8

Which of the following options will prevent any DML operations from being performed on the underlying table of a view?​

Accepted Answer

A)  ​WITH READ ONLY 
B)  ​WITH CHECK ONLY 
C)  ​WITH CHECK OPTION 
D)  ​NO WRITE OPTION 
A)  ​WITH READ ONLY 
B)  ​WITH CHECK ONLY 
C)  ​WITH CHECK OPTION 
D)  ​NO WRITE OPTION

Question 9

​Rows cannot be added through a complex view that is based on ____________________ data.

Accepted Answer

The answer of ​Rows cannot be added through a complex...

Question 10

An ORDER BY clause can be used to perform "TOP-N" analysis.​

Accepted Answer

A) True 
 B)False

Question 11

The ____ constraint ensures that any DML operations performed on the view (e.g. ,adding rows,changing data)will not prevent the row from being accessed by the view because it no longer meets the condition in the WHERE clause.​

Accepted Answer

A)  ​ON UPDATE CHECK 
B)  ​WITH CHECK OPTION 
C)  ​WITH READ ONLY 
D)  ​READ-WRITE ONLY 
A)  ​ON UPDATE CHECK 
B)  ​WITH CHECK OPTION 
C)  ​WITH READ ONLY 
D)  ​READ-WRITE ONLY

Question 12

A user can perform a DML operation (add,modify,delete)on a simple view if it does not violate which type of existing constraint on the underlying base table?​

Accepted Answer

A)  ​PRIMARY KEY 
B)  ​WITH CHECK OPTION 
C)  ​UNIQUE 
D)  ​all of the above 
A)  ​PRIMARY KEY 
B)  ​WITH CHECK OPTION 
C)  ​UNIQUE 
D)  ​all of the above

Question 13

A view cannot be given the same name as another database object.​

Accepted Answer

A) True 
 B)False

Question 14

The column names used in the view must be the same names as the column names in the underlying table(s).​

Accepted Answer

A) True 
 B)False

Question 15

If a view was created with the WITH CHECK OPTION constraint,to remove the constraint you will need to ____.​

Accepted Answer

A)  ​use the ALTER VIEW command 
B)  ​re-create the view without the option 
C)  ​rename the view 
D)  ​drop the option 
A)  ​use the ALTER VIEW command 
B)  ​re-create the view without the option 
C)  ​rename the view 
D)  ​drop the option

Question 16

A(n)____________________ is a database object that can be used to access data,but it does not actually store data itself.​

Accepted Answer

The answer of A(n)____________________ is a database object that can...

Question 17

Any DML operation can be performed on a simple view that was not created with the WITH READ ONLY option,unless it violates an existing constraint.​

Accepted Answer

A) True 
 B)False

Question 18

When a query references a view,the query in the view is processed,and the results are treated as a(n)permanent table._________________________

Accepted Answer

A) True 
 B)False

Question 19

​The ____________________ keywords are used to make certain any DML operations do not prevent a row from being accessible to the view after the DML operation is executed.

Accepted Answer

The answer of ​The ____________________ keywords are used to make...

Question 20

FORCE is the default mode for the CREATE VIEW command._________________________​

Accepted Answer

A) True 
 B)False

The DELETE operation can be performed through a complex view that contains an arithmetic operation._________________________

Which of the following statements about performing DML operations on complex views is correct?

A(n)____________________ table is a table that does not contain the primary key being used by a complex view to uniquely identify each row displayed by the view.

Which of the following statements about views is incorrect?

A view name must be enclosed in single quotation marks if it is referenced in the FROM clause of a SELECT statement.

The type of view that actually replicates data is called a(n)____ view.

A view can be created to simplify issuing complex SQL queries.

Which of the following options will prevent any DML operations from being performed on the underlying table of a view?

Rows cannot be added through a complex view that is based on ____________________ data.

An ORDER BY clause can be used to perform "TOP-N" analysis.

The ____ constraint ensures that any DML operations performed on the view (e.g. ,adding rows,changing data)will not prevent the row from being accessed by the view because it no longer meets the condition in the WHERE clause.

A user can perform a DML operation (add,modify,delete)on a simple view if it does not violate which type of existing constraint on the underlying base table?

A view cannot be given the same name as another database object.

The column names used in the view must be the same names as the column names in the underlying table(s).

If a view was created with the WITH CHECK OPTION constraint,to remove the constraint you will need to ____.

A(n)____________________ is a database object that can be used to access data,but it does not actually store data itself.

Any DML operation can be performed on a simple view that was not created with the WITH READ ONLY option,unless it violates an existing constraint.

When a query references a view,the query in the view is processed,and the results are treated as a(n)permanent table._________________________

The ____________________ keywords are used to make certain any DML operations do not prevent a row from being accessible to the view after the DML operation is executed.

FORCE is the default mode for the CREATE VIEW command._________________________

Overview of Database Concepts

Basic SQL Select Statements

Table Creation and Management

Constraints

Data Manipulation and Transaction Control

Additional Database Objects

User Creation and Management

Restricting Rows and Sorting Data

Joining Data From Multiple Tables

Selected Single-Row Functions

Group Functions

Subqueries and Merge Statements

Filters

Exam 13: Views

The DELETE operation can be performed through a complex view that contains an arithmetic operation._________________________​

Which of the following statements about performing DML operations on complex views is correct?​

​A(n)____________________ table is a table that does not contain the primary key being used by a complex view to uniquely identify each row displayed by the view.

Which of the following statements about views is incorrect?​

A view name must be enclosed in single quotation marks if it is referenced in the FROM clause of a SELECT statement.​

The type of view that actually replicates data is called a(n)____ view.​

​A view can be created to simplify issuing complex SQL queries.

Which of the following options will prevent any DML operations from being performed on the underlying table of a view?​

​Rows cannot be added through a complex view that is based on ____________________ data.

An ORDER BY clause can be used to perform "TOP-N" analysis.​

The ____ constraint ensures that any DML operations performed on the view (e.g. ,adding rows,changing data)will not prevent the row from being accessed by the view because it no longer meets the condition in the WHERE clause.​

A user can perform a DML operation (add,modify,delete)on a simple view if it does not violate which type of existing constraint on the underlying base table?​

A view cannot be given the same name as another database object.​

The column names used in the view must be the same names as the column names in the underlying table(s).​

If a view was created with the WITH CHECK OPTION constraint,to remove the constraint you will need to ____.​

A(n)____________________ is a database object that can be used to access data,but it does not actually store data itself.​

Any DML operation can be performed on a simple view that was not created with the WITH READ ONLY option,unless it violates an existing constraint.​

When a query references a view,the query in the view is processed,and the results are treated as a(n)permanent table._________________________

​The ____________________ keywords are used to make certain any DML operations do not prevent a row from being accessible to the view after the DML operation is executed.

FORCE is the default mode for the CREATE VIEW command._________________________​

Overview of Database Concepts

Basic SQL Select Statements

Table Creation and Management

Constraints

Data Manipulation and Transaction Control

Additional Database Objects

User Creation and Management

Restricting Rows and Sorting Data

Joining Data From Multiple Tables

Selected Single-Row Functions

Group Functions

Subqueries and Merge Statements

Filters

The DELETE operation can be performed through a complex view that contains an arithmetic operation._________________________

Which of the following statements about performing DML operations on complex views is correct?

A(n)____________________ table is a table that does not contain the primary key being used by a complex view to uniquely identify each row displayed by the view.

Which of the following statements about views is incorrect?

A view name must be enclosed in single quotation marks if it is referenced in the FROM clause of a SELECT statement.

The type of view that actually replicates data is called a(n)____ view.

A view can be created to simplify issuing complex SQL queries.

Which of the following options will prevent any DML operations from being performed on the underlying table of a view?

Rows cannot be added through a complex view that is based on ____________________ data.

An ORDER BY clause can be used to perform "TOP-N" analysis.

The ____ constraint ensures that any DML operations performed on the view (e.g. ,adding rows,changing data)will not prevent the row from being accessed by the view because it no longer meets the condition in the WHERE clause.

A user can perform a DML operation (add,modify,delete)on a simple view if it does not violate which type of existing constraint on the underlying base table?

A view cannot be given the same name as another database object.

The column names used in the view must be the same names as the column names in the underlying table(s).

If a view was created with the WITH CHECK OPTION constraint,to remove the constraint you will need to ____.

A(n)____________________ is a database object that can be used to access data,but it does not actually store data itself.

Any DML operation can be performed on a simple view that was not created with the WITH READ ONLY option,unless it violates an existing constraint.

The ____________________ keywords are used to make certain any DML operations do not prevent a row from being accessible to the view after the DML operation is executed.

FORCE is the default mode for the CREATE VIEW command._________________________