• ホーム
  • ブログ
  • [Q115-Q138] トップクラスOracle 1z1-071オンライン問題集で更新された[2024年10月]

[Q115-Q138] トップクラスOracle 1z1-071オンライン問題集で更新された[2024年10月]

Share

トップクラスOracle 1z1-071オンライン問題集で更新された[2024年10月]

1z1-071練習問題集で検証済みのPassTest更新された323問題あります


Oracle 1z1-071認定試験は、Oracle Database SQLにおけるスキルと知識を証明したいデータベースプロフェッショナル向けの人気のある認定試験です。この試験は、データベースからデータを取得、挿入、更新、および削除するためのSQLクエリの作成能力を個人の能力を検証します。試験は、Oracle Database 12c以降のバージョンでの作業経験がある個人向けに設計されています。


Oracle 1Z1-071認定試験は、Oracleデータベースを使用してSQLプログラミングで個人の知識とスキルをテストするように設計されています。この試験は、Oracle SQLの開発と管理の専門知識を証明したい個人を対象としています。この試験に合格すると、SQLを使用してOracleデータベース環境でデータを管理および操作する候補者のスキルが検証されます。

 

質問 # 115
Which two statements are true regarding the WHERE and HAVING clauses in a SELECT statement? (Choose two.)

  • A. The WHERE clause can be used to exclude rows before dividing them into groups.
  • B. The WHERE and HAVING clauses can be used in the same statement only if they are applied to different columns in the table.
  • C. The WHERE clause can be used to exclude rows after dividing them into groups.
  • D. The aggregate functions and columns used in the HAVING clause must be specified in the SELECT list of the query.
  • E. The HAVING clause can be used with aggregate functions in subqueries.

正解：C、E


質問 # 116
View the Exhibit and examine the description of the EMPLOYEES table.

You want to calculate the total remuneration for each employee. Total remuneration is the sum of the annual salary and the percentage commission earned for a year. Only a few employees earn commission.
Which SQL statement would you execute to get the desired output?

  • A. SELECT first_name, salary, salary*12+salary*commission_pct "Total"FROM EMPLOYEES;
  • B. SELECT first_name, salary (salary + NVL (commission_pct, 0)*salary)*12 "Total"FROM EMPLOYEES;
  • C. SELECT first_name, salary, salary*12 + NVL(salary,0)*commission_pct, "Total"FROM EMPLOYEES;
  • D. SELECT first_name, salary, salary*12+(salary*NVL2 (commission_pct,
    salary,salary+commission_pct))"Total"FROM EMPLOYEES;

正解：D


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

There is only one customer with the cust_last_name column having value Roberts. 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(SELECT o.order_id, o.order_date, o.order_mode, c.customer_id, o.order_totalFROM orders o, customers cWHERE o.customer_id = c.customer_idAND c.cust_last_name='Roberts' AND c.credit_limit=600 )VALUES (1, '10-mar-2007', 'direct', (SELECT customer_idFROM customersWHERE cust_last_name='Roberts' ANDcredit_limit=600), 1000);
  • B. INSERT INTO ordersVALUES(1, '10-mar-2007', 'direct',(SELECT customer_idFROM customersWHERE cust_last_name='Roberts' ANDcredit_limit=600), 1000);
  • C. INSERT INTO orders (order_id, order_data, order_mode,(SELECT customer_idFROM customersWHERE cust_last_name='Roberts' ANDcredit_limit=600), order_total)VALUES(1, '10-mar-2007', 'direct', &&customer_id, 1000);
  • D. INSERT INTO orders (order_id, order_data, order_mode,(SELECT customer_idFROM customersWHERE cust_last_name='Roberts' ANDcredit_limit=600), order_total)VALUES (1, '10-mar-2007', 'direct', &customer_id, 1000).

正解：B


質問 # 118
Which normal form is a table in if it has no multi-valued attributes and no partial dependencies?

  • A. second normal form
  • B. fourth normal form
  • C. first normal form
  • D. third normal form

