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?

2122

How to detect the server version?

1079

What is create database?

1008

What is database management system(dbms) and why it is used?

1013

What is the default '-sort' order for a sql?

901

What is the diff bet plan,package,dbrm?

1103

What is a key in database?

903

What is denormalization and why would someone consider doing so?

955

Tell us about some Dot operator queries?

1167

How many types of database language exist?

1043

What is the purpose of normalization in dbms?

1161

What does rdbms stand for?

1069

Explain meant by 3-tier architecture?

947

describe and contrast a trigger and a procedure.

1042

Can you explain the select into statement?

1024