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. | Page 1 of 9 __Installing Oracle Database 10g Software Item 1 Ref 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 this value specify j the directory location for the base of OFA j the directory location where the Oracle software is installed j the directory location where the script files of the database are stored j the directory location where the operating system searches for Oracle executables such as SQL Plus Answer the directory location where the Oracle software is installed 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. Copyright 2005 Self Test Software Inc. All Rights Reserved Page 2 of 9 Item 2 Ref 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 .
