1z0-071合格させる問題集でOracle24時間で試験合格できます [Q91-Q114]

1z0-071合格させる問題集でOracle24時間で試験合格できます

最新問題を使おう1z0-071試験問題と解答でPDFで一年間無料更新

質問 # 91
Examine the description of the PRODUCT_ DETAILS table:

Which two statements are true?

• A. PRODUCT_ ID can be assigned the PRIMARY KEY constraint.
• B. PRODUCT_ PRICE can be used in an arithmetic expression even if it has no value stored in it.
• C. PRODUCT_ PRICE contains the value zero by default if no value is assigned to it.
• D. EXPIRY_ DATE cannot be used in arithmetic expressions.
• E. EXPIRY_ DATE contains the SYSDATE by default if no date is assigned to it.
• F. PRODUCT_ NAME cannot contain duplicate values.

正解：A、B

質問 # 92
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 alias cannot be used in the ORDER BY clause.
• D. It fails because a column number and a column alias cannot be used together in the ORDER BY clause.

正解：B

質問 # 93
Which statement is true about SQL query processing in an Oracle database instance? (Choose the best answer.)

• A. During row source generation, rows that satisfy the query are retrieved from the database and stored in memory.
• B. During executing, the oracle server may read data from storage if the required data is not already in memory.
• C. During parsing, a SQL statement containing literals in the WHERE clause that has been executed by any session and which is cached in memory, is always reused for the current execution.
• D. During optimization, execution plans are formulated based on the statistics gathered by the database instance, and the lowest cost plan is selected for execution.

正解：B

質問 # 94
Examine this query:

Which two methods should you use to prevent prompting for a hire date value when this query is executed?
(Choose two.)

• A. Execute the SET VERIFY ONcommand before executing the query.
• B. Use the DEFINEcommand before executing the query.
• C. Store the query in a script and pass the substitution value to the script when executing it.
• D. Replace '&1'with '&&1'in the query.
• E. Use the UNDEFINEcommand before executing the query.
• F. Execute the SET VERIFY OFF command before executing the query.

正解：A、C

質問 # 95
You want to display the date for the first Monday of the next month and issue the following command:

What is the outcome?

• A. In generates an error because TO_CHAR should be replaced with TO_DATE.
• B. It executes successfully but does not return the correct result.
• C. In generates an error because fm and double quotation marks should not be used in the format string.
• D. In generates an error because rrrr should be replaced by rr in the format string.
• E. It executes successfully and returns the correct result.

正解：E

質問 # 96
View the Exhibit and examine the structure of the PRODUCT table.

Which two tasks would require subqueries? (Choose two.)

• A. display the minimum PROD_LIST_PRICE for each product status
• B. display all products whose PROD_MIN_PRICE is more than the average PROD_LIST_PRICE of all products, and whose status is orderable
• C. display the total number of products supplied by supplier 102 and have product status as 'OBSOLETE'
• D. display the number of products whose PROD_LIST_PRICE is more than the average PROD_LIST_PRICE.
• E. display suppliers whose PROD_LIST_PRICE is less than 1000

正解：B、D

質問 # 97
View the Exhibit and examine the structure of the EMPtable which is not partitioned and not an index-organized table. (Choose two.)

Evaluate this SQL statement:
ALTER TABLE emp
DROP COLUMN first_name;
Which two statements are true?

• A. The FIRST_NAMEcolumn would be dropped provided at least one column remains in the table.
• B. The drop of the FIRST_NAMEcolumn can be rolled back provided the SET UNUSEDoption is added to the SQL statement.
• C. The FIRST_NAMEcolumn would be dropped provided it does not contain any data.
• D. The FIRST_NAMEcolumn can be dropped even if it is part of a composite PRIMARY KEYprovided the CASCADEoption is added to the SQL statement.

正解：A

解説：
Explanation

質問 # 98
Examine the description of the PRODUCT_STATUStable:

