1. Which one of the following memory areas is not part of the SGA? A. Database B
ID: 3866167 • Letter: 1
Question
1. Which one of the following memory areas is not part of the SGA?
A. Database Buffer Cache
B. PGA
C. Redo Log Buffer
D. Shared Pool
2. Which of the following statements are true about the Shared Pool? (Choose all the applicable answers.)
A. The Shared Pool consists of the Data Dictionary Cache, Shared SQL area, Java Pool, and Large Pool.
B. The Shared Pool can be dynamically resized.
C. The Shared Pool is used for object that can be shared globally.
D. The Library Cache consists of the most recently used SQL and PL/SQL statements.
3. Which one of the following memory areas is used to cache the data dictionary information?
A. Database Buffer Cache
B. PGA
C. Redo Log Buffer
D. Shared Pool
4. Which two of these are not part of the Shared Pool?
A. Dictionary Cache
B. Redo Log Buffer
C. Library Cache
D. Database Buffer Cache
5. The PGA is a memory region that contains data and control information for multiple server processes
or multiple background processes.
A. True
B. False
6. Which of the following becomes available when an Oracle instance is started.
A. User process
B. Server process
C. Background processes
D. Foreground processes
7. The physical structure of an Oracle database consists of control files, data files, redo log files, and
archived log files.
A. True
B. False
8. Which statement about starting an instance without mounting the database (NOMOUNT) is true?
A. Use this startup state for renaming data files.
B. Use this startup state to perform a full database recovery.
C. Use this startup state to open the online redo log files and online data files.
D. Use this startup state for database creation of database or recreation of the control files.
9. Evaluate this statement: CREATE SPFILE FROM PFILE;
Which statements of the above statement are true? (Choose all the applicable answers.)
A. This statement requires the SYSDBA or SYSOPER role to execute.
B. This statement will only execute if the PFILE is available on the server.
C. This syntax CANNOT be reversed to create a PFILE from an SPFILE.
D. This statement will NOT execute because a name for the SPFILE was NOT specified.
10. Match the process with its task.
A. Database Writer 1 Assists with writing to the data file headers
B. Log Writer 2 Cleans up after failed processes
C. System Monitor 3 Responsible for instance recovery
D. Process Monitor 4 Records database changes for recovery purposes
E. Checkpoint 5 Writes dirty buffers to the data files
11. Which of the following is an invalid database start-up option?
A. STARTUP NORMAL
B. STARTUP MOUNT
C. STARTUP NOMOUNT
D. STARTUP FORCE
E. STARTUP OPEN
12. Which SHUTDOWN option requires instance recovery when the database is started the next time?
A. SHUTDOWN IMMEDIATE
B. SHUTDOWN TRANSACTIONAL
C. SHUTDOWN NORMAL
D. SHUTDOWN FORCE
E. None of the above
13. You create a table with the following command:
SQL> CREATE TABLE test
(Col1 Varchar2(30) Primary Key) Tablespace testdata
Storage (Initial 50M Next 100M Pctincrease 20) Minextents 1 Maxextents 200);
How large the 4th extent Oracle allocates?
14. The contents of the Shared Pool are managed using what type of algorithm?
A. Least Recently Needed
B. Least Recently Used
C. Least Recently Accessed
D. Least Recently Parsed
15. When performing the command SHUTDOWN IMMEDIATE, Oracle performs the following tasks in what order?
A. Closes all files
B. Disconnects the users
C. Rolls back all current uncommitted transactions
D. Shuts down instance
E. Dismounts the database
16. Which of the following is not typically a responsibility of an Oracle database administrator?
A. Creating new users
B. Creating database objects
C. Installing Oracle software
D. Application development to manipulate database data
E. Backing up the database
17. During the transition from NOMOUNT to MOUNT mode, which file or files are required?
A. Parameter file
B. Control files
C. Online redo logs
D. Data files
E. All of the above
18. Which initialization parameter can be manual dynamic tuned?
A. DB_KEEP_CACHE_SIZE
B. DB_RECYCLE_CACHE_SIZE
C. DB_nK_CACHE_SIZE
D. SGA_TARGET
E. All of the above
19. Which four memory pools are automatically sized when you are using Automatic Shared Memory Management?
A. Database buffer cache
B. Keep buffer cache
C. Java pool
D. Recycle buffer cache
E. Shared pool
F. Log buffer
G. Large pool
20. Which files must be synchronized for a database to open?
A. Data files, online redo log files, and the control files
B. The parameter file and the password file
C. All the online redo log files and the archived log files.
D. None. SMON will synchronize all files by instance recovery after opening the database.
Explanation / Answer
1.
SGA memory area consist of the java pool, buffer cache, redo buffer, shared pool, streams
pool, and large pool.
Therefore, the statement B. PGA is not a part of the SGA.
2.
Shared pool consists of the library cache that includes SQL areas and package.
Dictionary cache including detailed information along with the metadata.
Large pool is not a part of shared pool. Large pool is the separate heap used for memory
allocation purposes.
Java pool is concerned with the server memory and it is used for session specific purpose.
Java pool is not the part of the shared pool.
Shared pool size is dependent on its initialization parameter. Shared pool size can vary as
per the different value of initializing parameter.
Therefore, the correct options are as follows:
B. The Shared Pool can be dynamically resized.
C. The Shared Pool is used for object that can be shared globally.
D. The Library Cache consists of the most recently used SQL and PL/SQL statements.
3
Shared pool consist of the dictionary cache includes the detailed information along with
the metadata.
Data dictionary information is cached in the data dictionary cache that is a part of the
shared pool.
Therefore, the correct option is D. Shared Pool.
4.
Shared pool consists of the library cache and dictionary cache.
Shared pool consists of the library cache that includes SQL areas and package.
Dictionary cache including detailed information along with the metadata.
Therefore, the correct options are as follows:
B. Redo Log Buffer
D. Database Buffer Cache
5.
Program global area(PGA) is a non-shared memory region created for a server process.
PGA contains the data and control information related to the server process that created it.
PGA memory is allocated as per the database instances.
Therefore, the correct option is A. True.
6.
When an oracle instance is created, it starts a background process.
Background process consist of the database writer, log writer, check pointer, system
monitor, process monitor, and archiver.
Therefore, the correct option is C. Background processes.
7.
Physical structure of the Oracle database includes the Datafiles, Control Files, Redo Log Files, Archive Log Files, Parameter Files, Alert and Trace Log Files, and Backup Files.
Therefore, the correct option is A. True.
8.
Starting an instance by mounting the database is done to perform a full database recovery,
to open the online redo log files and online data files, and to rename the data files.
Starting an instance without mounting the database is done only to create the database or for recreation of the control files.
Therefore, the correct option is D. Use this startup state for database creation of
database or recreation of the control files.
9.
The statement: CREATE SPFILE FROM PFILE; requires the connection to the SYSDBA. The connection is required to access the database after creating the SPFILE and startup command is used.
Therefore, the correct option is A. This statement requires the SYSDBA or SYSOPER
role to execute.
10.
Database write is used to write or modify the files on disk from the database buffer.
Log writer contains the records for the chances made in the database.
System monitor is used for the failed instance recovery purpose.
Process monitor is responsible for the recovery of the failed process.
Checkpoint is used for a specific time to write the modified data to the database by the
help of writer process.
Process with their matching task is shown in the table below:
A. Database Writer
1 Assists with writing to the data file headers
B. Log Writer
4 Records database changes for recovery purposes
C. System Monitor
3 Responsible for instance recovery
D. Process Monitor
2 Cleans up after failed processes
E. Checkpoint
5 Writes dirty buffers to the data files
11.
Valid database start-up options are as follows:
Startup: it is used top startup the database.
Startup Force: it is used to start the instance forcefully and to perform the instance
recovery.
Startup Nomount: as per the spfile background process are started.
Startup Mount: it is used to open and read the content of the control files.
Therefore, the correct option is A. STARTUP NORMAL.
12.
SHUTDOWN ABORT is the shutdown option that requires the instance recovery for
starting the database for the next time.
Therefore, the correct option is E. None of the above.
13.
Fourth extent can be calculated as per the storage parameter values as follows:
100M+(20*100)/100
=120M
120M+(120*20)/100
=144M
Hence, the oracle allocates 144M to the 4th extent.
14.
Oracle uses LRU algorithm for managing the content of the shared pool. Shared Pool can
be allocated and deallocated using the LRU.
Therefore, the correct option is B. Least Recently Used.
15.
Shutdown Immediate does not wait for the user to disconnect, it just rollback the
transaction which are not committed.
Shutdown Immediate perform the task in following order:
C. Rolls back all current uncommitted transactions
B. Disconnects the users
A. Closes all files
E. Dismounts the database
D. Shuts down instance
16.
Application development is the work of application developers and not of the database
administrator.
Therefore, the correct option is D. Application development to manipulate database
data.
17.
During the transition from nomount to mount control files are required and data and redo
files are read.
Therefore, the correct option is B. Control files.
18.
Automatic Shared Memory Management uses sga_target initialization parameters.
initialization parameter can be manual dynamic tuned are DB_KEEP_CACHE_SIZE
, DB_RECYCLE_CACHE_SIZE, DB_nK_CACHE_SIZE, and SGA_TARGET.
These parameters are used to keep the pool, recycle the pool, for fixed SGA, and other
internal allocations.
Therefore, the correct option is E. All of the above.
19.
Automatic Shared Memory Management uses sga_target initialization parameter that
automatically set the Database Buffer cache, Shared pool Large pool, and Java pools.
Therefore, the correct options are as follows:
A.Database buffer cache
C.Java pool
E. Shared pool
G. Large pool
20.
To open the database, the datafiles, redo logfiles and the control files should be synchronized because they are required in order to read from the database and to write in the database.
Therefore, the correct option is A. Data files, online redo log files, and the control files.
A. Database Writer
1 Assists with writing to the data file headers
B. Log Writer
4 Records database changes for recovery purposes
C. System Monitor
3 Responsible for instance recovery
D. Process Monitor
2 Cleans up after failed processes
E. Checkpoint
5 Writes dirty buffers to the data files
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.