• ホーム
  • ブログ
  • PDF問題（2025年最新）実際のOracle 1z0-071試験問題 [Q98-Q113]

PDF問題（2025年最新）実際のOracle 1z0-071試験問題 [Q98-Q113]

Share

PDF問題（2025年最新）実際のOracle 1z0-071試験問題

問題集返金保証付きの1z0-071問題集には90%オフされます


Oracle 1z1-071試験は、SQL SELECT文、データ操作言語、データ定義言語、データベースオブジェクト、およびデータベースセキュリティなど、さまざまなトピックに関する候補者の能力をテストします。候補者はSQLコードを記述および実行し、一般的なSQLエラーをトラブルシューティングする能力を示す必要があります。この試験は73問の多肢選択問題から構成され、候補者は105分間でテストを完了する必要があります。


Oracle 1z0-071 認定試験は、100分以内に完了する必要がある73個の多肢選択問題から構成されています。試験は、SQLの基礎、データの取得、データの操作、テーブルの作成、およびテーブルのメンテナンスなど、さまざまなトピックをカバーしています。候補者は、SQLプログラミングの概念を深く理解し、その知識を実世界のシナリオに適用できる必要があります。

 

質問 # 98
View the exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTSand TIMEStables.

The PROD_IDcolumn is the foreign key in the SALEStables, which references the PRODUCTStable.
Similarly, the CUST_IDand TIME_IDcolumns are also foreign keys in the SALEStable referencing the CUSTOMERSand TIMEStables, respectively.
Evaluate the following CREATE TABLEcommand:
CREATE TABLE new_sales (prod_id, cust_id, order_date DEFAULT SYSDATE)
AS
SELECT prod_id, cust_id, time_id
FROM sales;
Which statement is true regarding the above command?

  • A. The NEW_SALEStable would get created and all the NOTNULLconstraints defined on the specified columns would be passed to the new table.
  • B. The NEW_SALEStable would not get created because the DEFAULTvalue cannot be specified in the column definition.
  • C. The NEW_SALEStable would get created and all the FOREIGNKEYconstraints defined on the specified columns would be passed to the new table.
  • D. The NEW_SALEStable would not get created because the column names in the CREATETABLE command and the SELECTclause do not match.

正解：A


質問 # 99
Which three statements are true about single-row functions?

  • A. They return a single result row per table.
  • B. They can be nested to any level.
  • C. The argument can be a column name, variable, literal or an expression.
  • D. They can accept only one argument.
  • E. The data type returned can be different from the data type of the argument.
  • F. They can be used only in the WHERE clause of a SELECT statement.

正解：B、C、E

解説：
Single-row functions in SQL return one result per row, and the following statements are true:
A: The data type of the returned value can indeed be different from the data type of the argument provided to the function. For example, the TO_CHAR function can take a numeric input and return a character string.
B: Single-row functions can be nested within each other to any level that is supported by Oracle. This means you can have a function call as an argument to another function, and so on.
E: The argument to a single-row function can be a column name, a variable, a literal, or an expression. This flexibility allows these functions to be very powerful in SQL expressions.
The incorrect options are:
C: Single-row functions do not return a single result row per table; they return a result for each row that is processed.
D: They are not limited to accepting only one argument. Some functions, like NVL, accept multiple arguments.
F: They are not limited to use in the WHERE clause; single-row functions can be used in any part of a SQL statement, including SELECT and ORDER BY clauses.
Reference:
Oracle Documentation on Single-Row Functions: SQL Functions


質問 # 100
Which two statements are true about INTERVAL data types?

  • A. INTERVAL YEAR TO MONTH columns only support monthly intervals within a range of years.
  • B. The YEAR field in an INTERVAL YEAR TO MONTH column must be a positive value.
  • C. The value in an INTERVAL DAY TO SECOND column can be copied into an INTERVAL YEAR TO MONTH column.
  • D. INTERVAL YEAR TO MONTH columns support yearly intervals.
  • E. INTERVAL DAY TO SECOND columns support fractions of seconds.
  • F. INTERVAL YEAR TO MONTH columns only support monthly intervals within a single year.

正解：D、E


質問 # 101
In which three situations does a new transaction always start?

  • A. when issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT statement was issued in the same session
  • B. when issuing a CREATE TABLE statement after a SELECT statement was issued in the same session
  • C. when issuing a TRUNCATE statement after a SELECT statement was issued in the same session
  • D. when issuing a CREATE INDEX statement after a CREATE TABLE statement completed successfully in the same session
  • E. when issuing the first Data Manipulation Language (DML) statement after a COMMIT or ROLLBACK statement was issued in the same session
  • F. when issuing a DML statement after a DML statement failed in the same session

正解：A、E、F


質問 # 102
Examine the structure of the MEMBERS table: (Choose the best answer.)

Examine the SQL statement:
SQL > SELECT city, last_name LNAME FROM MEMBERS ORDER BY 1, LNAME DESC; What would be the result execution?

  • A. It displays all cities in descending order, within which the last names are further sorted in descending order.
  • B. It displays all cities in ascending order, within which the last names are further sorted in descending order.
  • C. It fails because a column number and a column alias cannot be used together in the ORDER BY clause.
  • D. It fails because a column alias cannot be used in the ORDER BY clause.

