Question 1

​DML operations on a view created with the ____________________ keyword that is used to suppress duplicate data are not permitted.

Accepted Answer

The answer of ​DML operations on a view created with...

Question 2

A(n)____ stores a query and is used to access data in the underlying tables.​

Accepted Answer

A)  ​view 
B)  ​constraint 
C)  ​function 
D)  ​argument 
A)  ​view 
B)  ​constraint 
C)  ​function 
D)  ​argument

Question 3

A view can be modified using the MODIFY clause of the ALTER VIEW command.​

Accepted Answer

A) True 
 B)False

Question 4

Views are not database objects.​

Accepted Answer

A) True 
 B)False

Question 5

A(n)UPDATE operation can be performed on a complex view that contains an arithmetic operation._________________________​

Accepted Answer

A) True 
 B)False

Question 6

The OR REPLACE clause is only necessary if another view may already exist with the same name._________________________​

Accepted Answer

A) True 
 B)False

Question 7

You cannot create a view if the underlying table does not exist at the time the view is created.​

Accepted Answer

A) True 
 B)False

Question 8

​Which command will delete a view?

Accepted Answer

A)  ​ALTER TABLE...DROP VIEW 
B)  ​DROP VIEW 
C)  ​ALTER TABLE...DELETE VIEW 
D)  ​DELETE VIEW 
A)  ​ALTER TABLE...DROP VIEW 
B)  ​DROP VIEW 
C)  ​ALTER TABLE...DELETE VIEW 
D)  ​DELETE VIEW

Question 9

What is the procedure for assigning new names for the columns that are displayed by a view?​

Accepted Answer

A)  ​The new column names can be listed after the VIEW keyword,enclosed in parentheses. 
B)  ​Column aliases can be used in the subquery,and Oracle12c will use the aliases as column names in the view that is created. 
C)  ​all of the above 
D)  ​none of the above 
A)  ​The new column names can be listed after the VIEW keyword,enclosed in parentheses. 
B)  ​Column aliases can be used in the subquery,and Oracle12c will use the aliases as column names in the view that is created. 
C)  ​all of the above 
D)  ​none of the above

Question 10

A simple view cannot contain a simple arithmetic operation.​

Accepted Answer

A) True 
 B)False

Question 11

A(n)____________________ can be created to simplify the querying process for novice database users.​

Accepted Answer

The answer of A(n)____________________ can be created to simplify the...

Question 12

Which statement about the view created from the following command is correct,assuming no constraints exist on the underlying table?
CREATE VIEW prices
AS SELECT isbn,title,cost,retail,retail-cost profit
FROM books;

Accepted Answer

A)  ​The retail price of a book can be changed. 
B)  ​The profit generated by a book can be changed. 
C)  ​The profit generated by a book can be added. 
D)  ​Values for a new book can be added for all five columns displayed by the view. 
A)  ​The retail price of a book can be changed. 
B)  ​The profit generated by a book can be changed. 
C)  ​The profit generated by a book can be added. 
D)  ​Values for a new book can be added for all five columns displayed by the view.

Question 13

An inline view is created by a SELECT statement that contains a(n)____________________ in the FROM clause.​

Accepted Answer

The answer of An inline view is created by a...

Question 14

DML operations can be performed through a simple view even if the operation will violate constraints on the underlying table.​

Accepted Answer

A) True 
 B)False

Question 15

Which of the following types of views cannot contain grouped data?​

Accepted Answer

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

Question 16

A(n)____________________ view cannot contain grouped data.​

Accepted Answer

The answer of A(n)____________________ view cannot contain grouped data.​...

Question 17

Which of the following types of views cannot include an arithmetic expression?​

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 18

The NOFORCE keyword can be used to create a view based upon a table that has not yet been created._________________________​

Accepted Answer

A) True 
 B)False

Question 19

Which statement is true about the view created with the following command?
CREATE VIEW inventory AS SELECT isbn,title,retail price
FROM books
WITH READ ONLY;

Accepted Answer

A)  ​The command creates a simple view. 
B)  ​DML operations are NOT allowed on the data displayed by the view. 
C)  ​A view named INVENTORY did not previously exist. 
D)  ​all of the above 
A)  ​The command creates a simple view. 
B)  ​DML operations are NOT allowed on the data displayed by the view. 
C)  ​A view named INVENTORY did not previously exist. 
D)  ​all of the above

