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

Tips 2 (Question 2)

Your Oracle server has four databases SALESDB, FINDB, HRDB, and TESTDB installed on it. The SALESDB database is currently running. You set the ORACLE_SID environment variable on the operating system as follows:
C:\> SET ORACLE_SID=TESTDB

Then, you try to start the TESTDB database from another SQL*Plus prompt using this command:

SQL> STARTUP;


What will be the result of this command?

• The command will start the TESTDB database without any alterations to the SALESDB database.

• The command will start the TESTDB database and shut down the already-running SALESDB database.

• This command will return an Oracle already running, shut it down first error.

• The command will not start the TESTDB database because the assignment of the ORACLE_SID environment variable is incorrect, and you must specify the specific parameter file when issuing the STARTUP command.
  

Explanation:
The command will start the TESTDB database without any alterations to the SALESDB database. Setting the ORACLE_SID environment variable specifies the instance name for the database that is to be started. In this scenario, because there are four
databases on the same server you should specify the instance name that is to be started using the ORACLE_SID environment
variable. Setting this variable will not affect the instances that are already up and running.

The option stating that the command will start the TESTDB database and shut down the already-running SALESDB instance is
incorrect because the SALESDB instance will not shut down as a result of the STARTUP command.

The option stating that the command will return an error is incorrect because the error is generated only if you have not specified the instance name by setting the ORACLE_SID environment variable. If this variable is specified, this error will not be
generated.

The option stating that the command will not start the TESTDB database because the assignment of the ORACLE_SID variable is incorrect because the variable is set appropriately in this scenario. Additionally, it is not necessary to specify the specific
parameter file when issuing the STARTUP command. If no parameter file is specified, the default SPFILE will be used, if the SPFILE is not available, the default PFILE will be used to start the database.

Oracle Installation

Tips 1 (Question):

You are in the process of installing Oracle Database 10g on your client computer. You have set the value for environment variable ORACLE_HOME to /oracle/ora10g.
what does it Mean?

• The directory location for the base of OFA

• The directory location where the Oracle software is installed

• The directory location where the script files of the database are stored

• The directory location where the operating system searches for Oracle executables, such as SQL*Plus

Explanation:
The ORACLE_HOME environment variable specifies the directory location where the Oracle software is installed. In this scenario, /oracle/ora10g is the directory where the Oracle software is installed.

The ORACLE_HOME environment variable does not specify the directory location for the base of OFA. The ORACLE_BASE environment variable specifies the directory location for the base of OFA.

The ORACLE_HOME environment variable does not specify the directory where the script files of the database are stored.
The % ORACLE_HOME%/rdbms/admin/ directory specifies the location where the script files of the database are stored.

The ORACLE_HOME environment variable does not specify the directory location where the operating system searches for Oracle executables, such as SQL*Plus. The directory where the operating system searches for Oracle executables is specified
using the PATH environment variable.