[2022年04月03日] 手に入れよう！最新1z0-071認定された有効な試験問題集解答 [Q47-Q69]

[2022年04月03日] 手に入れよう！最新1z0-071認定された有効な試験問題集解答

100%合格率保証付きの素晴らしい1z0-071試験問題PDF

Oracle 1z0-071 認定試験の出題範囲：

トピック	出題範囲
トピック 1	Using Structured Query Language (SQL) Explain the relationship between a database and SQL
トピック 2	Use the EXISTS and NOT EXISTS operators Use single-row and multiple-row subqueries Create simple and complex views with visible invisible columns Create, maintain and use sequences
トピック 3	Managing Objects with Data Dictionary Views Use the data dictionary views to research data on objects Query various data dictionary views
トピック 4	Using DDL Statements to Create and Manage Tables Describe data types that are available for columns Describe how schema objects work
トピック 5	Include or exclude grouped rows by using the HAVING clause Describe the types of problems subqueries can solve Update and delete rows using correlated subqueries
トピック 6	Describe the different types of joins and their features Use joins to retrieve data from multiple tables
トピック 7	Build a SELECT statement to retrieve data from an Oracle Database table Use the WHERE clause to the SELECT statement to filter query results
トピック 8	Using Conversion Functions and Conditional Expressions Use the TO_CHAR, TO_NUMBER, and TO_DATE conversion functions
トピック 9	lumns and set column UNUSED Explain the theoretical and physical aspects of a relational database Use DDL to manage tables and their relationships
トピック 10	View data that generally does not meet a join condition by using outer joins Use a set operator to combine multiple queries into a single query
トピック 11	Use character, number, and date and analytical (PERCENTILE_CONT, STDDEV, LAG, LEAD) functions in SELECT statements Reporting Aggregated Data Using the Group Functions
トピック 12	Identify the connection between an ERD and a database using SQL SELECT statements Use the ORDER BY clause to sort SQL query results
トピック 13	Create and maintain indexes including invisible indexes and multiple indexes on the same columns Drop co

質問 47
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 returns the date for the first Monday of the next month.
C. It returns the date for the last Monday of the current month.
D. It generates an error.

正解: B

質問 48
Which statement is true regarding the default behavior of the ORDER BY clause?

A. Only those columns that are specified in the SELECT list can be used in the ORDER BY clause
B. In a character sort, the values are case-sensitive
C. Numeric values are displayed from the maximum to the minimum value if they have decimal positions
D. NULL values are not considered at all by the sort operation

正解: B

解説:
Character Strings and Dates
Character strings and date values are enclosed with single quotation marks.
Character values are case-sensitive and date values are format-sensitive.
The default date display format is DD-MON-RR.

質問 49
Which two statements are true regarding roles? (Choose two.)

A. A role can be granted to PUBLIC.
B. Roles are named groups of related privileges that can be granted to users or other roles.
C. A role can be granted to itself.
D. The REVOKE command can be used to remove privileges but not roles from other users.
E. A user can be granted only one role at any point of time.

正解: A,B

解説:
Explanation
http://docs.oracle.com/cd/E25054_01/network.1111/e16543/authorization.htm#autoId28

質問 50
View the Exhibit and examine the data in EMPand DEPTtables.

In the DEPTtable, DEPTNOis the PRIMARY KEY.
In the EMPtable, EMPNOis the PRIMARY KEYand DEPTNOis the FOREIGN KEYreferencing the DEPTNO column in the DEPTtable.
What would be the outcome of the following statements executed in the given sequence?
DROP TABLE emp;
FLASHBACK TABLE emp TO BEFORE DROP;
INSERT INTO emp VALUES (2, 'SCOTT', 10);
INSERT INTO emp VALUES (3, 'KING', 55);

A. Both the INSERTstatements would fail because the constraints are automatically retrieved when the table is flashed back.
B. Only the first INSERTstatement would succeed because all constraints except the primary key constraint are automatically retrieved after a table is flashed back.
C. Both the INSERTstatements would succeed because none of the constraints on the table are automatically retrieved when the table is flashed back.
D. Only the SECOND INSERTstatement would succeed because all the constraints except referential integrity constraints that reference other tables are retrieved automatically after the table is flashed back.

正解: D

質問 51
View the exhibit and examine the data in ORDERS_MASTERand MONTHLY_ORDERStables.

Evaluate the following MERGEstatement:
MERGE_INTO orders_master o
USING monthly_orders m
ON (o.order_id = m.order_id)
WHEN MATCHED THEN
UPDATE SET o.order_total = m.order_total
DELETE WHERE (m.order_total IS NULL)
WHEN NOT MATCHED THEN
INSERT VALUES (m.order_id, m.order_total)
What would be the outcome of the above statement?

