Q1 . What is physical data model?

Check Answer

SOLUTION

Physical data model can also be called the data base design that dictates the way in which the data would be stored physically in databases.for example using Oracle,DB2, SQL server etc

Q2 . What is an ER model?

Check Answer

SOLUTION

They are also called as Entity Relational models that depict the relation ship between data entities like one to one,many to one etc.

Q3 . what is a flat file database?

Check Answer

SOLUTION

They are databases with data stored in plain text files or flat files.

Q4 . what is an object model?

Check Answer

SOLUTION

In this the data is represented as objects.It is a combinations of oops concepts as well as database concepts.

Q5 . what is an associative data model?

Check Answer

SOLUTION

In other data models the data are stored as records.In associative data model the data and the qualities or the attributes of the data are also stored

Q6 . what are transactions ?

Check Answer

SOLUTION

A transaction In a database is a group of activities that occur for a task.The activities should be able to restore to the last successul position in event of fault.The ACID properties show the ideal properties of a transaction.

Q7 . What are ACID properties ?

Check Answer

SOLUTION

ACID stands for ;>Atomicity;>Consistency;>Isolation;>Durability;In databases the completion of all the 4 make the completion of a database transaction.

Q8 . what is normalization?

Check Answer

SOLUTION

It is the way or reorganising data or tables to remove the undesired characteristics like redundancy and many more anomalies in database systems.some examples of normalization are 1NF,2NF,BCNF etc

Q9 . what is indexing?

Check Answer

SOLUTION

Indexing is a way of fetching the data from a database by using some indexes or field that have been indexed.

Q10 . what is hashing?

Check Answer

SOLUTION

In hashing the data are stored in Data Buckets or Data Blocks for which the address for the data is generated using a hash function.Hash function can be any functions like even simple mathematical functions like log 3.

You are Currently reading

DBMS Interview Questions-3

For more Interview Questions on dbms

• DBMS Interview Questions-1
• DBMS Interview Questions-2
• DBMS Interview Questions-3