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 |
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
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
How can you rebuild an index?
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?
An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?
Name three advisory statistics you can collect.
I lost one datafile i dont have backup how can you recover that???
What the different topologies in which replication can be configured? : sql server DBA
How would you determine what sessions are connected and what resources they are waiting for?
Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
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)