The STATUScolumn contains the values IN STOCKor OUT OF STOCKfor each row.
Which two queries will execute successfully? (Choose two.)

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

正解：D、F

質問 # 99
Sales data of a company is stored in two tables, SALES1and SALES2, with some data being duplicated across the tables. You want to display the results from the SALES1table, which are not present in the SALES2table.

Which set operator generates the required output?

• A. INTERSECT
• B. PLUS
• C. UNION
• D. MINUS
• E. SUBTRACT

正解：D

解説：
Explanation/Reference:
References:
https://docs.oracle.com/cd/B19306_01/server.102/b14200/queries004.htm

質問 # 100
The sales table has columns prod_id and quantity_sold of data type number. Which two queries execute successfully?

• A. SELECT COUNT(prod_id) FROM sales WHERE quantity_sold > 55000 GROUP BY prod_id;
• B. SELECT prod Id FROH sales NHERE quantity sold > 55000 3RODI BY prod_id HAVING COUNT(*) > 10;
• C. SELECT COUNT(prod_id) FROM sales GROUP BY prod_id WHERE quantity_sold > 55000;
• D. SELECT prod_id FROM sales WHERE quantity_sold > 55000 AND
  COUNT(*) > 10 GROUP BY COUNT(*) > 10;
• E. SELECT prod_id FROM sales WHERE quantity_sold > 55000 AND COUNT(*) > 10 GROUP BY prod_id HAVING COUNT(*) > 10;

正解：A、B

質問 # 101
Examine the business rule:
Each student can work on multiple projects and each project can have multiple students.
You need to design an Entity Relationship Model (ERD) 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 in this scenario?

• A. PROJECT_ID must be the primary key in the PROJECTS entity and foreign key in the STUDENTS entity.
• B. The ERD must have a 1:M relationship between the STUDENTS and PROJECTS entities.
• C. STUDENT_ID must be the primary key in the STUDENTS entity and foreign key in the PROJECTS entity.
• D. 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.
• E. The ERD must have a M:M relationship between the STUDENTS and PROJECTS entities that must be resolved into 1:M relationships.

正解：D、E

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

質問 # 102
View the Exhibit and examine the structure of ORDER_ITEMS and ORDERS tables.

You need to remove from the ORDER_ITEMS table those rows that have an order status of 0 or 1 in the ORDERS table.
Which two DELETE statements are valid (Choose two.)

• A. DELETE FROM order_items iWHERE order_id = (SELECT order_id FROM orders oWHERE i.order_id = o.order_id AND order_status IN (0,1));
• B. DELETE *FROM order_itemsWHERE order_id IN (SELECT order_id)FROM ordersWHERE order_status IN (0,1));
• C. DELETEFROM order_itemsWHERE order_id IN (SELECT order_idFROM ordersWHERE orders_status in (0,1));
• D. DELETEFROM (SELECT * FROM order_items I,orders oWHERE i.order_id = o.order_id AND order_status IN (0,1));

正解：C、D

質問 # 103

Which two queries execute successfully?

• A. SELECT prod_id, exp_date FROM products
  UNION ALL
  SELECT prod_id, NULL FROM new_products;
• B. SELECT prod_id FROM products
  UNION ALL
  SELECT prod_id, prod_name FROM new_products;
• C. SELECT prod_id, prod_name FROM products
  INTERSECT
  SELECT 100, prod_name FROM newproducts;
• D. SELECT k FROM products
  MINUS
  SELECT prod_id FROM new_products;
• E. SELECT * FROM products
  UNION
  SELECT * FROM new_products;

正解：A、E

質問 # 104
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. SELECT prod_id q's not available" from product_ status WHERE status = 'OUT OF STOCK';
• B. SELECT PROD_ID||q'('s not available)' FROM
  product_ status WHERE status = 'OUT OF STOCK';
• C. SELECT prod_id ||q"' s not available" FROM
  product_ status WHERE status = 'OUT OF STOCK';
