You are working on a new Oracle Database 11g server, where only the software is installed and no
database is created. You plan to create a database on this server using the Database Configuration
Assistant (DBCA). Some of the requirements set for your database creation task are:
1. Configure the database to operate in shared server mode.
2. Disable automatic maintenance tasks such as optimizer statistics collection.
3. Configure a naming method to help the remote user connect to the database instance.
4. Use Automatic Storage Management (ASM) for storing the database files.
5. Configure daily database backup to flash recovery area.
6. Configure Enterprise Manager Database Control to manage the database.
Which of these requirements can be met while creating the database?
A.
4 and 6
B.
2, 3, 4, and 6
C.
1, 2, 4, 5, and 6
D.
1, 2, 3, 4, 5, and 6
Database Configuration Assistant (DBCA) is the preferred way to create a database, because it is a more automated approach, and your database is ready to use when DBCA completes.
Configuring Oracle Database for Shared Server
Shared memory resources are preconfigured to allow the enabling of shared server at run time.
Automatic Optimizer Statistics Collection—Collects optimizer statistics for all schema objects in the database for which there are no statistics or only stale statistics. The statistics gathered by this task are used by the SQL query optimizer to improve the performance of SQL execution.
The scripts in this section use the flash recovery area as the log archiving destination and the destination for all disk backups. Therefore, whenever there is no space to create archived logs or backups in the flash recovery area, Oracle automatically deletes archived logs and backups that are obsolete or that have been moved to tape.
Configuring the RMAN Environment for Disk and Tape Backups
Use RMAN to configure the retention policy, backup optimization, and the control file autobackup
At the end of a successful database creation, Oracle Enterprise Manager is automatically launched in your Web browser and the database is started.