Question 1

A view based on the contents of one table that uses an expression for one of the columns is considered a(n)____ view.​

Accepted Answer

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

Question 2

A(n)____________________ view can contain group functions.​

Accepted Answer

complex​

Question 3

​An inline view for "TOP-N" analysis is created by sorting data in descending order through the use of the ____________________ clause in the subquery.

Accepted Answer

ORDER BY

Question 4

A(n)existing view cannot be modified._________________________​

Accepted Answer

A) True 
 B)False

Question 5

The OR REPLACE clause is not required if ____.​

Accepted Answer

A)  ​another view does not exist with the same name 
B)  ​the view is not based on a group function 
C)  ​the view does not contain data from more than one table 
D)  ​the CREATE command does not specify the WITH CHECK OPTION option 
A)  ​another view does not exist with the same name 
B)  ​the view is not based on a group function 
C)  ​the view does not contain data from more than one table 
D)  ​the CREATE command does not specify the WITH CHECK OPTION option

Question 6

An inline analysis can be used to find the "Top-N" values._________________________​

Accepted Answer

A) True 
 B)False

Question 7

If a view needs to be modified,it must be re-created using the ____________________ keywords in the CREATE VIEW command.​

Accepted Answer

OR REPLACE

Question 8

Which type of view is created with the following command?
CREATE VIEW OR REPLACE outstanding
AS SELECT customer#,order#,orderdate,shipdate
FROM orders
WHERE shipdate IS NULL
WITH READ ONLY;

Accepted Answer

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

Question 9

"TOP-N" analysis is performed by sorting values in ascending or descending order in an inline view.​

Accepted Answer

A) True 
 B)False

Question 10

Which of the following types of views cannot include a GROUP BY clause?​

Accepted Answer

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

Question 11

Which statement about the view created from the following SQL command is correct,assuming ISBN from the BOOKS table is the primary key used by the view?
CREATE OR REPLACE VIEW prices
AS SELECT isbn,title,cost,retail,retail-cost profit,name
FROM books NATURAL JOIN publisher;

Accepted Answer

A)  ​DML operations can only be performed on the columns belonging to the PUBLISHER table. 
B)  No DML operations are allowed.​ 
C)  ​DML operations are allowed on both the BOOKS and PUBLISHER tables. 
D)  ​DML operations can only be performed on the columns belonging to the BOOKS table. 
A)  ​DML operations can only be performed on the columns belonging to the PUBLISHER table. 
B)  No DML operations are allowed.​ 
C)  ​DML operations are allowed on both the BOOKS and PUBLISHER tables. 
D)  ​DML operations can only be performed on the columns belonging to the BOOKS table.

Question 12

Which of the following describes a type of view that is based on a subquery that retrieves or derives data from one or more tables,and may also contain functions or grouped data?​

Accepted Answer

A)  ​simple view 
B)  ​complex view 
C)  ​inline view 
D)  ​"TOP-N" analysis 
A)  ​simple view 
B)  ​complex view 
C)  ​inline view 
D)  ​"TOP-N" analysis

Question 13

Views can be used to restrict a user's access to sensitive data.

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

key-preser

Question 15

Which type of view is created from the following SQL command?
CREATE OR REPLACE VIEW prices
AS SELECT isbn,title,cost,retail,retail-cost profit,name
FROM books NATURAL JOIN publisher;

Accepted Answer

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

Question 16

Update operations cannot be performed through a complex view that contains an arithmetic expression.​

Accepted Answer

A) True 
 B)False

Question 17

Rows can be added through a complex view that is based upon grouped data.​

Accepted Answer

A) True 
 B)False

Question 18

A view can be dropped or deleted using the DELETE VIEW command._________________________​

Accepted Answer

A) True 
 B)False

Question 19

A complex view can retrieve data from more than one table.​

Accepted Answer

A) True 
 B)False

Question 20

A(n)____________________ view cannot be created using a GROUP BY clause.​

Accepted Answer

The answer of A(n)____________________ view cannot be created using a...

A view based on the contents of one table that uses an expression for one of the columns is considered a(n)____ view.

A(n)____________________ view can contain group functions.

An inline view for "TOP-N" analysis is created by sorting data in descending order through the use of the ____________________ clause in the subquery.

A(n)existing view cannot be modified._________________________

The OR REPLACE clause is not required if ____.