• D. SELECT prod_id ||q'(' s not available)' 'CURRENT AVAILABILITY' FROM
  product_ status WHERE status = 'OUT OF STOCK'
• E. SELECT prod_id "CURRENT AVAILABILITY"||q' ('s not available)' from product_ status WHERE status
  = 'OUT OF STOCK';
• F. SELECT PROD_ID||q'('s not available)' "CURRENT AVAILABILITY"
  FROM product_ status WHERE status = 'OUT OF STOCK';

正解：B、F

質問 # 105
You must create a table for a banking application. (Choose the best answer.) One of the columns in the table has these requirements:
1: A column to store the duration of a short team loan
2: The data should be stored in a format supporting DATE arithmetic with DATE datatypes without using conversion functions.
3: The maximum loan period is 30 days.
4: Interest must be calculated based on the number of days for which the loan remains unpaid.
Which data type would you use?

• A. Number
• B. Timestamp
• C. Interval year to month
• D. Interval day to second
• E. Date

正解：D

質問 # 106
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 SYNONIM emp FOR hcm.employee_records;
• B. CREATE GLOBAL SYNONIM emp FOR hcm.employee_records;
• C. CREATE SYNONIM PUBLIC.emp FOR hcm.employee_records;
• D. CREATE SYNONIM SYS.emp FOR hcm.employee_records;
• E.

正解：B

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

質問 # 107
Which two statements are true about date/time functions in a session where NLS_DATE_FORMATis set to DD- MON-YYYY HH24:MI:SS? (Choose two.)

• A. CURRENT_TIMESTAMPreturns the same date and time as SYSDATEwith additional details of fractional seconds.
• B. SYSDATEcan be used in expressions only if the default date format is DD-MON-RR.
• C. CURRENT_DATEreturns the current date and time as per the session time zone.
• D. SYSDATEcan be queried only from the DUALtable.
• E. SYSDATEand CURRENT_DATEreturn the current date and time set for the operating system of the database server.
• F. CURRENT_TIMESTAMPreturns the same date as CURRENT_DATE.

正解：C、D

解説：
Explanation/Reference:

質問 # 108
Which two statements are true? (Choose two.)

• A. The USER SYNONYMS view can provide information about private synonyms.
• B. The USER OBJECTS view can provide information about the tables and views created by the user only.
• C. All the dynamic performance views prefixed with V$ are accessible to all the database users.
• D. The user SYSTEM owns all the base tables and user-accessible views of the data dictionary.
• E. DICTIONARY is a view that contains the names of all the data dictionary views that the user can access.

正解：A、E

質問 # 109
You execute this command:
TRUNCATE TABLE depts;
Which two are true?

• A. A ROLLBACK statement can be used to retrieve the deleted data.
• B. It always retains the space used by the removed rows
• C. It retains the integrity constraints defined on the table.
• D. It drops any triggers defined on the table.
• E. It retains the indexes defined on the table.
• F. A Flashback TABLE statement can be used to retrieve the deleted data.

正解：C、E

解説：
The TRUNCATE TABLE command in Oracle SQL is used to quickly delete all rows from a table:
* Option A:
* It retains the indexes defined on the table. TRUNCATE does not affect the structure of the table, including its indexes.
* Option D:
* It retains the integrity constraints defined on the table. TRUNCATE does not remove or disable integrity constraints, except for unenforced foreign keys.
Options B, C, E, and F are incorrect because:
* Option B: TRUNCATE does not drop triggers; it only removes all rows.
* Option C: Flashback Table cannot be used after a TRUNCATE because TRUNCATE is a DDL operation that does not generate undo data for flashback.
* Option E: A ROLLBACK cannot be used after a TRUNCATE because TRUNCATE is a DDL command that implicitly commits.
* Option F: TRUNCATE may deallocate the space used by the table, depending on the database version and specific options used with the TRUNCATE command.

質問 # 110
Examine the description of the ENPLOYES table:

Which query requires explicit data type conversion?

