Question 1

Rows cannot be added to a simple view.​

Accepted Answer

A) True 
 B)False

Question 2

If a view was created with the WITH READ ONLY 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 3

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

Accepted Answer

A)  ​The order# of an order cannot be changed through the view. 
B)  ​The shipping date of an order cannot be changed through the view. 
C)  ​No DML operations are permitted through the view. 
D)  ​all of the above 
A)  ​The order# of an order cannot be changed through the view. 
B)  ​The shipping date of an order cannot be changed through the view. 
C)  ​No DML operations are permitted through the view. 
D)  ​all of the above

Question 4

The WITH READ ONLY option can be used to prevent changes from being made to the data displayed by the view.​

Accepted Answer

A) True 
 B)False

Question 5

An inline view is used to create a(n)permanent table._________________________​

Accepted Answer

A) True 
 B)False

Question 6

Rows cannot be deleted if the complex view was created with a(n)GROUP BY clause._________________________​

Accepted Answer

A) True 
 B)False

Question 7

A(n)____ table is a table that does not contain the primary key that a 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 8

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

Accepted Answer

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

Question 9

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

Accepted Answer

A)  ​DML operations cannot be performed on a non primary key-locked table 
B)  ​DML operations cannot be performed on a non key-preserved table. 
C)  ​DML operations can be performed if a view contains a group function or a GROUP BY clause. 
D)  ​none of the above 
A)  ​DML operations cannot be performed on a non primary key-locked table 
B)  ​DML operations cannot be performed on a non key-preserved table. 
C)  ​DML operations can be performed if a view contains a group function or a GROUP BY clause. 
D)  ​none of the above

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

​How does a materialized view differ from the other types of views?

Accepted Answer

A materialized view allows you to store

Question 12

What is the definition of an inline view?​

Accepted Answer

A)  ​It is a permanent database object that can be referenced by subsequent queries. 
B)  ​It is a view that retrieves data from one or more tables,and can contain functions and grouped data. 
C)  ​It is a temporary data source that exists only while a command is being executed. 
D)  ​It is a temporary pseudo column. 
A)  ​It is a permanent database object that can be referenced by subsequent queries. 
B)  ​It is a view that retrieves data from one or more tables,and can contain functions and grouped data. 
C)  ​It is a temporary data source that exists only while a command is being executed. 
D)  ​It is a temporary pseudo column.

Question 13

Which statement is true about the view created with the following command?
CREATE VIEW outstanding
AS SELECT customer#,order#,orderdate,shipdate
FROM orders
WHERE shipdate IS NULL
WITH CHECK OPTION;

Accepted Answer

A)  ​The order# of an order cannot be changed through the view. 
B)  ​The shipping date of an order cannot be changed through the view. 
C)  ​No DML operations are permitted through the view. 
D)  ​none of the above 
A)  ​The order# of an order cannot be changed through the view. 
B)  ​The shipping date of an order cannot be changed through the view. 
C)  ​No DML operations are permitted through the view. 
D)  ​none of the above

Question 14

​How do the following three types of views differ in terms of the data they can contain: simple view,complex view and inline view?

Accepted Answer

A simple view cannot reference data from

Question 15

Rows can be updated 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 16

The WITH CHECK OPTION can be used when a view is created to ensure that any DML operations performed on the view will not prevent the row from being accessible by the view at a later time._________________________​

Accepted Answer

A) True 
 B)False

Question 17

Rows cannot be added to a table through a complex view that was created with the ORDER BY clause._________________________​

Accepted Answer

A) True 
 B)False

Question 18

​The ____________________ keywords can be used to ensure data cannot be changed through the view.

Accepted Answer

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

Question 19

Which statement is true about the view created with the following command?
CREATE VIEW OR REPLACE outstanding
AS SELECT customer#,order#,orderdate,shipdate
FROM orders
WHERE shipdate IS NULL;

Accepted Answer

