Question 1

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-keyedE) A) and D)
F) C) and D)

Question 2

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 3

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.E) None of the above
F) C) and D)

Question 4

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 aboveE) A) and B)
F) B) and D)

Question 5

Rows cannot be added to a simple view.​

Accepted Answer

A) True 
 B)False

Question 6

​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 7

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 optionE) None of the above
F) All of the above

Question 8

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 aboveE) A) and B)
F) C) and D)

Question 9

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 aboveE) C) and D)
F) None of the above

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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 12

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

Accepted Answer

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

Question 13

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 14

​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 15

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 16

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 17

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

Accepted Answer

A) True 
 B)False

Question 18

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

Accepted Answer

A materialized view allows you to store ...

Question 19

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

Accepted Answer

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

Question 20

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 aboveE) All of the above
F) C) and D)

Exam 13: Views

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.​

Correct AnswerverifiedShow Answer

What is the definition of an inline view?​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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;

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedA materialized view allows you to store ...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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.​

Correct AnswerverifiedShow Answer

Rows cannot be added to a simple view.​

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedA simple view cannot reference data from...View AnswerShow Answer

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

Correct AnswerverifiedShow Answer

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.​

Correct AnswerverifiedShow Answer

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;

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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;

Correct AnswerverifiedShow Answer

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._________________________​

Correct AnswerverifiedShow Answer

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.

Correct Answer
verified

What is the definition of an inline view?

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

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

Correct Answer
verified
A materialized view allows you to store ...
View Answer

A(n)____________________ view can contain grouped data.

Correct Answer
verified

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

Correct Answer
verified

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.

Correct Answer
verified

Rows cannot be added to a simple view.

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified
A simple view cannot reference data from...
View Answer

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

Correct Answer
verified

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.

Correct Answer
verified

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

Correct Answer
verified

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._________________________

Correct Answer
verified