Interview Questions Answers on DBMS 2016.
what is a database?
a dbms is a complex software system that is used to manage,store and manipulate
data and metadata used to describe the data.
what is a key?what are different keys in database?
a key is nothing but a attribute or group of attributes.they are used to perform
some specific operation depending on their operation.the keys are classified
into primary key,secondary key,alternative keysuper key,candidate key,compound
or concatinated or composite key.
what is a primary key?
primary key:an attribute to identify a record uniquely is considered to be
primary key.for eg in the student table student_no is the primary key because it
can be used to identify unique record or unique student.
what is a secondary key?
an attribute used to identify a group of records satisfying a given condition is
said to be a secondary key.in the employee table designation is a secondary key
because more than one employee can have the same designation.
what is a candidate key?
register no usually alloted in the exams is also unique for each student in that
case for identifying a student uniquely either student_no or register_no can be
used.here two different candidates are contesting for primary key post.any of
them can be selected as primary key.
what is an alternate key?
if any one of the candidate keys among the different candidate keys available is
selected as primary key then remaining keys are called alternate key.
what is a super key?
with primary key if any other attribute is added then that combination is called
super key in other words,primary key is the minimum possible super key.in the
student table student_no+student_name is one the super key.
what is a composite key?
if the primary key is combination of more than one key then it is calles the
composite key.in the table called marks student_no+subject is the composite key.
what is a relation?
a relation consists of a homogeneous set of tuples.
what is a table?
it is the representation of a relation having records as rows and attributes as