Question 1

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

Question 2

Which of the following describes a subquery used in a FROM clause to create a "temporary" table that can be referenced by the SELECT and WHERE clauses of the outer query?

Accepted Answer

A)   simple view
B)   complex view
C)   inline view
D)   "TOP-N" analysisE) A) and D)
F) None of the above

Question 3

Which of the following options will prevent any DML operations from being performed on the underlying table of a view?

Accepted Answer

A)   WITH READ ONLY
B)   WITH CHECK ONLY
C)   WITH CHECK OPTION
D)   NO WRITE OPTIONE) A) and C)
F) B) and C)

Question 4

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

Question 5

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 Oracle11g will use the aliases as column names in the view that is created.
C)   all of the above
D)   none of the aboveE) A) and C)
F) A) and B)

Question 6

The ____________________ keywords are used to make certain any DML operations do not prevent a row from being accessible to the view after the DML operation is executed.

Accepted Answer

The answer of The ____________________ keywords are used to make...

Question 7

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 8

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

Question 9

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 10

A(n) $\underline { \text { simple } }$ view can contain a GROUP BY clause. _________________________

Accepted Answer

A) True 
 B)False

Question 11

The UPDATE command cannot be used on a view created with the $\underline {\text { WITH CHECK OPTION. } }$. _________________________

Accepted Answer

A) True 
 B)False

Question 12

DML operations are not allowed on a view that includes the pseudo column ____.

Accepted Answer

A)   ROWNUMBER
B)   DISTINCTROW
C)   ROWNUM
D)   NUMROWE) A) and D)
F) None of the above

Question 13

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

Exam 13: Views

The ____________________ keywords are used to make certain any DML operations do not prevent a row from being accessible to the view after the DML operation is executed.

Correct Answer
verified

Which of the following options will prevent any DML operations from being performed on the underlying table of a view?

Correct Answer
verified

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

Correct Answer
verified

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

Correct Answer
verified

DML operations are not allowed on a view that includes the pseudo column ____.

Correct Answer
verified

Which of the following describes a subquery used in a FROM clause to create a "temporary" table that can be referenced by the SELECT and WHERE clauses of the outer query?

Correct Answer
verified

A(n) $\underline { \text { simple } }$ view can contain a GROUP BY clause. _________________________

Correct Answer
verified

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?

Correct Answer
verified

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 WITH READ ONLY;

Correct Answer
verified

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

Correct Answer
verified

The UPDATE command cannot be used on a view created with the $\underline {\text { WITH CHECK OPTION. } }$ . _________________________

Correct Answer
verified

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

Correct Answer
verified

The OR REPLACE clause is not required if ____.

Correct Answer
verified

Exam 13: Views

The ____________________ keywords are used to make certain any DML operations do not prevent a row from being accessible to the view after the DML operation is executed.

Correct AnswerverifiedShow Answer

Which of the following options will prevent any DML operations from being performed on the underlying table of a view?

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

DML operations are not allowed on a view that includes the pseudo column ____.

Correct AnswerverifiedShow Answer

Which of the following describes a subquery used in a FROM clause to create a "temporary" table that can be referenced by the SELECT and WHERE clauses of the outer query?

Correct AnswerverifiedShow Answer

A(n) simple ‾\underline { \text { simple } } simple ​ view can contain a GROUP BY clause. _________________________

Correct AnswerverifiedShow Answer

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?

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 WITH READ ONLY;

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The UPDATE command cannot be used on a view created with the WITH CHECK OPTION. ‾\underline {\text { WITH CHECK OPTION. } } WITH CHECK OPTION. ​ . _________________________

Correct AnswerverifiedShow Answer

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

Correct AnswerverifiedShow Answer

The OR REPLACE clause is not required if ____.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

A(n) $\underline { \text { simple } }$ view can contain a GROUP BY clause. _________________________

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

The UPDATE command cannot be used on a view created with the $\underline {\text { WITH CHECK OPTION. } }$ . _________________________

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified