Name two files used for network connection to a database.
Answer Posted / guest
listener and tnsname
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
Explain materialized views and how they are used.
What are the commands used in dcl? : sql server DBA
internal architecture
How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
how can you create a user-defined lock?
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.
What the different components in replication and what is their use? : sql server DBA
how can you find out if a table can be redefined?
What is the importance of a recovery model? : sql server DBA
What are statistics, under what circumstances they go out of date, how do you update them?
what is the diffrence between core dba and apps dba?
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.