We're so confident of our products that we provide no hassle product exchange.
Oracle AI Database Administration Professional Sample Questions:
1. Which two features are provided by AWR baselines?
(Choose two)
A) Auto-generation of redo log switch alerts
B) Automatic optimizer statistics gathering
C) Comparison of current performance metrics against a known workload
D) Retention of historical performance data for defined periods
2. How does enabling the In-Memory Column Store improve analytic query performance?
A) By eliminating the need for indexes entirely
B) By converting tables to columnar format in memory, accelerating scans and aggregations
C) By automatically converting redo logs into analytical indexes
D) By storing all tables in row format for faster transactional access
3. What utility is used with RMAN to perform cross-platform transport of tablespaces between systems with different endian formats?
A) Data Pump
B) RMAN CONVERT TABLESPACE
C) LogMiner
D) Transportable Database
4. When using DBCA in advanced mode, what advantage does template-based database creation offer?
A) It prevents automatic statistics gathering during creation
B) It disables archive log mode by default
C) It skips initialization parameter configuration entirely
D) It enables faster provisioning using preconfigured datafiles and options
5. Which RMAN command is required to configure a default device type for backups?
A) CONFIGURE DEFAULT DEVICE TYPE DISK;
B) ALLOCATE DEVICE TYPE DISK DEFAULT;
C) BACKUP DEVICE TYPE DEFAULT;
D) SET BACKUP DEVICE DEFAULT;
Solutions:
| Question # 1 Answer: C,D | Question # 2 Answer: B | Question # 3 Answer: B | Question # 4 Answer: D | Question # 5 Answer: A |
By Bartley
