**NOTE:**Each correct answer would give you 5 points
- Which portion of the System Global Area, also known as SGA holds information about changes made to the database?
The redo log buffer
The database buffer cache
The large pool
The shared pool
- Which task is performed by the system monitor or SMON process?
Copying redo log files to a designated storage device
Writing dirty buffers to disk
Performing instance recovery at instance startup
Cleaning up the database buffer cache
- Which task is performed by the ARCn processes?
Cleaning up the database buffer cache
Copying redo log files to a designated storage device
Writing dirty buffers to disk
Performing instance recovery at instance startup
- Which task is performed by the PMON process?
Performing instance recovery at instance startup
Writing dirty buffers to disk
Cleaning up the database buffer cache
Copying redo log files to a designated storage device
- What is the minimum Oracle block size?
1 KB
2 KB
4 KB
8 KB
- Which type of file in Oracle Database defines how the instance is configured when it starts up?
Parameter files
Data Files
Online redo log files
Control Files
- Which logical database structure groups data files together?
Tablespace
Data block
Extent
Segment
- What area in the shared pool holds a collection of database tables and views with reference information about the database, its structures and its users?
The shared SQL area
The data dictionary
The library cache
The database buffer cache
- Which task is performed by the checkpoint also known as CKPT, process?
Writing dirty buffers to disk
Copying redo log files to designated storage device
Updating the header of all data files with the current SCN
Cleaning up the database buffer cache
- Which task is performed by the database writer also known as DBWn process?
Cleaning up the database buffer cache
Updating the header of all data files with the current SCN
Writing dirty buffers to disk
Copying redo log files to designated storage device
- What is the task performed by recoverer or RECO process?
Copying redo log files to designated storage device
Automatically resolving failures involving distributed transactions
Updating the header of all data files with the current SCN
Cleaning up the database buffer cache
- Which edition of Oracle is only appropriate for servers upto 4 sockets?
Standard Edition
Enterprise Edition
Standard Edition One
RAC Edition
- Which task is performed by the database Configuration Assistant?
Configuring and managing Oracle Network configurations
Creating a database from Oracle supplied templates
Installing oracle software and options
Upgrading an existing database to new oracle release
- Which oracle environment variable controls client character set settings?
NLS_LANG
ORACLE_HOME
ORACLE_BASE
ORACLE_SID
- Which task is accomplished by executing the root.sh script during installation of Oracle Grid Infrastructure software?
Creating an ASM disk group
Changing the permission of the Oracle Central Inventory directory
Performing prerequisites check
starting the ohasd daemon
- Which tablespace in a preconfigured database is used during large sort operations or creation of an index?
UND0TBS1
SYSTEM
SYSAUX
TEMP
- How large is the default extent size when you specify the uniform extent allocation method?
256 KB
512 KB
1 MB
2 MB
- Which portion of data block grows from the bottom upwards?
Segment
Row data
Free space
header
- Which offline status for a tablespace has been deprecated in Oracle database 11g and has been retained only for backward compatibility?
For Recovery
Temporary
Normal
Immediate
- Which method of authentication is used if x509 certificates are used?
Global
Advanced
External
Password
- What system privilege assigned to a user will allow that user to connect to the database with the same privilege as the SYS user?
SYSDBA
SYSASM
SYSOPER
GRANT ANY OBJECT PRIVILEGE
- Which predefined role contains only the CREATE SESSION privilege?
RESOURCE
SCHEDULER_ADMIN
DBA
CONNECT
- When you create a user what is the default quota setting used for any available tablespace?
Unlimited
UNLIMITED TABLESPACE
None
Value
- If a user has been granted the CREATE ANY TABLE privilege, where can that user create the table?
In all schemas
In the DBA's schema only
In their schema only
In their schema and DBA's schema
- Which wildcard character provided by Oracle database 11g for archive log naming is optional?
%r
%d
%s
%d
- Which type of database is best suited for transaction processing?
Custom
Multipurpose
General purpose
Data Warehouse
- Which is an example of single byte character set?
AL32UTF8
JA16SJIS
WE8IS08859P1
ZHT16HKSCS
- What is the name of the process that should be started before using database control?
emctl
dbconsole
sqlplus
bin
- When selecting the database creation options, which action will be performed first if all options have been selected?
Creating the database
Modifying the database storage settings
Generating scripts
Saving the database as template
- Which shutdown mode performs the least amount of work before shutting down?
TRANSACTIONAL
ABORT
IMMEDIATE
NORMAL