1. A single set of related data values is referred to as
- data
- record
- table
- database
Ans: record
2. A relational database consists of a collection of
- tables
- fields
- records
- keys
Ans: tables
3. A ________ in a table represents a relationship among a set of values.
- column
- key
- row
- entry
Ans: row
4. Collection of all concepts that must be used to describe database structure is called
- structural model
- server model
- database model
- client model
Ans: database model
5. Data Models in DBMS are classified into ______ categories.
- 3
- 4
- 5
- 2
Ans: 3
6. First step in designing high level conceptual data model is
- logical design analysis
- conceptual design analysis
- functional requirement analysis
- requirement analysis
Ans: requirement analysis
7. Entity Relationship Diagrams are output from the following phase of Database Development:
- Physical Database Design
- Conceptual Data Modeling
- Logical Database Design
- Distributed Database Design
Ans: Conceptual Data Modeling
8. Which of the following decisions would be part of Physical Database Design?
- Student data and enrollment data will be stored in two different tables
- An index file will be created on the last name of students in the Student table
- The Social Security number will be chosen as the primary key of the Student table
- Student data and enrollment data will be stored in two different tables at two different locations
Ans: An index file will be created on the last name of students in the Student table
9. Form of data model which focuses concepts in same way as data stored in computer system is classified as
- low level data models
- high level data models
- dynamic data models
- medium level data models
Ans: low level data models
10. An ___________ Diagram is a type of flowchart that illustrates how “entities” such as people, objects or concepts relate to each other within a system.
- Use Case
- Sequence
- Entity Relationship
- Class
Ans: Entity Relationship
11. Entity is a _________
- Present working model
- Thing in real world
- Model of relation
- Object of relation
Ans: Thing in real world
12. Entities can be associated with one another in which of the following?
- Identifiers
- Attributes
- Entities
- Relationships
Ans: Relationships
13. The descriptive property possessed by each entity is _________
- Model
- Attribute
- Relation
- Entity
Ans: Attribute
14. An attribute is a:
- two dimensional table
- column of a table
- key of a table
- row of a table
Ans: column of a table
15. In an ERD, the focus is on the ____ and the relationships between them.
- indexes
- keys
- attributes
- entities
Ans: entities
16. 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
- Department Course Instructor Student
- Course Instructor Student
- None of the mentioned
- Department Course Student
Ans: Department Course Instructor Student
17. One course can be enrolled by many students and one student can enrol for many courses. Hence the cardinality between course and student is
- Many-to-One
- One-to-Many
- One-to-One
- Many-to-Many
Ans: Many-to-Many
18. One department has multiple instructors. But the instructor belongs to only one department. Hence the cardinality between department and instructor is
- Many-to-Many
- One-to-Many
- Many-to-One
- One-to-One
Ans: One-to-Many
19. One department offers many courses. But one particular course can be offered by only one department. hence the cardinality between department and course is
- One-to-Many Relationship
- One-to-One Relationship
- Composite Relationship
- Many-to-Many Relationship
Ans: One-to-Many Relationship
20. One course is taught by only one instructor. But one instructor teaches many courses. Hence the cardinality between course and instructor is
- One-to-One
- Many-to-One
- One-to-Many
- Many-to-Many
Ans: Many-to-One
21. Pick out the correct statement about the key in database design.
- must always be composed of two or more columns.
- can only be one column.
- identifies a row
- identifies a column
Ans: identifies a row
22. The primary key must be
- Not Null
- Unique
- Never Changing
- All of the listed options
Ans: All of the listed options
23. Which one of the following attribute can be taken as a primary key?
- Name
- Street
- Id
- Department
Ans: Id
24. Which one of the following cannot be taken as a primary key?
- Id
- Register_Number
- Dept_Id
- Street
Ans: Street
25. Address field of a person should not be part of primary key, since it is likely to be
- Dependent
- Changed
- Not Changed
- Too Long
Ans: Changed
26. A foreign key is
- a column containing the primary key of another table.
- used to define data types
- used to define null status
- All of the listed options
Ans: a column containing the primary key of another table.
27. Which of the following statement is false?
- In primary key field you cannot enter duplicate value
- Foreign key fields don’t allow duplicate values
- One student can have many Classes, hence Student and Class table got one-to-many relationship
- All of the listed statements are false
Ans: Foreign key fields don’t allow duplicate values
28. If I create ‘Student’ field in ‘Fees’ table to store ‘student_id’ of ‘Students’ table, then this ‘Student’ field in ‘Fees’ table is called:
- Foreign Key
- Primary Key
- Composite key
- Native key
Ans: Foreign Key
29. Identify the relationship between a Movie table and Stars table.
- One-to-One
- One-to-Many
- Many-to-Many
- Many-to-One
Ans: Many-to-Many
30. For which kind of relationship you need a junction table to reflect real world situation?
- One-to-One
- One-to-Many
- Many-to-Many
- Many-to-One
Ans: Many-to-Many
More MCQs coming soon…
