合格させるOracle 1z1-071テスト問題でテストエンジンとPDFを提供中 [Q173-Q193]

合格させるOracle 1z1-071テスト問題でテストエンジンとPDFを提供中

あなたをお手軽に1z1-071試験合格させるリアル1z1-071練習問題集で更新されたのは2025年03月30日

質問 # 173
View the exhibit and examine the data in the PROJ_TASK_DETAILS table.

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? (Choose the best answer.)

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 FULL 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 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 LEFT OUTER JOIN proj_task_details dON (p.based_on = d.task_id);

正解：D

質問 # 174
Which three statements are true about defining relations between tables in a relational database?

A. Primary key columns allow null values.
B. Every primary or unique key value must refer to a matching foreign key value.
C. Every foreign key value must refer to a matching primary or unique key value.
D. Foreign key columns allow null values.
E. Unique key columns allow null values

正解：C、D

解説：
A). Correct. Foreign key constraints can be nullable. This allows the possibility of a row not having a link to another table. B. Incorrect. Unique key constraints do not allow multiple rows to have null values unless the constraint is defined on multiple columns. C. Incorrect. Primary key columns must be NOT NULL and unique across the table. D. Incorrect. Primary or unique key values do not refer to foreign keys; it's the foreign keys that refer to primary or unique keys. E. Correct. Foreign key constraints enforce referential integrity by requiring that each foreign key value matches a primary or unique key value in the related table.
These are standard rules in relational databases, which can be confirmed in the Oracle Database Concepts Guide.

質問 # 175
Which three tasks can be performed using SQL functions built into Oracle Database? (Choose three.)

A. finding the number of characters in an expression
B. combining more than two columns or expressions into a single column in the output
C. displaying a date in a nondefault format
D. substituting a character string in a text expression with a specified string

正解：A、C、D

質問 # 176
View the Exhibit and examine the structure of the PROMOTIONS table.

Evaluate the following SQL statement:

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

A. It shows COST_REMARK for all the promos in the table.
B. It shows COST_REMARK for all the promos in the promo category 'TV'.
C. It produces an error because subqueries cannot be used with the CASE expression.
D. It produces an error because the subquery gives an error.

正解：A

質問 # 177
You execute this query:
SELECT TO CHAR (NEXT_DAY(LAST_DAY(SYSDATE),'MON' ),' dd"Monday for" fmMonth rrr') FROM DUAL;
What is the result?

A. It executes successfully but does not return any result.
B. It generates an error.
C. It returns the date for the last Monday of the current month.
D. It returns the date for the first Monday of the next month.

正解：D

質問 # 178
Which three are true about subqueries?

A. A subquery cannot be used in a FROM clause.
B. A subquery can be used in a WHERE clause.
C. A subquery can be used in a HAVING clause.
D. A subquery cannot be used in the select list.
E. < any returns true if the argument is less than the lowest value returned by the subquery.
F. =ANY can only evaluate the argument against a subcjuery if it returns two or more values.
G. <ANY returns true if the argument is less than the highest value returned by the subquery.

正解：B、C、G

解説：
About the roles and behavior of subqueries in SQL:
* A. A subquery can be used in a WHERE clause: Subqueries are often used in WHERE clauses to filter rows based on a condition evaluated against a set of returned values.
* B. A subquery can be used in a HAVING clause: Similar to WHERE, subqueries can be used in HAVING clauses to filter groups based on aggregate conditions.
* D. <ANY returns true if the argument is less than the highest value returned by the subquery: The <ANY (or <SOME) operator compares a value to each value returned by a subquery and returns true if the comparison is true for any one of the returned values.
Incorrect options:
* C: =ANY evaluates true if the argument matches any single value returned by the subquery, irrespective of the number of values.
* E: A subquery can indeed be used in a FROM clause, known as a derived table or inline view.
* F: <ANY returns true if the argument is less than any of the values returned by the subquery, not necessarily the lowest.
* G: A subquery can be used in a SELECT list, particularly when the subquery is designed to return a single value (scalar subquery).

質問 # 179
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=
(SELECT e1.salary + MIN(e2.salary)
FROM employees e2
WHERE e1. department_ id = e2.department_id);
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 = salary+(SELECT MIN (salary)
FROM employees e2) ;

正解：B

質問 # 180
Which two are true about the precedence of opertors and condtions

A. AND and OR have the same order of precedence in a condition
B. NOT has a higher order of precedence than AND and OR in a condition.
C. + (addition) has a higher order of precedence than * (mliplpition)
D. || has a higher order of precedence than +(addition)
E. Operators are evaluated before conditions.

