Jamonero Blanco
Quiz by , created more than 1 year ago

OCA-8-Introducing Oracle Database 12c Components and Architecture

555
3
0
Jamonero Blanco
Created by Jamonero Blanco over 7 years ago
Close

OCA-8-Introducing Oracle Database 12c Components and Architecture

Question 1 of 20

1

1.Choose two SGA structures that are required in every Oracle instance.

Select one or more of the following:

  • A. Large pool

  • B. Shared pool

  • C. Buffer cache

  • D. Java pool

Explanation

Question 2 of 20

1

2. Which statement is true

Select one or more of the following:

  • 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.

Explanation

Question 3 of 20

1

3. Which component is configured at database startup and cannot be dynamically
managed?

Select one or more of the following:

  • A. Redo log buffer.

  • B. Streams pool

  • C. Java pool

  • D. Shared pool

  • E. None of the above

Explanation

Question 4 of 20

1

4. Which component is not part of an Oracle instance?

Select one or more of the following:

  • A. System global area.

  • B. Process monitor

  • C. Control file

  • D. Shared pool

  • E. None

Explanation

Question 5 of 20

1

5. Which background process guarantees that committed data is saved even when the
changes have not been recorded in data files?

Select one or more of the following:

  • A. DBWn

  • B. PMON

  • C. LGWR

  • D. CKPT

  • E. ARCn

Explanation

Question 6 of 20

1

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?

Select one or more of the following:

  • 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.

Explanation

Question 7 of 20

1

7. Which of the following best describes a RAC configuration?

Select one or more of the following:

  • A. One database, multiple instances

  • B. One instance, multiple databases

  • C. Multiple databases plugged in from multiple servers

  • D. Multiple databases, multiple instances

Explanation

Question 8 of 20

1

8. Which component of the SGA contains the parsed SQL code?

Select one or more of the following:

  • A. Database buffer cache

  • B. Dictionary cache

  • C. Library cache

  • D. Parse cache

Explanation

Question 9 of 20

1

9. Which tasks are accomplished by the SMON process? (Choose all that apply.)

Select one or more of the following:

  • 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

Explanation

Question 10 of 20

1

10. Choose the best statement from the options related to segments.

Select one or more of the following:

  • 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.

Explanation

Question 11 of 20

1

11. From the following list, choose two processes that are optional in an Oracle Database
12c database.

Select one or more of the following:

  • A. MMON

  • B. MMNL

  • C. ARCn

  • D. MMAN

Explanation

Question 12 of 20

1

12. Which SGA component will you increase or configure so that RMAN tape backups do
not use memory from the shared pool?

Select one or more of the following:

  • A. Java pool

  • B. Streams pool

  • C. Recovery pool

  • D. Large pool

Explanation

Question 13 of 20

1

13. When a user session is terminated, which processes are responsible for cleaning up and
releasing locks? (Choose all that apply.)

Select one or more of the following:

  • A. DBWn

  • B. LGWR

  • C. MMON

  • D. PMON

  • E. SMON

Explanation

Question 14 of 20

1

14. The LRU algorithm is used to manage what part of the Oracle architecture?

Select one or more of the following:

  • A. Users who log on to the database infrequently and may be candidates for being dropped

  • B. The data file that stores the least amount of information and will need the least frequent backup

  • C. The tables that users rarely access so that they can be moved to a less active tablespace

  • D. The shared pool and database buffer cache portions of the SGA

Explanation

Question 15 of 20

1

15. Two structures make up an Oracle server: an instance and a database. Which of the
following best describes the difference between an Oracle instance and a database?

Select one or more of the following:

  • A. An instance consists of memory structures and processes, whereas a database is
    composed of physical files.

  • B. An instance is used only during database creation; after that, the database is all
    that is needed.

  • C. An instance is started whenever the demands on the database are high, but the
    database is used all the time.

  • D. An instance is configured using a pfile, whereas a database is configured using
    a spfile.

Explanation

Question 16 of 20

1

16. Which of the following is the proper order of Oracle’s storage hierarchy, from smallest
to largest?

Select one or more of the following:

  • A. Operating-system block, database block, segment, extent

  • B. Operating-system block, database block, extent, segment

  • C. Segment, extent, database block, operating-system block

  • D. Segment, database block, extent, operating-system block

Explanation

Question 17 of 20

1

17. The DBA unknowingly terminated the process ID belonging to the PMON process
of Oracle Database 12c database using the kill -9 command on Unix. Choose the
best answer:

Select one or more of the following:

  • A. Oracle spawns another PMON process automatically.

  • B. The database hangs, and the DBA must manually start a PMON process.

  • C. If the database is in ARCHIVELOG mode, Oracle automatically starts another
    PMON process and recovers from the database hang.

  • D. The instance crashes and needs to be restarted.

Explanation

Question 18 of 20

1

18. When an incremental checkpoint happens in a database, which file(s) are updated with
the checkpoint position? Choose all options that are correct.

Select one or more of the following:

  • A. Data files

  • B. Control files

  • C. Initialization Parameter Files

  • D. Redo log files

  • E. Archive log files

Explanation

Question 19 of 20

1

19. User Isabella updates a table and commits the change after a few seconds. Which of the
following actions are happening in the database? Order them in the correct sequence
and ignore the actions that are not relevant.

Select one or more of the following:

  • A. Oracle reads the blocks from data file to buffer cache and updates the blocks.

  • B. Changed blocks from the buffer cache are written to data files.

  • C. The user commits the change.

  • D. LGWR writes the changed blocks to the redo log buffer.

  • E. The server process writes the change vectors to the redo log buffer.

  • F. LGWR flushes the redo log buffer to redo log files.

  • G. A checkpoint occurs.

Explanation

Question 20 of 20

1

20. Querying the V$LOG file shows the following information. Which redo group files are
required for instance crash recovery?
SQL> select GROUP#, ARCHIVED, STATUS from V$LOG;
GROUP# ARC STATUS
---------- --- ----------------
1 NO CURRENT
2 NO INACTIVE
3 NO INACTIVE
4 NO ACTIVE

Select one or more of the following:

  • A. Group 1 and 4

  • B. Group 2 and 3

  • C. Groups 1 through 4

  • D. Group 1

  • E. Group 4

Explanation

Previous
Next