2026年最新の実際に出る無料Oracle 1z0-071試験問題集と解答 [Q153-Q170]

2026年最新の実際に出る無料Oracle 1z0-071試験問題集と解答

1z0-071練習テストエンジンで今すぐ試そう437試験問題

質問 # 153
Examine the description of the CUSTONERS table:

CUSTNO is the PRIMARY KEY.
You must determine if any customers' details have been entered more than once using a different CUSTNO, by listing all duplicate names.
Which two methods can you use to get the required result?

• A. PULL OUTER JOIN with self join
• B. LEFT OUTER JOIN with self join
• C. subquery
• D. self Join
• E. RIGHT OUTER JOIN with self join

正解：C、D

質問 # 154
View the Exhibit and examine the data in the PRODUCT_INFORMATION table.
Which two tasks would require subqueries? (Choose two.)

• A. displaying the total number of products supplied by supplier 102071 and having product status OBSOLETE
• B. displaying all the products whose minimum list prices are more than average list price of products having the status orderable
• C. displaying all supplier IDs whose average list price is more than 500
• D. displaying the number of products whose list prices are more than the average list price
• E. displaying the minimum list price for each product status

正解：B、D

質問 # 155
View the Exhibit and examine the structure of the ORDERS table.

Which UPDATE statement is valid?

• A. UPDATE ordersSET order_date = '12-mar-2007',order_total IS NULLWHERE order_id = 2455;
• B. UPDATE ordersSET order_date = TO_DATE('12-mar-2007','dd-mon-yyyy'),SET order_total = TO_NUMBER (NULL)WHERE order_id = 2455;
• C. UPDATE ordersSET order_date = '12-mar-2007',AND order_total = TO_NUMBER(NULL)WHERE order_id = 2455;
• D. UPDATE ordersSET order_date = '12-mar-2007',order_total = NULLWHERE order_id = 2455;

正解：D

質問 # 156
Examine the structure of the BOOKS_TRANSACTIONStable.

You want to update this table such that BOOK_IDis set to 'INVALID'for all rows where no MEMBER_ID has been entered.
Examine this partial SQL statement:

Which condition must be used in the WHEREclause to perform the required update?
MEMBER_ID = '';

• A. MEMBER_ID IS NULL;
• B. MEMBER_ID = "";
• C. MEMBER_ID = NULL;
• D.

正解：A

質問 # 157
The SQL statements executed in a user session are as follows:

Which two statements describe the consequences of issuing the ROLLBACK TO SAVE POINT a command in the session? (Choose two.)

• A. Only the second DELETE statement is rolled back.
• B. No SQL statements are rolled back.
• C. Only the DELETE statements are rolled back.
• D. Both the DELETE statements and the UPDATE statement are rolled back.
• E. The rollback generates an error.

正解：B、E

質問 # 158
Examine this description of the PRODUCTS table:

You successfully execute this command:

Which two statements execute without errors? (Choose two.)

• A.
• B.
• C.
• D.

正解：B

質問 # 159
You execute these commands:
CREATE TABLE customers (customer id INTEGER, customer name VARCHAR2 (20));
INSERT INTO customers VALUES (1,'Custmoer1 ');
SAVEPOINT post insert;
INSERT INTO customers VALUES (2, 'Customer2 ');
<TODO>
SELECTCOUNT (*) FROM customers;
Which two, used independently, can replace <TODO> so the query retums 1?

• A. CONOIT TO SAVEPOINT post_ insert;
• B. ROLLBACK;
• C. ROLLEBACK TO post_ insert;
• D. COMMIT;
• E. ROLIBACK TO SAVEPOINT post_ insert;

正解：C、E

質問 # 160
View the Exhibit and examine the data in the PRODUCTS table. (Choose the best answer.)

You must display product names from the PRODUCTS table that belong to the 'Software/other' category with minimum prices as either $2000 or $4000 and with no unit of measure.
You issue this query:
SQL > SELECT prod_name, prod_category, prod_min_price FROM products
Where prod_category LIKE '%Other%' AND (prod_min_price = 2000 OR prod_min_price = 4000) AND prod_unit_of_measure <> ' '; Which statement is true?

• A. It generates an error because the condition specified for PROD_UNIT_OF_MEASURE is not valid.
• B. It executes successfully but returns no result.
• C. It executes successfully and returns the required result.
• D. It generates an error because the condition specified for the PROD_CATEGORY column is not valid.

正解：B

質問 # 161
Examine the structure of the CUSTOMERS table: (Choose two.)

CUSTNO is the PRIMARY KEY.
You must determine if any customers' details have been entered more than once using a different CUSTNO, by listing all duplicate names.
Which two methods can you use to get the required result?

• A. Full outer-join with self-join
• B. Self-join
• C. Subquery
• D. Right outer-join with self-join
• E. Left outer-join with self-join

正解：B、C

質問 # 162
Examine this query which executes successfully:
SELECT job, deptno FROM emp
UNION ALL
SELECT job, deptno FROM jobs_ history;
What will be the result?

