[2024-06-24更新,250問] 無料Oracle 1z0-071試験問題集、1z0-071予想試験(ページ 28)

1z0-071 試験問題 131

Which three statements are true about views in an Oracle Database? (Choose three.)

A. Views can join tables only if they belong to the same schema.

B. A view can be created that refers to a non-existent table in its defining query.

C. Views have no object number.

D. Views have no segment.

E. Rows inserted into a table using a view are retained in the table if the view is dropped.

F. A SELECT statement cannot contain a WHERE clause when querying a view containing a WHEREclause in its defining query.

1z0-071 試験問題 132

You issue this command which succeeds:
SQL> DROP TABLE products;
Which three statements are true?

A. Any uncommitted transaction in the session is committed.

B. Table data and the table structure are deleted.

C. All the table's indexes if any exist, are invalidated but retained.

D. Table data is deleted but the table structure is retained.

E. All existing views and synonyms that refer to the table are invalidated but retained.

1z0-071 試験問題 133

You issue the following command to drop the PRODUCTS table: (Choose all that apply.) SQL > DROP TABLE products; Which three statements are true about the implication of this command?

A. All data in the table is deleted but the table structure remains.

B. All data along with the table structure is deleted.

C. All views and synonyms on the table remain but they are invalidated.

D. All indexes on the table remain but they are invalidated.

E. A pending transaction in the session is committed.

1z0-071 試験問題 134

Examine the description of the CUSTOMERStable:

For customers whose income level has a value, you want to display the first name and due amount as 5% of their credit limit. Customers whose due amount is null should not be displayed.
Which query should be used?