· 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.

2 Item: 2 (Ref:1Z0-042.1.4.3)

2.1 Question

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?

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

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

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

nmlkThe 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.

2.2 Anwser

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

2.3 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.

3 Item: 3 (Ref:1Z0-042.1.3.1)

3.1 Question

Which three statements correctly describe the Manage Templates option available with DBCA? (Choose three.)

gfedIt allows you to create a template based on another template.

gfedIt allows you to create a database with a structure similar to an existing database.

gfedIt allows you to create a template that contains only the data of an existing database.

gfedIt allows you to create a template based on all the tablespaces of an existing database.

gfedIt allows you to create a template that contains only the structure of an existing database.

gfedIt allows you to create a template that contains the data as well as structure of an existing database

3.2 Anwser

· It allows you to create a template based on another template.

· It allows you to create a template that contains only the structure of an existing database.

· It allows you to create a template that contains the data as well as structure of an existing database.

3.3 Explanation

The Manage Templates option available with DBCA allows you to:

Create a template based on another template.
Create a template that contains only the structure of the database.
Create a template that contains the data as well as structure of the database.

The Manage Templates option in DBCA is accessed on the Operations page in DBCA. DBCA

files, when creating databases. Each template can include database options, and other specifics

initialization parameters. Using these templates makes it easier to create and clone databases.

Using the Manage Templates option in DBCA, you cannot create a database. It can only existing template or an existing database. This template can then be used to create the database.

Using the Manage Templates option in DBCA, you cannot create a template that contains database. You can create a template that contains the data as well as structure of an existing

Using the Manage Templates option in DBCA, you cannot create a template based on all database. A template based on tablespaces in an existing database cannot be created.

4 Item: 4 (Ref:1Z0-042.2.4.3)

4.1 Question

You are required to create a new database using DBCA. The database is required to store historical data pertaining to the last 20 years for a multinational bank. This data is generally accessed to create reports needed in different quarters of the year. In addition, new data is inserted into the database at the end of every month.

Considering these requirements, which template would be the best template to use to create the database?

nmlkData Warehouse

nmlkGeneral Purpose

nmlkCustom Database

nmlkTransaction Processing

4.2 Anwser

Data Warehouse

4.3 Explanation

· In this scenario, it would be best to use the Data Warehouse template because you have a large volume of historical data. This historical data is typically read-only and used generally to produce reports.

· The General Purpose template can be used to create this database, but because the data specifically matches the requirements of a data warehouse, you should use the Data Warehouse template to create the database. The General Purpose template combines features of the Data Warehouse and Transaction Processing templates and is usually used when you are creating a database for which you are not sure of the kind of data that will be stored.

· The Custom Database template can be used to create this database, but because the data specifically matches the requirements of a data warehouse, you should use the Data Warehouse template. The Custom Database template is generally used for scenarios that are more complex. Using the Custom Database template, you can explicitly define the options for the structure of the database that is to be created.

· The Transaction Processing template is generally used in situations where the number of concurrent users is higher and the data is accessed and updated more often, such as OLTP systems.

5 Item: 5 (Ref:1Z0-042.2.3.2)

5.1 Question

You have installed Oracle Enterprise Manager 10g Database Control on your computer to manage your production database located on a remote host computer through a Web-enabled interface.

Which component is NOT a component of Oracle Enterprise Manager 10g Database Control?

nmlkOracle Management Agent

nmlkOracle Management Service

nmlkOracle Management Interface

nmlkOracle Management Repository

5.2 Anwser

Oracle Management Interface

5.3 Explanation

The Oracle Management Interface is not part of Oracle Enterprise Manager 10g Database Control. Oracle Enterprise Manager 10g Database Control consists of the following components:

· Oracle Management Agent

· Oracle Management Service

· Oracle Management Repository

All of the other options are incorrect because they are components of Oracle Enterprise Manager 10g Database Control.

6 Item: 6 (Ref:1Z0-042.2.4.2)

6.1 Question

You are creating a database using DBCA. Which options can be configured when creating a database using DBCA? (Choose all that apply.)

gfedcharacter sets

gfedmemory sizing

gfeddatabase block size

gfedconnection mode

gfedmaximum number of users in the database

gfeddefault profile allocation for users

6.2 Anwser

character sets

memory sizing

database block size

connection mode

6.3 Explanation