正解：A

解説：
Explanation/Reference:
References:
https://blog.udemy.com/database-normal-forms/


質問 # 119
Which three statements indicate the end of a transaction? (Choose three.)

  • A. after a CREATEstatement is issued
  • B. after a ROLLBACKis issued
  • C. after a SELECTstatement is issued
  • D. after a COMMITis issued
  • E. after a SAVEPOINTis issued

正解：A、B、D


質問 # 120
View the exhibit and examine the structure of the CUSTOMERStable.

Which two tasks would require subqueries or joins to be executed in a single statement?

  • A. finding the average credit limit of male customers residing in 'Tokyo'or 'Sydney'
  • B. finding the number of customers, in each city, who's marital status is 'married'.
  • C. finding the number of customers, in each city, whose credit limit is more than the average credit limit of all the customers
  • D. listing of those customers, whose credit limit is the same as the credit limit of customers residing in the city 'Tokyo'.
  • E. listing of customers who do not have a credit limit and were born before 1980

正解：C、D


質問 # 121
You need to display the date 11-oct-2007 in words as 'Eleventh of October, Two Thousand Seven'.
Which SQL statement would give the required result?

  • A. SELECT TO_DATE (TO_CHAR ('11-oct-2007'), 'fmDdspth "of" Month, Year')) FROM DUAL
  • B. SELECT TO_CHAR (TO_DATE ('11-oct-2007'), 'fmDdspth of month, year')
    FROM DUAL
  • C. SELECT TO_CHAR ('11-oct-2007', 'fmDdspth "of" Month, Year')
    FROM DUAL
  • D. SELECT TO_CHAR (TO_DATE ('11-oct-2007'), 'fmDdthsp "of" Month, Year') FROM DUAL

正解：B


質問 # 122
Examine the description of the CUSTOMERStable:

You need to display last names and credit limits of all customers whose last name starts with A or B in lower or upper case, and whose credit limit is below 1000.
Examine this partial query:

Which two WHEREconditions give the required result? (Choose two.)

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

正解：A、D


質問 # 123
Examine this SELECT statement and view the Exhibit to see its output:

SELECT constraints_name, constraints_type, search_condition, r_constraint_name, delete_rule, status, FROM user_constraints WHERE table_name = 'ORDERS'; Which two statements are true about the output? (Choose two.)

  • A. The R_CONSTRAINT_NAME column contains an alternative name for the constraint.
  • B. The STATUS column indicates whether the table is currently in use.
  • C. The DELETE_RULE column indicates the desired state of related rows in the child table when the corresponding row is deleted from the parent table.
  • D. In the second column, 'c' indicates a check constraint.

正解：C、D


質問 # 124
Examine the description of the PRODUCTS table:

Which two statements execute without errors?

  • A. MERGE INTO new_prices n
    USING (SELECT * FROM products WHERE cost>150) p
    ON (n.prod_id= p.prod_id)
    WHEN MATCHED THEN
    DELETE WHERE (p.cost<200)
  • B. MERGE INTO new_prices n
    USING products p
    ON (p.prod_id =n.prod_id)
    WHEN NOT MATCHED THEN
    INSERT (n.prod _id, n.price) VALUES (p.prod_id, cost*.01)
    WHERE (p.cost<200);
  • C. MERGE INTO new_prices n
    USING (SELECT * FROM products WHERE cost>150) p
    ON (n.prod_id= p.prod_id)
    WHEN MATCHED THEN
    UPDATE SET n.price= p.cost*.01
    DELETE WHERE (p.cost<200);
  • D. MERGE INTO new_prices n
    USING (SELECT * FROM products) p
    WHEN MATCHED THEN
    UPDATE SET n.price= p.cost* 01
    WHEN NOT MATCHED THEN
    INSERT(n.prod_id, n.price) VALUES(p.prod_id, cost*.01)
    WHERE(p.cost<200);

正解：C

