Tips 3

Q.
While installing the Oracle10g database on a UNIX platform you are prompted to run the script file orainstRoot.sh, which creates another file oraInst.loc.
For which purpose is the newly created oraInst.loc file used?

• It is used to set the UNIX kernel parameters for the Oracle database.

• It is used to store information about the users accessing the Oracle database.

• It is used by Oracle Universal Installer at startup to find the inventory location.

• It is used by Oracle Universal Installer to store the home directory and base directory locations.

Answer:
It is used by Oracle Universal Installer at startup to find the inventory location.

Explanation:
The orainstRoot.sh script file creates the inventory pointer file, oraInst.loc, which is used by Oracle Universal Installer at startup to find the inventory location.

The oraInst.loc file is not used to set the UNIX kernel parameters for the Oracle database. The UNIX kernel parameters for the Oracle database are set in the /etc/system file on a UNIX system.

The oraInst.loc file is not used to store information about the users accessing the Oracle database. Information about the users accessing the Oracle database is present in the data dictionary.

The oraInst.loc file is not used by Oracle Universal Installer to store the home directory and base directory locations. No particular file stores the home directory and base directory. These are specified by environment variables.

Q
While installing the Oracle 10g database using OUI, which file storage option will provide you with additional features such as
mirroring and stripping?

• File System
• Raw Devices
• Oracle-Managed Files
• Automatic Storage Management

Answer:
Automatic Storage Management

Explanation:
The Automatic Storage Management (ASM) file storage option is a new feature introduced in Oracle 10g for automatically managing the Oracle database files. The ASM file storage option also supports features such as mirroring and stripping.

The File System storage option does not support mirroring and stripping. Instead, this storage option only supports storage of the Oracle database files in the operating system file system.

The Raw Devices storage option does not support mirroring and stripping. Raw devices are disk partitions that do not have a file system.

Oracle-Managed Files is not a valid storage option when installing with OUI. Oracle-Managed Files is a feature supported by Oracle to automatically manage the Oracle database files. However, Oracle-managed files do not support mirroring and stripping.


Q
You want to use the Oracle-Managed Files feature to minimize file management and provide efficient storage for your Oracle database.
Which two initialization parameters are used to configure to use the Oracle-Managed Files feature? (Choose two.)

• DB_NAME
• INSTANCE_NAME
• DB_CREATE_FILE_DEST
• DB_RECOVERY_FILE_DEST
• DB_CREATE_ONLINE_LOG_DEST_n

Answer:
DB_CREATE_FILE_DEST
DB_CREATE_ONLINE_LOG_DEST_n

Explanation:
The DB_CREATE_FILE_DEST and DB_CREATE_ONLINE_LOG_DEST_n initialization parameters are used to configure your database to use the Oracle-Managed Files feature. The DB_CREATE_FILE_DEST initialization parameter specifies the destination for storage of the Oracle datafiles that are created. The DB_CREATE_ONLINE_LOG_DEST_n initialization parameter specifies the destination for storage of the Oracle redo log files and control files.

The DB_NAME initialization parameter specifies only the name of the Oracle database and does not need to be changed or configured to use the Oracle-Managed Files feature.

The INSTANCE_NAME initialization parameter specifies only the name of the Oracle database instance and does not need to be changed or configured to use the Oracle-Managed Files feature.


Q.

While installing the Oracle 10g database, you have set the NLS_LANG environment variable to
AMERICAN_AMERICA.WE8IS08859P1.
What will be the default date format assigned to the Oracle 10g database?

• DDMMYY
• DD-MM-YY
• DD-MON-YY
• DD-MONTH-YYYY

Answer:
DD-MON-YY

Explanation:
The default date format assigned to the Oracle 10g database will be DD-MON-YY. The NLS_LANG environment variable specifies the language, territory, and character set supported by the user sessions in an Oracle 10g database. The format to specify NLS_LANG is _.. The portion specifies the default date
format, numeric formats, and monetary formats. In this scenario, the value for is set to AMERICA, which signifies that the date format, numeric formats, and monetary format will be according to the American territorial region. Therefore, the default date format assigned to the Oracle 10g database will be DD-MON-YY.

All the other options are incorrect because DDMMYY, DD-MM-YY, and DD-MONTH-YYYY are not default date formats for the given territory that is assigned the value AMERICA.

6