Database Management Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

Database Management Interview Questions

Questions Answers Views Company eMail

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

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 4482

Suppose database is running slow, what will you do?

2570

what is scan listener.

2290

how to restore particular schema from rman full backup?

HCL,

1812

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?

HCL,

1 3187

how to solve cardinality in dbms...many to many ralationships

1769

All questions related to Control m monitoring tool

HCL, TY,

2603

For each user who needs access, the DBA creates an account in which database?

1304

Define view, sequence and index in DBMS.

HAL,

993

Discuss transparent DBMS?

Ernst Young,

1252

Explain top-n analysis in DBMS.

ITC Indian Tobacco Company,

1655

In DBMS, what are the two integrity rules used?

TCS,

997

State three differences between Dbms and Rdbms?

BirlaSoft,

1121

What are the properties of a primary key in DBMS?

HAL, Honeywell, Zomato,

1004

Post New Database Management Questions

Un-Answered Questions { Database Management }

What are the different technologies used to access Database from Visual Basic?

1013

what are database files, control files and log files. How many of these files should a database have at least? Why?

915

Is there an example how to configure externalfileaccess setting in firebird.conf?

1008

What is dba in dbms?

1148

Explain 5nf?

988

What is building blocks of client/server?

1180

Is driver a software?

895

List few restrictions that are imposed while creating views?

923

What is sonicmq?

956

How to get a book from database MS access that contain 'i' charactor in it's name like internetbook or networkingbook. what will be java query for this purpose?

1045

Is there a database program for mac?

989

What is database definition (dbd)?

1039

Describe concurrency control.

1111

What is database implementation?

979

What is 3nf in dbms?

955

For More Un-Answered { Database Management } Questions Click Here