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?

1688

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 3113

Suppose database is running slow, what will you do?

2064

what is scan listener.

1787

how to restore particular schema from rman full backup?

HCL,

1279

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 2388

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

1254

All questions related to Control m monitoring tool

HCL, TY,

1994

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

557

Define view, sequence and index in DBMS.

HAL,

548

Discuss transparent DBMS?

Ernst Young,

738

Explain top-n analysis in DBMS.

ITC Indian Tobacco Company,

1018

In DBMS, what are the two integrity rules used?

TCS,

524

State three differences between Dbms and Rdbms?

BirlaSoft,

541

What are the properties of a primary key in DBMS?

HAL, Honeywell, Zomato,

497


Post New Database Management Questions

Un-Answered Questions { Database Management }

Explain by listing some major advantages of dbms.

429


i have a web page and in this page i create 3 textbax and a "summit" button do you have any html code for add text velue in my web page like link summation(form) sites.

1409


Why do we need database management?

470


Define database system.

543


What are the disadvantages of file processing systems?

461






What do you understand by cursor?

476


Does google have a database program?

468


Explain atomicity and aggregation?

550


Explain the terms ‘attribute’ and ‘relations’

649


What is the biggest advantage of rdbms?

497


How do I create a database in access 2010?

463


What is the role of database server in database management system?

428


How do I convert a spreadsheet to a database?

443


What is sorting in dbms?

492


What is default value database?

476