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

The answer of Which type of view is created from...

Question 2

A view based on the contents of one table that uses an expression for one of the columns is considered a(n)____ view.​

Accepted Answer

A complex view is based on the contents of one or more tables and can use expressions for one of the columns, making it more than just a straightforward representation of a single table's data.

Question 3

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

The command creates a simple view because it does not involve any joins, group by clauses, or subqueries. It simply selects columns from one table based on a condition.

Question 4

Which type of view is created from the following SQL statement?
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

The view created from the SQL statement is a complex view because it involves multiple tables being joined and aggregated with the GROUP BY clause. It is not a simple view because it involves calculations and grouping. It is also not an inline or partial view.

Question 5

If a view was created with the WITH READ ONLY constraint,to remove the constraint you will need to ____.​

Accepted Answer

To remove the WITH READ ONLY constraint from a view, you must re-create the view without this option, as there is no direct command to alter this aspect of a view after it has been created.

Question 6

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;

Accepted Answer

The answer of Which statement is true about the view...

Question 7

Which of the following statements about performing DML operations on complex views is correct?​

Accepted Answer

When performing DML operations on complex views, it is important to ensure that the view is key-preserved, meaning that the view's primary key columns are present in the underlying table and cannot be changed through the view. If the view is not key-preserved, then DML operations may result in errors or unexpected results. Option A is incorrect because primary key locking is not relevant to the ability to perform DML operations on a table. Option C is also incorrect because the presence of group functions or a GROUP BY clause does not impact the ability to perform DML operations on a view.

Question 8

Which statement about the view created from the following command is correct,assuming no constraints exist on the underlying table?
CREATE VIEW prices
AS SELECT isbn,title,cost,retail,retail-cost profit
FROM books;

Accepted Answer

The view is a virtual table created based on the SELECT statement. It does not store data itself but displays data from the underlying tables. While you cannot directly modify a calculated column (profit in this case), you can change the data in the underlying table (e.g., the retail price) that affects the view. Adding new books or directly changing the profit column through the view is not possible because views do not support inserting or updating calculated columns directly.

Question 9

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

Accepted Answer

When a view is created with the DISTINCT keyword, it removes duplicate rows from the result set. Since the view is created with a distinct keyword, the exact rows that need updating, deleting, or inserting may not be identified, so DML operations on such views are not allowed.

Question 10

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

The view prices was created with only three columns - isbn, title, and profit (which is calculated from the cost and retail columns). Therefore, the INSERT statement can only insert values into these three columns. Option A and B both have four columns (title, cost, retail, profit) and cannot be executed on this view. Option C has the correct number of columns and matches the data types of the columns in the view.

Question 11

A(n)____ table is a table that does not contain the primary key that a view uses to uniquely identify each record being displayed by the view.​

Accepted Answer

A non key-preserved table is used by a view, but it does not contain the primary key that uniquely identifies each record being displayed by the view. This means that any updates, inserts or deletes on the view may not be directly applied to the underlying table since it lacks the primary key.

Question 12

Which type of view is created from the following SQL command?
CREATE OR REPLACE VIEW prices
AS SELECT isbn,title,cost,retail,retail-cost profit,name
FROM books NATURAL JOIN publisher;

Accepted Answer

The answer of Which type of view is created from...

Question 13

Which of the following statements about performing DML operations on complex views is correct?​

Accepted Answer

The answer of Which of the following statements about performing...

Question 14

Which statement is true about the view 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

The "WITH CHECK OPTION" ensures that any updates or inserts through the view must satisfy the view's WHERE clause condition, which is "shipdate IS NULL". Therefore, the shipping date cannot be changed to a non-null value through the view.

Question 15

If a view was created with the WITH CHECK OPTION constraint,to remove the constraint you will need to ____.​

Accepted Answer

The WITH CHECK OPTION constraint is a part of the view definition, so it cannot be altered or dropped using ALTER VIEW command. The only way to remove the constraint is to drop and recreate the view without the option. Therefore, option B is the correct choice.

