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
Obviously A and E are correct, while C and D are wrong, and those four are already discussed.
but what about B?
according to documentation, "seed" templates can include datafiles, and that's why B is wrong.
so the Correct answer is A and E
https://docs.oracle.com/database/121/ADMQS/GUID-418CDFD6-340C-40B4-AC08-5005560ED9DC.htm
Yes, Oracle Database Configuration Assistant (DBCA) templates can store database files, but it depends on the type of template you create:
Data Templates (with data files): These templates include both the database structure and actual database files, allowing you to replicate a fully functioning database with pre-configured tables, indexes, and any other objects that were in the original database. This type of template can be very large because it contains the physical data files.
Structure-Only Templates: These templates only contain the structural definitions of the database (such as tablespaces, parameters, and configuration) without the actual data files. When you create a database with a structure-only template, you’re effectively creating a new database that mimics the structure of the original but does not include any data.
When you create or use a template in DBCA, make sure to specify whether you want to include database files or just the structure, depending on your needs.
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
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
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
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
taotsumiau
Highly Voted 4 years, 5 months agojanw
Highly Voted 4 years, 4 months agowagihov
Most Recent 1 day, 3 hours agogonza150
1 month, 2 weeks agoauwia
5 months, 3 weeks agovkra
1 year, 9 months agoDhanushbh
3 years, 4 months agoAsmodeus
3 years, 8 months agoauwia
5 months, 2 weeks agoSimoneF
3 years, 7 months agoEric_F
2 years, 6 months ago_gio_
1 year, 6 months agocerebro2000x
4 years, 4 months agoCyborgQ
4 years, 4 months agoyou1234
4 years, 5 months agoklever35
4 years, 5 months ago