• A. SELECT join_ date + '20' EROM employees;
• B. SELECT join_ date'' salary FROM employees;
• C. SELECT salary + '120.50' FROM employees;
• D. SELECT join _ date FROM employees WHERE join date > *10-02-2018';
• E. SELECT SUBSTR(join date, 1, 2) - 10 FROM employees;

正解：D

質問 # 111
View the exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS and TIMES tables.
The PROD_ID column is the foreign key in the SALES table referencing the PRODUCTS table.
The CUST_ID and TIME_ID columns are also foreign keys in the SALES table referencing the CUSTOMERS and TIMES tables, respectively.
Examine this command:
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?

• A. The NEW_SALES table would get created and all the NOT NULL constraints defined on the selected columns from the SALES table would be created on the corresponding columns in the NEW_SALES table.
• B. The NEW_SALES table would not get created because the column names in the CREATE TABLE command and the SELECT clause do not match.
• C. The NEW_SALES table would get created and all the FOREIGN KEY constraints defined on the selected columns from the SALES table would be created on the corresponding columns in the NEW_SALES table.
• D. The NEW_SALES table would not get created because the DEFAULT value cannot be specified in the column definition.

正解：A

質問 # 112
Examine the description of the PROMOTIONStable:

You want to display the unique promotion costs in each promotion category.
Which two queries can be used? (Choose two.)
SELECT DISTINCT promo_category || ' has ' || promo_cost AS COSTS FROM

• A. SELECT DISTINCT promo_cost ||' in '|| DISTINCT promo_category FROM promotions
• B. ORDER BY 1;
  SELECT promo_cost, promo_category FROM promotions ORDER BY 1;
• C.
• D. SELECT promo_category, DISTINCT promo_cost FROM promotions ORDER BY 2;
• E. promotions ORDER BY 1;
  SELECT DISTINCT promo_category, promo_cost FROM promotions ORDER BY 1;

正解：A、D

質問 # 113
Examine the description of the EMPLOYEES table:

Which statement increases each employee's SALARY by the minimum SALARY for their DEPARTM ENT_ID?

• A. UPDATE employees e1
  SET salary = salary +
  (SELECT MIN(e1. salary)
  FROM employees e2
  WHERE e1.department_id = e2 .department_id);
• B. UPDATE employees e1
  SET salary = salary+(SELECT MIN (salary)
  FROM employees e2) ;
• C. UPDATE employees e1
  SET salary =(SELECT e2. salary + MIN(e2.salary)
  FROM employees e2
  WHERE e1.department_ id = e2. department_id GROUP BY e2. department_id) ;
• D. UPDATE employees e1
  SET salary=
  (SELECT e1.salary + MIN(e2.salary)
  FROM employees e2
  WHERE e1. department_ id = e2.department_id);

正解：D

解説：
The correct statement to increase each employee's salary by the minimum salary for their department is:
D: This option correctly increases each employee's salary by the minimum salary in their department. The subquery calculates the minimum salary for the department of the current row being updated (e1) in the outer UPDATE statement. The subquery does not use GROUP BY since it returns a single value - the minimum salary for the matching department.A, B, and C are incorrect. Specifically:
* A uses a subquery with an aggregate function combined with GROUP BY, which is not needed and will result in an error.
* B incorrectly references MIN(e1.salary) within the subquery, which is incorrect since e1 is the alias for the outer query's table and should not be used within the subquery.
* C sets the salary to itself plus the minimum salary across all employees, not filtered by the department.
References:
* Oracle Database SQL Language Reference, 12c Release 1 (12.1): "UPDATE"

質問 # 114
......

最新問題をダウンロード1z0-071問題集で2026年最新の1z0-071試験問題集：https://www.goshiken.com/Oracle/1z0-071-mondaishu.html

最新のOracle 1z0-071認定練習テスト問題：https://drive.google.com/open?id=1V2WWPTpdHmjpkqG7tM2oHziL-Y8OPWJN