a2zinterviews

25.	What is a database link?
	A database link is created to access a remote database from a local database. One requirement to create a database link is that the database server should be able to connect to the remote database. A private database link is available to the owner of the link while a public database link is available to all the users. A fixed user database link is available only to the user specified in the link.
	Discuss Your Name Your Email-ID Your Answer

26.	Explain the use of GLOBAL_NAMES setting?
	The GLOBAL_NAMES setting determines whether database link can be created with a different name rather than the remote database name. If the parameter is set to TRUE, then the database link must be created with the same name as remote database. If the parameter is set to FALSE, then the database link can be created with a different name. Oracle lets you create database link with different name even when the GLOBAL_NAMES is set to TRUE but the link cannot be used. You will receive the error ORA-02085, if you try to use a database link with different name when GLOBAL_NAMES is set to TRUE.
	Discuss Your Name Your Email-ID Your Answer

27.	What is EXECUTE IMMEDIATE?
	EXECUTE IMMEDIATE is a statement required to process most dynamic SQL statements.
	Discuss Your Name Your Email-ID Your Answer

28.	What is a profile?
	Profile means to limit resources a user can use. It can be created using the create profile ; statement. After a profile is created, it can be assigned to any user using the alter user statement.
	Discuss Your Name Your Email-ID Your Answer