Question 1

The UPDATE command cannot be used on a view created with the WITH CHECK OPTION._________________________​

Accepted Answer

A) True 
 B)False

Question 2

____ aren't allowed in the CREATE VIEW command.​

Accepted Answer

A)  ​Arithmetic expressions 
B)  ​ORDER BY clauses 
C)  ​Group functions 
D)  ​GROUP BY clauses 
A)  ​Arithmetic expressions 
B)  ​ORDER BY clauses 
C)  ​Group functions 
D)  ​GROUP BY clauses

Question 3

DML operations cannot be performed on a key-preserved table.​

Accepted Answer

A) True 
 B)False

Question 4

​An ORDER BY clause can be included in a(n)____________________ view to perform "TOP-N" analysis.

Accepted Answer

The answer of ​An ORDER BY clause can be included...

Question 5

​The ____________________ command can be used to permanently remove a view from a database.

Accepted Answer

The answer of ​The ____________________ command can be used to...

Question 6

If you want to create a view based upon a table or tables that do not yet exist,or are currently unavailable (e.g. ,off-line),what keyword can you use to avoid receiving an error message?​

Accepted Answer

A)  ​FORCE 
B)  ​NOERROR 
C)  ​OVERRIDE 
D)  ​none of the above 
A)  ​FORCE 
B)  ​NOERROR 
C)  ​OVERRIDE 
D)  ​none of the above

Question 7

​When a view includes columns from more than one table,updates can only be applied to the table that contains the ____________________ for the view.

Accepted Answer

The answer of ​When a view includes columns from more...

Question 8

DML operations cannot be performed on non key-preserved tables through a complex view._________________________​

Accepted Answer

A) True 
 B)False

Question 9

A(n)view is a database object,but it does not actually store data._________________________​

Accepted Answer

A) True 
 B)False

Question 10

Which type of view is created from the following SQL statement?
CREATE VIEW balancedue
AS SELECT customer#,order#,SUM(quantity*retail)amtdue
FROM customers NATURAL JOIN orders NATURAL JOIN
Orderitems NATURAL JOIN books
GROUP BY customer#,order#;

Accepted Answer

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

Question 11

Rows can be deleted through a simple view as long as the operation does not violate existing constraints and the view was created with the WITH READ ONLY option.​

Accepted Answer

A) True 
 B)False

Question 12

Which of the following types of views cannot include a group function?

Accepted Answer

A)  ​simple view 
B)  ​inline view 
C)  ​complex view 
D)  ​all of the above 
A)  ​simple view 
B)  ​inline view 
C)  ​complex view 
D)  ​all of the above

Question 13

Which of the following statements is incorrect?​

Accepted Answer

A)  ​A view can be created with the CREATE VIEW command. 
B)  ​Views can be modified by using the ALTER VIEW...MODIFY command. 
C)  ​A view cannot be modified; if you need to change it,you must use the CREATE OR REPLACE VIEW keywords. 
D)  ​A view cannot be given the same name as another database object in the same schema. 
A)  ​A view can be created with the CREATE VIEW command. 
B)  ​Views can be modified by using the ALTER VIEW...MODIFY command. 
C)  ​A view cannot be modified; if you need to change it,you must use the CREATE OR REPLACE VIEW keywords. 
D)  ​A view cannot be given the same name as another database object in the same schema.

Question 14

A(n)____ table is the table that contains the primary key the view uses to uniquely identify each record being displayed by the view.​

Accepted Answer

A)  ​non key-preserved 
B)  ​key-preserved 
C)  ​primary 
D)  ​non primary-keyed 
A)  ​non key-preserved 
B)  ​key-preserved 
C)  ​primary 
D)  ​non primary-keyed

Question 15

Rows cannot be deleted from a table through a complex view that is based on a group function._________________________​

Accepted Answer

A) True 
 B)False

Question 16

Which constraint ensures that the data in a view cannot be changed?​

Accepted Answer

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

Question 17

DML operations can be performed on a view created with the DISTINCT keyword.​

Accepted Answer

A) True 
 B)False

Question 18

A(n)simple view can contain a GROUP BY clause._________________________​

Accepted Answer

A) True 
 B)False

Question 19

Which of the following statements about complex views is incorrect?​

Accepted Answer

A)  ​It is created with the same CREATE VIEW command as a simple view. 
B)  ​It retrieves or derives data from one or more tables. 
C)  ​All DML operations can be performed on complex views,just like simple views. 
D)  ​It may contain functions or grouped data. 
A)  ​It is created with the same CREATE VIEW command as a simple view. 
B)  ​It retrieves or derives data from one or more tables. 
C)  ​All DML operations can be performed on complex views,just like simple views. 
D)  ​It may contain functions or grouped data.

Question 20

​A(n)____________________ view is used to replicate data which can be called a snapshot.

