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 |
hi, suppose i created one table after few days i did some insert,update how can i know when will i did ddl or dml operation is undergone on that table
what is ora 600?
What are the different sql server versions you have worked on? : sql server DBA
What type of index should you use on a fact table?
Explain the difference between a hot backup and a cold backup and the benefits associated with each?
What command would you use to encrypt a PL/SQL application?
What is database replicaion? What are the different types of replication you can set up in SQL Server?
What are statistics, under what circumstances they go out of date, how do you update them?
Give two examples of referential integrity constraints.
What happens on checkpoint? : sql server DBA
who owns the operating system files created by the utl_file package?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
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)