OCP Oracle 12C Advanced Administration(1Z0-063) Set 3

Which files are required for a full recovery of the database in ARCHIVELOG mode?


Options are :

  • None of the above
  • Control file from a backup
  • Online redo logs
  • Database data files

Answer : Database data files

Which command(s) are used to back up the control file?


Options are :

  • ALTER DATABASE BACKUP CONTROLFILE TO TRACE
  • ALTER CONTROLFILE BACKUP
  • ALTER SYSTEM BACKUP CONTROLFILE
  • ALTER DATABASE BACKUP CONTROL FILE

Answer : ALTER DATABASE BACKUP CONTROLFILE TO TRACE

What does the SCN represent?


Options are :

  • The security change number, which represents the security code that is needed to access any database structure.
  • UTC time in the database, providing a standardized way of tracking time in Oracle.
  • The system change number, which is a marker indicating a point in time relative to transactions within a given database.
  • A conversion factor that converts internal database time to external clock time.
  • A number that represents time. Thus, at 1300 hours, the SCN is the same on all databases.

Answer : The system change number, which is a marker indicating a point in time relative to transactions within a given database.

1Z0-518 Oracle EBS R12 Receivables Essentials Practice Exam Set 3

What parameter controls how often the database checkpoints and also tries to reduce the time that instance recovery will take?


Options are :

  • MTTR_TARGET
  • FAST_START_RECOVERY
  • FAST_START_MTTR_RECOVERY
  • CHECKPOINT_TIME
  • RESTART_FAST

Answer : FAST_START_MTTR_RECOVERY

Your database backup scripts keep failing on the ALTER TABLESPACE BEGIN BACKUP command. Your junior DBA informs you that the failure is because the database is in ARCHIVELOG mode. Is he correct?


Options are :

  • Yes
  • There is insufficient information to decide the answer to this question.
  • No
  • None of the Above

Answer : No

Which are the correct steps, in order, to deal with the loss of an online redo log if the database has not yet crashed?
1. Issue a checkpoint.
2. Shut down the database.
3. Issue an ALTER DATABASE OPEN command to open the database.
4. STARTUP MOUNT the database.
5. Issue an ALTER DATABASE CLEAR LOGFILE command.
6. Recover all database data files.


Options are :

  • NONE
  • 2,4,5,6
  • 2,6,4,6,3
  • 1,2,4,5,3
  • 2,4,1,3
  • 1,2,3,4

Answer : 1,2,4,5,3

Oracle 1Z0-976 Cloud Service Implementation Essentials Exam Set 1

You have lost all your SYSTEM tablespace data files (system_01.dbf and system_02.dbf) and the database has crashed. The database is in ARCHIVELOG mode and you have a current backup. What would be the appropriate order of operations to correct the situation?
1. Mount the database with the STARTUP MOUNT command.
2. Take the SYSTEM data file offline with the ALTER DATABASE command.
3. Restore the SYSTEM_01.dbf data file from backup media with the required archived redo logs.
4. Restore all SYSTEM tablespaceĖrelated data files from backup media.
5. Issue the RECOVER TABLESPACE SYSTEM command.
6. Issue the RECOVER DATAFILE SYSTEM_01.DBF command.
7. Open the database with the ALTER DATABASE OPEN command.
8. Open the database with the ALTER DATABASE OPEN RESETLOGS command.


Options are :

  • 1,3,6,7
  • 4,1,5,7
  • 1,2,3,6,7
  • 2,3,6,5,7
  • 2,4,5,8

Answer : 4,1,5,7

What parameter is used to tune instance recovery in Oracle Database 12c?


Options are :

  • FAST_MTTR_RECOVERY
  • FAST_START_RECOVERY_TIME
  • FAST_START_MTTR_RECOVERY
  • INSTANCE_RECOVERY_TIME

Answer : FAST_START_RECOVERY_TIME

Which of the following will cause instance recovery to occur? 


