Oracle Database Programming MCQs with Answers
Practice important Oracle Database Programming MCQs with answers and explanations.
Multiple Choice Questions
Q1: Who developed the Entity-Relationship (ER) model?
- A: Peter Chen
- B: Edgar Codd
- C: E.F. Codd
- D: Charles Bachman
View Answer
A
Q2: What does an Entity Relationship Diagram (ERD) visually represent?
- A: Business processes
- B: Data flows
- C: Relationships between data in a database
- D: Business objectives
View Answer
C
Q3: What is not a component of an ERD?
- A: Entity
- B: Attribute
- C: Class
- D: Relationships
View Answer
C
Q4: In the school database, which of the following is NOT considered an entity?
- A: Students
- B: Teachers
- C: Courses
- D: Fees
View Answer
D
Q5: The relationship between a student and a course can be described as what type of relationship?
- A: One-to-One
- B: Many-to-Many
- C: One-to-Many
- D: Zero-to-Many
View Answer
C
Q6: Which of the following is the smallest storage unit in a database?
- A: Entity
- B: Attribute
- C: Relationship
- D: Foreign Key
View Answer
B
Q7: A relationship in ERD is a combination of what two concepts?
- A: Normalization and Denormalization
- B: Cardinality and Optionality
- C: Data types and Formats
- D: Keys and Constraints
View Answer
B
Q8: What type of line represents an optional relationship in ERD?
- A: Solid Line
- B: Dotted Line
- C: Dashed Line
- D: Double Line
View Answer
B
Q9: What is the rule for representing a Many-to-Many relationship in ERD?
- A: By using a third intersection entity
- B: By using a foreign key in one of the entities
- C: By linking tables directly
- D: By removing redundancy
View Answer
A
Q10: In a One-to-Many relationship, the primary key of the parent table becomes what in the child table?
- A: Composite key
- B: Foreign Key
- C: Unique Key
- D: Candidate Key
View Answer
B