Question 1

​The ____________________ keyword can be used to create a view based upon a table that does not yet exist.

Accepted Answer

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

Question 2

​How is a "TOP-N" analysis performed?

Accepted Answer

The "TOP-N" analysis is perfor

Question 3

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 4

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

Accepted Answer

A) True 
 B)False

Question 5

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

Accepted Answer

A) True 
 B)False

Question 6

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

Accepted Answer

A) True 
 B)False

Question 7

Which statement about the view created from the following SQL statement is correct?
CREATE VIEW balancedue
AS SELECT customer#,order#,SUM(quantity*retail)amtdue
FROM customers NATURAL JOIN orders NATURAL JOIN
Orderitems NATURAL JOIN books
GROUP BY customer#,order#;

Accepted Answer

A)  ​No DML operations can be performed through the view. 
B)  ​DML operations can only be performed on the CUSTOMERS table since it is the primary key for the view. 
C)  ​Only rows can be added through the view - no other DML operations are allowed. 
D)  ​none of the above 
A)  ​No DML operations can be performed through the view. 
B)  ​DML operations can only be performed on the CUSTOMERS table since it is the primary key for the view. 
C)  ​Only rows can be added through the view - no other DML operations are allowed. 
D)  ​none of the above

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

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

Accepted Answer

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

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

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

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

Accepted Answer

A) True 
 B)False

Question 13

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

Accepted Answer

A) True 
 B)False

Question 14

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

Accepted Answer

The answer of ​____________________ analysis could be used to find...

Question 15

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

Accepted Answer

A) True 
 B)False

Question 16

​Any DML operation can be performed on a(n)____________________ view as long as the view was not created with the WITH READ ONLY option and existing constraints are not violated.

Accepted Answer

The answer of ​Any DML operation can be performed on...

Question 17

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

Accepted Answer

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

Question 18

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

Accepted Answer

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

Which type of view is created by the following command?
CREATE VIEW OR REPLACE outstanding
AS SELECT customer#,order#,orderdate,shipdate
FROM orders
WHERE shipdate IS NULL;

Accepted Answer

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

Question 20

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

Accepted Answer

A) True 
 B)False

The ____________________ keyword can be used to create a view based upon a table that does not yet exist.

How is a "TOP-N" analysis performed?

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

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

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

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

Which statement about the view created from the following SQL statement is correct? CREATE VIEW balancedue AS SELECT customer#,order#,SUM(quantity*retail)amtdue FROM customers NATURAL JOIN orders NATURAL JOIN Orderitems NATURAL JOIN books GROUP BY customer#,order#;

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

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?

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

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

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

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.

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

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

Any DML operation can be performed on a(n)____________________ view as long as the view was not created with the WITH READ ONLY option and existing constraints are not violated.

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

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;

Which type of view is created by the following command? CREATE VIEW OR REPLACE outstanding AS SELECT customer#,order#,orderdate,shipdate FROM orders WHERE shipdate IS NULL;

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

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

​The ____________________ keyword can be used to create a view based upon a table that does not yet exist.

​How is a "TOP-N" analysis performed?

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

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

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

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

Which statement about the view created from the following SQL statement is correct? CREATE VIEW balancedue AS SELECT customer#,order#,SUM(quantity*retail)amtdue FROM customers NATURAL JOIN orders NATURAL JOIN Orderitems NATURAL JOIN books GROUP BY customer#,order#;

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

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

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

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

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

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

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

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

​Any DML operation can be performed on a(n)____________________ view as long as the view was not created with the WITH READ ONLY option and existing constraints are not violated.

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

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

Which type of view is created by the following command? CREATE VIEW OR REPLACE outstanding AS SELECT customer#,order#,orderdate,shipdate FROM orders WHERE shipdate IS NULL;

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

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

The ____________________ keyword can be used to create a view based upon a table that does not yet exist.

How is a "TOP-N" analysis performed?

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

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

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

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

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

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?

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

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

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.

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

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

Any DML operation can be performed on a(n)____________________ view as long as the view was not created with the WITH READ ONLY option and existing constraints are not violated.

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

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;

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