ORACLE INTERVIEW QUESTIONS

Posted Date: 11 Mar 2008 Resource Type: Articles/Knowledge Sharing Category: Placement Papers

Posted By: ramya Member Level: Gold
Rating:

Points: 3

1. What is Database Link ?

2. What are the types of Database Links ?

3. What is Private Database Link ?

4. What is Public Database Link ?

5. What is Network Database link ?

6. What is Data Block ?

7. How to define Data Block size ?

Answers

1. A database link is a named object that describes a "path" from one database to another.

2.Private Database Link, Public Database Link & Network Database Link.

3.Private database link is created on behalf of a specific user. A private database link can be used only when the owner of the link specifies a global object name in a SQL statement or in the definition of the owner's views or procedures.

4.Public database link is created for the special user group PUBLIC. A public database link can be used when any user in the associated database specifies a global object name in a SQL statement or object definition.

5.Network database link is created and managed by a network domain service. A network database link can be used when any user of any database in the network specifies a global object name in a SQL statement or object definition.

6.ORACLE database's data is stored in data blocks. One data block corresponds to a specific number of bytes of physical database space on disk.

7. A data block size is specified for each ORACLE database when the database is created. A database users and allocated free database space in ORACLE datablocks. Block size is specified in INIT.ORA file and cann't be changed latter.

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

(No tags found.)

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: SAP Interview Questions
	Previous Resource: 5 common PHP database Problems
	Return to Discussion Resource Index
	Post New Resource
	Category: Placement Papers

Post resources and earn money!

Related Resources

Fresher Jobs

Resources

Colleges

ORACLE INTERVIEW QUESTIONS

Responses

Post Feedback