Explain issues for database performance.

997

what are the differences between an exclusive lock and a shared lock?

1058

What are the limitations of rdbms?

1015

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?

2172

How do you set a primary key?

1074

How to stop superserver service on linux using only firebird tools?

1148

When would you use a database?

973

What is compound key?

998

What do you understand by data independence?

1172

Name two utilities that oracle provides, which are use for backup and recovery.

943

What is the quickest sorting method to use?

1125

Enlist some commands of ddl, dml, and dcl.

1034

Is it good to save image in database?

1079

What are database modules?

976

What is the difference between indexes,views,synonyms?

1193