最新 [2023年12月19日] リアルOracle 1z0-071試験問題集解答 [Q125-Q142]

最新 [2023年12月19日] リアルOracle 1z0-071試験問題集解答

1z0-071問題集を使って一日でOracle PL/SQL Developer Certified Associate試験合格（最新の305解答)

Oracleの1z0-071試験は、候補者のSQLクエリの作成と管理、およびSQLを使用したデータの操作能力を測定します。この試験は、100分以内に完了する必要がある73の多肢選択問題から構成されています。試験の合格スコアは63％以上です。試験でカバーされるトピックには、SQLを使用したデータの取得、データ操作とトランザクション制御、テーブルの作成と管理、およびスキーマオブジェクトの管理が含まれます。

Oracle 1z1-071 試験は、73問の多肢選択問題からなるコンピュータベースの試験です。試験時間は100分で、合格するには少なくとも63%の得点が必要です。試験は英語、日本語、ポルトガル語など、いくつかの言語で利用可能です。

 

質問 # 125
Which three statements are true about GLOBAL TEMPORARY TABLES?

• A. A GLOBAL TEMPORARY TABLE can have only one index.
• B. A GLOBAL TEMPORARY TABLE can have multiple indexes.
• C. Data Manipulation Language (DML) on GLOBAL TEMPORARY TABLES generates no REDO.
• D. A trigger can be created on a GLOBAL TEMPORARY TABLE.
• E. A GLOBAL TEMPORARY TABLE can be referenced in the defining query of a view.
• F. A GLOBAL TEMPORARY TABLE cannot have a PUBLIC SYNONYM.

正解：C、D、E

質問 # 126
Examine the business rule:
Each student can work on multiple projects and each project can have multiple students.
You must design an Entity Relationship (ER) model for optimal data storage and allow for generating reports in this format:
STUDENT_ID FIRST_NAME LAST_NAME PROJECT_ID PROJECT_NAME PROJECT_TASK
Which two statements are true? (Choose two.)

• A. The ER must have a 1-to-many relationship between the STUDENTSand PROJECTSentities.
• B. STUDENT_IDmust be the primary key in the STUDENTSentity and foreign key in the PROJECTSentity.
• C. An associative table must be created with a composite key of STUDENT_ID and PROJECT_ID, which is the foreign key linked to the STUDENTS and PROJECTS entities.
• D. PROJECT_IDmust be the primary key in the PROJECTSentity and foreign key in the STUDENTSentity.
• E. The ER must have a many-to-many relationship between the STUDENTSand PROJECTS entities that must be resolved into 1-to-many relationships.

正解：C、E

解説：
Explanation/Reference:
References:
http://www.oracle.com/technetwork/issue-archive/2011/11-nov/o61sql-512018.html

質問 # 127
Which two statements are true regarding the COUNT function? (Choose two.)

• A. The COUNT function can be used only for CHAR, VARCHAR2, and NUMBER data types.
• B. COUNT(cust_id) returns the number of rows including rows with duplicate customer IDs and NULLs in the CUST_ID column.
• C. COUNT(*) returns the number of rows including duplicate rows and rows containing NULL value in any column.
• D. A SELECT statement using the COUNT function with a DISTINCT keyword cannot have a WHERE clause.
• E. COUNT(DISTINCT inv_amt) returns the number of rows excluding rows containing duplicates and NULLs in the INV_AMT column.

正解：C、E

質問 # 128
Examine the structure of the BOOKS_TRANSACTIONS table:

Examine the SQL statement:

Which statement is true about the outcome?

• A. It displays details for only members A101 and A102 who have borrowed before today with RM TRANSACTION_TYPE.
• B. It displays details for members who have borrowed before today's date with either RM as TRANSACTION_TYPE or MEMBER_ID as A101 and A102.
• C. It displays details for members who have borrowed before today with RM as TRANSACTION_TYPE and the details for members A101 or A102.
• D. It displays details only for members who have borrowed before today with RM as TRANSACTION_TYPE.

正解：C

質問 # 129
In your session , the NLS_DATE_FORMAT is DD_MM_YYYY.
There are 86400 seconds in a day.
Examine this result:

Which statement returns this?

