On your Oracle 12c database, you Issue the following commands to create indexes<br /> SQL > CREATE INDEX oe.ord_customer_ix1 ON oe.orders (customers_id, sales_rep_id) INVISIBLE;<br /> SQL> CREATE BITMAP INDEX oe.ord_customer_ix2 ON oe.orders (customers_id, sales_rep_id);<br /> Which two statement are correct?（）..

第1题

[] You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?（） You notice a performance change in your production Oracle 12c database. You want to know which change caused this performance difference. Which method or feature should you use?（）

A、A. Compare Period ADDM report B、B. AWR Compare Period report C、C. Active Session History (ASH) report D、D. Taking a new snapshot and comparing it with a preserved snapshot

点击查看答案

第2题

[] You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB) as a pluggable database (PDB). The characteristics of the non-CDB are as follows: -Version: Oracle Database 12c Releases 1 64-bit -Character set: WE8ISO8859P15 -National character set: AL16UTF16 -O/S: Oracle Linux 6 64-bit The characteristics of the CDB are as follows: -Version: Oracle Database 12c Release 1 64-bit -Character set: AL32UTF8 -O/S: Oracle Linux 6 64-bit Which technique should you use to minimize down time while plugging this non-CDB into the CDB?（） You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB) as a pluggable database (PDB). The characteristics of the non-CDB are as follows: -Version: Oracle Database 12c Releases 1 64-bit -Character set: WE8ISO8859P15 -National character set: AL16UTF16 -O/S: Oracle Linux 6 64-bit The characteristics of the CDB are as follows

A、A. Transportable database B、B. Transportable tablespace C、C. Data Pump full export / import D、D. The DBMS_PDB package E、E. RMAN

点击查看答案

第3题

[判断题] 相对原子质量是指某原子的质量与12C原子质量的1/12的比值。

点击查看答案

第4题

[多选题] On your Oracle 12c database, you invoked SQL *Loader to load data into the EMPLOYEES table in the HR schema by issuing the following command: $> sqlldr hr/hr@pdb table=employees Which two statements are true regarding the command?（）

A、It succeeds with default settings if the EMPLOYEES table belonging to HR is already defined in the database. B、It fails because no SQL *Loader data file location is specified. C、It fails if the HR user does not have the CREATE ANY DIRECTORY privilege. D、It fails because no SQL *Loader control file location is specified.

点击查看答案

第5题

[] The following parameter are set for your Oracle 12c database instance: OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE You want to manage the SQL plan evolution task manually. Examine the following steps: 1. Set the evolve task parameters. 2. Create the evolve task by using the DBMS_SPM.CREATE_EVOLVE_TASK function. 3. Implement the recommendations in the task by using the DBMS_SPM.IMPLEMENT_EVOLVE_TASK function. 4. Execute the evolve task by using the DBMS_SPM.EXECUTE_EVOLVE_TASK function. 5. Report the task outcome by using the DBMS_SPM.REPORT_EVOLVE_TASK function. Identify the correct sequence of steps:（） The following parameter are set for your Oracle 12c database instance: OPTIMIZER_CAPTURE_SQL_PLAN_BASELINES=FALSE OPTIMIZER_USE_SQL_PLAN_BASELINES=TRUE You want to manage the SQL plan evolution task manually. Examine the following steps: 1. Set the evolve task para

A、A.2，4，5 B、B.2，1，4，3，5 C、C.1，2，3，4，5 D、D.1，2，4，5

点击查看答案

第6题

[多选题] You support Oracle Database 12c Oracle Database 11g, and Oracle Database log on the same server. All databases of all versions use Automatic Storage Management (ASM). Which three statements are true about the ASM disk group compatibility attributes that are set for a disk group?（）

A、The ASM compatibility attribute controls the format of the disk group metadata. B、RDBMS compatibility together with the database version determines whether a database Instance can mount the ASM disk group. C、The RDBMS compatibility setting allows only databases set to the same version as the compatibility value, to mount the ASM disk group. D、The ASM compatibility attribute determines some of the ASM features that may be used by the Oracle disk group. E、The ADVM compatibility attribute determines the ACFS features that may be used by the Oracle 10g database.

点击查看答案

第7题

[简答题] 乙炔车间的DCS系统控制站使用的ADM12C，ADM52C联接的是什么信号？

点击查看答案

第8题

[多选题] You work as a database administrator for Certkiller .com. You want to administer your database servers，which are running on different host machines，using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective？（）

A、Application Server Control B、Oracle Management Service C、Oracle Enterprise Manager Repository D、Oracle Enterprise Manager Database Control

点击查看答案

第9题

[] You work as a database administrator for Supportcenter.cn. You want to administer your database servers， which are running on different host machines， using the Web-enabled grid control interface. You have configured the agent on the host machines. You have started the Oracle Database 10g Grid Control utility on your machine. Which two additional components would you configure to achieve this objective？（）

A、A.Application Server Control B、B.Oracle Management Service C、C.Oracle Enterprise Manager Repository D、D.Oracle Enterprise Manager Database Control

点击查看答案

请使用微信扫码支付