Oracle AI Database Administration Professional Sample Questions:
1. Why must the RESETLOGS option be used when opening a database after incomplete recovery?
A) It bypasses datafile header checks
B) It creates a new incarnation of the database and resets the redo sequence
C) It preserves the SCN for the next recovery
D) It merges temporary and permanent tablespaces
2. What is the difference between opatch and opatchauto
Response:
A) opatch can patch Grid Infrastructure, but opatchauto cannot
B) opatchauto applies interim patches, and opatch applies bundle patches
C) opatchauto handles both GI and database patching, while opatch is used for a single Oracle Home
D) opatch is GUI-based, while opatchauto is command-line only
3. Which two tuning actions help reduce SQL execution cost?
(Choose two)
A) Disable SQL plan baselines
B) Gather optimizer statistics regularly
C) Disable adaptive query optimization
D) Use bind variables instead of literals
4. When you define a guaranteed restore point, what happens in the background?
A) Oracle starts capturing redo entries in archived logs
B) Oracle enables flashback logs specifically for that restore point
C) Oracle schedules automatic RMAN backups
D) Oracle disables normal flashback log purging
5. Which two steps are recommended before applying a Grid Infrastructure patch?
(Choose two)
A) Stop listener processes permanently
B) Disable redo log archiving
C) Back up the Grid Infrastructure home
D) Verify free space and cluster node status
Solutions:
| Question # 1 Answer: B | Question # 2 Answer: C | Question # 3 Answer: B,D | Question # 4 Answer: D | Question # 5 Answer: C,D |
We're so confident of our products that we provide no hassle product exchange.


By Aldrich

