- Home
- Database
- Oracle 12 C
- OCP Oracle 12C Advanced Administration(1Z0-063)
6.
What does the SCN represent?
- A.The system change number, which is a marker indicating a point in time relative to transactions within a given database.
- B.A number that represents time. Thus, at 1300 hours, the SCN is the same on all databases.
- C.The security change number, which represents the security code that is needed to access any database structure.
- D.A conversion factor that converts internal database time to external clock time.
- E.UTC time in the database, providing a standardized way of tracking time in Oracle.
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
| The SCN is a number that represents a point in time in the database relative to transactions within a given database. |
7.
Which command(s) are used to back up the control file? (Choose all that apply.)
- A.ALTER SYSTEM BACKUP CONTROLFILE
- B.ALTER DATABASE BACKUP CONTROLFILE TO TRACE
- C.ALTER DATABASE BACKUP CONTROL FILE
- D.ALTER DATABASE BACKUP CONTROLFILE TO 'FILENAME'
- E.ALTER CONTROLFILE BACKUP
- Answer & Explanation
- Report
Answer : [B, D]
Explanation :
Explanation :
| The ALTER DATABASE BACKUP CONTROLFILE TO TRACE command will create a trace file with the create controlfile commands inside that are needed to recreate the control file. The ALTER DATABASE BACKUP CONTROLFILE TO 'FILENAME' command will create a backup control file that can be used later to recover the control file should the database control file be lost. |
8.
What is the purpose of MAA?
- A.MAA is a set of practices that Oracle has created to help you better administer your databases.
- B.MAA is a set of practices that standardizes Oracle database creation, file naming conventions and operating system directory names.
- C.MAA is a set of practices that align around providing maximum availability for Oracle databases.
- D.MAA is a new form of Oracle martial arts.
- E.MAA is an online document available from oracle.com that provides a list of current critical issues related to database backup and recovery.
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
9.
Which of the following will cause instance recovery to occur? (Choose all that apply.)
- A.Power failure causes the database server to crash.
- B.You issue a SHUTDOWN IMMEDIATE command from the SQL prompt.
- C.You issue the ALTER DATABASE CHECKPOINT command.
- D.You issue the SHUTDOWN ABORT command from the SQL prompt.
- E.You issue the SHUTDOWN TRANSACTIONAL command from the SQL prompt.
- Answer & Explanation
- Report
Answer : [A, D]
Explanation :
Explanation :
| Any action that causes the database to shut down abnormally will cause instance recovery to occur when the database is restarted. Thus, a power failure of the database server or use of the SHUTDOWN ABORT command will force instance recovery to occur. |
10.
What parameter controls how often the database checkpoints and also tries to reduce
the time that instance recovery will take?
- A.FAST_START_RECOVERY
- B.MTTR_TARGET
- C.RESTART_FAST
- D.CHECKPOINT_TIME
- E.FAST_START_MTTR_RECOVERY
- Answer & Explanation
- Report
Answer : [E]
Explanation :
Explanation :
| The FAST_START_MTTR_RECOVERY parameter is used to indicate to the Oracle database how much time to allow for instance recovery. Based on this parameter, the Database Writer process will write to the database data files at a rate that will try to match this target. |
|
|
||||||||||||||||||||||||||||