A. The ORDERS_MASTERtable would contain the ORDER_IDs1, 2 and 3.
B. The ORDERS_MASTERtable would contain the ORDER_IDs1, 2 and 4.
C. The ORDERS_MASTERtable would contain the ORDER_IDs1, 2, 3 and 4.
D. The ORDERS_MASTERtable would contain the ORDER_IDs1 and 2.

正解: B

解説:
Explanation/Reference:
References:
https://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_9016.htm

質問 52
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.)

正解: D,E

質問 53
View the Exhibit and examine the structure of the EMPLOYEES table.
You want to display all employees and their managers having 100 as the MANAGER_ID. You want the output in two columns: the first column would have the LAST_NAME of the managers and the second column would have LAST_NAME of the employees.
Which SQL statement would you execute?

A. SELECT m.last_name "Manager", e.last_name "Employee"
FROM employees m JOIN employees e
ON m.employee_id = e.manager_id
WHERE e.manager_id=100;
B. SELECT m.last_name "Manager", e.last_name "Employee"
FROM employees m JOIN employees e
WHERE m.employee_id = e.manager_id AND e.manager_id=100;
C. SELECT m.last_name "Manager", e.last_name "Employee"
FROM employees m JOIN employees e
ON m.employee_id = e.manager_id
WHERE m.manager_id=100;
D. SELECT m.last_name "Manager", e.last_name "Employee"
FROM employees m JOIN employees e
ON e.employee_id = m.manager_id
WHERE m.manager_id=100;

正解: A

質問 54
View the exhibit and examine the data in the PROJ_TASK_DETAILS table. (Choose the best answer.)

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?

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

正解: A

質問 55
You create a table by using this command:
CREATE TABLE rate_list (rate NUMBER(6,2));
Which two are true about executing statements?

A. INSERT INTO rate_list VALUES (-99.99) inserts the value as 99.99.
B. INSERT INTO rate_list VALUES (0.999) produces an error.
C. INSERT INTO rate_list VALUES (87654. 556) inserts the value as 87654.6.
D. INSERT INTO rate_list VALUES (0.551) inserts the value as .55.
E. INSERT INTO rate_list VALUES (-10) produces an error.
F. INSERT INTO rate_list VALUES (-.9) inserts the value as -.9.

正解: D,F

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

A. 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. During row source generation, rows that satisfy the query are retrieved from the database and stored 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 executing, the oracle server may read data from storage if the required data is not already in memory.

正解: D

質問 57
In your session NLS_ DATE_ FORMAT is set to DD-MON_RR.
Which two queries display the year as four digits?

A. SELECT TO_DATE (ADD_MONTHS(SYSDATE,6), 'dd-mon-yyyy') FROM DUAL;
B. SELECT TO_CHAR (SYSDATE, 'MM/DD/YYYY') FROM DUAL;
C. SELECT TO_DATE(TO_CHAR(SYSDATE,'MM/DD/YYYY'),'MM/DD/YYYY') FROM DUAL;
D. SELECT TO_DATE (SYSDATE, 'RRRR-MM-DD') FROM DUAL;
E. SELECT TO_CHAR (ADD_MONTHS (SYSDATE,6)) FROM DUAL;
F. SELECT TO_CHAR (ADD_MONTHS (SYSDATE, 6), 'dd-mon-yyyy') FROM DUAL;

正解: B,F

質問 58
Which two statements are true about Oracle databases and SQL?

A. When you execute an UPDATE statement, the database instance locks each updated row.
B. Updates performed by a database user can be rolled back by another user by using the ROLLBACK command.
C. A user can be the owner of multiple schemas In the same database.
D. The database guarantees read consistency at select level on user-created tablers.
E. A query can access only tables within the same schema.

正解: A,D

質問 59
Examine the description of the sales table.
The sales table has 55,000 rows.
Examine this statements:
Which two statements are true?

A. SALES1 created with no rows.
B. SALES1 created with 1 row.
C. SALES1 has NOT NULL constraints on any I selected columns which had those constraints I in the SALES table.
D. SALES1 created with 55, 000 rows
E. SALES1 has PRIMARY KEY and UNIQUE constraints on any selected columns which had those constraints in the SALES table.

正解: C,D

質問 60
Which statement is true about transactions?

A. Each Data Definition Language (DDL) statement executed forms a single transaction.
B. A set of DDL statements executed in a sequence ending with a COMMIT forms a single transaction.
C. A combination of DDL and DML statements executed in a sequence ending with a COMMIT forms a single transaction.
D. A set of Data Manipulation Language (DML) statements executed in a sequence ending with a SAVEPOINT forms a single transaction.

