最新的OCP認證 1z0-067考試題庫

問題1

Which four actions are possible during an Online Datafile Move operation?

A. Querying tables in the datafile being moved

B. Performing file shrink of the data file being moved

C. Performing Block Media Recovery for a data block in the datafile being moved

D. Creating and dropping tables in the datafile being moved

E. Executing DML statements on objects stored in the datafile being moved

F. Flashing back the database

正確答案: A,D,E,F

說明：（僅 VCESoft 成員可見）

問題2

In a database supporting an OLTP workload, tables are frequently updated on both key and non-keycolumns.
Reports are also generated by joining multiple tables.
Which table organization or type would provide the best performance for this hybrid workload?

A. external table

B. global temporary table

C. hash clustered table

D. index clustered table

E. heap table with a primary key index

正確答案: D

說明：（僅 VCESoft 成員可見）

問題3

A redaction policy was added to the SAL column of the SCOTT.EMP table:
BEGIN
DBMS_REDACT.ADD_POLICY(
OBJECT_SCHEMA => 'SCOTT',
OBJECT_NAME => 'EMP',
POLICY_NAME => 'SCOTT_EMP',
COLUMN_NAME => 'SAL',
EXPRESSION => 'SYS_CONTEXT (''SYS_SESSION_ROLES'', ''MGR'') = ''FALSE'''); END;
/
All users have their default set of system privileges.
For which three situations will data not be redacted? (Choose three.)

A. SYSTEM sessions, regardless of the roles that are set in the session

B. SCOTT sessions, only if the MGR role is granted to SCOTT

C. SYS sessions, regardless of the roles that are set in the session

D. SCOTT sessions, because he is the owner of the table

E. SCOTT sessions, only if the MGR role is set in the session

正確答案: B,C,E

問題4

Which three statements are true about transportable databases? (Choose three.)

A. Recovery Manager (RMAN) is used to convert the necessary data files of a database if the endian format of the target platform is different

B. Both the source and target databases must use the same character set

C. Redo logs and control files are also transported

D. The COMPATIBLE parameter must be set to 10.0.0 or higher and the database must be opened in read-only mode before being transported

E. The transported database must have the same database identifier (DBID) as the source database

正確答案: A,C,D

問題5

You wish to create jobs to satisfy these requirements:
1. Automatically bulk load data from a flat file.
2. Rebuild indexes on the SALES table after completion of the bulk load.
How would you create these jobs?

A. Create both jobs using application raised events.

B. Create one job to rebuild indexes using Scheduler raised events and another job to perform bulk load by using events raised by the application.

C. Create one job to rebuild indexes using application raised events and another job to perform bulk load using Scheduler raised events.

D. Create both jobs by using Scheduler raised events.

正確答案: C

說明：（僅 VCESoft 成員可見）

問題6

Your database instance is abnormally terminated because of a power outage. At the next startup, from which point in the redo log does the recovery start?
Choose the best answer.

A. from the beginning of the current redo log file to the checkpoint position

B. from the last committed transaction

C. from the most recent incremental checkpoint

D. from the last complete checkpoint position

E. from the beginning of the current redo log file until the instance failure

正確答案: D

問題7

You want to reduce fragmentation and reclaim unused space for the sales table but not its dependent objects.
During this operation, you want to ensure the following:
i.Long-running queries are not affected.
ii.No extra space is used.
iii.Data manipulation language (DML) operations on the table succeed at all times throughout the process.
iv.Unused space is reclaimed both above and below the high water mark.
Which alter TABLE option would you recommend?

A. SHRINK SPACE CASCADE

B. SHRINK SPACE COMPACT

C. DEALLOCATE UNUSED

D. ROW STORE COMPRESS BASIC

正確答案: B

說明：（僅 VCESoft 成員可見）

問題8

The CATDB12C database contains an Oracle Database 12c catalog schema owned by the rc12c user.
The CATDB11 database contains an Oracle Database 11g catalog schema owned by the rc11 user.
A database with dbid=1423241 is registered in the catdb11 catalog. Both the recovery catalog databases are open.
In the CATDB12c database, you execute the commands:
$rman
RKAN> CONNECT CATALOG rc12c/pass12c@catdb12c
RKAN> IMPORT CATALOG rc11/pwdcat11@catdb11 DBID=1423241;
What is the outcome of the import?

A. It fails because RMAN is not connected to the target database with DBID=1423241

B. It succeeds and all global scripts in the RC11 catalog that have the same name as existing global scripts in the RCI2C catalog are automatically renamed.

C. It fails because the target database and recovery catalog database are of different versions.

D. It succeeds but the database is not automatically registered in the RC12C catalog.

正確答案: C

說明：（僅 VCESoft 成員可見）

問題9

You plan to use the In-Database Archiving feature of Oracle Database 12c, and store rows that are inactive for over three months, in Hybrid Columnar Compressed (HCC) format.
Which three storage options support the use of HCC?

A. ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files

B. Database files stored in any file system and accessed using the Oracle Direct NFS feature

C. ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays

D. Database files stored in ZFS and accessed using the Oracle Direct NFS feature

E. ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array

F. Database files stored in ZFS and accessed using conventional NFS mounts.

G. ASM disk groups with ASM disks consisting of Exadata Grid Disks.

正確答案: C,D,G

說明：（僅 VCESoft 成員可見）

問題10

Which statement is true about Enterprise Manager (EM) express in Oracle Database 12c?

A. You can use EM express to manage multiple databases running on the same server.

B. By default, EM express is available for a database after database creation.

C. You can perform basic administrative tasks for pluggable databases by using the EM express interface.

D. You can create and configure pluggable databases by using EM express.

E. You cannot start up or shut down a database instance by using create and configure pluggable databases by using EM express.

正確答案: B

說明：（僅 VCESoft 成員可見）

最新的Oracle Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP - 1z0-067免費考試真題

最新更新

站內鏈接

聯系我們