- Home
- Database
- Oracle 12 C
- OCA Oracle 12C Administration(1Z0-062)
11.
You noticed that the current value of the UNDO_RETENTION parameter is 900 and is too
low for some of your transactions. The database was created using DBCA. You issue
the following statement:
ALTER SYSTEM SET UNDO_RETENTION=4800;
Which option is true?
ALTER SYSTEM SET UNDO_RETENTION=4800;
Which option is true?
- A.UNDO_RETENTION is a static parameter and, therefore, cannot be changed using ALTER SYSTEM.
- B.The change will be available to the instance only after a database cycle.
- C.The value is changed in memory, and when the database restarts the next time, the new value will be preserved when using the spfile.
- D.The value is changed only in memory, and the server parameter file needs to be updated for the change to persist across database shutdowns.
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| When using ALTER SYSTEM to change parameter values, the change is made to the server parameter file (spfile) too, because the default for the SCOPE clause is BOTH. Option D would have been correct, if the pfile were used to start up the database. When a database is created using DBCA, the parameter file created is always spfile. |
12.
You need to find the directory where the Oracle alert log is being written. Which initialization
parameter can be best used to list the full directory path of the alert log location?
- A.ALERT_LOG_DEST
- B.BACKGROUND_DUMP_DEST
- C.DIAGNOSTIC_DEST
- D.INIT_LOG_DUMP_DEST
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| DIAGNOSTIC_DEST is the initialization parameter that determines where the Automatic Diagnostic Repository home is located. The alert log file would be in the <diagnostic_dest>/diag/rdbms/<dbname>/<instancename>/alert directory. A text version of the alert log is in the <diagnostic_dest>/diag/ rdbms/<dbname>/<instancename>/trace directory. But BACKGROUND_DUMP_DEST shows the full path of the trace directory location. |
13.
Which data dictionary view is used to view the current values of parameters?
- A.V$DATABASE
- B.V$SPPARAMETER
- C.V$PARAMETER
- D.V$SYSPARAMETER
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| V$PARAMETER shows information about the parameters and their current values in the database. V$SPPARAMTER shows the information as read from the spfile. |
14.
Which startup options must be used to start the instance when you create a new database?
- A.STARTUP FORCE
- B.STARTUP MOUNT
- C.STARTUP RESTRICT
- D.STARTUP NOMOUNT
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| When creating a new database or creating a control file, the database should be in the NOMOUNT state. |
15.
The DIAGNOSTIC_DEST parameter is not set up in the initialization-parameter file. The
value of the ORACLE_HOME environment variable is /u01/app/oracle/product/12.1.0,
and the value of ORACLE_BASE is /u01/app/oracle. The database and instance name is
xyz. What is the location of the text-alert log file for the xyz database?
- A./u01/app/oracle/product/12.1.0/log/rdbms/xyz/xyz/trace
- B./u01/app/oracle/diag/rdbms/xyz/xyz/trace
- C./u01/app/oracle/diag/rdbms/xyz/xyz/alert
- D./u01/app/oracle/product/12.1.0/diag/rdbms/xyz/xyz/trace
- E./u01/app/oracle/log/rdbms/xyz/xyz/trace
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| The alert log file in Oracle Database 12c is saved in the $ORACLE_BASE/diag/ rdbms/<dbname>/<instancename>/trace directory. The XML version of the alert log file is in the $ORACLE_BASE/diag/rdbms/<dbname>/<instancename>/alert directory. |
|
|
||||||||||||||||||||||||||||