• A. It will return rows common to both SELECT statements.
• B. It will return rows from both SELECT statements after eliminating duplicate rows.
• C. It will return rows that are not common to both SELECT statements.
• D. It will return rows from both SELECT statements including duplicate rows.

正解：D

解説：
The UNION ALL operator in SQL is used to combine the results of two or more SELECT statements:
* Option D: It will return rows from both SELECT statements including duplicate rows.
* UNION ALL does not eliminate duplicates; it simply combines all rows from the queries provided.
Options A, B, and C are incorrect as they describe behaviors of other set operators:
* Option A: Describes the behavior of INTERSECT, not UNION ALL.
* Option B: Describes the behavior of UNION, not UNION ALL.
* Option C: Describes the behavior of EXCEPT or MINUS, not UNION ALL.

質問 # 163
Which two tasks can be performed by using Oracle SQL statements? (Choose two.)

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

正解：A、E

解説：
References:
http://www.techonthenet.com/oracle/password.php
https://docs.oracle.com/cd/B28359_01/server.111/b28324/tdpii_distdbs.htm

質問 # 164
Examine this query which executes successfully;
Select job,deptno from emp
Union all
Select job,deptno from jobs_history;
What will be the result?

• A. It will return rows that are not common to both select statements.
• B. It will return rows from both select statements after eliminating duplicate rows.
• C. It will return rows both select statements including duplicate rows.
• D. It will return rows common to both select statements.

正解：C

解説：
For the provided UNION ALL query:
* Option C: It will return rows from both SELECT statements including duplicate rows.
* UNION ALL is used to combine the results of two SELECT statements and does not eliminate duplicates.
Options A, B, and D are incorrect because:
* Option A: UNION ALL does not eliminate duplicate rows, unlike UNION.
* Option B: This would be true for INTERSECT, not UNION ALL.
* Option D: This would be true for EXCEPT or MINUS, not UNION ALL.

質問 # 165
Examine this SQL statement:

Which two are true?

• A. The subquery is executed for every row in the employees table.
• B. The subquery is not a correlated subquery.
• C. All existing rows in the EMPLOYEES table are deleted.
• D. The subquery is executed before the DELETE statement is executed.
• E. The DELETE statement executes successfully even if the subquery selects multiple rows.

正解：A、D

質問 # 166
View the Exhibit and examine the structure of the ORDERS table.

You must select ORDER_ID and ORDER_DATE for all orders that were placed after the last order placed by CUSTOMER_ID 101.
Which query would give you the desired result?

• A. SELECT order_id, order_date FROM orders
  WHERE order_date > ALL
  (SELECT MAX(order_date) FROM orders ) AND customer_id = 101;
• B. SELECT order_id, order_date FROM orders
  WHERE order_date >
  ANY
  (SELECT order_date FROM orders WHERE customer_id = 101);
• C. SELECT order_id, order_date FROM orders
  WHERE order_date > ALL
  (SELECT order_date FROM orders WHERE customer_id = 101);
• D. SELECT order_id, order_date FROM orders
  WHERE order_date > IN
  (SELECT order_date FROM orders WHERE customer_id = 101);

正解：C

解説：
Explanation

質問 # 167
In which three situations does a transaction complete?

• A. when a TRUNCATE statement is executed after the pending transaction
• B. when a ROLLBACK command is executed
• C. when a DELETE statement is executed
• D. when a PL/SQL anonymous block is executed
• E. when a data definition language (DDL) statement is executed

正解：A、B、E

解説：
References:
https://docs.oracle.com/cd/B19306_01/server.102/b14220/transact.htm

質問 # 168
View the Exhibit and examine the structure of the PROMOTIONS table.

Evaluate the following SQL statement:

Which statement is true regarding the outcome of the above query?

• A. It produces an error because the subquery gives an error.
• B. It shows COST_REMARKfor all the promos in the table.
• C. It produces an error because subqueries cannot be used with the CASEexpression.
• D. It shows COST_REMARKfor all the promos in the promo category 'TV'.

正解：B

質問 # 169
View the Exhibit for the structure of the STUDENT and FACULTY tables.

You need to display the faculty name followed by the number of students handled by the faculty at the base location. Examine the following two SQL statements:

Which statement is true regarding the outcome?

• A. Only statement 1 executes successfully and gives the required result.
• B. Both statements 1 and 2 execute successfully and give the same required result.
• C. Both statements 1 and 2 execute successfully and give different results.
• D. Only statement 2 executes successfully and gives the required result.

正解：B

質問 # 170
......

Oracle 1Z0-071認定試験は、73の複数選択の質問で構成されるコンピューターベースの試験です。試験の長さは105分で、候補者は合格するために少なくとも63％のスコアを達成する必要があります。この試験は、英語、日本、簡素化された中国語を含む複数の言語で利用できます。

 

試験合格保証付きのOracle PL/SQL Developer Certified Associate 1z0-071試験問題集：https://jp.fast2test.com/1z0-071-premium-file.html

Oracle 1z0-071日常練習試験は2026年最新のに更新された437問あります：https://drive.google.com/open?id=1k09O34PMzsnA0H-sRSRAYQeNEYZIYT_8