how will you see when the database was started using sql prompt?

Question Posted / pvenkiroyal

Answers were Sorted based on User's Feedback

how will you see when the database was started using sql prompt?..

Answer / pvenkiroyal

select to_char(startup_time,'hh24:mi:ss dd-mom-yy') from
v$instance;

Is This Answer Correct ?

7 Yes

0 No

how will you see when the database was started using sql prompt?..

Answer / mohapatra.gouranga@gmail.com

In RAC env.

select instance_name,status,host_name,to_char
(startup_time,'DD-MON-YY HH24:MI:SS')
from gv$instance order by instance_name;

Is This Answer Correct ?

1 Yes

0 No

More DB Administration Interview Questions

wat is global index and local indes

what are the types of connection load-balancing?

How do you trace the traffic hitting a sql server? : sql server DBA

why do we give pctfree and pctused in create table statement?

What are the different sql server versions you have worked on? : sql server DBA

What is the recommended interval at which to run statspack snapshots, and why?

If we issue alter database begin backup. What happens to database?

how can you schedule a job in database?

what is the difference between db2start command and start database manager command?

what is difference between user managed backup and rman backup?

Explain what partitioning is and what its benefit is.

what is the differnce between process and thread ?

For more DB Administration Interview Questions Click Here