Database Management System Set 57
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),
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