How can we know the exact updation date of a particular
database?
Answer Posted / pavana kumar.s
Just query the registry$history view in oracle to view the las t exact date of update.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Can you redefine a table online?
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
How do you open a cluster administrator? : sql server DBA
What the different types of replication and why are they used? : sql server DBA
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
Why would you use sql agent? : sql server DBA
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.
how can you initialize log miner?
What is the default port no on which sql server listens? : sql server DBA
What are the steps you will take to improve performance of a poor performing query?
How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?
When setting replication, can you have distributor on sql server 2005, publisher on sql server 2008? : sql server DBA
what are the performance views in an oracle rac environment?