Q.1:
Which initialization parameter specifies the location of the alert log file?L
A.
UTL_FILE_DIR
B.
USER_DUMP_DEST
C.
LOG_ARCHIVE_DEST
D.BACKGROUND_DUMP_DEST
Q.2:
Which of the following is mandatory when using the easy connect naming method? O
A.Host name
B.
Database name
C.
Service name
D.
Port number
Q.3:
Which graphical DBA administration tool should be used to tune an Oracle database? S
A.
SQL*Plus
B.Oracle Enterprise Manager
C.
Oracle Universal Installer
D.
Oracle Database Configuration Assistant+
Q.4:
What will the command EXECUTE DBMS_SCHEDULER.PURGE_LOG(); do?=
A.
Purge only all the window logs
B.
Purge only all the job logs
C.Purge all window and job logs
D.
Purge only yesterday's job logs#
Q.5:
What should be confirmed before changing the CURSOR_SPACE_FOR_TIME parameter in the initialization file to TRUE? y
A.
The TIMED_STATISTICS parameter is set to TRUE-
B.
The hit percentage in the buffer cache is at least 95%6
C.
The OPEN_CURSOR parameter is set to at least twice the default valueD
D.The value in the RELOADS column of V$LIBRARYCACHE is consistently zeroF
Q.6:
Which DBMS_LOGMNR feature facilitates the automatic adding of redo log files for mining? Y
A.
REMOVE_LOGFILE
B.CONTINUOUS_MINE
C.
NO_ROWID_IN_STMT
D.
AUTOMATIC_LOGFILE
Q.7:
Which option lists the correct hierarchy of storage structures, from largest to smallest? Z
A.
Segment, extent, tablespace, data block'
B.
Data block, extent, segment, tablespace'
C.
Tablespace, extent, data block, segment'
D.Tablespace, segment, extent, data block+
Q.8:
An index on the PASSPORT_RECORDS table has to be created. It contains 10 million rows of data. The key columns have low cardinality. The queries generated against this table use a combination of multiple WHERE conditions involving the OR operator.Which of the following index will be used for this criteria?3
A.Bitmap
B.
Unique
C.
Partitioned
D.
Reverse key
Q.9:
Who will be the owner of the job, if you create a job in user SCOTTs schema?L
A.SYS will be the owner of the job
B.
You will be the owner of the job
C.
PUBLIC will be the owner of the job#
D.
SCOTT will be the owner of the job&
Q.10:
Where can the nondefault parameters be found when the instance is started? K