正解：B、D

解説：
Regarding the precedence of operators and conditions in Oracle Database 12c:
* Option B: NOT has a higher order of precedence than AND and OR in a condition.
* In logical operations, NOT is evaluated first, followed by AND and then OR.
* Option E: || has a higher order of precedence than +(addition).
* The string concatenation operator || has a higher precedence than the arithmetic + operator.
Options A, C, and D are incorrect because:
* Option A: Multiplication (*) has a higher precedence than addition (+).
* Option C: AND has a higher precedence than OR.
* Option D: Conditions (which may contain operators) are evaluated according to the rules of operator precedence.

質問 # 181
View the Exhibit and examine the data in the PRODUCTS table.

You must display product names from the PRODUCTS table that belong to the 'Software/other' category with minimum prices as either $2000 or $4000 and with no unit of measure.
You issue this query:

Which statement is true?

A. It executes successfully but returns no result.
B. It generates an error because the condition specified for PROD_UNIT_OF_MEASURE is not valid.
C. It generates an error because the condition specified for the PROD_CATEGORY column is not valid.
D. It executes successfully and returns the required result.

正解：A

質問 # 182
Examine this description of the PRODUCTS table:

Rows exist in this table with data in all the columns. You put the PRODUCTS table in read-only mode.
Which three commands execute successfully on PRODUCTS?

A. CREATE INDEX price_idx ON products (price);
B. TRUNCATE TABLE products;
C. ALTER TABLE products SET UNUSED (expiry_date);
D. ALTER TABLE products DROP UNUSED COLUMNS;
E. DROP TABLE products;
F. ALTER TABLE products DROP COLUMN expiry_date;

正解：A、B、E

質問 # 183
View the exhibit and examine the structure and data in the INVOICE table.

Which two SQL statements would execute successfully? (Choose two.)

A. SELECT MAX(AVG(SYSDATE -inv_date))FROM invoice;
B. SELECT MAX(inv_date),MIN(cust_id)FROM invoice;
C. SELECT AVG( inv_date - SYSDATE), AVG(inv_amt)FROM invoice;
D. SELECT AVG(inv_date)FROM invoice;

正解：B、C

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

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

正解：A、C、D

解説：
Single-row functions in SQL operate on each row independently and can modify the returned value:
* Option A: Incorrect. Single row functions can be used in multiple parts of a SELECT statement, including SELECT, WHERE, and ORDER BY clauses.
* Option B: Incorrect. Single row functions can accept more than one argument, such as the CONCAT function, which can accept multiple string arguments.
* Option C: Incorrect. They return one result for each row processed, not per table.
* Option D: Correct. Single row functions can take various types of arguments including column names, literals, variables, and other expressions.
* Option E: Correct. Functions can be nested within other functions, allowing complex expressions and calculations.
* Option F: Correct. The data type of the result can differ from the arguments' data types, such as the SUBSTR function returning a VARCHAR2 even when used on a number after converting it to a string.

質問 # 185
Examine the data in the COLORS table:

Examine the data in the BRICKS table:

Which two queries return all the rows from COLORS?

正解：C、D

質問 # 186
View the Exhibits and examine PRODUCTSand SALES tables.
Exhibit 1

Exhibit 2

You issue the following query to display product name the number of times the product has been sold:

What happens when the above statement is executed?

A. The statement executes successfully and produces the required output.
B. The statement produces an error because ITEM_CNTcannot be displayed in the outer query.
C. The statement produces an error because the GROUP BYclause cannot be used in a subquery in the FROMclause.
D. The statement produces an error because a subquery in the FROMclause and outer-joins cannot be used together.

正解：A

質問 # 187
Which two are true about savepoints?

A. After issuing a savepoint, you can roll back to the savepoint name within the current transaction.
B. They make uncommitted updates visible to sessions owned by other users.
C. They make uncommitted updates visible to other sessions owned by the? same user.
D. After issuing a savepoint, you cannot roll back the complete transaction.
E. A rollback to savepoint command issued before the start of a transaction results In an error.
F. You can commit updates done between two savepoints without committing other updates In the current transaction.

正解：A、C

質問 # 188
Whith three statements are true about built in data types?

A. A CHAR column definition does not require the length to be specified
B. A BLOB stores unstructured binary data within the database
C. A VARCHAR2 column definition does not require the length to be specified
D. A BFILE stores unstructured binary data in operating systerm files
E. A VARCHAR2 blank pads column values only if the data stored is non numeric and contains no special characlers
F. The default length for a CHAR column is always one character

