OCA Oracle Database 10g Administrator I-1Z0-042 & II-1Z0-043 Set 2

What is the name of the API that interfaces RMAN with different tape devices?


Options are :

  • Media Manager Library Interface
  • Media Management Layer
  • Media Library Interface
  • Management Media Interface

Answer : Media Management Layer

What are the required steps to perform a RMAN-based incomplete recovery with the SET UNTIL TIME clause?


Options are :

  • Start up the database in MOUNT mode, verify or set the NLS_DATE_FORMAT environment variable, designate the SET UNTIL TIME time stamp, restore the necessary files with the RESTORE DATABASE command, recover the database with the RECOVER DATABASE command, and then open the database with ALTER DATABASE OPEN RESETLOGS command.
  • Start up the database in MOUNT mode, designate the SET UNTIL TIME time stamp, restore the necessary files with the RESTORE DATABASE command, recover the database with the RECOVER DATABASE command, and then open the database with ALTER DATABASE OPEN NORESETLOGS command.
  • Start up the database in MOUNT mode, verify or set the NLS_DATE_FORMAT environment variable, designate time with the SET UNTIL TIME time stamp, restore the necessary files with the RESTORE DATABASE command, recover the database with the RECOVER DATABASE command, and then open the database with the ALTER DATABASE OPEN command.
  • Start up the database in NOMOUNT mode, verify or set the NLS_DATE_FORMAT environment variable, designate the SET UNTIL TIME time stamp, restore the necessary files with the RESTORE DATABASE command, recover the database with the RECOVER DATABASE command, and then open the database with the ALTER DATABASE OPEN RESETLOGS command.

Answer : Start up the database in MOUNT mode, verify or set the NLS_DATE_FORMAT environment variable, designate the SET UNTIL TIME time stamp, restore the necessary files with the RESTORE DATABASE command, recover the database with the RECOVER DATABASE command, and then open the database with ALTER DATABASE OPEN RESETLOGS command.

1Z0-409 Oracle Linux Fundamentals Practice Exam Set 4

The FORMAT command within the RMAN utility performs what function?


Options are :

  • It provides the capability to rebuild channel devices.
  • It provides the capability for unique identification.
  • It provides the capability to rebuild disk devices.
  • It provides the capability to recreate channel devices.

Answer : It provides the capability for unique identification.

What is required to perform a UNTIL SEQUENCE recovery in RMAN?


Options are :

  • Identifying the sequence number with V$LOGHISTORY
  • Identifying the SCN number with V$LOG_HISTORY
  • Identifying the SCN number with V$LOGHISTORY
  • Identifying the sequence number with V$LOG_HISTORY

Answer : Identifying the sequence number with V$LOG_HISTORY

When performing incomplete recovery, which command allows you to stop the recovery process at a random point?


Options are :

  • UNTIL SCN, when performing a RMAN-based recovery
  • UNTIL CANCEL, when performing a RMAN-based recovery
  • UNTIL SEQUENCE, when performing a user-managed recovery
  • UNTIL CANCEL, when performing a user-managed recovery

Answer : UNTIL CANCEL, when performing a user-managed recovery

1Z0-497 Oracle Database 12c Essentials Certification Exam Set 3

When using EM to perform a whole database incomplete recovery, what sequence of events must occur?


Options are :

  • The database must be started in MOUNT mode.
  • The database must be shut down and restarted.
  • The database must be shut down and started in NOMOUNT mode.
  • The database must be shut down and started in MOUNT mode.

Answer : The database must be shut down and started in MOUNT mode.

Which of the following methods should you use for creating a control file?


Options are :

  • Dump the control file information to a trace file.
  • None of the above.
  • Use the CREATE CONTROLFILE command.

Answer : Dump the control file information to a trace file.

Which of the following descriptions best describes incomplete recovery? 


Options are :

  • None of the above
  • Recovery that is missing transactions
  • Recovery that stops at the point of failure
  • Recovery that stops before the failure

Answer : Recovery that stops before the failure

Oracle 1Z0-516 EBS R12 General Essential Practice Exam Set 15

What is the main purpose of channel control options or commands?


