Oracle Database Programming MCQs with Answers
Practice important Oracle Database Programming MCQs with answers and explanations.
Multiple Choice Questions
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
View Answer
C
Q12: Fill in the blank: Participation in an entity relationship can be either ______ or mandatory.
- A: optional
- B: fixed
- C: hybrid
- D: arbitrary
View Answer
A
Q13: Fill in the blank: In ERD, ______ describes how data is connected among the entities.
- A: Normalization
- B: Relationship
- C: Constraint
- D: Index
View Answer
B
Q14: In a Many-to-Many relationship, which additional entity is created?
- A: Parent entity
- B: Intersection table
- C: Child entity
- D: Super entity
View Answer
B
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
View Answer
A
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
View Answer
C
Q17: What is the maximum number of songs an album can contain according to the scenario?
- A: 8
- B: 10
- C: 12
- D: 14
View Answer
C
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
View Answer
B
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
View Answer
C
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
View Answer
A