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