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
correct 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
correct 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
correct 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
correct answer: c
5. In one server can we have different oracle versions?
A. No
B. Yes
correct 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.
correct answer: d
7. Which SGA memory structure cannot be resized dynamically after instance startup?
A. Database Buffer Cace
B. Java Pool
C. Large pool
D. Log buffer
E. Shared Pool
correct 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 logfile
D. Nothing is written until the change is committed
correct 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
a) Database buffer
b) Redo log buffer
c) Stored procedure
d) Shared pool
correct 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
correct 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
correct 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
correct answer: c
5. In one server can we have different oracle versions?
A. No
B. Yes
correct 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.
correct answer: d
7. Which SGA memory structure cannot be resized dynamically after instance startup?
A. Database Buffer Cace
B. Java Pool
C. Large pool
D. Log buffer
E. Shared Pool
correct 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 logfile
D. Nothing is written until the change is committed
correct 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
0 comments:
Post a Comment