- Home
- Database
- Oracle 12 C
- OCA Oracle 12C Administration(1Z0-062)
6.
User John has updated several rows in a table and issued a commit. What does the
DBWn (database writer) process do at this time in response to the commit event?
- A.Writes the changed blocks to data files.
- B.Writes the changed blocks to redo log files.
- C.Triggers checkpoint and thus LGWR writes the changes to redo log files.
- D.Does nothing
- Answer & Explanation
- Report
Answer : [D]
Explanation :
Explanation :
| When a user issues a commit, the LGWR process makes sure the redo log buffer is written to the online redo log files. Database writer takes no action against the commit event. |
7.
Which of the following best describes a RAC configuration?
- A.One database, multiple instances
- B.One instance, multiple databases
- C.Multiple databases plugged in from multiple servers
- D.Multiple databases, multiple instances
- Answer & Explanation
- Report
Answer : [A]
Explanation :
Explanation :
| With Real Application Clusters, multiple instances (known as nodes) can mount one database. One instance can be associated with only one database. |
8.
Which component of the SGA contains the parsed SQL code?
- A.Database buffer cache
- B.Dictionary cache
- C.Library cache
- D.Parse cache
- Answer & Explanation
- Report
Answer : [C]
Explanation :
Explanation :
| The shared SQL area is stored in the library cache in a shared pool and is shared between users. If a query is executed again before it is aged out of the library cache, Oracle will use the parsed code and execution plan from the library cache. The database buffer cache has the data blocks cached. The dictionary cache caches data dictionary information. There is no SGA component called the parse cache. |
9.
Which tasks are accomplished by the SMON process? (Choose all that apply.)
- A.Performs recovery at instance startup
- B.Performs cleanup after a user session is terminated
- C.Starts any server process that stopped running
- D.Coalesces contiguous free space in dictionary-managed tablespaces
- Answer & Explanation
- Report
Answer : [A, D]
Explanation :
Explanation :
| SMON is responsible for performing instance recovery using the online redo log files and for coalescing contiguous free space in tablespaces. The PMON is responsible for session cleanup and for freeing up all resources after a user session is terminated. |
10.
Choose the best statement from the options related to segments.
- A.A contiguous set of blocks constitutes a segment.
- B.A nonpartitioned table can have only one segment.
- C.A segment can belong to more than one tablespace.
- D.All of the above are true.
- Answer & Explanation
- Report
Answer : [B]
Explanation :
Explanation :
| A table or index has a segment. A segment consists of one or more extents. A segment can belong to only one tablespace, but it can span across multiple data files. |
|
|
||||||||||||||||||||||||||||