正解：B


質問 # 103
In which three situations does a new transaction always start?

  • A. When issuing a CREATE TABLE statement after a SELECT statement was issued in the same session
  • B. When issuing the first Data Manipulation Language (OML) statement after a COMMIT or ROLLBACK statement was issued in the same session
  • C. When issuing a SELECT FOR UPDATE statement after a CREATE TABLE AS SELECT statement was issued in the same session
  • D. When issuing a DML statement after a DML statement filed in the same session.
  • E. When issuing a TRUNCATE statement after a SELECT statement was issued in the same session
  • F. When issuing a CREATE INDEX statement after a CREATE TABLE statement completed unsuccessfully in the same session

正解：B、C、F


質問 # 104
View the exhibit and examine the data in the PROJ_TASK_DETAILS table. (Choose the best answer.) The PROJ_TASK_DETAILS table stores information about project tasks and the relation between them.
The BASED_ON column indicates dependencies between tasks.
Some tasks do not depend on the completion of other tasks.
You must generate a report listing all task IDs, the task ID of any task upon which it depends and the name of the employee in charge of the task upon which it depends.
Which query would give the required result?

  • A. SELECT p.task_id, p.based_on, d.task_in_chargeFROM proj_task_details p JOIN proj_task_details dON (p.task_id = d.task_id);
  • B. SELECT p.task_id, p.based_on, d.task_in_chargeFROM proj_task_details p LEFT OUTER JOIN proj_task_details dON (p.based_on = d.task_id);
  • C. SELECT p.task_id, p.based_on, d.task_in_chargeFROM proj_task_details p FULL OUTER JOIN proj_task_details dON (p.based_on = d.task_id);
  • D. SELECT p.task_id, p.based_on, d.task_in_chargeFROM proj_task_details p JOIN proj_task_details dON (p.based_on = d.task_id);

正解：B


質問 # 105
Examine the data in the CUSTOMERStable:

You want to list all cities that have more than one customer along with the customer details.
Evaluate the following query:

Which two JOIN options can be used in the blank in the above query to give the correct output? (Choose two.) LEFT OUTER JOIN

  • A. RIGHT OUTER JOIN
  • B. NATURAL JOIN
  • C. FULL OUTER JOIN
  • D. LEFT OUTER JOIN
  • E. JOIN

正解：A、E


質問 # 106
You have the privileges to create any type of synonym.
Which stalement will create a synonym called EMP for the HCM.EMPLOYEE_RECORDS table that is accesible to all users?

  • A. CREATE SYNONYM emp FOR hcm.employee_records;
  • B. CREATE GLOBAL SYNONYM emp FOR hcm.employee_records;
  • C. CREATE SYNONYM SYS.emp FOR hcm.employee_records;
  • D. CREATE SYNONYM PUBLIC.emp FOR hcm.employee_records;
  • E. CREATE PUBLIC SYNONYM emp FOR hcm. employee_records;

正解：E

解説：
Synonyms in Oracle are aliases for database objects that can simplify SQL statements for database users.
A: The term "GLOBAL" is not used in the creation of synonyms in Oracle.
B: The statement without the keyword PUBLIC will create a private synonym that is only accessible to the user creating the synonym, not all users.
C: The correct syntax does not include PUBLIC as a prefix to the synonym name itself, making this option incorrect.
D: You cannot specify the SYS schema for creating synonyms, as it is reserved for system objects.
E: This is the correct syntax to create a public synonym, which makes the underlying object accessible to all users.
References:
* Oracle Database SQL Language Reference, 12c Release 1 (12.1): "CREATE SYNONYM"


質問 # 107
You have the privileges to create any type of synonym.
Which statement will create a synonym called EMPfor the HCM.EMPLOYEE_RECORDS table that is accessible to all users?
CREATE PUBLIC SYNONIM emp FOR hcm.employee_records;

  • A. CREATE GLOBAL SYNONIM emp FOR hcm.employee_records;
  • B. CREATE SYNONIM SYS.emp FOR hcm.employee_records;
  • C. CREATE SYNONIM emp FOR hcm.employee_records;
  • D. CREATE SYNONIM PUBLIC.emp FOR hcm.employee_records;
  • E.

正解：A

解説：
CREATE PUBLIC SYNONYM emp_table
Reference: https://docs.oracle.com/database/121/SQLRF/statements_7001.htm#SQLRF01401


質問 # 108
MANAGER is an existing role with no privileges or roles.
EMP is an existing role containing the CREATE TABLE privilege.
EMPLOYEES is an existing table in the HR schema.
Which two commands execute successfully?

  • A. GRANT CREATE TABLE, emp TO manager;
  • B. GRANT SELECT, INSERT ON hr.employees TO manager WITH GRANT OPTION:
  • C. GRANT CREATE TABLE, SELECT ON hr. employees TO manager;
  • D. GRANT CREATE ANY SESSION, CREATE ANY TABLE TO manager;
  • E. GRANT CREATE SEQUENCE TO manager, emp;

