Oracle Database Programming MCQs with Answers
Practice important Oracle Database Programming MCQs with answers and explanations.
Multiple Choice Questions
Q61: Which section in a PL/SQL block is mandatory?
- A: DECLARE
- B: BEGIN
- C: EXCEPTION
- D: END
View Answer
B
Q62: The application tier in Oracle 11i manages communication between which tiers?
- A: Client Tier and Database Tier
- B: Web Tier and Database Tier
- C: Middle Tier and Client Tier
- D: Middleware Tier and Web Tier
View Answer
A
Q63: Which tier is responsible for storing Oracle Applications online help?
- A: Client Tier
- B: Application Tier
- C: Database Tier
- D: Middle Tier
View Answer
C
Q64: PL/SQL programs are compiled by the __________.
- A: Oracle Database server
- B: Application Server
- C: Web Server
- D: Client-side programs
View Answer
A
Q65: PL/SQL is designed to embrace which type of statements within its syntax?
- A: C++ statements
- B: SQL statements
- C: Web-based statements
- D: Java-based statements
View Answer
B
Q66: What does the DBMS_OUTPUT.PUT_LINE statement do in PL/SQL?
- A: Writes to a file
- B: Reads from the database
- C: Displays output
- D: Deletes a record
View Answer
C
Q67: In the thick database paradigm, SQL statements are issued by ________.
- A: PL/SQL subprograms inside the database
- B: Web server subprograms
- C: Client-side subprograms
- D: Java applets
View Answer
A
Q68: PL/SQL is used for both __________ development.
- A: Database and Web
- B: Server-side and Client-side
- C: Client-side and Application-side
- D: Server-side and Database-side
View Answer
B
Q69: The minimum executable unit in PL/SQL is the __________.
- A: Procedure
- B: Trigger
- C: Function
- D: Block
View Answer
D
Q70: In PL/SQL, which section allows variable declarations?
- A: EXECUTION section
- B: DECLARE section
- C: EXCEPTION section
- D: END section
View Answer
B