Oracle 10g New Features Review Questions Ch1

Chapter 1 - Installing and Upgrading to Oracle 10g


1. On most platforms, to install Oracle 9i software, you needed three installation CDs. How many CDs are required for Oracle 10g installation?
A. 4
B. 3
C. 2
D. 1
---
Ans: D
Oracle has made several enhancements to Oracle 10g installation. Oracle 10g can be installed
with just one CD. You can also install a preconfigured database or a custom database with
the software install. Oracle achieved this by removing all duplicate files and having only
one database template. The Oracle database examples are installed from the companion CD.

2. Of the following options, which is not true when installing Oracle 10g?
A. The operating system must be certified.
B. A product key must be entered and activated.
C. 512MB RAM is required for each database instance with Database Control
D. Enough swap space available
---
Ans: B.
You do not need to provide or activate any product key to install the Oracle1Oracle 10g software.

3. Which component can be installed from the Oracle 10g database installation CD?
A. Legato Single Server Version
B. Database examples
C. Oracle Enterprise Manager Database Control
D. Oracle Database Client
---
Ans: C.
The EM Database Control is installed by default for Enterprise Edition or Standard Edition;
for custom install you can optionally not install this. Legato and database examples are installed
from the companion CD. (Remember, database examples are not the same as sample schema; sample schema can be installed along with the database creation.) Beginning with Oracle 10g, the client software can be installed only from database client installation media.


4. When using the DBCA GUI tool to create a database, which feature is supported?
A. Databases that use ASM storage
B. Databases that need to be controlled using the Enterprise Manager Central Management Control
C. Real Application Cluster database
D. All of the above
---
Ans: D.
The DBCA supports RAC, ASM, backup and recovery options, administrative passwords,
and so on. The DBCA supports all the new features of Oracle 10g database including database management control using Enterprise Manager. You can also use the DBCA to clone an existing database.


5. Identify the statement that is true regarding cloning a database using DBCA.
A. When cloning a database, the source database must not be started.
B. When cloning a database, the source database must be started.
C. Cloning using the DBCA creates a copy of the database data files under templates
and can be used for creating any number of cloned databases at any time.
D. When cloning a database to more than one destination, the source database must
remain in the mount state until all cloning operations are completed.
------
Ans: C.
Database cloning using DBCA is accomplished by creating a template with structure
and data option. Once the template is created, it can be used to create any number of
similar (cloned) databases. The source database will be in the mount state when
creating the template. The state of the source database does not matter when creating
the clones using the template.



6. When upgrading a database to Oracle 10g, which of the following options are true?
A. Any version of Oracle 8, Oracle 8i, or Oracle 9i database can be upgraded to Oracle 10g using the DBUA.
B. Only the versions 8.0.6, 8.1.7, 9.0.1, and 9.2.0 can be upgraded to Oracle 10g.
C. Once upgraded to Oracle 10g, the database can be downgraded only to Oracle 9i 9.2.0.
D. The upgraded database can be downgraded to its original version by using the DBUA if no Oracle 10g–related feature is implemented in the database.

---
Ans C.
The Oracle 10g database provides the provision to downgrade the database to Oracle 9i Release 2, provided the COMPATIBLE parameter is still set to 9.2.0. Not all versions of the database can be upgraded to Oracle 10g using the DBUA; only 8.0.6, 8.1.7, 9.0.1, and 9.2.0 databases can be directly upgraded to Oracle 10g. The DBUA supports only direct upgrade. Any version of Oracle database can be upgraded to Oracle 10g either using the direct upgrade method, first upgrading to a version supported by direct upgrade, or by using export/import method.


7. Which option in the database is used to monitor the database feature usage?
A. Automatic Workload Repository
B. Enterprise Manager Database Control
C. Database monitoring feature
D. The SYSAUX tablespace

