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

What background process refreshes materialized views?

any body know about orawaves do they really provide placements in their unique placement program

how will u see whether the dabase is in archive log mode or not?

How would you determine who has added a row to a table?

What are the steps you will take to improve performance of a poor performing query?

What are the ways tablespaces can be managed and how do they differ?

what are the benefits of flashback feature?

How would you determine what sessions are connected and what resources they are waiting for?

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

Give two methods you could use to determine what DDL changes have been made.

What are the different ways of moving data or databases between servers and databases in SQL Server?

What are the different types of database compression introduced in sql server 2008? : sql server DBA

For more DB Administration Interview Questions Click Here