1. Which of the following does not affect the size of the SGA
a) Database buffer
b) Redo log buffer
c) Stored procedure
d) Shared pool
Answer: c
2. A set of Dictionary tables are created
a) Once for the Entire Database
b) Every time a user is created
c) Every time a Tablespace is created
d) None of the above
Answer: a
3. The order in which Oracle processes a single SQL statement is ?
a). execute, parse, fetch
b). execute, fetch, parse
c). parse, execute, fetch
d). parse, fetch, execute
Answer: c
4. What are the mandatory datafiles to create a database in Oracle 11g?
a). system, sysaux
b). system, userdata, temp
c). system, sysaux, undo
Answer: c
5. In one server can we have different oracle versions?
a). No
b). Yes
Answer: b
6. How do sessions communicate with database?
a). Server processes use oracle net to connect to the instance.
b). Background processes use oracle net to connect to the database
c). User processes read from the database and write to the instance;
d). Server processes execute SQL received from user processes.
Answer: d
7. Which SGA memory structure cannot be resized dynamically after instance startup?
a). Database Buffer Cache
b). Java Pool
c). Large Pool
d). Log Buffer
e). Shared Pool
Answer: d
8. When a session changes data, where does the change get written?
a). To the data block in the cache, and the redo log buffer
b). To the data block on disk, and the current online redo log file
c). The session writes to the database buffer cache, and the log writer writes to the current online redo log file
d). Nothing is written until the change is committed
Answer: a
9. How many maximum no of control files we can have within a database
a). 3
b). 5
c). 1
d). 8
Answer: d
10.System Data File Consists of
a). Metadata
b). Business Data
c). Temporary Data
d). Undo Data
Answer: a
11. What is the function of SMON in instance recovery?
a). It writes data to the archive log files.
b). It writes data to the online redo log files.
c). It frees resources held by user processes.
d). It synchronizes data file header and control files.
e). It roles forward by applying changes in the redo log.
f). It writes dirty buffers from the buffer cache to the data files.
Answer: e
12. Which action occur during a checkpoint?
A.Oracle updates a control file.
B.Oracle performs a delayed block clean-out.
C.Oracle copies the online redo-log to the archive destinations. `
D.Oracle flushes the dirty blocks in the database buffer cache to disk.
Answer: d
13. SMON process is used to write into LOG files
a). TRUE
b). FALSE
Answer: b
14. Oracle does not consider a transaction committed until
a). The Data is written back to the disk by DBWR
b). The LGWR successfully writes the changes to redo
c). PMON Process commits the process changes
d). SMON Process Writes the data
Answer: b
15. How many maximum DBWn(Db writers) we can invoke?
a). 3
b). 1
c). 10
d). 20
Answer: d
16. Which activity would generate less undo data?
a). INSERT
b). UPDATE
c). SELECT
d). DELETE
Answer: a
17. What happens when a user issues a COMMIT?
a). The CKPT process signals a checkpoint.
b). The DBWn process wrtes the transactions changed buffers to the datafiles.
c). The LGWR flushes the log buffer to the online redo log.
d). The ARCn process writes the change vectors to the archive redo log
Answer: c
18.What happens when a user process fails?
a). PMON performs process recovery.
b). SMON performs ICR
c). SMON frees resources held by user process.
d). Oracle Updates a controlfile.
Answer:a
19. What are the free buffers in the database buffer cache.
a). Buffer that have changed should be pushed to the disk.
b). Buffers that are currently in use.
c). Buffer that are being written to disk.
d). Buffer that can be overwritten.
Answer:d
20.When thw SMON Procees perform ICR.
a). For every startup
b). Only at the time of startup after graceful shutdown
c). Only at the time of startup after abort shutdown
Answer: c
a) Database buffer
b) Redo log buffer
c) Stored procedure
d) Shared pool
Answer: c
2. A set of Dictionary tables are created
a) Once for the Entire Database
b) Every time a user is created
c) Every time a Tablespace is created
d) None of the above
Answer: a
3. The order in which Oracle processes a single SQL statement is ?
a). execute, parse, fetch
b). execute, fetch, parse
c). parse, execute, fetch
d). parse, fetch, execute
Answer: c
4. What are the mandatory datafiles to create a database in Oracle 11g?
a). system, sysaux
b). system, userdata, temp
c). system, sysaux, undo
Answer: c
5. In one server can we have different oracle versions?
a). No
b). Yes
Answer: b
6. How do sessions communicate with database?
a). Server processes use oracle net to connect to the instance.
b). Background processes use oracle net to connect to the database
c). User processes read from the database and write to the instance;
d). Server processes execute SQL received from user processes.
Answer: d
7. Which SGA memory structure cannot be resized dynamically after instance startup?
a). Database Buffer Cache
b). Java Pool
c). Large Pool
d). Log Buffer
e). Shared Pool
Answer: d
8. When a session changes data, where does the change get written?
a). To the data block in the cache, and the redo log buffer
b). To the data block on disk, and the current online redo log file
c). The session writes to the database buffer cache, and the log writer writes to the current online redo log file
d). Nothing is written until the change is committed
Answer: a
9. How many maximum no of control files we can have within a database
a). 3
b). 5
c). 1
d). 8
Answer: d
10.System Data File Consists of
a). Metadata
b). Business Data
c). Temporary Data
d). Undo Data
Answer: a
11. What is the function of SMON in instance recovery?
a). It writes data to the archive log files.
b). It writes data to the online redo log files.
c). It frees resources held by user processes.
d). It synchronizes data file header and control files.
e). It roles forward by applying changes in the redo log.
f). It writes dirty buffers from the buffer cache to the data files.
Answer: e
12. Which action occur during a checkpoint?
A.Oracle updates a control file.
B.Oracle performs a delayed block clean-out.
C.Oracle copies the online redo-log to the archive destinations. `
D.Oracle flushes the dirty blocks in the database buffer cache to disk.
Answer: d
13. SMON process is used to write into LOG files
a). TRUE
b). FALSE
Answer: b
14. Oracle does not consider a transaction committed until
a). The Data is written back to the disk by DBWR
b). The LGWR successfully writes the changes to redo
c). PMON Process commits the process changes
d). SMON Process Writes the data
Answer: b
15. How many maximum DBWn(Db writers) we can invoke?
a). 3
b). 1
c). 10
d). 20
Answer: d
16. Which activity would generate less undo data?
a). INSERT
b). UPDATE
c). SELECT
d). DELETE
Answer: a
17. What happens when a user issues a COMMIT?
a). The CKPT process signals a checkpoint.
b). The DBWn process wrtes the transactions changed buffers to the datafiles.
c). The LGWR flushes the log buffer to the online redo log.
d). The ARCn process writes the change vectors to the archive redo log
Answer: c
18.What happens when a user process fails?
a). PMON performs process recovery.
b). SMON performs ICR
c). SMON frees resources held by user process.
d). Oracle Updates a controlfile.
Answer:a
19. What are the free buffers in the database buffer cache.
a). Buffer that have changed should be pushed to the disk.
b). Buffers that are currently in use.
c). Buffer that are being written to disk.
d). Buffer that can be overwritten.
Answer:d
20.When thw SMON Procees perform ICR.
a). For every startup
b). Only at the time of startup after graceful shutdown
c). Only at the time of startup after abort shutdown
Answer: c
No comments:
Post a Comment