There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how?
2122You loss one datafile and DB is running in ARCHIVELOG mode. You have full database backup of 1 week old and partial backup of this datafile which is just 1 day old. From which backup should you restore this file?
2 4336user says the db performance is slow or yesterday the query runned 1min and today its taking 30 min. how to trouble shot or were to start with?
HCL,
1 3095Post New Database Management Questions
What is difference between database and dbms?
What's the difference between delete and truncate ?
What is the structure of a database?
What is the e-r model?
what are the different integrity rules present in the dbms?
Differentiate nested loop, hash join and merge join.
What do you understand by database triggers?
How many number of columns can a RECORD GROUP have ?
dear sir please provide what question will be asked in bank it officer interview
Explain the term ‘relations’?
What are the different technologies used to access Database from Visual Basic?
Describe the difference between embedded and dynamic sql.
Mention the different types of cursor?
What is trigger in dbms?
How to load a file into database column?