Winter Sale Special Limited Time 65% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: v4s65

  1. Home
  2. Oracle
  3. Oracle Database 12c
  4. 1z0-067 - Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP
Note! Following 1z0-067 Exam is Retired now. Please select the alternative replacement for your Exam Certification.

1z0-067 Exam Dumps - Upgrade Oracle9i/10g/11g OCA to Oracle Database 12c OCP

Go to page:
Question # 17

Examine the following impdp command to import a database over the network from a pre-12c Oracle database (source):

$> impdp full=Y network_link=hrdb_test transportable=always

transport_datafiles=

‘/u01/app/oracle/oradata/hrdb/sales01.dbf’,

‘/u01/app/oracle/oradata/hrdb/cust01.dbf’,

‘/u01/app/oracle/oradata/hrdb/emp01.dbf’,

version=12 logfile=import.log

Which three are prerequisites for successful execution of the command?

A.

The impdp operation must be performed by the same user that performed the expdp operation.

B.

The path of data files on the target database must be the same as that on the source database.

C.

The export dump file must be created before starting the import on the target database.

D.

All the user defined tablespaces must be in read-only mode on the source database.

E.

The import operation must be performed by a user on the target database with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user on the source database with the DATAPUMP_EXP_FULL_DATABASE role.

F.

The source and target databases must be running on the same platform with the same endianness.

Full Access
Question # 18

View the SPFILE parameter settings in the Exhibit.

You issue this command and get errors:

SQL> startup

ORA-00824:cannotsetSGAJTARGET or MEMORY_TARGET dueto existing internalsettings,seealertlog for moreinformation

Why did the instance fail to start?

A.

because pga_aggregate_target is not set

B.

because statistics_level is set to basic

C.

because memory_target and memory_max_target cannot be equal

D.

because sga_target and memory_target are both set

Full Access
Question # 19

Your database is running in ARCHIVELOG mode. Complete database backups are performed daily at midnight. A user accidently truncates an important table at 10 AM after the last backup. After that, a few important transactions are performed on the database.

Which two best methods are performed the truncated table data? (Choose two.)

A.

Table Point-in-Time Recovery.

B.

Database Point-in-Time Recovery

C.

Tablespace Point-in-Time Recovery

D.

Flashback Database

E.

Flashback Transaction Backout

Full Access
Question # 20

You notice that the performance of your production 24x7 Oracle 12c database has significantly degraded. Sometimes, you are not able to connect to the database instance because it hangs.

How can you detect the cause of the degraded performance?

A.

by performing emergency monitoring using Real-Time Automatic Database Diagnostic Monitor (ADDM) to fetch data directly from SGA for analysis

B.

by running ADDM to fetch information from the latest Automatic Workload Repository (AWR) snapshots

C.

by using Active Session History (ASH) data and performing hang analysis

D.

by running ADDM in diagnostic mode

Full Access
Question # 21

Which two statements are true regarding an Automatic Storage Management (ASM) instance?

(Choose two.)

A.

An ASM instance mounts an ASM control file

B.

An ASM instance uses the ASMB process for rebalancing of disks within a disk group

C.

Automatic Memory Management is enabled in an ASM instance even when the MEMORY_TARGET parameters not set explicitly

D.

An RDBMS instance gets connected to an ASM instance using ASMB as a foreground process when the database instance is started

Full Access
Question # 22

Examine the RMAN commands executed in your database:

RMAN>CONFIGURE DEFAULT DEVICE TYPE TO disk;

RMAN>CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO BACKUPSET;

RKAN> CONFIGURE CONTROLFILE AUTOBACKUP ON;

You issue the command:

RMAN> BACKUP DATABASE;

Which two statements are true about the command?

A.

It performs a log switch.

B.

It creates compressed backup sets by using binary compression by default.

C.

It backs up only the used blocks in data files.

D.

It backs up data files, the control file, and the server parameter file.

E.

It creates a backup of only the control file whenever the database undergoes a structural change.

Full Access
Question # 23

Your database is running in ARCHIVELOG mode. You observe that the fast recovery area does not have enough free space and there is no scope to add more space to it.

Identify two events that can occur at the time of a log switch. (Choose two.)

A.

All active transactions are rolled back and the database instance shuts down.

B.

The database instance status is automatically changed to RESTRICTED mode and file creation in the fast recovery area is prevented.

C.

The Oracle Database server deletes a file that is on the obsolete file list to create free space in the fast recovery area.

D.

An entry is written in the alert log and the database instance is automatically placed in MOUNT state.

E.

The log switch hangs until free space is available in the fast recovery area.

Full Access
Question # 24

You issue the command:

SQL> ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

Which statement is true about the command?

A.

It creates a copy of the control file and stores it in the location specified in the diagnostic_dest initialization parameter.

B.

It creates a file that contains the SQL statement, which is required to re-create the control file.

C.

It updates the alert log file with the location and contents of the control file.

D.

It creates a binary backup of the control file.

Full Access
Go to page:

Hot Exams

ADM-201 Dumps
Platform-App-Builder Dumps
AZ-500 Dumps
350-701 Dumps
SY0-601 Dumps
NCSE-Core Dumps
PDP9 Dumps
DP-203 Dumps
AZ-700 Dumps
NSE7_EFW-7.0 Dumps
Integration-Architect Dumps
CS0-003 Dumps