1z0-047 考試是 Oracle認證的 Oracle Database SQL Expert 認證考試官方代號，Oracle Database SQL Expert 認證作為全球IT領域專家 Oracle 熱門認證之壹，是許多大中IT企業選擇人才標準的必備條件。

Other Oracle Certification認證是業界最廣泛認可的IT技術認證之壹，也是業界最權威、最受尊敬的認證之壹。獲得1z0-047認證不僅僅能證明您的IT技術能力，更是您進入職場的敲門磚，也是提高您身價的另壹捷徑。

Examsoon的Oracle認證考古題由資深IT認證講師和Oracle産品專家結合PROMETRIC或VUE的真實考試環境最新原題傾心打造。

Examsoon認證考試題庫－始終致力與爲客戶提供ORACLE 認證的全真考題及認證學習資料,助您壹次通過ORACLE 認證考試。下面是ORACLE 認證考試1Z0-047考古題分享：

1z0-047考古題問題與答案賞析

1. You need to load information about new customers from the NEW_CUST table into the tables CUST and CUST_SPECIAL. If a new customer has a credit limit greater than 10,000, then the details have to be inserted into CUST_SPECIAL. All new customer details have to be inserted into the CUST table. Which technique should be used to load the data most efficiently?

A. external table

B. the MERGE command

C. the multitable INSERT command

D. INSERT using WITH CHECK OPTION

Answer: C

2. Which three tasks can be performed using regular expression support in Oracle Database 10g? (Choose three.)

A. It can be used to concatenate two strings.

B. It can be used to find out the total length of the string.

C. It can be used for string manipulation and searching operations.

D. It can be used to format the output for a column or expression having string data.

E. It can be used to find and replace operations for a column or expression having string data.

Answer: CDE

3. Which two statements are true? (Choose two.)

A. The USER_SYNONYMS view can provide information about private synonyms.

B. The user SYSTEM owns all the base tables and user-accessible views of the data dictionary.

C. All the dynamic performance views prefixed with V$ are accessible to all the database users.

D. The USER_OBJECTS view can provide information about the tables and views created by the user only.

E. DICTIONARY is a view that contains the names of all the data dictionary views that the user can access.

Answer: AE

4. In which scenario would you use the ROLLUP operator for expression or columns within a GROUP BY clause?

A. to find the groups forming the subtotal in a row

B. to create group-wise grand totals for the groups specified within a GROUP BY clause

C. to create a grouping for expressions or columns specified within a GROUP BY clause in one direction,

from right to left for calculating the subtotals

D. to create a grouping for expressions or columns specified within a GROUP BY clause in all possible directions, which is cross-tabular report for calculating the subtotals

Answer: C

5. OE and SCOTT are the users in the database. The ORDERS table is owned by OE. Evaluate the

statements issued by the DBA in the following sequence: CREATE ROLE r1; GRANT SELECT, INSERT ON oe.orders TO r1; GRANT r1 TO scott; GRANT SELECT ON oe.orders TO scott; REVOKE SELECT ON oe.orders FROM scott; What would be the outcome after executing the statements?

A. SCOTT would be able to query the OE.ORDERS table.

B. SCOTT would not be able to query the OE.ORDERS table.

C. The REVOKE statement would remove the SELECT privilege from SCOTT as well as from the role R1.

D. The REVOKE statement would give an error because the SELECT privilege has been granted to the role R1.

Answer: A

1z0-047考試資料：

Oracle Database SQL Expert

科目編號 : 1z0-047

科目名稱 : Oracle Database SQL Expert

分享更多證照考試科目代碼：

350-040