Q. Data Models in DBMS are classified into ______ categories.
A) 3
B) 4
C) 5
D) 2
Answer: B)
Q. Form of data model which focuses requirement-gathering process is classified as
A) level data models
B)highlow level data models
C)dynamic data models
D)medium level data models
Answer: A)
Q. Collection of all concepts that must be used to describe database structure is called
A) structural model
B) server model
C) database model
D) client model
Answer: C)
Q. First step in designing high level conceptual data model is
A) logical design analysis
B) conceptual design analysis
C) functional requirement analysis
D) requirement analysis
Answer: D)
Q. A single set of related data values is referred to as
A) data
B) record
C) table
D) database
Answer: B)
Q. One department offers many courses. But one particular course can be offered by only one department.
hence the cardinality between department and course is
A) One-to-One Relationship
B) One-to-Many Relationship
C) Many-to-Many Relationship
D) Composite Relationship
Answer: B)
Q. A relational database consists of a collection of
A) tables
B) fields
C) records
D) keys
Answer: A)
Q. Which of the following decisions would be part of Physical Database Design?
A) Defining columns should have exact datatypes, lengths assigned and default values.
B) All of these
C) Defining Primary and Foreign keys, views, indexes, access profiles, and authorizations, etc.
D) Identifying relationships between tables that which addresses cardinality and nullability of the relationships.
Answer: B)
Q. One department has multiple instructors . But instructor belongs to only one department.
Hence the cardinality between department and instructor is
A) One-to-One
B) One-to-Many
C) Many-to-Many
D) Many-to-One
Answer: B)
Q. One course is taught by only one instructor. But one instructor teaches many courses. Hence the cardinality between course and instructor is
A) One-to-One
B) One-to-Many
C) Many-to-Many
D) Many-to-One
Answer: D)
Q. Here we are going to design an Entity Relationship (ER)
model for a college database.
Say we have the following statements.
1. A college contains many departments
2. Each department can offer any number of courses
3. Many instructors can work in a department
4. An instructor can work only in one department
5. For each department there is a Head
6. An instructor can be head of only one department
7. Each instructor can take any number of courses
8. A course can be taken by only one instructor
9. A student can enroll for any number of courses
10. Each course can have any number of students
From the statements given, the entities are
A) Department Course Student
B) Department Course Instructor Student
C) Course Instructor Student
D) None of the mentioned
Answer: B)
Q. One course can be enrolled by many students and one student can enroll for many courses.
Hence the cardinality between course and student is
A) One-to-One
B) One-to-Many
C) Many-to-Many
D) Many-to-One
Answer: C)
Q. A ________ in a table represents a relationship among a set of values.
A) column
B) key
C) row
D) entry
Answer: C)
Q. Entity Relationship Diagrams are output from the following phase of Database Development:
A) Physical Database Design
B) Conceptual Data Modeling
C) Logical Database Design
D) Distributed Database Design
Answer: B)