Interested to Buy Any Domain ? << Click Here >> for more details...
how will you see when the database was started using sql prompt?
- 2 Answers
- 6487 Views
- IBM, I also Faced
- E-Mail Answers
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
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
how can you schedule a job in database?
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What are the recovery models for a database? : sql server DBA
What are the commands used in dcl? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
What are statistics, under what circumstances they go out of date, how do you update them?
suppose you want to audit specific activities on sensitive data. How can you achieve that?
how can you process messages in order asynchronously?
What is the difference between dropping a database and taking a database offline? : sql server DBA
Where do you find the default index fill factor and how to change it? : sql server DBA
How do you trace the traffic hitting a sql server? : sql server DBA
What are the different ways you can create databases in sql server? : sql server DBA
What are the different types of database compression introduced in sql server 2008? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
