Deck 13: Views

Question 1

An inline view is a temporary table that only lasts for the duration of the SELECT statement used to create it.​

Answer 1

True

Question 2

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

Answer 2

False

Question 3

Any DML operation can be performed on a simple view that was not created with the WITH READ ONLY option,unless it violates an existing constraint.​

Answer 3

True

Question 4

Column aliases can be used in the subquery to assign new column names to the columns contained in a view.​

Question 5

A simple view is based upon a subquery that references only one table and doesn't contain any group functions,expressions,or a GROUP BY clause.​

Question 6

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

Question 7

A view name must be enclosed in single quotation marks if it is referenced in the FROM clause of a SELECT statement.​

Question 8

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

Question 9

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

Question 10

A view cannot be given the same name as another database object.​

Question 11

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

Question 12

Views are database objects that store data.​

Question 13

A complex view cannot contain any group functions.​

Question 14

The column names used in the view must be the same names as the column names in the underlying table(s).​

Question 15

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

Question 16

Rows cannot be added to a simple view.​

Question 17

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

Question 18

​A view can be created to simplify issuing complex SQL queries.

Question 19

Views are not database objects.​

Question 20

A simple view cannot contain a simple arithmetic operation.​

Question 21

The WITHOUT UPDATE keywords prevent DML operations from being performed through a view._________________________​

Question 22

DML operations can be performed on a view created with the DISTINCT keyword.​

Question 23

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

Question 24

An ORDER BY clause can be used to perform "TOP-N" analysis.​

Question 25

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

Question 26

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

Question 27

A(n)view is a database object,but it does not actually store data._________________________​

Question 28

A(n)simple view can contain a GROUP BY clause._________________________​

Question 29

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

Question 30

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

Question 31

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

Question 32

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

Question 33

FORCE is the default mode for the CREATE VIEW command._________________________​

Question 34

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

Question 35

Rows in an underlying table cannot be deleted through a complex view that contains an arithmetic operation.​

Question 36

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

Question 37

When a query references a view,the query in the view is processed,and the results are treated as a(n)permanent table._________________________

Question 38

DML operations cannot be performed on a key-preserved table.​

Question 39

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

Question 40

Values cannot be inserted through a view into columns that are based on arithmetic expressions.​

Question 41

The pseudo column ROW can be used to perform a "TOP-N" analysis._________________________​

Question 42

Rows cannot be deleted from a table through a complex view that is based on a group function._________________________​

Question 43

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

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

Question 44

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

Question 45

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

Question 46

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

Question 47

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

Question 48

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

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

Question 49

Any DDL operation can be performed on a simple view that was not created with the WITH READ ONLY option,unless it violates an existing constraint._________________________​

Question 50

"TOP-N" analysis can be used to find the highest values in a column by sorting the data in ascending order._________________________​

Question 51

Rows cannot be added to a table through a complex view that is based on a group function._________________________​

Question 52

Which of the following statements about views is incorrect?​

A) ​Views assist users who do not have the training to issue complex SQL inquiries.
B) ​Views restrict users' access to sensitive data.
C) ​Views are database objects that actually store data.
D) ​A view can be referenced in a SELECT...FROM statement,just like any table.

Question 53

Which of the following describes a type of view that is based upon a subquery that only references one table and does not include any group functions,expressions,or GROUP BY clauses?​

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

Question 54

A(n)complex view can contain data from more than one table._________________________​

Question 55

The DELETE operation can be performed through a complex view that contains an arithmetic operation._________________________​

Question 56

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

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

Question 57

DML operations cannot be performed on non key-preserved tables through a complex view._________________________​

Question 58

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

Question 59

The UPDATE command cannot be used on a view created with the WITH CHECK OPTION._________________________​

Question 60

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

Question 61

If you want to create a view based upon a table or tables that do not yet exist,or are currently unavailable (e.g. ,off-line),what keyword can you use to avoid receiving an error message?​

A) ​FORCE
B) ​NOERROR
C) ​OVERRIDE
D) ​none of the above

Question 62

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

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

Question 63

What is the default mode for the CREATE VIEW command?​

A) ​COMPILE
B) ​NOCOMPILE
C) ​FORCE
D) ​NOFORCE

Question 64

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

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

Question 65

The OR REPLACE clause is not required if ____.​

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 66

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

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

Question 67

____ aren't allowed in the CREATE VIEW command.​

A) ​Arithmetic expressions
B) ​ORDER BY clauses
C) ​Group functions
D) ​GROUP BY clauses

Question 68

The ____ constraint ensures that any DML operations performed on the view (e.g. ,adding rows,changing data)will not prevent the row from being accessed by the view because it no longer meets the condition in the WHERE clause.​

A) ​ON UPDATE CHECK
B) ​WITH CHECK OPTION
C) ​WITH READ ONLY
D) ​READ-WRITE ONLY

Question 69

Which constraint ensures that the data in a view cannot be changed?​

A) ​WITH CHECK OPTION
B) ​WITH READ OPTION
C) ​WITH READ ONLY
D) ​NO WRITE OPTION

Question 70

Which of the following statements is incorrect?​

A) ​A view can be created with the CREATE VIEW command.
B) ​Views can be modified by using the ALTER VIEW...MODIFY command.
C) ​A view cannot be modified; if you need to change it,you must use the CREATE OR REPLACE VIEW keywords.
D) ​A view cannot be given the same name as another database object in the same schema.

Question 71

A user can perform a DML operation (add,modify,delete)on a simple view if it does not violate which type of existing constraint on the underlying base table?​

A) ​PRIMARY KEY
B) ​WITH CHECK OPTION
C) ​UNIQUE
D) ​all of the above

Question 72

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

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

Question 73

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;

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 74

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

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;

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

Question 76

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

A) ​WITH READ ONLY
B) ​WITH CHECK ONLY
C) ​WITH CHECK OPTION
D) ​NO WRITE OPTION

Question 77

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

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 78

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

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 79

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

A) ​The command creates a complex view.
B) ​DML operations are not allowed on the data displayed by the view.
C) ​A database object named INVENTORY may already exist.
D) ​all of the above

Question 80

Which of the following types of views cannot include a group function?

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