正解: A

解説:
References:
https://docs.oracle.com/database/121/CNCPT/transact.htm#CNCPT038

質問 61
Which three statements are true about indexes and their administration in an Oracle database?

A. An index can be created as part of a CREATE TABLE statement.
B. If a query filters on an indexed column then it will always be used during execution of the query.
C. An INVISIBLE index is not maintained when Data Manipulation Language (DML) is performed on its underlying table.
D. A descending index is a type of function-based index.
E. A DROP INDEX statement always prevents updates to the table during the drop operation.
F. A UNIQUE and non-unique index can be created on the same table column.

正解: A,C,D

質問 62
View the Exhibit and examine the structure of CUSTOMERS table.

Evaluate the following query:

Which statement is true regarding the above query?

A. It produces an error because conditions on the CUST_CREDIT_LIMIT column are not valid.
B. It produces an error because the condition on the CUST_CITY column is not valid.
C. It produces an error because the condition on the CUST_FIRST_NAME column is not valid.
D. It executes successfully.

正解: D

質問 63
Which three statements are true about views in an Oracle Database? (Choose three.)

A. Views can join tables only if they belong to the same schema.
B. Views have no object number.
C. A SELECT statement cannot contain a WHERE clause when querying a view containing a WHEREclause in its defining query.
D. Rows inserted into a table using a view are retained in the table if the view is dropped.
E. A view can be created that refers to a non-existent table in its defining query.
F. Views have no segment.

正解: A,B,E

解説:
Explanation/Reference: https://docs.oracle.com/cd/B28359_01/server.111/b28286/statements_8004.htm#SQLRF01504
https://community.oracle.com/thread/2178948

質問 64
Choose two
Examine the description of the PRODUCT DETALS table:

A. EXPIRY_DATE contains the SYSDATE by default if no date is assigned to it
B. PRODUCT_NAME cannot contain duplicate values.
C. EXPIRY_DATE cannot be used in arithmetic expressions.
D. PRODUCT_PRICE contains the value zero by default if no value is assigned to it.
E. PRODUCT_PRICE can be used in an arithmetic expression even if it has no value stored in it
F. PRODUCT_ID can be assigned the PEIMARY KEY constraint.

正解: E,F

質問 65
Examine these SQL statements which execute successfully:

Which two statements are true after execution?

A. The primary key constraint will be enabled and IMMEDIATE.
B. The foreign key constraint will be enabled and IMMEDIATE.
C. The foreign key constraint will be enabled and DEFERRED.
D. The foreign key constraint will be disabled.
E. The primary key constraint will be enabled and DEFERRED.

正解: B,E

質問 66
Which two are true about dropping columns from a table? (Choose two.)

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

正解: A,B

質問 67
Which three statements are true? (Choose three.)

A. The data dictionary views consist of joins of dictionary base tables and user-defined tables.
B. The usernames of all the users including the database administrators are stored in the data dictionary.
C. Views with the same name but different prefixes, such as DBA, ALLand USER, reference the same base tables from the data dictionary.
D. The data dictionary is created and maintained by the database administrator.
E. The USER_CONS_COLUMNSview should be queried to find the names of the columns to which constraints apply.
F. Both USER_OBJECTSand CATviews provide the same information about all the objects that are owned by the user.

正解: B,C,E

解説:
Explanation/Reference:
References:
https://docs.oracle.com/cd/B10501_01/server.920/a96524/c05dicti.htm

質問 68
View the exhibit and examine the descriptions of the DEPTand LOCATIONStables.

You want to update the CITYcolumn of the DEPTtable for all the rows with the corresponding value in the CITYcolumn of the LOCATIONStable for each department.
Which SQL statement would you execute to accomplish the task?

A. UPDATE dept d
SET city = (SELECT city
FROM locations l
WHERE d.location_id = l.location_id);
B. UPDATE dept d
SET city = ANY (SELECT city
FROM locations l)
C. UPDATE dept d
SET city = (SELECT city
FROM locations l)
WHERE d.location_id = l.location_id;
D. UPDATE dept d
SET city = ALL (SELECT city
FROM locations l
WHERE d.location_id = l.location_id);

正解: A

解説:
Explanation/Reference:

質問 69
......

無料1z0-071別格な問題集をダウンロード：https://www.goshiken.com/Oracle/1z0-071-mondaishu.html

1z0-071問題集で2022年最新のOracle試験問題：https://drive.google.com/open?id=1gH0HuaVk8Xn1-EYj-N6DsTL2N-yMhtfV

関するブログ

もっと

1z0-071無料問題集