Question 1

Which type of view is created from the following command?
CREATE VIEW prices
AS SELECT isbn,title,cost,retail,retail-cost profit
FROM books;

Accepted Answer

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

Question 2

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

Accepted Answer

A)  ​ROWNUMBER 
B)  ​DISTINCTROW 
C)  ​ROWNUM 
D)  ​NUMROW 
A)  ​ROWNUMBER 
B)  ​DISTINCTROW 
C)  ​ROWNUM 
D)  ​NUMROW

Question 3

Views are database objects that store data.​

Accepted Answer

A) True 
 B)False

Question 4

DML operations are not allowed on a view that is created with the ____ keyword.​

Accepted Answer

A)  ​JOIN 
B)  ​NATURAL JOIN 
C)  ​DISTINCT 
D)  ​REPLACE 
A)  ​JOIN 
B)  ​NATURAL JOIN 
C)  ​DISTINCT 
D)  ​REPLACE

Question 5

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 6

The subquery used to create a(n)____ view can contain an ORDER BY clause.​

Accepted Answer

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

Question 7

A complex view cannot contain any group functions.​

Accepted Answer

A) True 
 B)False

Question 8

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

Accepted Answer

A) True 
 B)False

Question 9

​A(n)____________________ view only exists while the SELECT command is being executed.

Accepted Answer

The answer of ​A(n)____________________ view only exists while the SELECT...

Question 10

Which type of view is 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)  ​complex 
B)  ​partial 
C)  ​simple 
D)  ​none of the above 
A)  ​complex 
B)  ​partial 
C)  ​simple 
D)  ​none of the above

Question 11

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" analysis 
A)  ​simple view 
B)  ​complex view 
C)  ​inline view 
D)  ​"TOP-N" analysis

Question 12

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

Accepted Answer

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

Question 13

A(n)____________________ can be used to restrict a user's access to sensitive data.​

Accepted Answer

The answer of A(n)____________________ can be used to restrict a...

Which type of view is created from the following command? CREATE VIEW prices AS SELECT isbn,title,cost,retail,retail-cost profit FROM books;

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

Views are database objects that store data.

DML operations are not allowed on a view that is created with the ____ keyword.

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;

The subquery used to create a(n)____ view can contain an ORDER BY clause.

A complex view cannot contain any group functions.

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

A(n)____________________ view only exists while the SELECT command is being executed.

Which type of view is created with the following command? CREATE VIEW outstanding AS SELECT customer#,order#,orderdate,shipdate FROM orders WHERE shipdate IS NULL WITH CHECK OPTION;

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?

What is the default mode for the CREATE VIEW command?

A(n)____________________ can be used to restrict a user's access to sensitive data.

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

Which type of view is created from the following command? CREATE VIEW prices AS SELECT isbn,title,cost,retail,retail-cost profit FROM books;

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

Views are database objects that store data.​

DML operations are not allowed on a view that is created with the ____ keyword.​

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;

The subquery used to create a(n)____ view can contain an ORDER BY clause.​

A complex view cannot contain any group functions.​

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

​A(n)____________________ view only exists while the SELECT command is being executed.

Which type of view is created with the following command? CREATE VIEW outstanding AS SELECT customer#,order#,orderdate,shipdate FROM orders WHERE shipdate IS NULL WITH CHECK OPTION;

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

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

A(n)____________________ can be used to restrict a user's access to sensitive data.​

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

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

Views are database objects that store data.

DML operations are not allowed on a view that is created with the ____ keyword.

The subquery used to create a(n)____ view can contain an ORDER BY clause.

A complex view cannot contain any group functions.

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

A(n)____________________ view only exists while the SELECT command is being executed.

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?

What is the default mode for the CREATE VIEW command?

A(n)____________________ can be used to restrict a user's access to sensitive data.