Interested to Buy Any Domain ? << Click Here >> for more details...
how will you see when the database was started using sql prompt?
- 2 Answers
- 6606 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / pvenkiroyal
select to_char(startup_time,'hh24:mi:ss dd-mom-yy') from
v$instance;
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
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
what do you understand by flashback feature of oracle?
What is dbcc? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
What is the difference between dropping a database and taking a database offline? : sql server DBA
How to start SQL Server in minimal configuration mode?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Why would you call update statistics? : sql server DBA
What the different topologies in which replication can be configured? : sql server DBA
What are the steps you will take to improve performance of a poor performing query?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : 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.
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
What would you do with an "in-doubt" distributed transaction?
