Oracle 12c 1z0-071认证考试实战题目与解答

需积分: 25 56 浏览量更新于2024-07-17 收藏 3.38MB PDF 举报

"Oracle OCP 12c认证考试1z0-071的最新实用题库提供了针对Oracle数据库管理的实践测试题目。该题库包含了标准答案，适合考生参考学习，以准备Oracle Certified Professional (OCP) 12c的认证考试。" Oracle OCP 12c认证是Oracle公司为数据库管理员提供的专业认证，1z0-071是其中的一个考试科目，主要考察的是Oracle 12c数据库的管理技能。这个认证对那些希望在Oracle数据库管理领域提升专业能力的IT专业人士至关重要。题目示例展示了SQL查询语句的应用，这在1z0-071考试中是常见的考核内容。题目的目标是根据给定的条件从`stores`表中提取特定信息： 1. 查询应返回`name`（商店名称）。 2. 合并`address`、`city`和`country`字段形成`full_address`。 3. 显示`start_date`（开业日期）。 4. 显示`property_price`（物业价格）。 5. 计算`projected_property_price`，即物业价格的115%。四个选项中，正确答案需要满足以下条件： - 使用`concat`函数将地址字段组合成一个完整的地址。 - 使用`MONTHS_BETWEEN`函数计算`start_date`与'01-JAN-2000'之间的月数，确保开业日期在36个月的范围内。 - 计算`property_price`的115%，需用到乘法操作。 - 使用`TO_DATE`函数将字符串转换为日期格式。分析选项： A) 使用了`TO_NUMBER`函数，但这里并不需要将日期转换为数值，因此不正确。 B) 计算物业价格的提升比例时错误地使用了`property_price*15/100`，应该是`property_price*115/100`，所以此选项不正确。 C) `MONTHS_BETWEEN`函数使用正确，但未指定日期格式，可能导致解析错误，因此不正确。 D) 此选项正确地组合了所有要求的条件，包括`concat`函数、`MONTHS_BETWEEN`函数、正确的日期格式转换以及计算115%的物业价格。因此，正确答案是D)。这个例子体现了在实际数据库操作中如何构造复杂的SQL查询来满足特定业务需求，是Oracle OCP 12c认证考试中会涉及的关键技能之一。通过这样的练习，考生可以提高对Oracle SQL语法的理解，以及在实际场景中应用这些知识的能力。

Examine this select statement and view the Exhibit to see its output:

SELECT constrain_name, constraint_type, search_condition, r_constraint_namer delete_rule, status

FROM user_constraints WHERE table_naine = 'ORDERS'

Which two statements are true about the output?

A) In the second column, 'C' indicates a check 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) The R_CONSTRAINST_NAME column contains an alternative name for the constraint.

Answer: AC

Q34.

Q|Exibit

View the Exhibit and examine the structure of the orders and order_items tables

You must create a view that selects the order id, order_date, and the total number of items in each order. Which create

view statement would create the view successfully?

A) CREATE OR REPLACE VIEW ord_vu AS

SELECT o.order_id, o.order_date, COUNT (i. line_item_id | | ' NO OF ITEMS

FROM orders o JOIN order_items I ON (o.order_id=i.order_id)

GROUP BY o.order_id, o.order_date WITH CHECK OPTION;

B) CREATE OR REPLACE VIEW ord_vu (order_id,order_date) AS

SELECT o.order_id, o. order_date, COUNT (i. Line_item_id "NO OF ITEMS"

FROM orders o JOIN order_items i ON (o.order_id = i.order_id)

GROUP BY o. order_id, o. order_date;

C) CREATE OR REPLACE VIEW ord_vu AS

SELECT o.order_id, o.order_date, COUNT (i. line_item_id)

FROM orders o JOIN order_items i

on (o.order_id = i.order_id)

GROUP BY o.order_id,o.order_date;

D) CREATE OR REPLACE VIEW ord_vu AS

SELECT o.order_id, o . order_date, COUNT (i. line_item_id) "NO OF ITEMS"

FROM orders o JOIN order_items i

ON (o.order_id = i.order_id)

GROUP BY o.order id,o.order date;

Answer: D

Q35.

Evaluate this SQL statement:

SELECT product_name | |' it's not available for order'

FROM product_information

WHERE product_status = 'obsolete';

You received this error:

ERROR: ORA-01756: quoted string not properly terminated

What would you do to execute the query successfully?

A) Remove the single quotation marks enclosing the character literal string in the select clause

B) Use the escape character to negate the single quotation mark within the literal character string in the select clause.

C) Enclose the character literal string in the select clause within double quotation marks.

D) Use the Quote (q) operator and delimiter to allow the use of a single quotation mark within the literal character string

in the SELECT clause.

Answer: D

Q36.

You muat display the date for the first Monday of the next month and issue this command:

SQL> SELECT to_char(NEXT_DAY(LAST_DAY(SYSDATE) , 'MON' ) ,'dd "is the first Monday for" fmmonth rrrr') FROM DUAL;

What is the result?

A) It generates an error because rrrr should be replaced by rr in the format string.

B) It generates an error because to_char should be replaced with to_date

C) It generates an error because fm and double quotation marks should not be used in the format string.

D) It executes successfully and returns the correct result.

E) It executes successfully but does not return the correct result.

Answer: D

Q37.

Choose three.

You issue this command which succeeds:

SGL> DROP TABLE products;

Which three statements are true?

A) Table data is deleted but the table structure is retained

B) Table data and the table structure are deleted

C) All existing views and synonyms that refer to the table are invalidated but retained

D) All the table's indexes if any exist, are invalidated but retained

E) Any uncommitted transaction in the session is committed

Answer: BCE

Q38.

Which statement is true regarding the default behavior of the order by clause?

剩余86页未读，继续阅读

aninao

粉丝: 3
资源: 22

Oracle 12c 1z0-071认证考试实战题目与解答

ORACLE-OCP-071考试题目和答案附带解析

Oracle Database 12c SQL v6.0 (1z0-071)

2018 OCP 1z0-071 最新题库

Oracle OCP 12c认证考试1z0-063实用题库

Oracle 12C OCP最新题库，1Z0-062_166Q / 1Z0-062_362Q / 1Z0-063 / 1Z0-071，含答案解析说明

OCP 12C 题库1Z0-062 1Z0-063-Q263 1Z0-071更20.5.28_Q237

Oracle OCP 1z0-071 SQL考试题库解析

oracle升级OCP到12c考试题库 Oracle-1z0-060

Oracle OCP 12C升级考试 060题库

Oracle OCP考试题库解析：1Z0-071-20210115

最新资源