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
What are the commands you'd issue to show the explain plan for "select * from dual"?
In what script is "snap$" created? In what script is the "scott/tiger" schema created?
How can you control the amount of free space in your index pages? : sql server DBA
What is the importance of a recovery model? : sql server DBA
What the different components in replication and what is their use? : sql server DBA
What is dbcc? : sql server DBA
What the different topologies in which replication can be configured? : sql server DBA
What are the commands used in dcl? : sql server DBA
what is grd?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
How would you go about verifying the network name that the local_listener is currently using?
You create a private database link and upon
connection, fails with: ORA-2085: connects to
how can you generate profile of pl/sql applications to identify performance bottlenecks?
Due to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down? : sql server DBA
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.