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?
1699You 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 3135user 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 2404Post New Database Management Questions
What is the difference between delete and truncate command in dbms?
Enlist the advantages of normalizing database.
1.If we have a Salary coloumn in Staff entity with this description the salary must be monetary and >=$35450.00, how we can write it in into schemain SQL? 2. If we have Weight and Marks in Assessment entity and the Weight has the description of this it must be Non-zero percentage. And also the Marks attribute stores the maximum possible raw mark for assessment (e.g., 30), while Weight stores of the weight of this assessment for the paper as a whole (e.g., 10%). If Marks is not specified, then Weight is used for both. How we can convert this into schema in SQL????
What is normalization and what are the different types of normalization?
What are the functions of a database?
Explain a database server?
Which software is best for database?
Define scalar functions.
What is a functional dependency in the dbms?
What are indexes? What are b-trees?
What are the features of a database management system?
How to reorder the table columns (fields)?
Is sql a database?
What is a concurrency problem in dbms?
Describe the purposes and advantages stored procedure?
