when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
how can you communicate with operating system files from oracle?
What is fill factor? : sql server DBA
What is a correlated sub-query? : sql server DBA
What is the difference between dropping a database and taking a database offline? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
What are statistics, under what circumstances they go out of date, how do you update them?
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
Why would you call update statistics? : sql server DBA
how can you get actual data change values from previous transactions in oracle?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
how can you schedule a job in database?
Can you redefine a table online?
What authentication modes does sql server support? : sql server DBA