Explain the advantages and disadvantages of a hierarchical database?
What's the difference between delete and truncate ?
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?
What are procedures in database?
Explain, why is rdbms better than dbms?
Define database lock?
Give us a non-computer example of preemptive and non-preemptive scheduling?
With DTS packaging I can store tables in Excel and convert them back to SQL. But once I copied tables to Excel I want to modify some info. How you do that without editing the Excel file?
What is 1nf 2nf 3nf in dbms?
Explain a database server?
What is meant by database server?
In which format image is stored in database?
how you will identify the mapping level bottleneck ? if there is a mapping level bottleneck then how will you try to improve the mapping