最新的Oracle 1Z0-060免費考試真題

問題1

Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyze impact on the performance of SQL statements.

A. Change in the hardware configuration of the database server

B. Change in your network infrastructure

C. Database and operating system upgrade

D. Change in the Oracle Database version

E. Migration of database storage from non-ASM to ASM storage

正確答案: A,C,D

說明：（僅 Fast2test 成員可見）

問題2

Which two statements are true about the RMAN validate database command?

A. It can detect corruptpfiles.

B. It checks the database for interblock corruptions.

C. It can detect corruptspfiles.

D. It can detect corrupt block change tracking files.

E. It checks the database for intrablock corruptions.

正確答案: C,E

說明：（僅 Fast2test 成員可見）

問題3

You created a new database using the "create database" statement without specifying the
"ENABLE PLUGGABLE" clause.
What are two effects of not using the "ENABLE PLUGGABLE database" clause?

A. The database is created as a non-CDB and can never be plugged into a CDB.

B. The database is created as a non-CDB but will become a CDB whenever the first PDB is plugged in.

C. The database is created as a non-CDB and can never contain a PDB.

D. The database is created as a non-CDB but can be plugged into an existing CDB.

E. The database is treated as a PDB and must be plugged into an existing multitenant container database (CDB).

正確答案: C,D

說明：（僅 Fast2test 成員可見）

問題4

Which three SQL statements would display the value 1890.55 as $1, 890.55?

A. Option D

B. Option B

C. Option C

D. Option E

E. Option A

正確答案: A,D,E

問題5

Which two are true concerning a multitenant container database with three pluggable databases?

A. Pluggable databases can make database consolidation easier

B. All administration tasks must be done to each pluggable database.

C. Pluggable databases in the same container database (CDB) each have their own buffer cache

D. Pluggable databases are patched together

E. Pluggable databases increase patching time.

正確答案: A,D

問題6

What are two benefits of installing Grid Infrastructure software for a stand-alone server before installing and creating an Oracle database?

A. Helps you to easily upgrade the database from a prior release.

B. Enables the Installation of Grid Infrastructure files on block or raw devices.

C. Effectively implements role separation

D. Automatically registers the database with Oracle Restart.

E. Enables you to take advantage of Oracle Managed Files.

正確答案: C,D

說明：（僅 Fast2test 成員可見）

問題7

In a recent Automatic Workload Repository (AWR) report for your database, you notice a high number of buffer busy waits. The database consists of locally managed tablespaces with free list managed segments.
On further investigation, you find that buffer busy waits is caused by contention on data blocks.
Which option would you consider first to decrease the wait event immediately?

A. Using Automatic Segment Space Management (ASSM)

B. Decreasing PCTUSED

C. Decreasing PCTFREE

D. Increasing db_buffer_cache based on the V$DB_CACHE_ADVICE recommendation

E. Increasing the number of DBWNprocess

正確答案: A

說明：（僅 Fast2test 成員可見）

問題8

You executed a DROP USER CASCADE on an Oracle 11g release 1 database and immediately realized that you forgot to copy the OCA.EXAM_RESULTS table to the OCP schema.
The RECYCLE_BIN enabled before the DROP USER was executed and the OCP user has been granted the FLASHBACK ANY TABLE system privilege.
What is the quickest way to recover the contents of the OCA.EXAM_RESULTS table to the OCP schema?

A. Execute FLASHBACK TABLE OCA.EXAM_RESULTS TO BEFORE DROP RENAME TO
EXAM_RESULTS; connected as the OCP user.

B. Recovery the table sing Database Point In Time Recovery.

C. Recover the table using traditional Tablespace Point In Time Recovery.

D. Recover the table using Automated Tablespace Point In Time Recovery.

E. Execute FLASHBACK TABLE OCA.EXAM_RESULTS TO BEFORE DROP RENAME TO
OCP.EXAM_RESULTS; connected as SYSTEM.

正確答案: D

說明：（僅 Fast2test 成員可見）

問題9