解説：
B: True. This MERGE statement should execute without errors. It uses a conditionally filtered selection from the products table as a source to update or delete rows in the new_prices table based on whether the prod_id matches and the cost is greater than 150. The delete operation within a MERGE statement is allowed in Oracle when a WHEN MATCHED clause is specified.
The MERGE statement is correctly structured with a USING clause that includes a subquery with a valid WHERE condition, an ON condition that specifies how to match rows between the source and the target, and a WHEN MATCHED THEN clause that specifies the update and delete operations based on the cost condition.
References:Oracle SQL documentation specifies that within a MERGE statement, you can specify a WHEN MATCHED clause to update and/or delete rows in the target table based on the condition specified after the DELETE keyword.


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

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

正解：B、F


質問 # 126
Examine the structure of the SALES table.

Examine this statement:

Which two statements are true about the SALES1 table? (Choose two.)

  • A. It will have NOT NULL constraints on the selected columns which had those constraints in the SALES table.
  • B. It will not be created because the column-specified names in the SELECT and CREATE TABLE clauses do not match.
  • C. It has PRIMARY KEY and UNIQUE constraints on the selected columns which had those constraints in the SALES table.
  • D. It is created with no rows.
  • E. It will not be created because of the invalid WHERE clause.

正解：A、D


質問 # 127
View the Exhibit and examine the structure of ORDERS and ORDER_ITEMS tables.
ORDER_ID is the primary key in the ORDERS table. It is also the foreign key in the ORDER_ITEMS table wherein it is created with the ON DELETE CASCADE option.
Which DELETE statement would execute successfully?

  • A. DELETE ordersWHERE order_total < 1000;
  • B. DELETEFROM ordersWHERE (SELECT order_idFROM order_items);
  • C. DELETE orders o, order_items IWHERE o.order_id = i.order_id;
  • D. DELETE order_idFROM ordersWHERE order_total < 1000;

正解：B


質問 # 128
Which two are true about dropping columns from a table?

  • A. A column can be removed only if it contains no data.
  • B. A column drop is implicitly committed.
  • C. A column that is referenced by another column in any other table cannot be dropped.
  • D. A column must be set as unused before it is dropped from a table.
  • E. Multiple columns can be dropped simultaneously using the ALTER TABLEcommand.
  • F. A primary key column cannot be dropped.

正解：E、F

解説：
Explanation/Reference: https://oracle-base.com/articles/8i/dropping-columns


質問 # 129
Which three statements are true regarding indexes?

  • A. A SELECT statement can access one or more indices without accessing any tables.
  • B. An update to a table can result in no updates to any of the table's indexes.
  • C. An update to a table can result in updates to any or all of the table's indexes.
  • D. When a table is dropped and is moved to the RECYCLE BIN, all Indexes built on that table are permanently dropped.
  • E. A UNIQUE index can be altered to be non-unique.
  • F. A table belonging to one user can have an index that belongs to a different user,

正解：B、D、F


質問 # 130
Examine the commands used to create DEPARTMENT_DETAILS and COURSE_DETAILS tables:

You want to generate a list of all department IDs that do not exist in the COURSE_DETAILS table.
You execute the SQL statement:

What is the outcome?

  • A. It fails because the ON clause condition is not valid.
  • B. It executes successfully but displays an incorrect list.
  • C. It fails because the join type used is incorrect.
  • D. It executes successfully and displays the required list.

正解：D


質問 # 131
Examine the description of the MEMBERStable:

Examine the partial query:
SELECT city, last_name LNAME FROM members ...;
You want to display all cities that contain the string AN. The cities must be returned in ascending order, with the last names further sorted in descending order.
Which two clauses must you add to the query? (Choose two.)

  • A. WHERE city IN ('%AN%')
  • B. ORDER BY last_name DESC, city ASC
  • C. ORDER BY 1, 2
  • D. WHERE city LIKE '%AN%'
  • E. WHERE city = '%AN%'
  • F. ORDER BY 1, LNAME DESC