---
Ans. A.
The AWR is used to monitor the database feature usage. The MMON process collects information on database feature usage (can be queried from DBA_FEATURE_USAGE_STATISTICS view) and database high-watermark statistics (can be queried from DBA_HIGH_WATER_MARK_STATISTICS view).


8. Which is the best option to upgrade an Oracle 8i, 8.1.7 database to Oracle 10g?
A. Use the export utility from Oracle 8i and import utility from Oracle 10g.
B. Perform a direct upgrade using DBUA.
C. Upgrade to Oracle 9i 9.2.0 using the Oracle 9i DBUA and then upgrade the database to Oracle 10g using the Oracle 10g DBUA.
D. Run u0801070.sql script on an Oracle 8i instance and then start the instance in Oracle 10g.

---
Ans: B.
Oracle 10g supports direct upgrade from 8.0.6, 8.1.7, 9.0.1, and 9.2.0 databases.


9. When upgrading a database using the DBUA to Oracle 10g, which activity is not performed by the DBUA?
A. Perform preupgrade steps.
B. Create the SYSAUX tablespace.
C. Change the listener.ora file to enter new Oracle home directory information.
D. Back up the database after upgrade.
D1. Disable archiving during upgrade.
E. Lock new user accounts created.
F. Adjust initialization parameter values.
G. Remove deprecated initialization parameters.
H. Recompile invalid objects.

----
Ans: D.
The DBUA has an option to back up the database prior to upgrade. It's up to you to back up the database after the upgrade is completed.


10. When performing a manual upgrade to Oracle 10g, in what order are the following steps performed? (Note: Some steps may be missing.)
1. Run utlu101s.sql.
2. Run utlu101i.sql.
3. Run utlrp.sql.
4. Create the SYSAUX tablespace.
5. Start the database using the STARTUP UPGRADE option.
A. 1, 2, 3, 4, 5.
B. 2, 5, 4, 1, 3.
C. 5, 4, 2, 1, 3.
D. 5, 2, 4, 1, 3.

----
Ans: B.
The first step is to run the preupgrade information utility utlu101i.sql. Fix all the discrepancies listed in this result, and shut down the database. Start the Oracle 10g instance after adjusting any initialization parameters using STARTUP UPGRADE. Create the SYSAUX tablespace and then run the upgrade script based on the release of the database from which you're upgrading. After the upgrade, verify the status of upgrade using utlu101s.sql. Shut down and start up the database, and recompile any invalid objects using utlrp.sql script.


11. When using the DBCA to create a database, which types of file storage cannot be chosen for the database?
A. Raw device
B. ASM storage
C. File system
D. Oracle Managed Files (OMF)
E. None of the above

---
Ans: E.
DBCA in Oracle 10g provides provisions to create the database with any of the storage options. OMF is a subcategory of file system storage.



12. Which of the following actions are performed by the preupgrade utility utlu101i.sql?
A. Resize redo log files to 4MB if they are smaller.
B. Create the SYSAUX tablespace.
C. Resize the SYSTEM tablespace.
D. Suggest the size for the PGA_AGGREGATE_TARGET parameter.

---
Ans: D.
The preupgrade information utility - utlu101i.sql - does not make any database changes; it advises you on what parameters need to be changed and tablespaces that need more space for a successful database upgrade. This utility is run on the database environment that needs the upgrade. When upgrading the database manually, you must perform all the suggestion by the utlu101i.sql before performing the upgrade. If you're using DBUA to upgrade, it will take care of all these changes.


13. Which two options are not true with the STARTUP UPGRADE mode instance startup?
A. Prepares the database for upgrade; no need to run any special script.
B. Suppresses spurious and unnecessary error messages, especially the ORA-00942.
C. Handles certain system startup parameters that could interfere with the upgrade.
D. This option is more of a documentation purpose when the database is started for upgrade; its functionality is no different from the default STARTUP option.

---
Ans: A, D.

