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?1270
You 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 2381
how to restore particular schema from rman full backup?
user 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?
Define view, sequence and index in DBMS.
Discuss transparent DBMS?198
Explain top-n analysis in DBMS.213
In DBMS, what are the two integrity rules used?
State three differences between Dbms and Rdbms?163
What is data types in database?
Enlist the disadvantages of query.
What is the purpose of a model?
What are collection pools? What are the advantages?
What do you understand by functional dependency?
Define join types.
What do you understand by index hunting?
dear sir please provide what question will be asked in bank it officer interview
What are the different types of database?
What is difference between database and spreadsheet?
Explain what are the types of transparencies?
Where is database stored?
What is the type of image in database?
What are the 5 databases?
What is data sublanguage?