Oracle Database Programming MCQs with Answers
Practice important Oracle Database Programming MCQs with answers and explanations.
Chapter: 1
Q1:
Who developed the Entity-Relationship (ER) model?
A. Peter Chen
B. Edgar Codd
C. E.F. Codd
D. Charles Bachman
Correct Answer:
A
Chapter: 1
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
Correct Answer:
C
Chapter: 1
Q3:
What is not a component of an ERD?
A. Entity
B. Attribute
C. Class
D. Relationships
Correct Answer:
C
Chapter: 1
Q4:
In the school database, which of the following is NOT considered an entity?
A. Students
B. Teachers
C. Courses
D. Fees
Correct Answer:
D
Chapter: 1
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
Correct Answer:
C
Chapter: 1
Q6:
Which of the following is the smallest storage unit in a database?
A. Entity
B. Attribute
C. Relationship
D. Foreign Key
Correct Answer:
B
Chapter: 1
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
Correct Answer:
B
Chapter: 1
Q8:
What type of line represents an optional relationship in ERD?
A. Solid Line
B. Dotted Line
C. Dashed Line
D. Double Line
Correct Answer:
B
Chapter: 1
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
Correct Answer:
A
Chapter: 1
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
Correct Answer:
B
Chapter: 1
Q11:
A foreign key in a one-to-one relationship must be declared as which of the following?
A. Primary key
B. Foreign Key
C. Unique key
D. Composite Key
Correct Answer:
C
Chapter: 1
Q12:
Fill in the blank: Participation in an entity relationship can be either ______ or mandatory.
A. optional
B. fixed
C. hybrid
D. arbitrary
Correct Answer:
A
Chapter: 1
Q13:
Fill in the blank: In ERD, ______ describes how data is connected among the entities.
A. Normalization
B. Relationship
C. Constraint
D. Index
Correct Answer:
B
Chapter: 1
Q14:
In a Many-to-Many relationship, which additional entity is created?
A. Parent entity
B. Intersection table
C. Child entity
D. Super entity
Correct Answer:
B
Chapter: 1
Q15:
Which of the following describes a One-to-One relationship?
A. A record in one entity is linked to exactly one record in another entity
B. One record is linked to many records
C. Many records linked to one record
D. No link between entities
Correct Answer:
A
Chapter: 1
Q16:
How many songs can an album contain, as per the given scenario?
A. 0 to 1
B. 1 to 5
C. 1 to 12
D. Unlimited
Correct Answer:
C
Chapter: 1
Q17:
What is the maximum number of songs an album can contain according to the scenario?
A. 8
B. 10
C. 12
D. 14
Correct Answer:
C
Chapter: 2
Q18:
What is Oracle 11g on Cloud?
A. A locally installed Oracle database
B. A cloud service hosted by Oracle
C. An open-source database
D. A programming language
Correct Answer:
B
Chapter: 2
Q19:
What can you manage using Oracle 11g on Cloud without purchasing hardware?
A. Only user accounts
B. Network configurations
C. Full database management and development
D. Security settings
Correct Answer:
C
Chapter: 2
Q20:
Which of the following is NOT required to access Oracle 11g on Cloud?
A. Purchasing hardware
B. Knowing backup and recovery commands
C. Maintaining cloud storage
D. Internet connection
Correct Answer:
A