Important Oracle DBA Question and Answer
1.Multiple ____________ can share an SGA
A. PMON processes
B. Server processes
C. Instances
D. Database
E. Tablespaces
Ans: B
2. Which component in the following list is not part of the SGA?
A. Database buffer cache
B. Library cache
C. Sort area
D. Share pool
E. Java pool
Ans: C
3. Which background process updates the online redo log files with the redo log buffer entries when a COMMIT occurs in the database?
A. DBWn
B. LGWR
C. CKPT
D. CMMT
Ans: B
4. Which script creates the data dictionary table ?
A. catalog.sql
B. catproc.sql
C. sql.bsq
D. dictionary.sql
Ans: C
5. Which SQL*Plus command can you use to see whether the database is in ARCHIVELOG mode?
A. SHOW DB LIST
B. ARCHIVELOG LIST
C. ARCHIVE LOG LIST
D. LIST ARCHIVELOG
Ans: C
6. Which tow extent management option available for tablespaces.
A. Dictionary-managed
B. Data file-managed
C. Locally managed
D. Remote managed
E. System-managed
Ans: A,C
7. Which dictionary views would give you information about the total size of a tablespace? (Chose two)
A. DBA_TABLESPACES
B. DBA_TEMP_FILES
C. DBA_DATA_FILES
D. DBA_FREE_SPACE
Ans: B,C
8 Which component is not part of the Oracle instance?
A. System Global Area
B. Process monitor
C. Control file
D. Shared pool
Ans:C
9.What is the maximum number of database writer processes allowed in an Oracle instances?
A. 1
B. 10
C. 256
D. Limit specified by an operating system parameter
Ans: B
10 Which background process is not started by default when you start up the Oracle instance?
A. DBWn
B. LGWR
C. CKPT
D. ARCn
Ans: D
11. Choose the correct hierarchy, from largest to smallest, from this list of logical database structures.
A. Database, tablespace, extent, segment, block
B. Database, tablespace, segment, extent, block
C. Database, segment, tablespace, extent, block
D. Database, extent, tablespace, segment, block
Ans: B
12. Which component of the SGA contains the parsed SQL code?
A. Buffer cache
B. Dictionary cache
C. Library cache
D. Parse cache
Ans: C
13. Which background process is responsible for writing the dirty buffers to the database files?
A. DBWn
B. SMON
C. LGWR
D. CKPT
E. PMON
Ans: A
14. When a server process is terminated abnormally, which background process is responsible for releasing the locks head by the user?
A. DBWn
B. LGWN
C. SMON
D. PMON
Ans: D
15. 12. What is a dirty buffer?
A. Data buffer that is begin accessed
B. Data buffer that is changed but is not written to the disk
C. data buffer that is free
D. Data buffer that is changed and written to the disk
Ans: B
16. which memory structure records all database changes made to the instance?
A. Database buffer
B. Dictionary cache
C. Redo log buffer
D. Library cache
Ans: C
17.18. What is the minimum number of online redo log file required in a database?
A. One
B. Two
C. Four
D. Zero
Ans: B
18.19. When are the system change numbers assigned?
A. When a trasaction begins
B. When a transaction ends abnormally
C. When a checkpoint occurs
D. When a COMMIT is issued
Ans: D
19. 1. Which of the following is an invalid database start-up option?
A. STARTUP NORMAL
B. STARTUP MOUNT
C. STARTUP NOMOUNT
D. STARTUP FORCE
Ans:A
20.4. What information is available in the alert log files?
A. Block corruption errors
B. users connecting and disconnecting from the database
C. All user errors
D. The default values of the parameters used to start up the database
Ans: A
1.Which underlying database technology is used by flashback
table, and Flashback version query to recovery data?
A. Redo
logs
B. Rollback
segments
C. Undo
data
D. Archive
logs
Ans: c
2. What action does
the Flashback Drop process perform?
A. Back up
table only
B. Back up
table and indexes only
C. Back up
table and referential constraints only
D. Back up
table and dependent objects
Ans: d
3. One method of dropping objects and bypassing the Recycle
bin is to perform which command?
A. DROP
USER user CASCADE
B. DROP
TABLE
C. DROP
TABLE INCLUDING CONTENTS
D. DROP
USER user
Ans:a
4. Which command is responsible for removing the objects in
multiple users from the recycle bin?
A. PURGE
RECYCLEBIN
B. PURGE
TABLESPACE user
C. PURGE
DBA_RECYCLEBIN
D. PURGE
TABLE user
Ans: c
5. What is the naming convention of a Recycle Bin object?
A.
BIN$globalUID$version
B.
BIN$global$UIDversion
C.
BIN$globalUIDversion
D.
BINglobalUIDversion
Ans:a
6. What two methods can be used to view the Recycle Bin
A. Run the
SHOW RECYCLEBIN command.
B. Query
the view DBA_RECYCLEBIN.
C.Query the
view V$RECYCLEBIN
D. Query
the view RECYCLEBIN.
Ans: ad
7. What view can be used to query diagnostic information
about transactional changes in the database?
A.
FLASHBACK_TRANSACTION_QUERY
B.
DBA_TRANSACTION_QUERY
C.
V$TRANSACTION_QUERY
D.
V$FLASHBACK_TRANSACTION_QUERY
Ans: a
8.Which pseudocolumn do you use to identify a unique row in
a Flashback Version Query?
A.
VERSIONS_XID
B.
BVERSIONS_OPERATION
C.
VERSIONS_ENDTIME
D.
VERSION_STARTTIME
Ans: a
9. How can you protect the amount of time you can query
information from the Flashback Transaction Query?
A. Add UNDO
GUARANTEE to the UNDO tablespace.
B. Add
RETENTION GUARANTEE to the UNDO tablespace.
C. Add RETENTION
GUARANTEE to the Recycle Bin logical storage container.
D. Add UNDO
GUARANTEE to the Recycle Bin logical storage container.
Ans: b
10. Which of the
following are type of problems that the ADDM will consider?(Choose all the
apply)
A. Database
configuration issues
B.
Concurrency issues
C. CPU
bottlenecks
D.
Suboptimal use of Oracle by an application
E. All of
the above
Ans: e
11. The statistical data needed for ADDM to accurately
diagnose problems is stroed in which of the following areas?
A.
Automatic Workload Repository(AWR)
B. Data
dictionary
C. ADDM
repository
D. PERFSTAT
table
E. None of
the above
Ans:a
12. The AWR resides
in which tablespace?
A. SYSTEM.
B. TOOLS
C. SYSAUX
D. AWR
E. None of the above
Ans: c
13. Which view shows the current AWR settings?
A.
DBA_AWR_SETTINGS
B.
DBA_AWR_CONFIG
C.
DBA_HIST_WR_CONTROL
D.
DBA_HIST_WR_SETTINGS
E.
DBA_REPOSITORY
Ans: c
14. Extents in an ASM file are allocated in units of which
size?
A. 100KB
B. 10MB
C. 1MB
D. 64KB
Ans:c
15. Which initialization parameter in an ASM instance
specifies the disk group to be automatically mounted at instance startup?
A.
ASM_DISKMOUNT
B.
ASM_DISKGROUP
C.
ASM_DISKSTRING
D.
ASM_MOUNTGROUP
Ans: b
16. Which of the following command options is not valid
for an ASM instance?
A. STARTUP
OPEN
B. STARTUP
NOMUNT
C. STARTUP
MOUNT
D. STARTUP
OPEN RESTRICT
E. SHUTDOWN
ABORT
Ans: a
17. To prevent connections to an ASM instance, you can use
which of the following commands?
A. ALTER
SYSTEM ENABLE RESTRICTED SESSION
B. SHUTDOWN
IMMEDIATE
C. ALTER
SYSTEM DISABLE CONNECTIONS
D. ALTER
DATABASE ENABLE RESTRICTED SESSION
Ans: a
18. Which an ASM instance receives a SHUTDOWN NORMAL
command, what command does it pass on to all database instances that rely on
the ASM instance’s disk grougs?
A.
TRANSACTIONAL
B.
IMMEDIATE
C. ABORT
D. NORMAL
E. None of
the above
Ans: d
19. When creating a disk group, what keyword must be
specified if you need to reuse a disk that has previously been used as part of
another disk group?
A. NOFORCE
B. REUSE
C. USE
D. FORCE
E.
INCLUDING CONTENTS
Ans: d
20. Which type of database file is spread across all disks
in a disk group?
A. All
types of files are spread across all disks in the disk group
B.
Datafiles
C. Redo log
files
D. Archived
redo log files
E. Control
files
Ans: a
No comments:
Post a Comment