Oracle Database Administration II — Question 67

Which two are true about Oracle Database Configuration Assistant (DBCA) templates? (Choose two.)

Answer options

• A. The General Purpose of Transaction Processing templates are most suitable when concurrency and recoverability are key criteria.
• B. Oracle DBCA templates can store only logical structure and not database files.
• C. New templates can only be created by modifying an existing user-created template.
• D. The Data Warehouse template is most suitable when transaction response time is the key criterion.
• E. Oracle DBCA templates can be used to create new databases and duplicate existing databases.

Correct answer: A, E

Explanation

Option A is correct because the General Purpose and Transaction Processing templates focus on high concurrency and recoverability. Option E is also correct as DBCA templates are designed to create new databases and replicate existing ones. Options B, C, and D are incorrect because they misrepresent the capabilities of DBCA templates or their intended use cases.