• ホーム
  • ブログ
  • [Q81-Q102] まもなく無料セール終了！リアル1z1-071のPDF解答で合格せよ [2025年04月02日]

[Q81-Q102] まもなく無料セール終了！リアル1z1-071のPDF解答で合格せよ [2025年04月02日]

Share

まもなく無料セール終了！リアル1z1-071のPDF解答で合格せよ [2025年04月02日]

最新の2025年04月試験1z1-071問題集合格できる認証試験合格させます

質問 # 81
You must create a table for a banking application.
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. INTERVAL YEAR TO MONTH
  • C. DATE
  • D. TIMESTAMP
  • E. INTERVAL DAY TO SECOND

正解：E


質問 # 82
Examine the description of the PRODCTS table which contains data:

Which two are true?

  • A. The PROD NAME column cannot have a DEFAULT clause added to it.
  • B. The PROD ID column can be renamed.
  • C. The EXPIRY DATE column cannot be dropped.
  • D. The PROD_ ID column data type can be changed to VARCHAR2 (2).
  • E. The EXPIRY DATE column data type can be changed to TIME STAMP.

正解：B、E

解説：
* A: True, the name of a column can be changed in Oracle using the ALTER TABLE ... RENAME COLUMN command.
* B: False, you cannot change a column's data type from NUMBER to VARCHAR2 if the table contains data, unless the change does not result in data loss or inconsistency.
* C: True, it is possible to change a DATE data type column to TIMESTAMP because TIMESTAMP is an extension of DATE that includes fractional seconds. This operation is allowed if there is no data loss.
* D: False, any column that is not part of a primary key or does not have a non-deferrable constraint can generally be dropped unless it contains data that does not allow for such a change.
* E: False, the DEFAULT clause can be added to a column provided there is no data that contradicts the default value or it doesn't violate any constraints.
These statements are verified against the Oracle Database 12c SQL documentation, specifically the sections on data types, the ALTER TABLE command, and the use of literals in SQL expressions.


質問 # 83
In the PROMOTIONS table, the PROMO_BEGIN_DATEcolumn is of data type DATEand the default date format is DD-MON-RR.
Which two statements are true about expressions using PROMO_BEGIN_DATEcontained a query? (Choose two.)

  • A. TO_DATE(PROMO_BEGIN_DATE * 5)will return a date.
  • B. PROMO_BEGIN_DATE- 5 will return a date.
  • C. PROMO_BEGIN_DATE - SYSDATEwill return an error.
  • D. PROMO_BEGIN_DATE - SYSDATEwill return a number.
  • E. TO_NUMBER(PROMO_BEGIN_DATE)- 5 will return a number.

正解：B、D


質問 # 84
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. The rollback generates an error.
  • B. Only the second DELETEstatement is rolled back.
  • C. Both the DELETEstatements and the UPDATEstatement are rolled back.
  • D. No SQL statements are rolled back.
  • E. Only the DELETEstatements are rolled back.

正解：A、D


質問 # 85
View the Exhibit and examine the structure of the PRODUCT_INFORMATION and INVENTORIES tables.

You have a requirement from the supplies department to give a list containing PRODUCT_ID, SUPPLIER_ID, and QUANTITY_ON_HAND for all the products wherein QUANTITY_ON_HAND is less than five.
Which two SQL statements can accomplish the task? (Choose two.)

  • A. SELECT i.product_id, i.quantity_on_hand, pi.supplier_idFROM product_information pi JOIN inventories iON (pi.product_id=i.product_id) AND quantity_on_hand < 5;
  • B. SELECT product_id, quantity_on_hand, supplier_idFROM product_informationNATURAL JOIN inventories AND quantity_on_hand < 5;
  • C. SELECT i.product_id, i.quantity_on_hand, pi.supplier_idFROM product_information pi JOIN inventories iUSING (product_id) AND quantity_on_hand < 5;
  • D. SELECT i.product_id, i.quantity_on_hand, pi.supplier_idFROM product_information pi JOIN inventories iON (pi.product_id=i.product_id)WHERE quantity_on_hand < 5;

正解：A、D


質問 # 86
Which two will execute successfully?

  • A. SELECT NVL('DATE',200) FROM (SELECT NULL AS "DATE" FROM DUAL);
  • B. SELECT COALESCE(O,SYSDATE) TRCH DUAL;
  • C. SELECT NVL('DATE',SYSDATE) FROM DUAL;
  • D. SELECT COALESCR('DATE', SYSDATE) FROM DUAL;
  • E. SELECT COALESCE('DATE',SYSDATE) FROM (SELECT NULL AS "DATE" FROM DUAL) ;

