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