Question 1

____________________ analysis could be used to find the top five values stored in a column.

Accepted Answer

"TOP-N"
TOP-N

Question 2

A(n) $\underline {\text { UPDATE } }$ operation can be performed on a complex view that contains an arithmetic operation. _________________________

Accepted Answer

A) True 
 B)False  True

Question 3

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

Accepted Answer

A) True 
 B)False  True

Question 4

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 5

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

Accepted Answer

A) True 
 B)False

Question 6

Which SQL statement can be executed based upon the view created from the following command, 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)  INSERT INTO prices (title, cost, retail, profit)
VALUES ('A NEW BOOK', 49.99, 69.99, 20); 
B)  INSERT INTO prices (title, cost, retail, profit)
VALUES ('A SECOND BOOK', 49.99, 39.99, -10); 
C)  INSERT INTO prices (title, cost, retail)
VALUES ('A NEW BOOK', 49.99, 69.99); 
D)  none of the above 
A)  INSERT INTO prices (title, cost, retail, profit)
VALUES ('A NEW BOOK', 49.99, 69.99, 20); 
B)  INSERT INTO prices (title, cost, retail, profit)
VALUES ('A SECOND BOOK', 49.99, 39.99, -10); 
C)  INSERT INTO prices (title, cost, retail)
VALUES ('A NEW BOOK', 49.99, 69.99); 
D)  none of the above

Question 7

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 8

Which of the following statements about complex views is incorrect?

Accepted Answer

A)  It is created with the same CREATE VIEW command as a simple view. 
B)  It retrieves or derives data from one or more tables. 
C)  All DML operations can be performed on complex views, just like simple views. 
D)  It may contain functions or grouped data. 
A)  It is created with the same CREATE VIEW command as a simple view. 
B)  It retrieves or derives data from one or more tables. 
C)  All DML operations can be performed on complex views, just like simple views. 
D)  It may contain functions or grouped data.

Question 9

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 10

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

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

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

Accepted Answer

The answer of When a view includes columns from more...

Question 13

A(n) ____________________ view can contain grouped data.

Accepted Answer

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

Question 14

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

Accepted Answer

A) True 
 B)False

Question 15

A(n) ____ table is the table that contains the primary key the 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 16

If a view needs to be modified, it must be re-created using the ____________________ keywords in the CREATE VIEW command.

Accepted Answer

OR REPLACE

Question 17

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 18

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.

Accepted Answer

A) True 
 B)False

Question 19

Views are not database objects.

Accepted Answer

A) True 
 B)False

Question 20

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

____________________ analysis could be used to find the top five values stored in a column.

A(n) $\underline {\text { UPDATE } }$ operation can be performed on a complex view that contains an arithmetic operation. _________________________

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

Which command will delete a view?

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

Which SQL statement can be executed based upon the view created from the following command, assuming no constraints exist on the underlying table? CREATE VIEW prices AS SELECT isbn, title, cost, retail, retail-cost profit FROM books;

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

Which of the following statements about complex views is incorrect?

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 column names used in the view must be the same names as the column names in the underlying table(s).

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

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

A(n) ____________________ view can contain grouped data.

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

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

If a view needs to be modified, it must be re-created using the ____________________ keywords in the CREATE VIEW command.

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

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.

Views are not database objects.

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

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

____________________ analysis could be used to find the top five values stored in a column.

A(n) UPDATE ‾\underline {\text { UPDATE } } UPDATE ​ operation can be performed on a complex view that contains an arithmetic operation. _________________________

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

Which command will delete a view?

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

Which SQL statement can be executed based upon the view created from the following command, assuming no constraints exist on the underlying table? CREATE VIEW prices AS SELECT isbn, title, cost, retail, retail-cost profit FROM books;

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

Which of the following statements about complex views is incorrect?

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 column names used in the view must be the same names as the column names in the underlying table(s).

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

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

A(n) ____________________ view can contain grouped data.

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

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

If a view needs to be modified, it must be re-created using the ____________________ keywords in the CREATE VIEW command.

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

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.

Views are not database objects.

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

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

A(n) $\underline {\text { UPDATE } }$ operation can be performed on a complex view that contains an arithmetic operation. _________________________