Options are :

  • To control automatic channel allocation
  • To control the operating system resources RMAN uses when performing RMAN operations
  • To control manual channel allocation
  • To control channel access options

Answer : To control the operating system resources RMAN uses when performing RMAN operations

Which command is required when performing an incomplete recovery?


Options are :

  • UNTIL CANCEL.
  • ALTER DATABASE OPEN
  • ALTER DATABASE OPEN NORESETLOGS
  • ALTER DATABASE OPEN RESETLOGS

Answer : ALTER DATABASE OPEN RESETLOGS

Which incomplete recovery capability is available to RMAN or user-managed methods?


Options are :

  • SET UNTIL TIME
  • UNTIL SCN
  • UNTIL TIME
  • UNTIL SEQUENCE

Answer : UNTIL TIME

1Z0-409 Oracle Linux Fundamentals Practice Test Set 4

What is the parameter that determines the capacity of the RMAN repository?


Options are :

  • CONTROL_FILE_KEEP_TIME
  • CONTORL_FILE_RECORD_TIME
  • CONTROL_FILE_RECORD_KEEP_TIME
  • CONTROLFILE_RECORD_KEEP_TIME

Answer : CONTROL_FILE_RECORD_KEEP_TIME

What is required to recover your database through a RESETLOGS recovery from a backup created prior to the RESETLOGS recovery?


Options are :

  • NORESETLOGS
  • RESETLOGS
  • UNTIL SEQUENCE
  • Nothing, this feature is automatic.

Answer : Nothing, this feature is automatic.

Which files need to be available and in the matching location of the ASCII control file in order to rebuild the control file? 


Options are :

  • Server file, PFILE or SPFILE
  • Control files
  • Redo logs
  • None of the above

Answer : Server file, PFILE or SPFILE

1Z0-208 Oracle Comm Billing & Revenue Mgmt Server Developer Set 4

The RESETLOGS clause is required with which of the following types of incomplete recovery?


Options are :

  • All of the above
  • Using the SET UNTIL SEQUENCE command and stopping before the last redo log sequence
  • Using the UNTIL TIME command and stopping before the current time
  • Using the UNTIL CANCEL command and applying almost all the archived redo logs before cancelling recovery

Answer : All of the above

Which command configures a device so that channel allocation is automatically available during backup, restore, or delete?


Options are :

  • CHANNEL DEVICE TYPE DISK CONFIGURE
  • CONFIGURE DEVICE CHANNEL TYPE DISK
  • CONFIGURE CHANNEL DEVICE TYPE DISK
  • CONFIGURE DEVICE TYPE TO DISK

Answer : CONFIGURE CHANNEL DEVICE TYPE DISK

Which of the following would be a reason for using incomplete recovery? 


Options are :

  • Stopping the recovery at a certain time when database corruption occurred
  • Stopping the recovery before a bad transaction is executed
  • All the above
  • Stopping the recovery at a certain redo log sequence before a database corruption point

Answer : All the above

OCP Oracle Database 11g Administrator Certified Professional Set 2

What privileges must be granted to allow an account to create the recovery catalog? 


Options are :

  • SELECT ANY DICTIONARY TABLE
  • None of the above
  • RECOVERY_CATALOG_OWNER
  • DBA

Answer : RECOVERY_CATALOG_OWNER

What are the database connection types available with RMAN?


Options are :

  • All the above
  • Target database
  • Auxiliary database
  • Recovery catalog

Answer : All the above

What are the types of devices that channel allocation can utilize? 


Options are :

  • TYPE DISK
  • None of the above
  • TYPE FLASH_AREA
  • DISK TYPE

Answer : TYPE DISK

1Z1-574 Oracle IT Architecture Essentials Practice Exam Set 3

You want to change the password for your listener. The listener.ora file contains the following entries:

PASSWORDS_LISTENER=64F4692D9E6443F
LOGGING_LISTENER=ON
ADMIN_RESTRICTIONS=ON
Which of the following methods can you use to change the password?


Options are :

  • EM Database Control
  • Manually editing the listener.ora file
  • netmgr
  • netca
  • lsnrctl

Answer : Manually editing the listener.ora file