An inline analysis can be used to find the "Top-N" values._________________________

If a view needs to be modified,it must be re-created using the ____________________ keywords in the CREATE VIEW command.

Which type of view is created with the following command? CREATE VIEW OR REPLACE outstanding AS SELECT customer#,order#,orderdate,shipdate FROM orders WHERE shipdate IS NULL WITH READ ONLY;

"TOP-N" analysis is performed by sorting values in ascending or descending order in an inline view.

Which of the following types of views cannot include a GROUP BY clause?

Which statement about the view created from the following SQL command is correct,assuming ISBN from the BOOKS table is the primary key used by the view? CREATE OR REPLACE VIEW prices AS SELECT isbn,title,cost,retail,retail-cost profit,name FROM books NATURAL JOIN publisher;

Which of the following describes a type of view that is based on a subquery that retrieves or derives data from one or more tables,and may also contain functions or grouped data?

Views can be used to restrict a user's access to sensitive data.

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

Which type of view is created from the following SQL command? CREATE OR REPLACE VIEW prices AS SELECT isbn,title,cost,retail,retail-cost profit,name FROM books NATURAL JOIN publisher;

Update operations cannot be performed through a complex view that contains an arithmetic expression.

Rows can be added through a complex view that is based upon grouped data.

A view can be dropped or deleted using the DELETE VIEW command._________________________

A complex view can retrieve data from more than one table.

A(n)____________________ view cannot be created using a GROUP BY clause.

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

A view based on the contents of one table that uses an expression for one of the columns is considered a(n)____ view.​

A(n)____________________ view can contain group functions.​

​An inline view for "TOP-N" analysis is created by sorting data in descending order through the use of the ____________________ clause in the subquery.

A(n)existing view cannot be modified._________________________​

The OR REPLACE clause is not required if ____.​

An inline analysis can be used to find the "Top-N" values._________________________​

If a view needs to be modified,it must be re-created using the ____________________ keywords in the CREATE VIEW command.​

Which type of view is created with the following command? CREATE VIEW OR REPLACE outstanding AS SELECT customer#,order#,orderdate,shipdate FROM orders WHERE shipdate IS NULL WITH READ ONLY;

"TOP-N" analysis is performed by sorting values in ascending or descending order in an inline view.​

Which of the following types of views cannot include a GROUP BY clause?​

Which statement about the view created from the following SQL command is correct,assuming ISBN from the BOOKS table is the primary key used by the view? CREATE OR REPLACE VIEW prices AS SELECT isbn,title,cost,retail,retail-cost profit,name FROM books NATURAL JOIN publisher;

Which of the following describes a type of view that is based on a subquery that retrieves or derives data from one or more tables,and may also contain functions or grouped data?​

Views can be used to restrict a user's access to sensitive data.

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

Which type of view is created from the following SQL command? CREATE OR REPLACE VIEW prices AS SELECT isbn,title,cost,retail,retail-cost profit,name FROM books NATURAL JOIN publisher;

Update operations cannot be performed through a complex view that contains an arithmetic expression.​

Rows can be added through a complex view that is based upon grouped data.​

A view can be dropped or deleted using the DELETE VIEW command._________________________​

A complex view can retrieve data from more than one table.​

A(n)____________________ view cannot be created using a GROUP BY clause.​

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

A view based on the contents of one table that uses an expression for one of the columns is considered a(n)____ view.

A(n)____________________ view can contain group functions.

An inline view for "TOP-N" analysis is created by sorting data in descending order through the use of the ____________________ clause in the subquery.

A(n)existing view cannot be modified._________________________

The OR REPLACE clause is not required if ____.

An inline analysis can be used to find the "Top-N" values._________________________

If a view needs to be modified,it must be re-created using the ____________________ keywords in the CREATE VIEW command.

"TOP-N" analysis is performed by sorting values in ascending or descending order in an inline view.

Which of the following types of views cannot include a GROUP BY clause?

Which of the following describes a type of view that is based on a subquery that retrieves or derives data from one or more tables,and may also contain functions or grouped data?

Update operations cannot be performed through a complex view that contains an arithmetic expression.

Rows can be added through a complex view that is based upon grouped data.

A view can be dropped or deleted using the DELETE VIEW command._________________________

A complex view can retrieve data from more than one table.

A(n)____________________ view cannot be created using a GROUP BY clause.