Oracle 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