正解：A

解説：
D). True. The NVL function can replace a NULL value with a specified value, and it does not require the data types to match exactly, allowing implicit conversion where possible. Here, 'DATE' is a string literal, and 200 is a number, and since the selected column is NULL, NVL will return 200.
The other options are incorrect because the COALESCE function requires all arguments to be of the same data type or at least compatible types that Oracle can implicitly convert. In A and E, the use of COALESCE with a string literal 'DATE' and SYSDATE (which is a date type) is not compatible without explicit conversion. Option C has a typo (TRCH instead of FROM) and is mixing data types incorrectly.


質問 # 87
Evaluate the following SQL statement
SQL>SELECT promo_id, prom _category FROM promotions
WHERE promo_category='Internet' ORDER BY promo_id
UNION
SELECT promo_id, promo_category FROM Pomotions
WHERE promo_category = 'TV'
UNION
SELECT promoid, promocategory FROM promotions WHERE promo category='Radio' Which statement is true regarding the outcome of the above query?

  • A. It executes successfully and displays rows in the descend ignore of PROMO CATEGORY.
  • B. It produces an error because positional, notation cannot be used in the ORDER BY clause with SBT operators.
  • C. It executes successfully but ignores the ORDER BY clause because it is not located at the end of the compound statement.
  • 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


質問 # 88
which is true about the round,truncate and mod functions>?

  • A. ROUND(MOD(25,3),-1) AND TRUNC(MOD(25,3),-1) ARE BOTH VALID AND GIVE THE SAME RESULT.
  • B. TRUNC(MOD(25,3),-1) IS INVALID.
  • C. ROUND(MOD(25,3),-1) IS INVALID
  • D. ROUND(MOD(25,3),-1) AND TRUNC(MOD(25,3),-1) ARE BOTH VALID AND GIVE THE DIFFERENT RESULTS.

正解：A


質問 # 89
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? Assume there exists only one row with CUST_LAST_NAME as Roberts and CREDIT_LIMIT as 600.

  • A. INSERT INTO orders (order_id, order_date, order_mode,(SELECT customer_idFROM customersWHERE cust_last_name='Roberts' AND credit_limit=600), order_total)VALUES (1,'10-mar-2007', 'direct', &customer_id, 1000);
  • B. INSERT INTO ordersVALUES (1,'10-mar-2007', 'direct',(SELECT customer_idFROM customersWHERE cust_last_name='Roberts' AND credit_limit=600), 1000);
  • C. 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_id AND c.cust_last_name='Roberts' AND c.credit_limit=600)VALUES (1,'10-mar-2007', 'direct', (SELECT customer_idFROM customersWHERE cust_last_name='Roberts' AND credit_limit=600), 1000);
  • D. INSERT INTO orders (order_id, order_date, order_mode,(SELECT customer_idFROM customersWHERE cust_last_name='Roberts' AND credit_limit=600), order_total)VALUES (1,'10-mar-2007', 'direct', &&customer_id, 1000);

正解：B


質問 # 90
Examine the structure proposed for the TRANSACTIONS table:

Which two statements are true regarding the creation and storage of data in the above table structure? (Choose two.)

  • A. The CUST_CREDIT_LIMIT column would be able to store decimal values.
  • B. The TRANS_VALIDITY column would give an error.
  • C. The CUST_STATUS column would give an error.
  • D. The CUST_STATUS column would store exactly one character.
  • E. The TRANS_DATE column would be able to store day, month, century, year, hour, minutes, seconds, and fractions of seconds.
  • F. The TRANS_VALIDITY column would have a maximum size of one character.

正解：B、D


質問 # 91
Examine the ORDER _ITEms table:

Which two queries return rows where QUANTITY is a multiple of ten?

  • A. SELECT FROM order_ items WHERE quantity / 10 = TRUNC (quantity);
  • B. SELECT * FROM order_ items WHERE quantity = TRUNC (quantity, -1);
  • C. SELECT * FROM order_ items WHERE MOD (quantity, 10) = 0;
  • D. SELECT" FROM order_ _items WHERE quantity = ROUND (quantity, 1);
  • E. SELECT" FROM order_ items WHERE FLOOR (quantity / 10) = TRUNC (quantity / 10);

正解：C、E

