Oracle Database Programming MCQs with Answers
Practice important Oracle Database Programming MCQs with answers and explanations.
Chapter: 3
Q41:
In SQL, what does the GROUP BY clause do?
A. Groups identical data
B. Joins multiple tables
C. Filters aggregated data
D. Sorts data in ascending order
Correct Answer:
A
Chapter: 3
Q42:
Which SQL clause is used to sort the result set in ascending or descending order?
A. GROUP BY
B. WHERE
C. ORDER BY
D. HAVING
Correct Answer:
C
Chapter: 3
Q43:
What is the role of a subquery in SQL?
A. Joining tables
B. Filtering rows
C. Inserting data
D. Query within a query
Correct Answer:
D
Chapter: 3
Q44:
Which SQL function is used to concatenate two strings?
A. ROUND
B. TRUNC
C. CONCAT
D. INSTR
Correct Answer:
C
Chapter: 3
Q45:
Which clause is used to group rows that have the same values in SQL?
A. ORDER BY
B. GROUP BY
C. HAVING
D. DISTINCT
Correct Answer:
B
Chapter: 3
Q46:
Which of the following SQL functions is used to find the position of a character in a string?
A. LENGTH
B. SUBSTR
C. INSTR
D. CONCAT
Correct Answer:
C
Chapter: 3
Q47:
In SQL, what does the AVG function calculate?
A. Total sum of values
B. Average of values
C. Maximum value
D. Minimum value
Correct Answer:
B
Chapter: 3
Q48:
Which SQL query returns the total number of rows in a table?
A. SELECT COUNT(*)
B. SELECT SUM(column)
C. SELECT AVG(column)
D. SELECT MIN(column)
Correct Answer:
A
Chapter: 3
Q49:
Which of the following is an example of a single-row function in SQL?
A. COUNT
B. AVG
C. LENGTH
D. SUM
Correct Answer:
C
Chapter: 3
Q50:
Which SQL keyword is used to combine rows from two or more tables based on a related column between them?
A. GROUP BY
B. WHERE
C. JOIN
D. HAVING
Correct Answer:
C
Chapter: 3
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
Correct Answer:
B
Chapter: 3
Q52:
Which function is used to count the total number of rows in a SQL table?
A. COUNT
B. SUM
C. AVG
D. MIN
Correct Answer:
A
Chapter: 4
Q53:
What does the client tier provide in Oracle 11i?
A. Business Logic
B. User Interface
C. Database Management
D. Application Logic
Correct Answer:
B
Chapter: 4
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
Correct Answer:
C
Chapter: 4
Q55:
Which tier stores all the data in Oracle Applications?
A. Client Tier
B. Application Tier
C. Database Tier
D. Middleware Tier
Correct Answer:
C
Chapter: 4
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
Correct Answer:
A
Chapter: 4
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
Correct Answer:
B
Chapter: 4
Q58:
What is the basic unit of a PL/SQL program?
A. Block
B. Procedure
C. Function
D. Trigger
Correct Answer:
A
Chapter: 4
Q59:
In a PL/SQL block, which keyword indicates the start of the executable part?
A. DECLARE
B. EXCEPTION
C. BEGIN
D. END
Correct Answer:
C
Chapter: 4
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
Correct Answer:
A