Basics of DBMS Set 2
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 Basics of DBMS Set 2
Q1 | The attribute name could be structured as an attribute consisting of first name, middleinitial, and last name. This type of attribute is called
- Simple attribute
- Composite attribute
- Multivalued attribute
- Derived attribute
Q2 | In a relation between the entities the type and condition of the relation should be specified.That is called as______attribute.
- Desciptive
- Derived
- Recursive
- Relative
Q3 | _____________ can help us detect poor E-R design.
- Database Design Process
- E-R Design Process
- Relational scheme
- Functional dependencies
Q4 | Which of the following has each related entity set has its own schema and there is anadditional schema for the relationship set.
- A many-to-many relationship set
- A multivalued attribute of an entity set
- A one-to-many relationship set
- All of the mentioned
Q5 | In which of the following, a separate schema is created consisting of that attribute and theprimary key of the entity set.
- A many-to-many relationship set
- A multivalued attribute of an entity set
- A one-to-many relationship set
- All of the mentioned
Q6 | Suppose the user finds the usage of room number and phone number in a relationalschema there is confusion.This is reduced by
- Unique-role assumption
- Unique-key assignment
- Role intergral assignment
- None of the mentioned
Q7 | Designers use which of the following to tune the performance of systems to support timecritical operations?
- Denormalization
- Redundant optimization
- Optimization
- Realization
Q8 | In the schema (dept name, size) we have relations total inst 2007, total inst 200Q:8) Whichdependency have lead to this relation ?
- Dept name, year->size
- Year->size
- Dept name->size
- Size->year
Q9 | Relation dept year(dept name, total inst 2007, total inst 2008, total inst 2009). Here theonly functional dependencies are from dept name to the other attributes. This relation is in
- Fourth NF
- BCNF
- Third NF
- Second NF
Q10 | Thus a _______ of course data gives the values of all attributes, such as title anddepartment, of all courses at a particular point in time.
- Instance
- Snapshot
- Both Instance and Snapshot
- All of the mentioned
Q11 | Representations such as the in the dept year relation, with one column for each value of an attribute, are called _______ they are widely used in spreadsheets and reports and in data analysis tools.
- Cross-tabs
- Snapshot
- Both Cross-tabs and Snapshot
- All of the mentioned
Q12 | Data Model is collection of conceptual tools for describing -
- Data
- All of these
- Data Schema
- Consistency Constaints
Q13 | Data Models in DBMS are classified into ______ categories.
- 3
- 2
- 5
- 4
Q14 | Object based logical model(s) are used to describe data at - [Select Appropriate Option(s)]
- View Level
- Logical Level
- Physical Level
- None of these
Q15 | Which of the following is example of Object based logical model ?
- Relational Model
- Hierarchical Model
- Network Model
- Entity Relationship Model
Q16 | Entity Relationship model consists of collection of basic objects called _________ andrelationship among these objects.
- functions
- models
- None of these
- entities
Q17 | Which of the following gives a logical structure of the database graphically?
- Entity-relationship diagram
- Entity diagram
- Database diagram
- Architectural representation
Q18 | Consider a directed line(->) from the relationship set advisor to both entity sets instructorand student. This indicates _________ cardinality
- One to many
- One to one
- Many to many
- Many to one
Q19 | We indicate roles in E-R diagrams by labeling the lines that connect ___________ to__________
- Diamond , diamond
- Rectangle, diamond
- Rectangle, rectangle
- Diamond, rectangle
Q20 | An entity set that does not have sufficient attributes to form a primary key is termed a__________
- Strong entity set
- Variant set
- Weak entity set
- Variable set
Q21 | For a weak entity set to be meaningful, it must be associated with another entity set, calledthe
- Identifying set
- Owner set
- Neighbour set
- Strong entity set
Q22 | If you were collecting and storing information about your music collection, an albumwould be considered a(n) _____
- Relation
- Entity
- Instance
- Attribute
Q23 | What term is used to refer to a specific record in your music database; for instance;information stored about a specific album?
- Relation
- Instance
- Table
- Column
Q24 | If a multivalued dependency holds and is not implied by the corresponding functionaldependency, it usually arises from one of the following sources.
- A many-to-many relationship set
- A multivalued attribute of an entity set
- A one-to-many relationship set
- Both A many-to-many relationship set and A multivalued attribute of an entity set
Q25 | Relational Algebra is a __________ query language that takes two relations as input andproduces another relation as an output of the query.
- Relational
- Structural
- Procedural
- Fundamental