Oracle 1Z0-516 EBS R12 General Essential Practice Exam Set 7

Which of the following are not automatically sized components of ASMM?


Options are :

  • SQL work area
  • Keep buffer cache
  • Streams pool
  • Recycle buffer cache
  • All of the above

Answer : All of the above

You want to set a password on the listener. Why might you want to use lsnrctl rather than manually editing the listener.ora file? 


Options are :

  • The listener.ora file is stored in binary format.
  • It is easier.
  • It will encrypt the password in the listener.ora file.
  • lsnrctl will log the event to the alert log.

Answer : It will encrypt the password in the listener.ora file.

Your external procedure agent is governed by the following listener setting:

ENVS="EXTPROC_DLLS=/lib/javalib.so:/lib/tlib.so"

Which of the following statements is true regarding external procedure requests handled by this listener?


Options are :

  • None
  • They can access procedures in the /lib/javalib.so or /lib/tlib.so shared libraries, as well as in any libraries in the $ORACLE_HOME/lib directory.
  • They can access procedures only in the /lib/javalib.so and /lib/tlib.so shared library files.
  • They can access procedures in the /lib/javalib.so or /lib/tlib.so shared libraries, as well as in any libraries in the $ORACLE_HOME/lib directory. They can also access any external libraries referenced by these procedures.
  • They can access procedures in the /lib/javalib.so and /lib/tlib.so shared libraries, as well as in any external libraries referenced by these procedures.

Answer : They can access procedures in the /lib/javalib.so or /lib/tlib.so shared libraries, as well as in any libraries in the $ORACLE_HOME/lib directory.

1Z0-330 Oracle Fusion Workforce Compensation Cloud Test Set 4

Your database instance has the following initialization parameter set:

MAX_DUMP_FILE_SIZE = 1000

What effect will this setting have on user session trace files?


Options are :

  • Trace files will be limited to 1000 blocks.
  • Trace files will be limited to 1000 bytes.
  • Trace files will be limited to 1000 kilobytes.
  • No effect. MAX_DUMP_FILE_SIZE affects only background process trace files.
  • Trace files will be limited to 1000 megabytes.

Answer : Trace files will be limited to 1000 blocks.

You are working with Oracle Support to resolve a database issue. The support technician asks you to forward any diagnostic files that might help them resolve the issue. Which two of the following choices represent the best files to send?


Options are :

  • Alert log
  • External procedure files
  • Trace files from the USER_DUMP_DEST directory
  • Files from both the USER_DUMP_DEST directory and the BACKGROUND_DUMP_DEST directory

Answer : Alert log

The following initialization parameters reside in your initialization file:
SGA_TARGET=8G STREAMS_POOL_SIZE=500M JAVA_POOL_SIZE=1G SHARED_POOL_SIZE=3G
Which of the following statements will be true when your instance is started? 


Options are :

  • The total SGA size will be 8GB.
  • The total SGA size will be 9GB.
  • None of the above
  • The automatically sized components will have 6.5GB allocated among them.

Answer : The total SGA size will be 8GB.

1Z0-330 Oracle Fusion Workforce Compensation Cloud Test Set 6

Which of the following operations is not impacted by the size of the SQL work area?


Options are :

  • Bulk load operations
  • Bitmap creation
  • Sort operations
  • Index lookups
  • Bitmap merges

Answer : Index lookups

You wish to limit database access to a select group of hosts. The following lines have been added to your sqlnet.ora file:

tcp.validnode_checking = yes
tcp.invited_nodes = (peabody, 159.162.210.24,
?159.162.211.*, 159.163.*.*)

From which of the following hosts will database requests be allowed?


Options are :

  • 159.163.212.6
  • 159.162.210.22
  • 159.162.211.44
  • None. Valid node checking is defined in the tnsnames.ora file.
  • peabody

Answer : peabody

What is another name for RMAN-based database recovery?


Options are :

  • Server-managed recovery
  • User-managed recovery
  • Traditional recovery
  • Database recovery

Answer : Server-managed recovery

Oracle 1Z0-516 EBS R12 General Essential Practice Exam Set 8

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions