- Home
- Database
- Oracle 12 C
- OCA Oracle 12C Administration(1Z0-062)
76.
Which of the following initialization parameters specifies the location where the
control file trace backup is sent?
- A.DIAGNOSTIC_DEST
- B.BACKGROUND_DUMP_DEST
- C.LOG_ARCHIVE_DEST
- D.CORE_DUMP_DEST
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
| The trace backup is created in a subdirectory under the location specified by the DIAGNOSTIC_DEST parameter— $DIAGNOSTIC_DEST/diag/<dbname>/<instancename>/ trace directory . |
77.
Which of the following pieces of information is not available in the control file?
- A.Instance name
- B.Database name
- C.Tablespace names
- D.Log sequence number
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
| The instance name is not in the control file. The control file has information about the physical database structure. |
78.
Which statement adds a member /logs/redo22.log to redo log-file group 2?
- A.ALTER DATABASE ADD LOGFILE '/logs/redo22.log' TO GROUP 2;
- B.ALTER DATABASE ADD LOGFILE MEMBER '/logs/redo22.log' TO GROUP 2;
- C.ALTER DATABASE ADD MEMBER '/logs/redo22.log' TO GROUP 2;
- D.ALTER DATABASE ADD LOGFILE '/logs/redo22.log';
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| When adding log-file members, specify the group number or specify all the existing group members. |
79.
To place the database into ARCHIVELOG mode, in which state must you start the
database?
- A.MOUNT
- B.NOMOUNT
- C.OPEN
- D.SHUTDOWN
- E.Any of the above
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
| To put the database into ARCHIVELOG mode, the database must be in the MOUNT state; the control files and all data files that are not offline must be available to change the database to ARCHIVELOG mode. |
80.
Which of the following substitution-variable formats are always required for specifying
the names of the archived redo log files? Choose all that apply.
- A.%d
- B.%s
- C.%r
- D.%t
- Answer & Explanation
- Report
Answer : [B, C, D]
Explanation :
Explanation :
| The substitution variable %d , which represents the database ID, is required only if multiple databases share the same archive log destination. |
|
|
||||||||||||||||||||||||||||
