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
How to start SQL Server in minimal configuration mode?
What authentication modes does sql server support? : sql server DBA
What are the steps you will take to improve performance of a poor performing query?
Explain materialized views and how they are used.
What are statistics, under what circumstances they go out of date, how do you update them?
What the different components in replication and what is their use? : sql server DBA
how can you record information about current session?
what are the benefits of flashback feature?
What is dcl? : sql server DBA
How can you control the amount of free space in your index pages? : sql server 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.
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
what is the last version,the release date of that version and fix pack of ibm db2 udb?
Why would you use sql agent? : sql server DBA
What are the commands used in dcl? : sql server DBA