解説：
A: This statement will not work because TRUNC(quantity, -1) will truncate the quantity to zero decimal places when the number is a negative power of ten, which does not guarantee that the quantity is a multiple of ten.
B: This statement is correct. The MOD function returns the remainder of a division. If MOD(quantity, 10) equals zero, it means that quantity is a multiple of ten.
C: This statement is correct. FLOOR(quantity / 10) equals TRUNC(quantity / 10) when quantity is an exact multiple of ten, as FLOOR returns the largest integer less than or equal to a number, and TRUNC will truncate the decimal part.
D: This statement is incorrect because TRUNC(quantity) would remove any decimal places from quantity, and comparing it to quantity / 10 will not guarantee that the quantity is a multiple of ten.
E: This statement is incorrect. ROUND(quantity, 1) will round the quantity to one decimal place, not check if it's a multiple of ten.


質問 # 92
Examine the data in the CUST NAME column of the CUSTOMERS table:
CUST_NAME
------------------------------
Renske Ladwig
Jason Mallin
Samuel McCain
Allan MCEwen
Irene Mikkilineni
Julia Nayer
You want to display the CUST_NAME values where the last name starts with Mc or MC. Which two WHERE clauses give the required result?

  • A. WHERE INITCAP (SUBSTR(cust_name, INSTR(cust_name,'') +1)) IN ('MC%','Mc%)
  • B. WHERE SUBSTR(cust_name, INSTR(cust_name,'') +1) LIKE'Mc%'
  • C. WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name,'') +1)) LIKE'Mc%'
  • D. WHERE SUBSTR(cust_name,INSTR(cust_name,'') +1) LIKE'Mc%' OR'MC%'
  • E. WHERE UPPER (SUBSTR(cust_name, INSTR(cust_name, '') +1)) LIKE UPPER('MC%')

正解：C、E

解説：
To find customers whose last names start with "Mc" or "MC", we need to ensure our SQL query correctly identifies and compares these prefixes regardless of case variations. Let's analyze the given options:
* Option B: WHERE UPPER(SUBSTR(cust_name, INSTR(cust_name, ' ') + 1)) LIKE UPPER(' MC%')This clause uses UPPER to convert both the extracted substring (starting just after the first space, assuming it indicates the start of the last name) and the comparison string 'MC%' to uppercase.
This ensures case-insensitive comparison. The LIKE operator is used to match any last names starting with "MC", which will correctly capture both "Mc" and "MC". This option is correct.
* Option C: WHERE INITCAP(SUBSTR(cust_name, INSTR(cust_name, ' ') + 1)) LIKE 'Mc%' This clause applies INITCAP to the substring, which capitalizes the first letter of each word and makes other letters lowercase. The result is compared to 'Mc%', assuming only the last name follows the space.
This approach will match last names starting with "Mc" (like "McEwen"), but not "MC". However, considering we're looking for "Mc" specifically, this clause works under the assumption that "Mc" is treated as proper capitalization for these last names. Thus, it can also be considered correct, albeit less inclusive than option B.
The other options either use incorrect syntax or apply case-sensitive matches without ensuring that both "Mc" and "MC" are captured:
* Option A: Contains syntax errors (unmatched quotes and wrong use of IN).
* Option D: Uses case-sensitive match without combining both "Mc" and "MC".
* Option E: Only matches "Mc", which is too specific.


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

Examine this statement:

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

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

正解：B、C

解説：
Explanation/Reference:


質問 # 94
Which two are true about queries using set operators (UNION, UNION ALL, INTERSECT and MINUS)?

  • A. There must be an equal number of columns in each SELECT list.
  • B. Each SELECT statement in the query can have an ORDER BY clause.
  • C. The name of each column in the first SELECT list must match the name of the corresponding column in each subsequent SELECT list.
  • D. The FOR UPDATE clause cannot be specified.
  • E. None of the set operators can be used when selecting CLOB columns.

正解：A、D

解説：
A). True. When using set operators, the number and order of columns must be the same in all SELECT statements involved in the query. The data types of those columns must also be compatible.
E). True. The FOR UPDATE clause cannot be specified in a subquery or a SELECT statement that is combined with another SELECT statement by using a set operator.
B is incorrect because the column names do not need to match; only the number and data types of the columns must be compatible. C is incorrect because only the final SELECT statement in the sequence of UNION/INTERSECT/MINUS operations can have an ORDER BY clause. D is incorrect because, as of Oracle 12c, UNION ALL can be used with CLOB columns, but UNION, INTERSECT, and MINUS cannot.


