Oracle DBA Question $ Answers(Part 8)

1. Can we create spfile in shutdown mode?

A.Yes
B. No

correct answer: a

2. Can we alter static parameters by using scope=both

A. Yes
B. No

correct answer: b

3. Can we take backup of spfile in RMAN?

A. Yes
B. No

correct answer: a

4. Does Drop Database command removes spfile?

A. Yes
B. No

correct answer: a

5. Using which SQL command we can alter the parameters?

A. Alter database
B. Alter parameter
C. Alter system

correct answer: c

6.OMF database will Improve the performance?

A. Yes
B. No

correct answer: b

7.Max number of controlfiles that can be multiplexed in an OMF database?

A. 1
B. 5
C. 8
D. unlimited

correct answer: b