How can we know the exact updation date of a particular
database?
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / guest
Schdule a job for required database.
Every day it will give the job history.
| Is This Answer Correct ? | 5 Yes | 5 No |
What is dcl? : sql server DBA
who owns the operating system files created by the utl_file package?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
How would you go about increasing the buffer cache hit ratio?
Give two examples of how you might determine the structure of the table DEPT.
Which dictionary tables and/or views would you look at to diagnose a locking issue?
what do you understand by fine-grained auditing?
What command would you use to create a backup control file?
Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog
CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva
now one user in online.now i want drop him..how do u drop him?
How would you go about verifying the network name that the local_listener is currently using?
Oracle (3253)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)