On This Page

This set of DataBase Management System (DBMS) Multiple Choice Questions & Answers (MCQs) focuses on Database Management System Set 57

Q1 | A relation between 2 set of attributes is called as
  • Join dependency
  • Association
  • Functional Dependency
  • Multivalued dependency
Q2 | In 1NF, the value of the attribute must be
  • Atomic
  • Single
  • Multivalued
  • Null.
Q3 | The process of Normalization is
  • Iterative
  • Non-reversible
  • Reversible
  • None
Q4 | Which normal form is most desirable ?
  • DKNF
  • 3 NF
  • BCNF
  • 4 NF
Q5 | A functional dependency is a relationship between
  • Tables
  • Columns
  • Attributes
  • Rows
Q6 | Two or more attributes that can be a key are called :
  • determinants
  • primary key
  • Composite key
  • foreign key
Q7 | Cartesian product in relational algebra is
  • a Unary operator.
  • a Binary operator.
  • a Ternary operator
  • not defined
Q8 | In the relational modes, cardinality is termed as:
  • Number of tuples.
  • Number of attributes.
  • Number of tables.
  • Number of constraints.
Q9 | Relational calculus is a
  • Procedural language.
  • Non- Procedural language.
  • Data definition language.
  • High level language
Q10 | In a relational database a referential integrity constraint can be specified with the helpof
  • primary key
  • foreign key
  • secondary key
  • none of the above
Q11 | A super key is a set of one or more attributes that, taken collectively, allow us
  • to identify uniquely an entity in the entity set
  • to make the key most powerful for faster retrieval
  • to increase effectiveness of database access
  • none of the above
Q12 | 4NF is designed to cope with:
  • Transitive dependency
  • Join dependency
  • Multi valued dependency
  • None of these
Q13 | A relational database developer refers to a record as
  • a criteria.
  • a relation.
  • a tuple.
  • an attribute.
Q14 | The relational model feature is that there
  • is no need for primary key data.
  • is much more data independence than some other database models.
  • are explicit relationships among records.
  • are tables with many dimensions.
Q15 | SET concept is used in :
  • Network Model
  • Hierarchical Model
  • Relational Model
  • None of these
Q16 | Relational Algebra is
  • Data Definition Language .
  • Meta Language
  • Procedural query Language
  • None of the above