|
INTERVIEW QUESTIONS
ORACLE
ORACLE ARCHITECTURE
DETAILS
Question: what is the difference between SID and Global Database Name ?
Answer: SID (System Identifier) : A SID (almost) uniquely identifies an instance. Actually, $ORACLE_HOME, $ORACLE_SID and $HOSTNAME identify an instance uniquely. The SID is 64 characters, or less; at least on Oracle 9i. The system identifier is included in the CONNECT_DATA parts of the connect descriptors in a tnsnames.ora file. The SID defaults to the database name.
Global Database Name : A database is uniquely identified by a global database name. Usually, a global database name has the form somename.domain. The global database name is the composit of db_domain and db_name.
|
|
|
Category |
Oracle Architecture Interview Questions & Answers -
Exam Mode /
Learning Mode
|
Rating |
(0.2) By 9369 users |
Added on |
8/27/2014 |
Views |
67427 |
Rate it! |
|
|
Question:
what is the difference between SID and Global Database Name ?
Answer:
SID (System Identifier) : A SID (almost) uniquely identifies an instance. Actually, $ORACLE_HOME, $ORACLE_SID and $HOSTNAME identify an instance uniquely. The SID is 64 characters, or less; at least on Oracle 9i. The system identifier is included in the CONNECT_DATA parts of the connect descriptors in a tnsnames.ora file. The SID defaults to the database name.
Global Database Name : A database is uniquely identified by a global database name. Usually, a global database name has the form somename.domain. The global database name is the composit of db_domain and db_name.
Source: CoolInterview.com
If you have the better answer, then send it to us. We will display your answer after the approval.
Rules to Post Answers in CoolInterview.com:-
- There should not be any Spelling Mistakes.
- There should not be any Gramatical Errors.
- Answers must not contain any bad words.
- Answers should not be the repeat of same answer, already approved.
- Answer should be complete in itself.
|
|
Related Questions |
View Answer |
|
Explain in brief oracle database objects.
|
View Answer
|
|
SGA definition files
|
View Answer
|
|
Explain the types of data files used by the oracle RDBMS.
|
View Answer
|
|
Explain the areas of memory used by oracle, i.e. Software code area, system global area (SGA), program global area(PGA), sort area.
|
View Answer
|
|
What are the Back ground processes in Oracle?
|
View Answer
|
|
Explain the categories of oracle processes i.e. user, data writing processes, logging processes and monitoring processes.
|
View Answer
|
|
Physical database structure
|
View Answer
|
|
What is the physical and logical structure of oracle?
|
View Answer
|
|
Explain the methods provided by SQL Loader.
|
View Answer
|
|
What is SQL Loader? Explain the files used by SQL Loader to load file. i.e Loader control file, Input datafile, Log File, Bad File, Discard file
|
View Answer
|
|
Explain SGA memory structures: Shared Pool, Database buffer Cache, Redo log Cache, Large Pool Java Pool.
|
View Answer
|
|
Explain different types of segment. Data segment, Index segment, Rollback segment and temporary segment.
|
View Answer
|
|
What is the function of SMON?
|
View Answer
|
|
Describe Oracle architecture in brief.
|
View Answer
|
|
What is the differnece between materialized view and snapshot
|
View Answer
|
|
What are the Large object types supported by Oracle?
|
View Answer
|
|
What is the diff b/w BTREE INDEX and BITMAP INDEX
|
View Answer
|
Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.
View All Oracle Architecture Interview Questions & Answers - Exam Mode /
Learning Mode
|