Oracle Database Programming MCQs with Answers
Practice important Oracle Database Programming MCQs with answers and explanations.
Multiple Choice Questions
Q51: Which of the following is used to remove duplicate values in an SQL SELECT query?
- A: ORDER BY
- B: DISTINCT
- C: JOIN
- D: HAVING
View Answer
B
Q52: Which function is used to count the total number of rows in a SQL table?
- A: COUNT
- B: SUM
- C: AVG
- D: MIN
View Answer
A
Q53: What does the client tier provide in Oracle 11i?
- A: Business Logic
- B: User Interface
- C: Database Management
- D: Application Logic
View Answer
B
Q54: What is the responsibility of the Application Tier in Oracle 11i?
- A: Hosting client-side programs
- B: Managing database tier
- C: Hosting servers and business logic
- D: Connecting clients and servers
View Answer
C
Q55: Which tier stores all the data in Oracle Applications?
- A: Client Tier
- B: Application Tier
- C: Database Tier
- D: Middleware Tier
View Answer
C
Q56: What is PL/SQL?
- A: Procedural Language Extension to SQL
- B: Programming Language Interface
- C: A Database Query Language
- D: A Web Scripting Language
View Answer
A
Q57: How does PL/SQL enhance SQL?
- A: By adding database access
- B: By adding programming structures
- C: By adding web support
- D: By adding graphics capabilities
View Answer
B
Q58: What is the basic unit of a PL/SQL program?
- A: Block
- B: Procedure
- C: Function
- D: Trigger
View Answer
A
Q59: In a PL/SQL block, which keyword indicates the start of the executable part?
- A: DECLARE
- B: EXCEPTION
- C: BEGIN
- D: END
View Answer
C
Q60: What keyword is used to define an optional exception-handling part in a PL/SQL block?
- A: EXCEPTION
- B: BEGIN
- C: DECLARE
- D: END
View Answer
A