Database Management System Set 51

Computer Science Engineering (CSE),

Bachelor of Science in Computer Science FY (BSc CS),

Bachelor of Science in Computer Science SY (BSc CS),

Bachelor of Science in Information Technology SY (BSc IT),

Bachelor of Computer Applications (BCA),

Bachelor of Business Administration in Computer Applications (BBA [CA]),

Bachelor of Science in Information Technology (BSc IT),

Bachelor of Science in Computer Science (BSc CS),

Master of Business Administration (MBA)

Learning Mode Previous Next
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:
Q2 | A relation is in this form if it is in BCNF and has no multivalued dependencies:
Q3 | The primary key is selected from the:
Q4 | In the relational model, relationships between relations or tables are created by using:
Q5 | A relation is considered a:
Q6 | If attribute A determines both attributes B and C, then it is also true that:
Q7 | One solution to the multivalued dependency constraint problem is to:
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):
Q9 | In a one-to-many relationship, the entity that is on the one side of the relationship is called a(n) ________ entity.
Q10 | Which one of the following is a set of one or more attributes taken collectively to Uniquely identify a record?
Q11 | Consider attributes ID , CITY and NAME . Which one of this can be considered as a super key ?
Q12 | The subset of super key is a candidate key under what condition ?
Q13 | A _____ is a property of the entire relation, rather than of the individual tuples in Which each tuple is unique.
Q14 | Which one of the following attribute can be taken as a primary key ?
Q15 | Which one of the following cannot be taken as a primary key ?
Q16 | A attribute in a relation is a foreign key if the _______ key from one relation is used as an attribute in that relation .
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
Q18 | The ______ is the one in which the primary key of one relation is used as a normal Attribute in another 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.
Q20 | Relations produced from an E-R model will always be in:
Q21 | In ER model the details of the entities are hidden from the user. This process is called:
Q22 | ‘AS’ clause is used in SQL for
Q23 | ODBC stands for
Q24 | In a Hierarchical model records are organized as
Q25 | In an E-R diagram attributes are represented by
Previous Next