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 |
can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com
Can you redefine a table online?
wat is global index and local indes
how do see how much space is used and free in a tablespace
What's the benefit of "dbms_stats" over "analyze"?
What is database replicaion? What are the different types of replication you can set up in SQL Server?
What is the difference between dropping a database and taking a database offline? : sql server DBA
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
why we use cursors
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
what is the purpose of catlaog in oracle rman?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)