On This Page

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

Q1 | The different classes of relations created by the technique for preventing modificationanomalies are called:
  • normal forms.
  • referential integrity constraints.
  • functional dependencies.
  • None of the above is correct.
Q2 | A relation is in this form if it is in BCNF and has no multivalued dependencies:
  • second normal form.
  • third normal form.
  • fourth normal form.
  • domain/key normal form.
Q3 | The primary key is selected from the:
  • composite keys.
  • determinants.
  • candidate keys.
  • foreign keys.
Q4 | In the relational model, relationships between relations or tables are created by using:
  • composite keys.
  • determinants.
  • candidate keys.
  • foreign keys.
Q5 | A relation is considered a:
  • Column.
  • one-dimensional table.
  • two-dimensional table.
  • three-dimensional table.
Q6 | If attribute A determines both attributes B and C, then it is also true that:
  • A → B.
  • B → A.
  • C → A.
  • (B,C) → A.
Q7 | One solution to the multivalued dependency constraint problem is to:
  • split the relation into two relations, each with a single theme.
  • change the theme.
  • create a new theme.
  • add a composite key.
Q8 | When the values in one or more attributes being used as a foreign key must exist inanother set of one or more attributes in another table, we have created a(n):
  • transitive dependency.
  • insertion anomaly.
  • referential integrity constraint.
  • normal form.
Q9 | In a one-to-many relationship, the entity that is on the one side of the relationship is called a(n) ________ entity.
  • Parent
  • Child
  • Instance
  • Subtype
Q10 | Which one of the following is a set of one or more attributes taken collectively to Uniquely identify a record?
  • Candidate key
  • Sub key
  • Super key
  • Foreign key
Q11 | Consider attributes ID , CITY and NAME . Which one of this can be considered as a super key ?
  • NAME
  • ID
  • CITY
  • CITY , ID
Q12 | The subset of super key is a candidate key under what condition ?
  • No proper subset is a super key
  • All subsets are super keys
  • Subset is a super key
  • Each subset is a super key
Q13 | A _____ is a property of the entire relation, rather than of the individual tuples in Which each tuple is unique.
  • Rows
  • Key
  • Attribute
  • Fields
Q14 | Which one of the following attribute can be taken as a primary key ?
  • Name
  • Street
  • Id
  • Department
Q15 | Which one of the following cannot be taken as a primary key ?
  • Id
  • Register number
  • Dept_id
  • Street
Q16 | A attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation .
  • Candidate
  • Primary
  • Super
  • Sub
Q17 | The relation with the attribute which is the primary key is referenced in another relation. The relation which has the attribute as primary key is called
  • Referential relation
  • Referencing relation
  • Referenced relation
  • Referred relation
Q18 | The ______ is the one in which the primary key of one relation is used as a normal Attribute in another relation .
  • Referential relation
  • Referencing relation
  • Referenced relation
  • Referred relation
Q19 | A _________ integrity constraint requires that the values appearing in specified attributes of any tuple in the referencing relation also appear in specified attributes of at least one tuple in the referenced relation.
  • Referential
  • Referencing
  • Specific
  • Primary
Q20 | Relations produced from an E-R model will always be in:
  • First normal form
  • Second normal form
  • Third normal form
  • Fourth normal form
Q21 | In ER model the details of the entities are hidden from the user. This process is called:
  • Generalization
  • Specialization
  • Abstraction
  • none of these above
Q22 | ‘AS’ clause is used in SQL for
  • Selection operation.
  • Rename operation.
  • Join operation.
  • Projection operation.
Q23 | ODBC stands for
  • Object Database Connectivity.
  • Oral Database Connectivity.
  • Oracle Database Connectivity.
  • Open Database Connectivity
Q24 | In a Hierarchical model records are organized as
  • Graph.
  • List.
  • Links.
  • Tree.
Q25 | In an E-R diagram attributes are represented by
  • rectangle.
  • square.
  • ellipse
  • Triangle