- Home
- Database
- Oracle 12 C
- OCA Oracle 12C Administration(1Z0-062)
1.
Choose two SGA structures that are required in every Oracle instance.
- A.Large pool
- B.Shared pool
- C.Buffer cache
- D.Java pool
- Answer & Explanation
- Report
Answer : [B, C]
Explanation :
Explanation :
| Database buffer cache, shared pool, and log buffer are required; they are configured automatically in every instance. It is better to use Automatic Memory Management or Automatic Shared Memory Management, so that the DBA does not need to tune individual components. |
2.
Which statement is true?
- A.A database can have only one control file.
- B.A database must have at least two control files.
- C.A database may have zero or more control files.
- D.A database must have at least one control file.
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| The control file is the most key file in an Oracle database. Due to its importance, it is a good practice to have two more copies of the file. A database must have at least one control file to start the database. |
3.
Which component is configured at database startup and cannot be dynamically
managed?
- A.Redo log buffer
- B.Streams pool
- C.Java pool
- D.Shared pool
- E.None of the above
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
| An Oracle database allows you to manage all memory components dynamically, except the redo log buffer. Redo log buffer is set at instance startup and is not dynamically alterable without restarting the instance. |
4.
Which component is not part of an Oracle instance?
- A.System global area
- B.Process monitor
- C.Control file
- D.Shared pool
- E.None
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| Control file, data file, and redo log files are part of the Oracle database. The Oracle instance constitutes the memory structures and background processes. |
5.
Which background process guarantees that committed data is saved even when the
changes have not been recorded in data files?
- A.DBWn
- B.PMON
- C.LGWR
- D.CKPT
- E.ARCn
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| The log writer (LGWR) process writes the redo log buffer information to the online redo log files. A commit operation is completed only after the redo buffer is written to online redo log files. |
|
|
||||||||||||||||||||||||||||
