how will you see when the database was started using sql prompt?
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
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
What the different types of replication and why are they used? : sql server DBA
Why would you use sql agent? : sql server DBA
What is transparent data encryption? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
what is grd?
i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?
What are the different sql server versions you have worked on? : sql server DBA
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What are the different types of upgrades that can be performed in sql server? : sql server DBA
how can you get actual data change values from previous transactions in oracle?
when does an alert gets signaled?
Where would you look for errors from the database engine?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
What view(s) do you use to associate a user's SQLPLUS session with his o/s process?