nerdexam
Oracle

1Z0-052 · Question #186

You plan to implement the distributed database system in your company. You invoke Database Configuration Assistant (DBCA) to create a database on the server. During the installation, DBCA prompts…

The correct answer is A. It must be made up of a database name and a domain name. The Oracle Global Database Name uniquely identifies a database across a distributed network and is formed by combining the database name (DB_NAME) with a domain name (DB_DOMAIN).

Exploring the Oracle Database Architecture

Question

You plan to implement the distributed database system in your company. You invoke Database Configuration Assistant (DBCA) to create a database on the server. During the installation, DBCA prompts you to specify the Global Database Name. What must this name be made up of?

Options

  • AIt must be made up of a database name and a domain name.
  • BIt must be made up of the value in ORACLE_SID and HOSTNAME.
  • CIt must be made up of the value that you plan to assign for INSTANCE_NAME and HOSTNAME.
  • DIt must be made up of the value that you plan to assign for ORACLE_SID and SERVICE_NAMES.

How the community answered

(60 responses)
  • A
    88% (53)
  • B
    7% (4)
  • C
    3% (2)
  • D
    2% (1)

Why each option

The Oracle Global Database Name uniquely identifies a database across a distributed network and is formed by combining the database name (DB_NAME) with a domain name (DB_DOMAIN).

AIt must be made up of a database name and a domain name.Correct

The Global Database Name is constructed as DB_NAME.DB_DOMAIN (for example, orcl.us.example.com), providing a unique, network-wide identifier that distinguishes this database from all others in a distributed environment. DBCA uses these two components - the database name and domain name - to set the global_name parameter that distributed database links rely on.

BIt must be made up of the value in ORACLE_SID and HOSTNAME.

ORACLE_SID is an OS-level instance identifier and HOSTNAME is the server name; neither is a component used to form the logical Global Database Name.

CIt must be made up of the value that you plan to assign for INSTANCE_NAME and HOSTNAME.

INSTANCE_NAME identifies the Oracle instance process, not the database itself, and HOSTNAME is a network address, not a database naming component.

DIt must be made up of the value that you plan to assign for ORACLE_SID and SERVICE_NAMES.

SERVICE_NAMES is a parameter derived from the Global Database Name after it is set; it is a product of the global name, not a component used to construct it.

Concept tested: Oracle Global Database Name structure in distributed systems

Source: https://docs.oracle.com/cd/E11882_01/server.112/e40402/initparams071.htm

Topics

#Global Database Name#DBCA#database name#domain name

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 1Z0-052 Practice