Which two are true about Oracle Database Configuration Assistant (DBCA) templates? (Choose two.)
Which two are true about Oracle Database Configuration Assistant (DBCA) templates? (Choose two.)
The General Purpose or Transaction Processing templates are indeed most suitable when concurrency and recoverability are key criteria, as they are designed to handle many concurrent users performing numerous transactions that require rapid access to data. Oracle DBCA templates can also be used to create new databases and duplicate existing databases, highlighting their versatility in database management tasks.
A&E are correct. The new features are in Oracle 19c https://docs.oracle.com/en/database/oracle/oracle-database/19/admqs/installing-oracle-database-creating-database.html#GUID-418CDFD6-340C-40B4-AC08-5005560ED9DC
agree with AE
Klever35, have you attended the exam 1z0-083? Please suggest
AE correct
Very tricky question. A: true. https://docs.oracle.com/en/database/oracle/oracle-database/19/admqs/installing-oracle-database-creating-database.html#GUID-E59E0AE9-AF91-4DD2-B311-C92E3EFE9948 General Purpose or Transaction processing Many concurrent users perform numerous transactions that require rapid access to data. Availability, speed, concurrency, and recoverability are key issues. B: false. Some templates store database files. C: false. I can create template from existing database too. D: true From link provided above: Data warehouse Users perform numerous, complex queries that process large volumes of data. Response time, accuracy, and availability are key issues. E: true https://docs.oracle.com/en/database/oracle/oracle-database/19/admqs/installing-oracle-database-creating-database.html#GUID-2B8A3B5E-D319-4377-8B22-8BB67DCC9885 Templates are used in DBCA to create new databases and duplicate existing databases. So we have A and D on the same level (both are talking about existing templates) and E that point on DBCA usage at all, not the templates. Sometimes I think that A&D is correct answer...
D is false, complex queries are not the same as transaction processing: "A data warehouse is a database designed to enable business intelligence activities: it exists to help users understand and enhance their organization's performance. It is designed for query and analysis rather than for transaction processing" https://docs.oracle.com/en/database/oracle/oracle-database/19/dwhsg/introduction-data-warehouse-concepts.html#GUID-452FBA23-6976-4590-AA41-1369647AD14D
Option D: when transaction response time is the key criterion. but in doc, it describe as Response time, nor transaction response time
Yes tricky question or poorly written question. I think A D for the same reasons
As you wrote "General Purpose or Transaction processing", in the theory it is written"or", in the answer "of" so I think A is wrong!
I think B E
AE for me
In Oracle 18c the DBCA can now duplicate container databases. In the following example we have a container database called "cdb1". We use the following command to attempt to create a new CDB called "cdb2" as a clone of "cdb1", but it fails because the source database is not in archivelog mode. E correct
A + E is correct
A. False -> "The General Purpose of Transaction" it's "or" not "of" -> definition is definition, should be copy and paste :-) B. True -> Oracle DBCA templates are XML file, they cannot store data files! C. False D. False E. True