Question 16

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

This view is a result of a SELECT statement with GROUP BY clause, so it aggregates data from the base tables. DML operations cannot be performed through the view since it doesn't correspond to a single table directly.

Question 17

Which of the following statements about complex views is incorrect?​

Accepted Answer

Complex views, especially those involving joins, functions, or groupings, often do not support all DML operations (such as INSERT, UPDATE, DELETE) directly due to the complexity of mapping changes back to the underlying tables.

Question 18

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

This command creates a simple view because it selects columns directly from one table without using joins, subqueries, or aggregations. The "WITH CHECK OPTION" ensures that any modifications through the view adhere to its defining condition, but it doesn't change the view's classification as simple.

Question 19

Which statement about the view created from the following SQL command is correct,assuming ISBN from the BOOKS table is the primary key used by the view?
CREATE OR REPLACE VIEW prices
AS SELECT isbn,title,cost,retail,retail-cost profit,name
FROM books NATURAL JOIN publisher;

Accepted Answer

DML operations can only be performed on the columns belonging to the BOOKS table because ISBN, the primary key from the BOOKS table, is included in the view.

Question 20

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 key-preserved table is one where the primary key used in a view is guaranteed to be unique and not modified through the view. This ensures that each record in the view can be uniquely identified and traced back to a single record in the underlying table.

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

A view based on the contents of one table that uses an expression for one of the columns is considered a(n) ____ view.

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;

Which type of view is created from the following SQL statement? 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#;

If a view was created with the WITH READ ONLY constraint,to remove the constraint you will need to ____.

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;

Which of the following statements about performing DML operations on complex views is correct?

Which statement about the view created from the following command is correct,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 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;

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

Which type of view is created from the following SQL command? CREATE OR REPLACE VIEW prices AS SELECT isbn,title,cost,retail,retail-cost profit,name FROM books NATURAL JOIN publisher;

Which of the following statements about performing DML operations on complex views is correct?

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

If a view was created with the WITH CHECK OPTION constraint,to remove the constraint you will need to ____.

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

Which of the following statements about complex views is incorrect?

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 statement about the view created from the following SQL command is correct,assuming ISBN from the BOOKS table is the primary key used by the view? CREATE OR REPLACE VIEW prices AS SELECT isbn,title,cost,retail,retail-cost profit,name FROM books NATURAL JOIN publisher;

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

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

A view based on the contents of one table that uses an expression for one of the columns is considered a(n) ____ view.​

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;

Which type of view is created from the following SQL statement? 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#;

If a view was created with the WITH READ ONLY constraint,to remove the constraint you will need to ____.​

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;

Which of the following statements about performing DML operations on complex views is correct?​

Which statement about the view created from the following command is correct,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 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;

A(n) ____ table is a table that does not contain the primary key that a view uses to uniquely identify each record being displayed by the view.​

Which type of view is created from the following SQL command? CREATE OR REPLACE VIEW prices AS SELECT isbn,title,cost,retail,retail-cost profit,name FROM books NATURAL JOIN publisher;

Which of the following statements about performing DML operations on complex views is correct?​

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

If a view was created with the WITH CHECK OPTION constraint,to remove the constraint you will need to ____.​

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

Which of the following statements about complex views is incorrect?​

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 statement about the view created from the following SQL command is correct,assuming ISBN from the BOOKS table is the primary key used by the view? CREATE OR REPLACE VIEW prices AS SELECT isbn,title,cost,retail,retail-cost profit,name FROM books NATURAL JOIN publisher;

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

A view based on the contents of one table that uses an expression for one of the columns is considered a(n) ____ view.

If a view was created with the WITH READ ONLY constraint,to remove the constraint you will need to ____.

Which of the following statements about performing DML operations on complex views is correct?

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

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

Which of the following statements about performing DML operations on complex views is correct?

If a view was created with the WITH CHECK OPTION constraint,to remove the constraint you will need to ____.

Which of the following statements about complex views is incorrect?

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