正解：B、F

解説：
Explanation/Reference: https://www.techonthenet.com/sql/order_by.php
https://www.studytonight.com/dbms/orderby-clause.php


質問 # 132
You want to return the current date and time from the user session, with a data type of TIMESTAMP WITH TIME ZONE.
Which function will do this?

  • A. SYSDATE
  • B. CURRENT_ TIMESTAMP
  • C. CURRENT DATE
  • D. LOCALTIMESTAMP

正解：B

解説：
* A: CURRENT_DATE returns the current date in the session time zone, not with a TIMESTAMP WITH TIME ZONE data type.
* B: CURRENT_TIMESTAMP returns the current date and time in the session time zone with a TIMESTAMP WITH TIME ZONE data type. This is correct.
* C: SYSDATE returns the current date and time from the operating system of the database server in the DATE data type.
* D: LOCALTIMESTAMP returns the current date and time in the session time zone with a TIMESTAMP data type, without the TIME ZONE.
The TIMESTAMP WITH TIME ZONE data type and relevant functions are documented in the Oracle Database SQL Language Reference 12c.


質問 # 133
Which three statements are true about time zones, date data types, and timestamp data types in an Oracle database?

  • A. The DBTIMEZONE function can return an offset from Universal Coordinated Time (UTC).
  • B. A TIMESTAMP data type column contains information about year, month, and day.
  • C. A TIMESTAMP WITH LOCAL TIMEZONE data type column is stored in the database using the time zone of the session that inserted the row.
  • D. The CURRENT_TIMESTAMP function returns data without time zone information.
  • E. The SESSIONTIMEZONE function can return an offset from Universal Coordinated Time (UTC).

正解：A、D、E


質問 # 134
You must display details of all users whose username contains the string 'ch_'. (Choose the best answer.) Which query generates the required output?

  • A. SELECT * FROM users
    Where user_name LIKE '%ch_%'ESCAPE'%';
  • B. SELECT * FROM users
    Where user_name LIKE '%ch_';
  • C. SELECT * FROM users
    Where user_name LIKE 'ch\_%' ESCAPE '_';
  • D. SELECT * FROM users
    Where user_name LIKE '%ch\_%' ESCAPE '\';

正解：A


質問 # 135
Which two are true about dropping columns from a table?

  • A. A column drop is implicitly committed.
  • B. A column can be removed only if it contains no data.
  • C. A primary key column cannot be dropped.
  • D. A column that is referenced by another column in any other table cannot be dropped.
  • E. A column must be set as unused before it is dropped from a table.
  • F. Multiple columns can be dropped simultaneously using the ALTER TABLE command.

正解：A、D、F


質問 # 136
In the PROMOTIONS table, the PROMO_ BEGIN_DATE column is of data type and the default date format is DD-MON-RR
Which two statements are true about expressions using PROMO_ BEGIN_DATE in a query?

  • A. PROMO_ BEGIN_DATE - SYSDATE will return an error
  • B. PROMO_ BEGIN_DATE - 5 will return a date
  • C. PROMO_ BEGIN_DATE - SYSDATE will return a number
  • D. TODATE(PROMO BEGIN_DATE *5) will return a date
  • E. TONUMBER (PROMO BEGIN_DATE) - 5 will return a number

正解：B、C


質問 # 137
Examine the description of the PRODUCT_STATUS table:

The STATUS column contains the values 'IN STOCK' or 'OUT OF STOCK' for each row.
Which two queries will execute successfully?

  • A. Option E
  • B. Option C
  • C. Option B
  • D. Option A
  • E. Option F
  • F. Option D

正解：A、C


質問 # 138
......

最新（2024)Oracle 1z1-071試験問題集：https://www.passtest.jp/Oracle/1z1-071-shiken.html

更新された1z1-071試験問題集でPDF問題とテストエンジン：https://drive.google.com/open?id=1WP9zr5LFY8fSnOQNxqNwU6xz9jyDQPxj

関するブログ

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