Accepted Answer

The answer of ​A(n)____________________ view is used to replicate data...

The UPDATE command cannot be used on a view created with the WITH CHECK OPTION._________________________

____ aren't allowed in the CREATE VIEW command.

DML operations cannot be performed on a key-preserved table.

An ORDER BY clause can be included in a(n)____________________ view to perform "TOP-N" analysis.

The ____________________ command can be used to permanently remove a view from a database.

If you want to create a view based upon a table or tables that do not yet exist,or are currently unavailable (e.g. ,off-line),what keyword can you use to avoid receiving an error message?

When a view includes columns from more than one table,updates can only be applied to the table that contains the ____________________ for the view.

DML operations cannot be performed on non key-preserved tables through a complex view._________________________

A(n)view is a database object,but it does not actually store data._________________________

Which type of view is created from the following SQL statement? CREATE VIEW balancedue AS SELECT customer#,order#,SUM(quantity*retail)amtdue FROM customers NATURAL JOIN orders NATURAL JOIN Orderitems NATURAL JOIN books GROUP BY customer#,order#;

Rows can be deleted through a simple view as long as the operation does not violate existing constraints and the view was created with the WITH READ ONLY option.

Which of the following types of views cannot include a group function?

Which of the following statements is incorrect?

A(n)____ table is the table that contains the primary key the view uses to uniquely identify each record being displayed by the view.

Rows cannot be deleted from a table through a complex view that is based on a group function._________________________

Which constraint ensures that the data in a view cannot be changed?

DML operations can be performed on a view created with the DISTINCT keyword.

A(n)simple view can contain a GROUP BY clause._________________________

Which of the following statements about complex views is incorrect?

A(n)____________________ view is used to replicate data which can be called a snapshot.

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 UPDATE command cannot be used on a view created with the WITH CHECK OPTION._________________________​

____ aren't allowed in the CREATE VIEW command.​

DML operations cannot be performed on a key-preserved table.​

​An ORDER BY clause can be included in a(n)____________________ view to perform "TOP-N" analysis.

​The ____________________ command can be used to permanently remove a view from a database.

If you want to create a view based upon a table or tables that do not yet exist,or are currently unavailable (e.g. ,off-line),what keyword can you use to avoid receiving an error message?​

​When a view includes columns from more than one table,updates can only be applied to the table that contains the ____________________ for the view.

DML operations cannot be performed on non key-preserved tables through a complex view._________________________​

A(n)view is a database object,but it does not actually store data._________________________​

Which type of view is created from the following SQL statement? CREATE VIEW balancedue AS SELECT customer#,order#,SUM(quantity*retail)amtdue FROM customers NATURAL JOIN orders NATURAL JOIN Orderitems NATURAL JOIN books GROUP BY customer#,order#;

Rows can be deleted through a simple view as long as the operation does not violate existing constraints and the view was created with the WITH READ ONLY option.​

Which of the following types of views cannot include a group function?

Which of the following statements is incorrect?​

A(n)____ table is the table that contains the primary key the view uses to uniquely identify each record being displayed by the view.​

Rows cannot be deleted from a table through a complex view that is based on a group function._________________________​

Which constraint ensures that the data in a view cannot be changed?​

DML operations can be performed on a view created with the DISTINCT keyword.​

A(n)simple view can contain a GROUP BY clause._________________________​

Which of the following statements about complex views is incorrect?​

​A(n)____________________ view is used to replicate data which can be called a snapshot.

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 UPDATE command cannot be used on a view created with the WITH CHECK OPTION._________________________

____ aren't allowed in the CREATE VIEW command.

DML operations cannot be performed on a key-preserved table.

An ORDER BY clause can be included in a(n)____________________ view to perform "TOP-N" analysis.

The ____________________ command can be used to permanently remove a view from a database.

If you want to create a view based upon a table or tables that do not yet exist,or are currently unavailable (e.g. ,off-line),what keyword can you use to avoid receiving an error message?

When a view includes columns from more than one table,updates can only be applied to the table that contains the ____________________ for the view.

DML operations cannot be performed on non key-preserved tables through a complex view._________________________

A(n)view is a database object,but it does not actually store data._________________________

Rows can be deleted through a simple view as long as the operation does not violate existing constraints and the view was created with the WITH READ ONLY option.

Which of the following statements is incorrect?

A(n)____ table is the table that contains the primary key the view uses to uniquely identify each record being displayed by the view.

Rows cannot be deleted from a table through a complex view that is based on a group function._________________________

Which constraint ensures that the data in a view cannot be changed?

DML operations can be performed on a view created with the DISTINCT keyword.

A(n)simple view can contain a GROUP BY clause._________________________

Which of the following statements about complex views is incorrect?

A(n)____________________ view is used to replicate data which can be called a snapshot.