STARTUP UPGRADE is the only way you can bring up an instance of Oracle 10g database prior to upgrading a database. You still need to upgrade the database using the upgrade scripts after creating the SYSAUX tablespace. Though the STARTUP UPGRADE option prepares the database for upgrade, you still need to run the database upgrade script based on the release of the database. This option suppresses ORA-00942 error messages and disables certain startup parameters.
A, D.


14. When you click the Restore button on the Upgrade Results page, which options must be true to perform a complete restore?
A. The database upgraded from 9.2.0 to Oracle 10g.
B. The database must be backed up using the DBUA.
C. The COMPATIBLE parameter value must be 9.2.0.
D. You must have backed up the database prior to upgrading.

----
Ans: B.
DBUA performs a restore from the backup it created prior to upgrade, and it restores the database files and configuration files from the backup location. If the backup is performed by you, the DBUA only restores the database settings—data files are not restored.

15. Which product option installed from the Oracle 10g Companion CD must be installed in an Oracle home directory with database software installation?
A. JPublisher
B. HTML DB
C. HTTP Server
D. None

---
Ans: A.
JPublisher, was well as Legato Single Server Version, Java libraries, and other products, must be installed in the same Oracle home directory as the database software. HTTP Server must be installed in a separate Oracle home directory, and HTML DB must be installed in the same Oracle home directory as HTTP Server.

16. Which of the following database options must be upgraded after upgrading the database to Oracle 10g?
A. JServer Java Virtual Machine
B. Oracle Real Application Clusters
C. Oracle XML Database
D. All of the above
E. None of the above

---
Ans: E.
Oracle 10g has a very simplified upgrade process, which determines all the components of the database to be upgraded and automatically upgrades them. Oracle uses DBMS_REGISTRY to identify the components to be upgraded.


17. When creating a database to Oracle 10g, what is the minimum size for the redo log files?
A. 40KB
B. 4MB
C. 50MB
D. 100MB

---
Ans: B.
The minimum size of redo log file in Oracle 10g is 4MB. When creating a new database, the default is 50MB. If you're using OMF, the default is 100MB.
C.


18. Which component is used by Oracle to identify the options that need to be upgraded while upgrading a database to Oracle 10g?
A. V$OPTION
B. V$LICENSE
C. DBMS_REGISTRY
D. DBMS_OPTIONS

---
Ans: C.
Oracle uses DBMS_REGISTRY to keep the status of components loaded to the database. You can query DBA_REGISTRY to see all the components and their status. It also provides the schema owner of the component and the script to run if a component is invalid.


19. When you choose to create a Transaction Processing database while installing Oracle software, which of the following statements is most appropriate?
A. The OUI will invoke the DBCA in an interactive mode, where you enter more information about the database and data files.
B. The OUI will not invoke the DBCA; the OUI collects all the information to create the database and creates the database.
C. The OUI will invoke DBCA in a noninteractive mode to create the database.
D. Irrespective of the type of database, the OUI always invokes DBCA in noninteractive mode.

---
Ans: C.

When installing database software, you are given choice to create four types of databases: General Purpose, Data Warehouse, Transaction Processing, and Advanced. If you choose Advanced, the OUI invokes the DBCA in an interactive mode, where more information about the database is obtained by the DBCA. For the other three choices, OUI invokes DBCA in noninteractive mode to create the database; OUI gets the necessary information for database creation.

20. Before manually upgrading an Oracle 8i 8.1.7 database, which of the following would be the appropriate value of COMPATIBLE parameter? (Choose two.)
A. 8.1.7.
B. 9.2.0.
C. Any value between 8.1.7 and 10.1.0.
D. Leave the COMPATIBLE parameter's default value.

----
Ans: B, D.

The minimum COMPATIBLE value for Oracle 10g database is 9.2.0. You can set this value to 9.2.0 or 10.0.0 prior to upgrading the database (that is, prior to starting the instance in Oracle 10g). The default value of COMPATIBLE parameter in 10g is 10.0.0.