Which two partitioned table maintenance operations support asynchronous Global Index Maintenance in Oracle database 12c?

A. ALTER TABLE DROP PARTITION

B. ALTER TABLE TRUNCATE PARTITION

C. ALTER TABLE SPLIT PARTITION

D. ALTER TABLE ADD PARTITION

E. ALTER TABLE MERGE PARTITION

F. ALTER TABLE MOVE PARTITION

正確答案: A,B

說明：（僅 Fast2test 成員可見）

問題10

You have altered a non-unique index to be invisible to determine if queries execute within an acceptable response time without using this index.
Which two are possible if table updates are performed which affect the invisible index columns?

A. The index becomes unusable but the table is updated by the DML.

B. The index is not updated by the DML statements on the indexed table.

C. The index automatically becomes visible in order to have it updated by DML on the table.

D. The index is updated by the DML on the table.

E. The index remains invisible.

正確答案: D,E

說明：（僅 Fast2test 成員可見）

問題11

Which statement is true about Oracle Net Listener?

A. It acts as the listening endpoint for the Oracle database instance for all local and non-local user connections.

B. Service registration with the listener is performed by the listener registration process monitor (LREG) process of each database instance.

C. A single listener can service only one database instance and multiple remote client connections.

D. The listener.ora configuration file must be located in the ORACLE_HOME/network/admin directly.

E. The listener.ora configuration file must be configured with one or more listening protocol addresses to allow remote users to connect to a database instance.

正確答案: B

說明：（僅 Fast2test 成員可見）

問題12

You are about to plug a multi-terabyte non-CDB into an existing multitenant container database (CDB).
The characteristics of the non-CDB are as follows:
- Version: Oracle Database 11gRelease 2 (11.2.0.2.0) 64-bit
- Character set: AL32UTF8
- 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
- National character set: AL16UTF16
- O/S: Oracle Linux 6 64-bit
Which technique should you use to minimize down time while plugging this non-CDB into the CDB?

A. RMAN

B. The DBMS_PDB package

C. Transportable database

D. Data Pump full export/import

E. Transportable tablespace

正確答案: E

說明：（僅 Fast2test 成員可見）

問題13

Your multitenant container database (CDB) contains a pluggable database, HR_PDB. The default permanent tablespace in HR_PDB is USERDATA. The container database (CDB) is open and you connect RMAN.
You want to Issue the following RMAN command:
RMAN > BACKUP TABLESPACE hr_pdb:userdata;
Which task should you perform before issuing the command?

A. Place the root container in the nomount stage.

B. Ensure that HR_PDB is open.

C. Take the user data tablespace offline.

D. Place the root container in ARHCHIVELOG mode.

正確答案: D

問題14

You are connected using SQL* Plus to a multitenant container database (CDB) with SYSDBA privileges and execute the following sequence statements:

What is the result of the last SET CONTAINERstatement and why is it so?

A. It succeeds because the PDB_ADMIN user has the required privileges.

B. It fails because local users are unable to use the SET CONTAINER statement.

C. If fails because the SET CONTAINER statement cannot be used with PDB$SEED as the target pluggable database (PDB).

D. It fails because common users are unable to use the SET CONTAINER statement.

正確答案: B

說明：（僅 Fast2test 成員可見）

問題15

You execute the following PL/SQL:

Which two statements are true?

A. FGA is enabled for the PRICE column of the PRODUCTS table and the SQL statements is captured in the FGA audit trial.

B. Fine-Grained Auditing (FGA) is enabled for the PRICE column in the PRODUCTS table for SELECT statements only when a row with PRICE > 10000 is accessed.

C. FGA is enabled for all DML operations by JIMon the PRODUCTS.PRICE column.

D. FGA is enabled for the PRODUCTS.PRICE column and an audit record is written whenever a row with PRICE > 10000 is accessed.

正確答案: A,B

說明：（僅 Fast2test 成員可見）

最新的Oracle Upgrade to Oracle Database 12c - 1Z0-060免費考試真題

聯系我們

站內鏈接

最新更新