Oracle Database Programming MCQs with Answers
Practice important Oracle Database Programming MCQs with answers and explanations.
Multiple Choice Questions
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
View Answer
A
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
View Answer
C
Q43: What is the role of a subquery in SQL?
- A: Joining tables
- B: Filtering rows
- C: Inserting data
- D: Query within a query
View Answer
D
Q44: Which SQL function is used to concatenate two strings?
- A: ROUND
- B: TRUNC
- C: CONCAT
- D: INSTR
View Answer
C
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
View Answer
B
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
View Answer
C
Q47: In SQL, what does the AVG function calculate?
- A: Total sum of values
- B: Average of values
- C: Maximum value
- D: Minimum value
View Answer
B
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)
View Answer
A
Q49: Which of the following is an example of a single-row function in SQL?
- A: COUNT
- B: AVG
- C: LENGTH
- D: SUM
View Answer
C
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
View Answer
C