Go on. Explore!

lvl 0 • 0 xp

lvl 1

Home Market Decks Interests

Week #14 Quiz - CIST1220-Structured Query Language-SQL

memorize.ai (lvl 286)

(0)

10 cards

()

Section 1

Preview this deck

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 Oracle11g will use the aliases as column names in the view that is created. C) all of the above D) none of the above

Front

1 / 10

SQL

0.0

0 reviews

5			0
4			0
3			0
2			0
1			0

Active users

All-time users

Favorites

Last updated

4 years ago

Date created

Mar 1, 2020

Cards (10)

Section 1

(10 cards)

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 Oracle11g will use the aliases as column names in the view that is created. C) all of the above D) none of the above

Front

C) all of the above

Back

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

Front

A) simple view

Back

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

Front

A) FORCE

Back

Which of the following statements about complex views is incorrect? 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.

Front

C) All DML operations can be performed on complex views, just like simple views.

Back

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

Front

D) all of the above

Back

The WITH READ ONLY option can be used to prevent changes from being made to the data displayed by the view. A) True B) False

Front

A) True

Back

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) DML operations can only be performed on the columns belonging to the PUBLISHER table. B) No DML operations are allowed. C) DML operations are allowed on both the BOOKS and PUBLISHER tables. D) DML operations can only be performed on the columns belonging to the BOOKS table.

Front

D) DML operations can only be performed on the columns belonging to the BOOKS table.

Back

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

Front

C) WITH READ ONLY

Back

A(n) ____ stores a query and is used to access data in the underlying tables. A) view B) constraint C) function D) argument

Front

A) view

Back

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

Front

A) simple

Back