Oracle DBA Interview Question and Answers

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.
 
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.
 
Your Name Your Email-ID
Your Answer
27. What is EXECUTE IMMEDIATE?
 
  • EXECUTE IMMEDIATE is a statement required to process most dynamic SQL statements.
 
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.
 
Your Name Your Email-ID
Your Answer
12345678910 Page 8 of 10