正解：A、E


質問 # 109
Evaluate the following SQL statement:

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

  • A. It executes successfully but ignores the ORDER BY clause because it is not located at the end of the compound statement.
  • B. It executes successfully and displays rows in the descending order of PROMO_CATEGORY.
  • C. It produces an error because positional notation cannot be used in the ORDER BY clause with SET operators.
  • D. It produces an error because the ORDER BY clause should appear only at the end of a compound query-that is, with the last SELECT statement.

正解：D


質問 # 110
View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables.

Which INSERT statement should be used to add a row into the ORDERS table for the customer whose CUST LAST NAME is Roberts and CREDIT LIMIT is 600?

  • A. INSERT INTO orders
    VALUES (1,'10-mar-2007', 'direct',
    (SELECT customer_id
    FROM customers
    WHERE cust_last_name='Roberts' AND
    credit_limit=600), 1000);
  • B. INSERT INTO orders (order_id,order_date,order_mode,
    (SELECT customer_id
    FROM customers
    WHERE cust_last_name='Roberts' AND
    credit_limit=600) .order_total)
    VALUES(1 ,'10-mar-2007', 'direct', &&customer_id, 1000);
  • C. INSERT INTO orders (order_id.order_date.order_mode,
    (SELECT customer_id
    FROM customers
    WHERE cust_last_name='Roberts' AND
    credit _limit=600) .order_total)
    VALUES(1 ,'IO-mar-2007', 'direct', &customer_id, 1000);
  • D. INSERT INTO(SELECT o.order_id, o.order_date.o.orde_mode.c.customer_id, o.order_total FROM orders o, customers c WHERE o.customer_id = c.customer_id AND c.cust_last_name='Roberts'ANDc. Credit_limit=600) VALUES (1,'10-mar-2007', 'direct',(SELECT customer_id FROM customers WHERE cust_last_name='Roberts' AND Credit_limit=600), 1000);

正解：A


質問 # 111
You must create a SALES table with these column specifications and data types: (Choose the best answer.) SALESID: Number STOREID: Number ITEMID: Number QTY: Number, should be set to 1 when no value is specified SLSDATE: Date, should be set to current date when no value is specified PAYMENT: Characters up to 30 characters, should be set to CASH when no value is specified Which statement would create the table?

  • A. CREATE TABLE Sales(SALESID NUMBER (4),STOREID NUMBER (4),ITEMID
    NUMBER (4),QTY NUMBER DEFAULT = 1,SLSDATE DATE DEFAULT
    SYSDATE,PAYMENT VARCHAR2(30) DEFAULT = "CASH");
  • B. Create Table sales(salesid NUMBER (4),Storeid NUMBER (4),Itemid NUMBER (4),QTY NUMBER DEFAULT 1,Slsdate DATE DEFAULT SYSDATE,payment VARCHAR2(30) DEFAULT 'CASH');
  • C. CREATE TABLE Sales(SALESID NUMBER (4),STOREID NUMBER (4),ITEMID
    NUMBER (4),qty NUMBER DEFAULT = 1,SLSDATE DATE DEFAULT
    SYSDATE,PAYMENT VARCHAR2(30) DEFAULT = "CASH");
  • D. CREATE TABLE Sales(SALESID NUMBER (4),STOREID NUMBER (4),ITEMID
    NUMBER (4),QTY NUMBER DEFAULT = 1,SLSDATE DATE DEFAULT
    'SYSDATE',PAYMENT VARCHAR2(30) DEFAULT CASH);

正解：B


質問 # 112
View the exhibits and examine the structures of the COSTSand PROMOTIONStables.


Evaluate the following SQL statement:
SQL> SELECT prod_id FROM costs
WHERE promo_id IN (SELECT promo_id FROM promotions
WHERE promo_cost < ALL
( SELECT MAX(promo_cost) FROM promotions
GROUP BY (promo_end_date-
promo_begin_date)));
What would be the outcome of the above SQL statement?

  • A. It displays prod IDs in the promos which cost less than the highest cost in the same time interval.
  • B. It displays prod IDs in the promos with the lowest cost in the same time interval.
  • C. It displays prod IDs in the promo with the lowest cost.
  • D. It displays prod IDs in the promos with the highest cost in the same time interval.

正解：A


質問 # 113
......


Oracle 1Z0-071認定試験は、SQL開発者、データベース管理者、およびSQLの知識とスキルを検証したいデータベースアナリスト向けに設計されています。この試験では、データの操作、データ定義、データ制御言語など、SQLの基本について説明します。また、サブクエリ、セットオペレーター、データ集約などの高度なトピックも含まれています。

 

更新された2025年03月合格させる1z0-071試験リアル練習テスト問題：https://www.passtest.jp/Oracle/1z0-071-shiken.html

あなたを合格させる試験には100%確認済み1z0-071試験問題：https://drive.google.com/open?id=1Q8cvgApK0U25v3dxGpNCWdSqfgapD7Ns

関するブログ

もっと
1z0-071 無料問題集