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

Question Posted / pvenkiroyal

2 Answers
6622 Views
IBM, I also Faced
E-Mail Answers

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

Post New Answer

More DB Administration Interview Questions

Name three advisory statistics you can collect.

1 Answers

You have just had to restore from backup and do not have any control files. How would you go about bringing up this database?

3 Answers

internal architecture

0 Answers CSC,

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

0 Answers

what is a crs resource?

0 Answers Oracle,

Which types of backups you can take in Oracle? 2. A database is running in NOARCHIVELOG mode then which type of backups you can take? 3. Can you take partial backups if the Database is running in NOARCHIVELOG mode?

1 Answers

What's the benefit of "dbms_stats" over "analyze"?

1 Answers

What is RAID and what are different types of RAID configurations?

1 Answers

What command would you use to encrypt a PL/SQL application?

1 Answers

What is the difference between LMT & DLT?

1 Answers CTS,

what is the use of home directory???

1 Answers HP,

WHERE CAN WE SEE THE COMPLETE BACKBROUNG PROCESS IN RAC ENVIRONMENT THROUGH UNIX COMMAND.

2 Answers Cognizant,

For more DB Administration Interview Questions Click Here