7483382
Beschreibung
Quiz von Jamonero Blanco, aktualisiert more than 1 year ago
|
Erstellt von Jamonero Blanco
vor fast 8 Jahre
|
|
Frage 1
Frage
1.Choose two SGA structures that are required in every Oracle instance.
Antworten
-
A. Large pool
-
B. Shared pool
-
C. Buffer cache
-
D. Java pool
Frage 2
Frage
2. Which statement is true
Antworten
-
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.
Frage 3
Frage
3. Which component is configured at database startup and cannot be dynamically
managed?
Antworten
-
A. Redo log buffer.
-
B. Streams pool
-
C. Java pool
-
D. Shared pool
-
E. None of the above
Frage 4
Frage
4. Which component is not part of an Oracle instance?
Antworten
-
A. System global area.
-
B. Process monitor
-
C. Control file
-
D. Shared pool
-
E. None
Frage 5
Frage
5. Which background process guarantees that committed data is saved even when the
changes have not been recorded in data files?
Antworten
-
A. DBWn
-
B. PMON
-
C. LGWR
-
D. CKPT
-
E. ARCn
Frage 6
Frage
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?
Antworten
-
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.
Frage 7
Frage
7. Which of the following best describes a RAC configuration?
Antworten
-
A. One database, multiple instances
-
B. One instance, multiple databases
-
C. Multiple databases plugged in from multiple servers
-
D. Multiple databases, multiple instances
Frage 8
Frage
8. Which component of the SGA contains the parsed SQL code?
Antworten
-
A. Database buffer cache
-
B. Dictionary cache
-
C. Library cache
-
D. Parse cache
Frage 9
Frage
9. Which tasks are accomplished by the SMON process? (Choose all that apply.)
Antworten
-
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
Frage 10
Frage
10. Choose the best statement from the options related to segments.
Antworten
-
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.
Frage 11
Frage
11. From the following list, choose two processes that are optional in an Oracle Database
12c database.
Antworten
-
A. MMON
-
B. MMNL
-
C. ARCn
-
D. MMAN
Frage 12
Frage
12. Which SGA component will you increase or configure so that RMAN tape backups do
not use memory from the shared pool?
Antworten
-
A. Java pool
-
B. Streams pool
-
C. Recovery pool
-
D. Large pool
Frage 13
Frage
13. When a user session is terminated, which processes are responsible for cleaning up and
releasing locks? (Choose all that apply.)
Antworten
-
A. DBWn
-
B. LGWR
-
C. MMON
-
D. PMON
-
E. SMON
Frage 14
Frage
14. The LRU algorithm is used to manage what part of the Oracle architecture?
Antworten
-
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
Frage 15
Frage
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?
Antworten
-
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.
Frage 16
Frage
16. Which of the following is the proper order of Oracle’s storage hierarchy, from smallest
to largest?
Antworten
-
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
Frage 17
Frage
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:
Antworten
-
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.
Frage 18
Frage
18. When an incremental checkpoint happens in a database, which file(s) are updated with
the checkpoint position? Choose all options that are correct.
Antworten
-
A. Data files
-
B. Control files
-
C. Initialization Parameter Files
-
D. Redo log files
-
E. Archive log files
Frage 19
Frage
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.
Antworten
-
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.
Frage 20
Frage
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
Antworten
-
A. Group 1 and 4
-
B. Group 2 and 3
-
C. Groups 1 through 4
-
D. Group 1
-
E. Group 4
Möchten Sie mit GoConqr kostenlos Ihre eigenen Quiz erstellen? eigenen Mehr erfahren.