最新的Oracle 1z1-067免費考試真題

問題1

RMAN is connected to the target database PROD1 and an auxiliary instance in NOMOUNT state. Examine the command to create a duplicate database:
RMAN> DUPLICATE TARGET DATABASE TO dup1
FROM ACTIVE DATABASE
NOFILENAMECHECK
PASSWORD FILE
SPFILE;
Which two statements are true about the execution of the DUPLICATE command?

A. The duplicate database is created without using RMAN backups and PROD1 is allowed to remain open during duplication.

B. All archive redo log files are automatically copied to the duplicate database.

C. The duplicate database is created by using the backups created during the execution of the DUPLICATE command.

D. The password file and SPFILE for the duplicate database DUP1 are created in their respective default locations.

E. The duplicate database has the same directory structure as the source database.

正確答案: A,B

問題2

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. Compare Period ADDM report

B. AWR Compare Period report

C. taking a new snapshot and comparing it with a preserved snapshot

D. Active Session History (ASH) report

正確答案: B

說明：（僅 Fast2test 成員可見）

問題3

Examine the commands executed in CDB$ROOT of your multitenant container database (CDB) that has multiple pluggable databases (PDB):
SQL> CREATE ROLE c ##role1 CONTAINER-ALL;
SQL> GRANT CREATE SESSION, CREATE TABLE TO c##role1 CONTAINER'ALL;
SQL>CREATE USER c##admin IDENTIFIED BY orcl123;
SQL>GRANT c##role1 TO c##admin CONTAINER=ALL;
SQL> GRANT SELECT ON DBA_USERS to c##role1 CONTAINER*ALL;
Which statement is true about granting the select privilege on the DBA_users view to the c##ROLE1role?

A. The command succeeds and the common user c##admin can create a session and query the DBA users view only in CDB$ROOT

B. The command succeeds and the common user c##admin can create a session and query the DBA_users view in CDB$ROOT and all the PDBs.

C. The command succeeds and the common user c##admin can create a session in CDB$ROOT and all the PDBs, but can only query the dba_users view in CDB$ROOT

D. The command fails and gives an error because object privileges cannot be granted to a common user.

E. The command fails because container is not set to current.

正確答案: B

問題4

Which two statements are true about Flashback Version Query?

A. The result of a query can be used as part of a DML statement.

B. It can be used to create views.

C. It retrieves all versions of rows that exist in a time interval, including the start time and end time.

D. It can be used to retrieve the SQL that is required to undo a row change and the user responsible for the change.

E. It can be used only if Flashback Data Archive is enabled for a table.

正確答案: C,D

問題5

Your multitenant container database (CDB) cdb1, which has no startup triggers and contains multiple pluggable databases (PDBs), is started up by using the command:
SQL>STARTUP
Which two statements are true about the successful execution of the command?

A. The root, the seed, and all the PDBs are opened in read-write mode.

B. All redo log files are opened.

C. All the PDBs are in closed state.

D. All the PDBs are opened in read-write mode.

E. Only the root database is opened in read-write mode.

正確答案: B,E

說明：（僅 Fast2test 成員可見）

問題6

Examine the commands executed to monitor database operations:
$> conn sys/oracle@prod as sysdba
SQL> VAR eid NUMBER
SQL>EXEC :eid :=
DBMS_SQL_MONITOR.BEGlN_OPERATION('batch_job',FORCED_TRACKING=>'Y');
Which two statements are true?

A. Database operations will be monitored only when they consume a significant amount of resource.

B. All subsequent statements in the session will be treated as one database operation and will be monitored.

C. Only DML and DDL statements will be monitored for the session.

D. Database operations for all sessions will be monitored.

E. Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + TUNING.

正確答案: B,E

說明：（僅 Fast2test 成員可見）

問題7

Examine the output:
SQL > ARCHIVE LOGLIST
Database log mode Archive Mode
Automatic archival Enabled
Archive Destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 376
Next log sequence to archive 378
Current log sequence 378
Which three types of files are automatically placed in the fast recovery area?

A. Control file autobackups

B. Flashback data archives (FDA)

C. Archived redo log files

D. Server parameter file (SPFILE)

E. Recovery Manager (RMAN) backup pieces

正確答案: A,C,E

說明：（僅 Fast2test 成員可見）

問題8

Which two statements are true about RMAN duplexed backups? (Choose two.)

A. It is not supported for image copies.

B. It is only supported for backups to tape via media management interface.

C. For performing duplexed backups, the parallelism for the device must be set equal to the number of copies.

D. Duplex backups can be performed on either disk or media, but cannot be performed on media and disk simultaneously.

E. Duplex backups can contain only data files and control files.

正確答案: A,D

問題9

Which three statements are true about unplugging a pluggable database (PDB)? (Choose three.)

A. An unplugged PDB can be plugged into the same or another container database (CDB).

B. A PDB must have been opened at least once after creation.

C. PDB data files are automatically removed from disk.

D. A PDB must be in closed state before it can be unplugged.

E. A PDB must be in MOUNT state before it can be unplugged.

正確答案: A,D,E

問題10

Which two are prerequisites for creating a backup-based duplicate database?

A. creating an SPFILE for the target database

B. matching the database identifier (DBID) of the source database and the duplicate database

C. connecting to the target database and a recovery catalog to execute the duplicate command

D. connecting to an auxiliary instance

E. creating a password file for an auxiliary instance

正確答案: D,E

說明：（僅 Fast2test 成員可見）

問題11

Which three statements are true about the keystore storage framework for transparent data encryption?

A. It facilitates and helps to enforce keystore backup requirements.

B. It enables a keystore to be stored only in a file on a file system.

C. It transparently decrypts data for the database users and applications that access this data.

D. It helps to track encryption keys and implement requirements such as keystore password rotation and master encryption key reset or re-key operations.

E. It enables separation of duties between the database administrator and the security administrator.

F. It handles encrypted data without modifying applications.

正確答案: A,D,E

說明：（僅 Fast2test 成員可見）

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

聯系我們

站內鏈接

最新更新