Answer Posted / sweta
Dual is like a dummy table which contains 1 column and 1 row
in this.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is the importance of a recovery model? : sql server DBA
what is the use of ocr?
How would you extract DDL of a table without using a GUI tool?
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
internal architecture
What the different types of replication and why are they used? : sql server DBA
how can you schedule a job in database?
how can you process messages in order asynchronously?
what is the role of dip user in our database?
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
Why would you use sql agent? : sql server DBA
How would you go about verifying the network name that the local_listener is currently using?
Why would you call update statistics? : sql server DBA
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
how can you connect from 10g user to 11g user??