When creating a database using DBCA, you can configure the character sets to be used by the database, the memory sizing option, the database block size, and the connection mode used to connect to the server. When you create a database using DBCA and select the Create Database link on the DBCA Operations page, a wizard is started. One of the steps of the wizard allows you to set initialization parameter values for these, as well as other parameters. The character sets are specific to the territory of the database and language used by the database. The memory sizing option includes the distribution of physical memory into different components of the Oracle database. The block-sizing option configures the database block size to be used by the Oracle database that is being created. The connection mode configures which connection mode, shared server or dedicated server, will be used to connect to the server. DBCA can also be used to schedule database backups on a regular basis.

You cannot configure the maximum number of users in the database when using DBCA to create a database. However, the maximum number of users in the database can be configured at the database level by using the initialization parameter

LICENSE_MAX_USERS.

You cannot configure the default profile allocation for users when using DBCA to create a database. This is configured at the database level when users are created or by using the DEFAULT profile.

7 Item: 7 (Ref:1Z0-042.1.1.1)

7.1 Question

You are in the process of installing Oracle 10g on your host computer. Click the Exhibit(s) button to view the hardware composition of your host computer.

Which action should you take to successfully complete the installation of Oracle 10g on your computer?

nmlkIncrease the RAM on your computer to 512 MB.

nmlkIncrease the virtual memory on your computer to 1 GB.

nmlkIncrease the free hard disk space on your computer to a minimum of 2 GB.

nmlkIncrease the free hard disk space on your computer to a minimum of 1.5 GB.

nmlkIncrease the temporary disk space on your computer to a minimum of 200 MB.

7.2 Anwser

Increase the free hard disk space on your computer to a minimum of 1.5 GB.

7.3 Explanation

The minimum free hard disk space required for a successful installation of Oracle 10g is 1.5 GB. You need to increase the free hard disk space on your computer to a minimum of 1.5 GB.

You do not need to increase the RAM on your computer to 512 MB because the minimum amount of physical memory or RAM required for a successful installation of Oracle 10g is 256 MB. However, Oracle recommends that you use 512 MB of RAM for an Oracle 10g database.

You do not need to increase the virtual memory on your computer because the minimum amount of virtual memory required for a successful installation of Oracle 10g is twice the amount of RAM, which is 512 MB in this scenario.

You do not need to increase the free hard disk space on your computer to a minimum of 2 GB because the minimum amount of hard disk space required for a successful installation of Oracle 10g is 1.5 GB.

You do not need to increase the temporary disk space on your computer to a minimum of 200 MB because the minimum amount of temporary disk space required for a successful installation of Oracle 10g is 100 MB.

8 Item: 8 (Ref:1Z0-042.1.3.2)

8.1 Question

Your Oracle server is running on a Linux platform. You create a new database NEWDB on this server.

Which file is updated with the Oracle system identifiers (SIDs) when this new Oracle database, NEWDB, is created?

nmlkoratab

nmlkcrontab

nmlkcatexp.sql

nmlkorainstRoot.sh

8.2 Anwser

oratab

8.3 Explanation

The oratab file on a Linux platform is updated with the Oracle SIDs when a new Oracle database is created on the Linux platform. The path where the oratab file is located is /var/opt.

The crontab file on a Linux platform is used for scheduling jobs. This file is not updated with the Oracle SIDs when a new Oracle database is created on the Linux platform.

The catexp.sql file is a script file that creates data dictionary views in an Oracle database to support import and export activities in the Oracle database. This file is not updated with the Oracle SIDs when a new Oracle database is created on the Linux platform.

The orainstRoot.sh script file creates the inventory pointer file while installing the Oracle 10g database on a Linux platform.

This file is not updated with the Oracle SIDs when a new Oracle database is created on the Linux platform.

TrungNEMO 6:53 PM Tags : 9.1 OCP Real Examination

2 Comments

Anonymous August 1, 2008 at 8:22 PM

that's nice! thx bro..

Wisdom Tree Ventures November 4, 2020 at 4:32 AM

Social media optimisation offers an opportunity to generate new leads and grow your business. If you don't have time to create and manage your social media campaigns with the assistance of social media optimization company like Wisdom Tree Ventures. Their experts consistently optimise your best social media marketing campaigns to increase customer engagement. They offer a comprehensive plan that allows you to persistently optimise social media campaigns to nurture your business through digital media.

Tuesday, July 10, 2007

1Z0-042: Installing Oracle Database 10g Software