還在猶豫 1z1-071 題庫該選哪一家？Fast2test 提供免費範例試題，讓你在購買 Oracle Database SQL 完整題庫（共 437 題）之前，先親自檢驗內容品質再決定。

Oracle 1z1-071 考試概覽:

Oracle 1z1-071 考試大綱主題:

Oracle 1z1-071 考試疑問總整理

最新的 Oracle PL/SQL Developer Certified Associate 1z1-071 免費考試真題：

問題 #1

The BOOKS_TRANSACTIONS table exists in your schema in this database.
You execute this SQL statement when connected to your schema in your database instance.
SQL> SELECT * FROM books_transactions ORDER BY 3;
What is the result?

A. The first three rows in the table are displayed in the order that they are stored.
B. All table rows are displayed sorted in ascending order of the values in the third column.
C. Only the three rows with the lowest values in the key column are displayed in the order that they are stored.
D. The execution fails unless the numeral 3 in the ORDER BY clause is replaced by a column name.

問題 #2

Examine the command:

What does ON DELETE CASCADE Imply?

A. When a row in the books table is deleted, the rows in the BOOK__TRANSACTIONS table whose BOOK_ID matches that of the deleted row in the books table are also deleted.
B. When a value in the BOOKS.BOOK_ID column is deleted, the corresponding value is updated in the books transactions. BOOK_ID column.
C. When the books table is dropped, all the rows in the BOOK_TRANSACTIONS table are deleted but the table structure is retained.
D. When the books table is dropped, the BOOK_TRANSACTIONS table is dropped.

問題 #3

Which two tasks can be performed by using Oracle SQL statements?

A. querying data from tables across databases
B. changing the password for an existing database
C. executing operating system (OS) commands in a session
D. connecting to a database instance
E. starting up a database instance

問題 #4

Examine the structure of the SHIPMENTS table:

You want to generate a report that displays the PO_IDand the penalty amount to be paid if the SHIPMENT_DATEis later than one month from the PO_DATE. The penalty is $20 per day.
Evaluate the following two queries:

Which statement is true regarding the above commands?

A. Only the second query executes successfully but gives a wrong result.
B. Only the second query executes successfully and gives the correct result.
C. Both execute successfully and give correct results.
D. Only the first query executes successfully and gives the correct result.
E. Only the first query executes successfully but gives a wrong result.

問題 #5

Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)

A. Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.
B. GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.
C. A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.
D. A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.
E. GLOBAL TEMPORARY TABLE space allocation occurs at session start.
F. A GLOBAL TEMPORARY TABLE's definition is available to multiple sessions.

問題與答案：