Options are :

  • You issue the SHUTDOWN TRANSACTIONAL command from the SQL prompt.
  • Power failure causes the database server to crash.
  • You issue the ALTER DATABASE CHECKPOINT command.
  • You issue a SHUTDOWN IMMEDIATE command from the SQL prompt.

Answer : Power failure causes the database server to crash.

1Z0-207 Oracle Comm Billing & Revenue Mgmt Pricing Exam Set 4

Which files do you need to back up for a database that is in ARCHIVELOG mode to ensure recovery?


Options are :

  • None of the above
  • Archived redo logs
  • Online redo logs
  • Control file from a backup

Answer : Archived redo logs

What method of point-in-time recovery are available in ARCHIVELOG mode?


Options are :

  • Transaction number-based
  • none of the above
  • Change-based

Answer : Change-based

What type of backup is stored in a proprietary RMAN format?


Options are :

  • Backup group
  • Backup section
  • Image copy
  • Backup set

Answer : Backup set

1Z0-517 Oracle EBS R12.1 Payables Essentials Practice Exam Set 1

What is the purpose of MAA?


Options are :

  • MAA is a set of practices that Oracle has created to help you better administer your databases.
  • MAA is a set of practices that align around providing maximum availability for Oracle databases.
  • MAA is a new form of Oracle martial arts.
  • MAA is an online document available from oracle.com that provides a list of current critical issues related to database backup and recovery.
  • MAA is a set of practices that standardizes Oracle database creation, file naming conventions and operating system directory names.

Answer : MAA is a set of practices that Oracle has created to help you better administer your databases.

Which files will you need to perform a full recovery of a database backed up in NOARCHIVELOG mode? 


Options are :

  • None of the above
  • Flashback logs
  • Archived redo logs
  • Control files

Answer : Control files

Which command creates an image copy?


Options are :

  • COPY AS BACKUP
  • BACKUP AS COPY
  • COPY BACK
  • BACKUP COPY

Answer : BACKUP AS COPY

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

To enable resumable space allocation for the instance, which of the following initialization parameters should you set to a nonzero value?


Options are :

  • RESUMABLE_TIMEOUT
  • RESUMABLE_SPACE_TIME
  • RESUMABLE_SPACE
  • RESUMABLE_TIME
  • TIME_RESUMABLE

Answer : RESUMABLE_TIME

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

Which of the following statements is true regarding the initialization parameter DIAGNOSTIC_DEST ?


Options are :

  • DIAGNOSTIC_DEST is always equal to $ORACLE_BASE .
  • DIAGNOSTIC_DEST is always equal to $ORACLE_HOME .
  • The default value is the value of the environment variable $ORACLE_BASE ; if $ORACLE_BASE isnít set, then it is set to $ORACLE_HOME .
  • The default value is the value of the environment variable $ORACLE_HOME ; if $ORACLE_HOME isnít set, then the default is set to $ORACLE_BASE .

Answer : The default value is the value of the environment variable $ORACLE_BASE ; if $ORACLE_BASE isnít set, then it is set to $ORACLE_HOME .

Which of the following initialization parameters have been deprecated in Oracle 12c because of the introduction of the Automatic Workload Repository?


Options are :

  • DIAGNOSTIC_DEST
  • FOREGROUND_DUMP_DEST
  • All of the above
  • BACKGROUND_DUMP_DEST

Answer : BACKGROUND_DUMP_DEST

Which of the following methods can be used to detect block corruption?


Options are :

  • ANALYZE operations
  • RMAN
  • All of the above
  • dbv
  • SQL queries that access the potentially corrupt block

Answer : All of the above

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

The following query will provide what information about transportable tablespaces for the current database? (Choose all that apply.)

select d.platform_name "Source", t.platform_name
"Compatible Targets", endian_format
from v$transportable_platform t, v$database d
where t.endian_format = (select endian_format
from v$transportable_platform t,
v$database d where d.platform_name = t.platform_name);


Options are :

  • The list of target platforms having the same endian format as the source database
  • The list of all target platforms that can receive transportable tablespaces from the source database
  • The list of target platforms requiring endian conversion
  • None of the above

