Explain the use of setting GLOBAL_NAMES equal to TRUE.
Answer / guest
While this variable does not directly store a value that
you can identify your database with, it does dictate how
you might connect to a remote database. This variable is
either TRUE or FALSE and if it is set to TRUE it enforces
database links to have the same name as the remote database
to which they are linking.
Regards
Abhinav Phadnis
Is This Answer Correct ? | 5 Yes | 0 No |
what is the differnce between process and thread ?
Why would you use sql agent? : sql server DBA
Explain the use of table functions.
what are the benefits of flashback feature?
You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
what is the difference between hot backup n rman backup?
What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?
What are the new features in sql server 2005 when compared to sql server 2000? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.