• A. SELECT TO_CHAR (TO_DATE ('29-10-2019') + INTERVAL '2' MONTH + INTERVAL '6' DAY INTEVAL '120 SECOND DD-MON-YYYY) AS ''DATE''
• B. SELECT TO_CHAR (TO_DATE ('29-10-2019') + INTERVAL '3' MONTH + INTERVAL '7' DAY INTEVAL '120 SECOND DD-MON-YYYY) AS ''DATE''
• C. SELECT TO_CHAR (TO_DATE ('29-10-2019') + INTERVAL '2' MONTH + INTERVAL '6' DAY INTEVAL '120 SECOND DD-MON-YYYY) AS ''DATE''
• D. SELECT TO_CHAR (TO_DATE ('29-10-2019') + INTERVAL '2' MONTH + INTERVAL '5' DAY INTEVAL '120 SECOND DD-MON-YYYY) AS ''DATE''
• E. SELECT TO_CHAR (TO_DATE ('29-10-2019') + INTERVAL '2' MONTH + INTERVAL '4' DAY INTEVAL '120 SECOND DD-MON-YYYY) AS ''DATE''

正解：B

質問 # 130
Which two statements are true about a full outer join?

• A. It includes rows that are returned by an inner join.
• B. It returns matched and unmatched rows from both tables being joined.
• C. It includes rows that are returned by a Cartesian product.
• D. It returns only unmatched rows from both tables being joined.
• E. The Oracle join operator (+) must be used on both sides of the join condition in the WHERE clause.

正解：A、B

質問 # 131
What is the primary difference between the relational database (RDB) and object-oriented database (OODB) models?

• A. RDB allows the definition of relationships between different tables, whereas OODB does not allow this.
• B. OODB supports multiple objects in the same database, whereas RDB supports only tables.
• C. RDB supports only E.F. Codd's rules, whereas OODB does not support them.
• D. OODB incorporates methods with data structure definition, whereas RDB does not allow this.

正解：D

質問 # 132
View the Exhibit and examine the data in the PRODUCT_INFORMATIONtable.

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 the number of products whose list prices are more than the average list price
• C. displaying the minimum list price for each product status
• D. displaying all the products whose minimum list prices are more than average list price of products having the status orderable
• E. displaying all supplier IDs whose average list price is more than 500

正解：B、D

質問 # 133
View the exhibit and examine the ORDERStable.
ORDERS
Name Null? Type
ORDER ID NOT NULL NUMBER(4)
ORDATE DATE DATE
CUSTOMER ID NUMBER(3)
ORDER TOTAL NUMBER(7,2)
The ORDERStable contains data and all orders have been assigned a customer ID. Which statement would add a NOTNULLconstraint to the CUSTOMER_IDcolumn?

• A. ALTER TABLE orders
  ADD customer_id NUMBER(6)CONSTRAINT orders_cust_id_nn NOT NULL;
• B. ALTER TABLE orders
  MODIFY customer_id CONSTRAINT orders_cust_nn NOT NULL (customer_id);
• C. ALTER TABLE orders
  ADD CONSTRAINT orders_cust_id_nn NOT NULL (customer_id);
• D. ALTER TABLE orders
  MODIFY CONSTRAINT orders_cust_id_nn NOT NULL (customer_id);

正解：B

質問 # 134
Which two statements are true about Data Manipulation Language (DML) statements?

• A. An UPDATE... SET...statement can modify multiple rows based on multiple conditions on a table.
• B. An UPDATE....SET....statement can modify multiple rows based on only a single condition on a table.
• C. An INSERT INTO... VALUES..... statement can add a single row based on multiple conditions on a table.
• D. A DELETE FROM.....statement can remove rows based on only a single condition on a table.
• E. An INSERTINTO...VALUES..statement can add multiple rows per execution to a table.
• F. A DELETE FROM.....statement can remove multiple rows based on multiple conditions on a table.

正解：A、F

解説：
Explanation/Reference:
References:
http://www.techonthenet.com/sql/and_or.php

質問 # 135
View the Exhibit and examine the structure of ORDERS and CUSTOMERS tables. (Choose the best answer.)

You executed this UPDATE statement:

Which statement is true regarding the execution?

• A. It would not execute because a subquery cannot be used in the WHERE clause of an UPDATE statement.
• B. It would not execute because two tables cannot be referenced in a single UPDATE statement.
• C. It would not execute because a SELECT statement cannot be used in place of a table name.
• D. It would execute and restrict modifications to the columns specified in the SELECT statement.

正解：D

質問 # 136
The ORDERStable has a primary key constraint on the ORDER_IDcolumn.
The ORDER_ITEMStable has a foreign key constraint on the ORDER_IDcolumn, referencing the primary key of the ORDERStable.
The constraint is defined with ON DELETE CASCADE.
There are rows in the ORDERStable with an ORDER_TOTALof less than 1000.
Which three DELETEstatements execute successfully?
DELETE order_id FROM orders WHERE order_total < 1000;

• A. DELETE orders WHERE order_total < 1000;
• B. DELETE FROM orders;
• C.
• D. DELETE FROM orders WHERE order_total < 1000;
• E. DELETE * FROM orders WHERE order_total < 1000;

正解：A、C、E

質問 # 137
Which two statements are true about Data Manipulation Language (DML) statements?

• A. AH INSERT INTO. . .VALUES. . statement can add multiple rows per execution to a table.
• B. An UPDATE...SET... statement can modify multiple rows based on multiple conditions on a table.
• C. An INSERT INTO...VALUES..... statement can add a single row based on multiple conditions on a table.
• D. An UPDATE...SET.... statement can modify multiple rows based on only a single condition on a table.
• E. A DELETE FROM ..... statement can remove rows based on only a single condition on a table.
• F. A DELETE FROM..... statement can remove multiple rows based on multiple conditions on a table.

正解：A、E

質問 # 138
Examine this SQL statement
DELETE FROM employees e
WHERE EXISTS
(SELECT' dummy'
FROM emp history
WHERE employee_ id= e. employee id);
Which two are true?

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

正解：A、B

質問 # 139
View the exhibit and examine the descriptions of the DEPT and LOCATIONS tables.

You want to update the CITY column of the DEPT table for all the rows with the corresponding value in the CITY column of the LOCATIONS table for each department.
Which SQL statement would you execute to accomplish the task?

• A. UPDATE dept dSET city = (SELECT cityFROM locations lWHERE d.location_id = l.location_id);
• B. UPDATE dept dSET city = (SELECT cityFROM locations l)WHERE d.location_id = l.location_id;
• C. UPDATE dept dSET city = ALL (SELECT cityFROM locations lWHERE d.location_id = l.location_id);
• D. UPDATE dept dSET city = ANY (SELECT cityFROM locations l)

正解：A

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


Evaluate the following SQL statement:

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 promo with the lowest cost.
• C. It displays prod IDs in the promos with the highest cost in the same time interval.
• D. It displays prod IDs in the promos with the lowest cost in the same time interval.

正解：A

質問 # 141
View the Exhibit and examine the description of the ORDERS table. (Choose two.)

Which two WHERE clause conditions demonstrate the correct usage of conversion functions?

• A. WHERE TO_CHAR(Order_date, 'MON DD YYYY') = 'JAN 20 2003'
• B. WHERE Order_date > TO_CHAR(ADD_MONTHS(SYSDATE, 6), 'MON DD YYYY')
• C. WHERE Order_date > ( TO_DATE('JUL 10 2006', 'MON DD YYYY')
• D. WHERE Order_date_IN ( TO_DATE('OCT 21 2003', 'MON DD YYYY'), TO_CHAR('NOV
  21 2003', 'MON DD YYYY') )

正解：A、C

質問 # 142
......

Oracle 1Z1-071試験は、73の複数選択の質問で構成されるコンピューターベースの試験です。候補者は試験を完了するのに2時間あり、認定を獲得するために63％以上の合格スコアを達成する必要があります。この試験は、あらゆるOracle Testing Centerで、または世界中のPearson Vueテストセンターを介して撮影できます。

 

1z0-071試験正確な問題集で学習ノートと理論：https://www.jpntest.com/shiken/1z0-071-mondaishu

100% 高得点合格保証1z0-071無制限305解答：https://drive.google.com/open?id=11iZCo2CICOFQKFWkvQxwCJn4PaT9Edjv