正解：B、D、F

解説：
The true statements about built-in data types in Oracle are:
B: A BFILE is a data type in Oracle that allows for a read-only link to binary files stored outside the database in the operating system. This is correct as per Oracle's documentation.
D: The default length for a CHAR column, when not specified, is one character. This is according to the Oracle SQL standard.
F: A BLOB is used for storing binary data within the Oracle database, allowing for storage of large amounts of unstructured binary data.
The incorrect options are:
A: A VARCHAR2 column does not blank-pad values; it is CHAR that may blank-pad to the fixed length.
C: A CHAR column requires a length specification, although if omitted, the default is one character.
E: A VARCHAR2 column requires a length specification; without it, the statement will fail.
Reference:
Oracle Documentation on Data Types: Data Types
Oracle Documentation on LOBs: LOBs
Oracle Documentation on Character Data Types: Character Data Types

質問 # 189
View the Exhibit and examine the structure of CUSTOMERS table.
Using the CUSTOMERS table, you need to generate a report that shows an increase in the credit limit by 15% for all customers. Customers whose credit limit has not been entered should have the message "Not Available" displayed.
Which SQL statement would produce the required result?

A. SELECT NVL(cust_credit_limit * .15), 'Not Available') "NEW CREDIT"FROM customers;
B. SELECT NVL (TO CHAR(cust_credit_limit * .15), 'Not Available') "NEW CREDIT"FROM customers;
C. SELECT TO_CHAR (NVL(cust_credit_limit * .15), 'Not Available') "NEW CREDIT"FROM customers;
D. SELECT NVL(cust_credit_limit), 'Not Available') "NEW CREDIT"FROM customers;

正解：B

質問 # 190
Which two are true about external tables that use the ORACLE _DATAPUMP access driver?

A. Creating an external table creates a directory object.
B. Creating an external table creates a dump file that can be used by an external table in the same or a different database.
C. When creating an external table, data can be selected from another external table or from a table whose rows are stored in database blocks.
D. Creating an external table creates a dump file that can be used only by an external table in the same database.
E. When creating an external table, data can be selected only from a table whose rows are stored in database blocks.

正解：C

解説：
External tables using the ORACLE_DATAPUMP access driver have specific characteristics:
C). Creating an external table using the ORACLE_DATAPUMP access driver allows you to select data from other tables, including another external table or a regular table whose rows are stored in database blocks.
A, B, D, and E are incorrect. Specifically:
* A is incorrect because creating an external table does not automatically create a directory object; the
* directory object must exist prior to or be created separately.
* B is incorrect as it limits the creation to tables stored in database blocks, which is not a restriction.
* D is incorrect because creating an external table does not create a dump file; it reads from an existing dump file created by Data Pump.
* E is also incorrect because the dump file is not created as part of the external table creation process.
References:
* Oracle Database SQL Language Reference, 12c Release 1 (12.1): "CREATE TABLE" for External Tables

質問 # 191
Examine the data in the EMPLOYEES table:

Which statement will compute the total annual compensation for each employee?

A. SELECT last_ name (monthly_ salary+ monthly_ commission _ pct) *12 AS annual_
FROM employees ;
B. SELECT last name,
(monthly salary*12) + (monthly_commission_pct * 12) AS
annual comp
FROM employees
;
C. SELECT last name, (monthly_ salary *12) + (monthly_ salary * 12 * NVL
(monthly commission pct,0) ) As annual _ comp
FROM employees;
D. SELECT last_ name, monthly_ salary*12) + (monthly_ salary * 12 * Monthly commission _Pct) AS
annual_ comp
FROM employees;

正解：C

質問 # 192
Which statement is true regarding external tables?

A. The default REJECT LIMITfor external tables is UNLIMITED.
B. The CREATE TABLE AS SELECTstatement can be used to upload data into regular table in the database from an external table.
C. ORACLE_LOADERand ORACLE_DATAPUMPhave exactly the same functionality when used with an external table.
D. The data and metadata for an external table are stored outside the database.

正解：B

解説：
Explanation/Reference:
References:
https://docs.oracle.com/cd/B28359_01/server.111/b28310/tables013.htm

質問 # 193
......

1z1-071リアル無料試験問題と解答：https://www.passtest.jp/Oracle/1z1-071-shiken.html

2025年最新の実際に出る検証済みの無料Oracle 1z1-071試験問題：https://drive.google.com/open?id=1aBIBMDxKys-9aZwfOh8Kju4yQdqwKPD3

関するブログ

もっと

1z1-071 無料問題集