how will you see when the database was started using sql prompt?
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
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
how can you create a user-defined lock?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
Why would you call update statistics? : sql server DBA
How would you best determine why your MVIEW couldn't FAST REFRESH?
What are the recovery models for a database? : sql server DBA
how does an oracle clusterware manage crs resources?
what is a crs resource?
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
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.
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA