114.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?
A.It must be made up of a database name and a domain name.
B.It must be made up of the value in ORACLE_SID and HOSTNAME.
C.It must be made up of the value that you plan to assign for INSTANACE_NAME and HOSTNAME.
D.It must be made up of the value that you plan to assign for ORACLE_SID and SERVICE_NAMES.
答案:A
解析:
1.Global Database Name
The full database name that uniquely distinguishes it from any other database in your network domain.
For example:
sales.us.example.com
where sales is the name you want to call your database and us.example.com is the network domain in which the database is located.
2.GLOBAL_NAMES
GLOBAL_NAMES specifies whether a database link is required to have the same name as the database to which it connects.
它的功能主要是限制dblink的,大概意思就是
如果A通过dblinke连接B,并且A上的global_names参数设置为true的话,那么dblinke的名字必须与B上面的global_name名字相同,
如果想创建多个dblink那么可以在名字后面增加@...,这样就可以创建多个了
SQL> show parameter global_names
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
global_names boolean FALSE
SQL> select * from global_name;
GLOBAL_NAME
--------------------------------------------------------------------------------
WAHAHA3
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?
A.It must be made up of a database name and a domain name.
B.It must be made up of the value in ORACLE_SID and HOSTNAME.
C.It must be made up of the value that you plan to assign for INSTANACE_NAME and HOSTNAME.
D.It must be made up of the value that you plan to assign for ORACLE_SID and SERVICE_NAMES.
答案:A
解析:
1.Global Database Name
The full database name that uniquely distinguishes it from any other database in your network domain.
For example:
sales.us.example.com
where sales is the name you want to call your database and us.example.com is the network domain in which the database is located.
2.GLOBAL_NAMES
GLOBAL_NAMES specifies whether a database link is required to have the same name as the database to which it connects.
它的功能主要是限制dblink的,大概意思就是
如果A通过dblinke连接B,并且A上的global_names参数设置为true的话,那么dblinke的名字必须与B上面的global_name名字相同,
如果想创建多个dblink那么可以在名字后面增加@...,这样就可以创建多个了
SQL> show parameter global_names
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
global_names boolean FALSE
SQL> select * from global_name;
GLOBAL_NAME
--------------------------------------------------------------------------------
WAHAHA3