A)  ​The order# of an order can be changed through the view. 
B)  ​The shipping date of an order can be changed through the view. 
C)  ​A new order can be added through the view as long as no constraints on the underlying table are violated. 
D)  ​all of the above 
A)  ​The order# of an order can be changed through the view. 
B)  ​The shipping date of an order can be changed through the view. 
C)  ​A new order can be added through the view as long as no constraints on the underlying table are violated. 
D)  ​all of the above

Question 20

​DML operations are not allowed on views that include the pseudo column ____________________

Accepted Answer

The answer of ​DML operations are not allowed on views...

Rows cannot be added to a simple view.

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

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

The WITH READ ONLY option can be used to prevent changes from being made to the data displayed by the view.

An inline view is used to create a(n)permanent table._________________________

Rows cannot be deleted if the complex view was created with a(n)GROUP BY clause._________________________

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

A(n)____________________ view can contain grouped data.

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

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

How does a materialized view differ from the other types of views?

What is the definition of an inline view?

Which statement is true about the view created with the following command? CREATE VIEW outstanding AS SELECT customer#,order#,orderdate,shipdate FROM orders WHERE shipdate IS NULL WITH CHECK OPTION;

How do the following three types of views differ in terms of the data they can contain: simple view,complex view and inline view?

Rows can be updated 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.

The WITH CHECK OPTION can be used when a view is created to ensure that any DML operations performed on the view will not prevent the row from being accessible by the view at a later time._________________________

Rows cannot be added to a table through a complex view that was created with the ORDER BY clause._________________________

The ____________________ keywords can be used to ensure data cannot be changed through the view.

Which statement is true about the view created with the following command? CREATE VIEW OR REPLACE outstanding AS SELECT customer#,order#,orderdate,shipdate FROM orders WHERE shipdate IS NULL;

DML operations are not allowed on views that include the pseudo column ____________________

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

Rows cannot be added to a simple view.​

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

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

The WITH READ ONLY option can be used to prevent changes from being made to the data displayed by the view.​

An inline view is used to create a(n)permanent table._________________________​

Rows cannot be deleted if the complex view was created with a(n)GROUP BY clause._________________________​

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

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

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

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

​How does a materialized view differ from the other types of views?

What is the definition of an inline view?​

Which statement is true about the view created with the following command? CREATE VIEW outstanding AS SELECT customer#,order#,orderdate,shipdate FROM orders WHERE shipdate IS NULL WITH CHECK OPTION;

​How do the following three types of views differ in terms of the data they can contain: simple view,complex view and inline view?

Rows can be updated 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.​

The WITH CHECK OPTION can be used when a view is created to ensure that any DML operations performed on the view will not prevent the row from being accessible by the view at a later time._________________________​

Rows cannot be added to a table through a complex view that was created with the ORDER BY clause._________________________​

​The ____________________ keywords can be used to ensure data cannot be changed through the view.

Which statement is true about the view created with the following command? CREATE VIEW OR REPLACE outstanding AS SELECT customer#,order#,orderdate,shipdate FROM orders WHERE shipdate IS NULL;

​DML operations are not allowed on views that include the pseudo column ____________________

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

Rows cannot be added to a simple view.

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

The WITH READ ONLY option can be used to prevent changes from being made to the data displayed by the view.

An inline view is used to create a(n)permanent table._________________________

Rows cannot be deleted if the complex view was created with a(n)GROUP BY clause._________________________

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

A(n)____________________ view can contain grouped data.

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

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

How does a materialized view differ from the other types of views?

What is the definition of an inline view?

How do the following three types of views differ in terms of the data they can contain: simple view,complex view and inline view?

Rows can be updated 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.

The WITH CHECK OPTION can be used when a view is created to ensure that any DML operations performed on the view will not prevent the row from being accessible by the view at a later time._________________________

Rows cannot be added to a table through a complex view that was created with the ORDER BY clause._________________________

The ____________________ keywords can be used to ensure data cannot be changed through the view.

DML operations are not allowed on views that include the pseudo column ____________________