单项选择题

You are granted the CREATE VIEW privilege. What does this allow you to do?（）

A. Create a table view.
B. Create a view in any schema.
C. Create a view in your schema.
D. Create a sequence view in any schema.
E. Create a view that is accessible by everyone.
F. Create a view only of it is based on tables that you created.

点击查看答案

上一题目录下一题

相关考题

多项选择题

Evaluate the SQL statement
DROP TABLE DEPT:
Which four statements are true of the SQL statement? （）

A. You cannot roll back this statement.
B. All pending transactions are committed.
C. All views based on the DEPT table are deleted.
D. All indexes based on the DEPT table are dropped.
E. All data in the table is deleted, and the table structure is also deleted.
F. All data in the table is deleted, but the structure of the table is retained.
G. All synonyms based on the DEPT table are deleted.

单项选择题

Which statement describes the ROWID data type?（）

A. Binary data up to 4 gigabytes.
B. Character data up to 4 gigabytes.
C. Raw binary data of variable length up to 2 gigabytes.
D. Binary data stored in an external file, up to 4 gigabytes.
E. A hexadecimal string representing the unique address of a row in its table.

单项选择题

You need to produce a report for mailing labels for all customers. The mailing label must have only the customer name and address. The CUSTOMERS table has these columns:

Which SELECT statement accomplishes this task?（）

A. SELECT*   FROM customers;
B. SELECT name, address   FROM customers;
C. SELECT id, name, address, phone   FROM customers;
D. SELECT cust_name, cust_address   FROM customers;
E. SELECT cust_id, cust_name, cust_address, cust_phone   FROM customers;