Answer : The list of target platforms having the same endian format as the source database

Which of the following supplied functions is used to identify external tables, directories, and BFILES?


Options are :

  • DBMS_TDB.CHECK_DIRECTORIES
  • DBMS_TDB.CHECK_BFILE
  • DBMS_TDB.CHECK_EXT
  • DBMS_TDB.CHECK_EXTERNAL

Answer : DBMS_TDB.CHECK_EXTERNAL

Which of these formats represents the correct hierarchy for the ADR?


Options are :

  • None of the above
  • /diag/rdbms//
  • /rdbms/diag//
  • /diag/rdbms//

Answer : /diag/rdbms//

OCP Oracle Database 11g Administrator Certified Professional Set 1

Which of the following options describes segment shrink?


Options are :

  • Moves rows to a new physical location, resetting the high-water mark, but uses additional space during the operation
  • Reclaims space above and below the high-water mark without using additional space
  • None of the above
  • Deallocates space above the high-water mark that is currently not in use

Answer : Reclaims space above and below the high-water mark without using additional space

Which of the following describes how a distributed resumable transaction behaves?


Options are :

  • None of the above
  • The resumable setting for the initiating instance determines the resumable condi- tions for the entire distributed transaction.
  • The resumable setting on the initiating session controls only that part of the trans- action that occurs within the local instance; remote resumable settings determine the behavior of the distributed parts of the transaction.
  • The resumable setting on the initiating session determines the resumable condi- tions for the entire distributed transaction.

Answer : The resumable setting on the initiating session controls only that part of the trans- action that occurs within the local instance; remote resumable settings determine the behavior of the distributed parts of the transaction.

Which of the following are correct about block media recovery? 


Options are :

  • Archive log mode is not required if you have both a full and incremental backup for restore.
  • RMAN can use any backup for a BMR restore.
  • Logical corruptions are repairable by BMR.
  • Physical and logical block corruption is recorded automatically in V$DATABASE_ BLOCK_CORRUPTION

Answer : Physical and logical block corruption is recorded automatically in V$DATABASE_ BLOCK_CORRUPTION

1Z0-518 Oracle EBS R12 Receivables Essentials Practice Exam Set 1

Which pseudocolumn could you use to identify a unique row in a Flashback Version Query?


Options are :

  • VERSIONS_PK
  • XID
  • VERSIONS_XID
  • VERSIONS_UNIQUE

Answer : VERSIONS_XID

When exporting metadata for the transportable tablespaces, what is the correct next step after confirming endian format?


Options are :

  • Copy the data files from source to destination.
  • Convert the data files using RMAN.
  • Determine if the transportable set is self-contained.
  • Export the tablespaces using Data Pump.

Answer : Determine if the transportable set is self-contained.

Which of the following is a prerequisite for running DBMS_TDB.CHECK_DB to a successful completion?


Options are :

  • The database must be in read-write mode
  • The database must open in read-only mode.
  • The database must be mounted but not opened.
  • The database must have no external files.

Answer : The database must open in read-only mode.

1Z0-519 Oracle E-Business Suite R12.1 Inventory Essentials Set 3

Which of the following tasks does the tool Incident Packaging Service (IPS) perform?


Options are :

  • Identify all files associated with a critical error and add them to a zip file to be sent to Oracle Support.
  • Display a high-level view of critical errors on the database home page.
  • Clean up the ADR by deleting files not associated with an incident uploaded to Oracle Support.
  • Automatically open a service request with Oracle Support for each critical error and send all relevant files

Answer : Identify all files associated with a critical error and add them to a zip file to be sent to Oracle Support.

Which of the following are included in a transportable tablespace set?


Options are :

  • The system tablespace
  • The spfile
  • All of the above
  • The data files that make up a self-contained group of tablespaces required for copy

Answer : The data files that make up a self-contained group of tablespaces required for copy

Comment / Suggestion Section
Point our Mistakes and Post Your Suggestions