質問 # 95
Examine these SQL statements that are executed in the given order:

What will be the status of the foreign key EMP_MGR_FK?

  • A. It will remain disabled and can be re-enabled manually.
  • B. It will be enabled and immediate.
  • C. It will remain disabled and can be enabled only by dropping the foreign key constraint and re-creating it.
  • D. It will be enabled and deferred.

正解：A


質問 # 96
Which three statements are true regarding single row subqueries?

  • A. They can be used in the HAVING clause.
  • B. They can be used in the clause.
  • C. A SQL statement may have multiple single row subquery blocks.
  • D. They must be placed on the left side of the comparison operator or condition.
  • E. They must be placed on the right side of the comparison operator or condition.
  • F. They must return a row to prevent errors in the SQL statement.

正解：A、C、E

解説：
C: True. A SQL statement may include multiple single row subqueries in different parts of the statement, such as in the SELECT list, WHERE clause, or HAVING clause. Each subquery must independently satisfy the requirement of returning a single row to avoid runtime errors.
D: True. Single row subqueries can be used in the HAVING clause. This allows for filtering groups based on conditions evaluated against individual or aggregated values returned by the subquery. The subquery must return a single value to be valid in this context.
E: True. Single row subqueries are often placed on the right side of the comparison operator in a SQL condition. This positioning is typical because the left side often references a column or an expression related to the main query, while the subquery on the right side dynamically provides a value for comparison.


質問 # 97
Examine the commands used to createDEPARTMENT_DETAILS andCOURSE_DETAILS:

You want to generate a list of all department IDs along with any course IDs that may have
been assigned to them.
Which SQL statement must you use?
A)

B)

C)

D)

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

正解：D


質問 # 98
Examine the data in the COLORStable:

Examine the data in the BRICKStable:

Which two queries return all the rows from COLORS? (Choose two.)

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

正解：D、E


質問 # 99
Which two statements are true regarding the DELETEand TRUNCATEcommands? (Choose two.)

  • A. DELETEand TRUNCATEcan be used for tables that are parents for a child table that has a referential integrity constraint having an ON DELETErule.
  • B. DELETEcan be used to remove data from specific columns as well as complete rows.
  • C. DELETEcan be used to remove rows only for tables that are parents for a child table that has a referential integrity constraint referring to the parent.
  • D. DELETEcan be used to remove rows from multiple tables in one statement.
  • E. DELETEcan be used to remove rows from only one table in one statement.

正解：A、E


質問 # 100
Which two are true about scalar subquery expressions?

  • A. .You must enclose them in parentheses.
  • B. They can return at most one row.
  • C. You cannot correlate them with a table in the parent statement
  • D. You can use them as a default value for a column.
  • E. They can return two columns.

正解：A、C


質問 # 101
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. All existing rows in the EMPLOYEE table are deleted.
  • C. The subquery is not a correlated subquery.
  • D. The DELETE statement executes successfully even if the subquery selects multiple rows.
  • E. The subquery is executed before the DELETE statement is executed.

正解：A、D

解説：
The provided DELETE statement uses a correlated subquery to determine which rows should be deleted from the EMPLOYEES table.
A . The subquery is indeed executed for every row in the EMPLOYEES table. This is because it references e.employee_id, which is a column from the outer query, making it a correlated subquery.
B . The subquery is a correlated subquery, as explained above.
C . The subquery is executed for each row, not before the DELETE statement.
D . Not all existing rows in the EMPLOYEES table are deleted, only those that have a corresponding employee_id in the EMP_HISTORY table.
E . The DELETE statement executes successfully even if the subquery selects multiple rows because the EXISTS condition only checks for the presence of rows, not their count.
Reference:
Oracle Database SQL Language Reference 12c Release 1 (12.1), DELETE Statement Oracle Database SQL Language Reference 12c Release 1 (12.1), Subquery Factoring Oracle Database SQL Language Reference 12c Release 1 (12.1), Correlated Subqueries


質問 # 102
......

1z1-071問題集が合格させる、一日でOracle PL/SQL Developer Certified Associate試験合格：https://www.passtest.jp/Oracle/1z1-071-shiken.html

最新でリアルなOracle 1z1-071試験問題集解答：https://drive.google.com/open?id=1aBIBMDxKys-9aZwfOh8Kju4yQdqwKPD3

関するブログ

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