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

deleted of control file how will u recover control file?

what do you understand by fine-grained auditing?

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

What query tells you how much space a tablespace named "test" is taking up, and how much space is remaining?

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

What does coalescing a tablespace do?

how to restore files with rman?

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

Is it possible to update the multiple field values in a single query? If possible then write the actual query.

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

How many packages we have in db

What the different topologies in which replication can be configured? : sql server DBA

For more DB Administration Interview Questions Click Here