Question 20

A view can be thought of as the result of a(n)stored query._________________________​

Accepted Answer

A) True 
 B)False

DML operations on a view created with the ____________________ keyword that is used to suppress duplicate data are not permitted.

A(n)____ stores a query and is used to access data in the underlying tables.

A view can be modified using the MODIFY clause of the ALTER VIEW command.

Views are not database objects.

A(n)UPDATE operation can be performed on a complex view that contains an arithmetic operation._________________________

The OR REPLACE clause is only necessary if another view may already exist with the same name._________________________

You cannot create a view if the underlying table does not exist at the time the view is created.

Which command will delete a view?

What is the procedure for assigning new names for the columns that are displayed by a view?

A simple view cannot contain a simple arithmetic operation.

A(n)____________________ can be created to simplify the querying process for novice database users.

Which statement about the view created from the following command is correct,assuming no constraints exist on the underlying table? CREATE VIEW prices AS SELECT isbn,title,cost,retail,retail-cost profit FROM books;

An inline view is created by a SELECT statement that contains a(n)____________________ in the FROM clause.

DML operations can be performed through a simple view even if the operation will violate constraints on the underlying table.

Which of the following types of views cannot contain grouped data?

A(n)____________________ view cannot contain grouped data.

Which of the following types of views cannot include an arithmetic expression?

The NOFORCE keyword can be used to create a view based upon a table that has not yet been created._________________________

Which statement is true about the view created with the following command? CREATE VIEW inventory AS SELECT isbn,title,retail price FROM books WITH READ ONLY;

A view can be thought of as the result of a(n)stored query._________________________

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

​DML operations on a view created with the ____________________ keyword that is used to suppress duplicate data are not permitted.

A(n)____ stores a query and is used to access data in the underlying tables.​

A view can be modified using the MODIFY clause of the ALTER VIEW command.​

Views are not database objects.​

A(n)UPDATE operation can be performed on a complex view that contains an arithmetic operation._________________________​

The OR REPLACE clause is only necessary if another view may already exist with the same name._________________________​

You cannot create a view if the underlying table does not exist at the time the view is created.​

​Which command will delete a view?

What is the procedure for assigning new names for the columns that are displayed by a view?​

A simple view cannot contain a simple arithmetic operation.​

A(n)____________________ can be created to simplify the querying process for novice database users.​

Which statement about the view created from the following command is correct,assuming no constraints exist on the underlying table? CREATE VIEW prices AS SELECT isbn,title,cost,retail,retail-cost profit FROM books;

An inline view is created by a SELECT statement that contains a(n)____________________ in the FROM clause.​

DML operations can be performed through a simple view even if the operation will violate constraints on the underlying table.​

Which of the following types of views cannot contain grouped data?​

A(n)____________________ view cannot contain grouped data.​

Which of the following types of views cannot include an arithmetic expression?​

The NOFORCE keyword can be used to create a view based upon a table that has not yet been created._________________________​

Which statement is true about the view created with the following command? CREATE VIEW inventory AS SELECT isbn,title,retail price FROM books WITH READ ONLY;

A view can be thought of as the result of a(n)stored query._________________________​

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

DML operations on a view created with the ____________________ keyword that is used to suppress duplicate data are not permitted.

A(n)____ stores a query and is used to access data in the underlying tables.

A view can be modified using the MODIFY clause of the ALTER VIEW command.

Views are not database objects.

A(n)UPDATE operation can be performed on a complex view that contains an arithmetic operation._________________________

The OR REPLACE clause is only necessary if another view may already exist with the same name._________________________

You cannot create a view if the underlying table does not exist at the time the view is created.

Which command will delete a view?

What is the procedure for assigning new names for the columns that are displayed by a view?

A simple view cannot contain a simple arithmetic operation.

A(n)____________________ can be created to simplify the querying process for novice database users.

An inline view is created by a SELECT statement that contains a(n)____________________ in the FROM clause.

DML operations can be performed through a simple view even if the operation will violate constraints on the underlying table.

Which of the following types of views cannot contain grouped data?

A(n)____________________ view cannot contain grouped data.

Which of the following types of views cannot include an arithmetic expression?

The NOFORCE keyword can be used to create a view based upon a table that has not yet been created._________________________

A view can be thought of as the result of a(n)stored query._________________________