Oracle Database Programming MCQs with Answers
Practice important Oracle Database Programming MCQs with answers and explanations.
Multiple Choice Questions
Q31: What is a feature of Oracle 11g on Cloud that helps simplify database management?
- A: Automatic database backups
- B: Required manual updates
- C: Limited access to cloud storage
- D: Full manual control over database upgrades
View Answer
A
Q32: What is the command used to retrieve data from a database in SQL?
- A: DELETE
- B: SELECT
- C: INSERT
- D: UPDATE
View Answer
B
Q33: What does the SELECT statement retrieve from a table?
- A: All rows and all columns
- B: Only specific rows
- C: Only specific columns
- D: Both specific rows and columns
View Answer
D
Q34: Which SQL clause is used to filter rows returned by a query?
- A: GROUP BY
- B: HAVING
- C: WHERE
- D: ORDER BY
View Answer
C
Q35: What does the DISTINCT keyword do in an SQL SELECT statement?
- A: Retrieves all values from a column
- B: Retrieves unique values
- C: Retrieves duplicate values
- D: Retrieves null values
View Answer
B
Q36: Which clause is used to filter the results of an aggregated query in SQL?
- A: WHERE
- B: GROUP BY
- C: HAVING
- D: ORDER BY
View Answer
C
Q37: In SQL, what symbol is used as a wildcard for one or more characters in a query?
- A: %
- B: _
- C: *
- D: ?
View Answer
A
Q38: Which SQL function is used to find the length of a string?
- A: ROUND
- B: TRUNC
- C: LENGTH
- D: INSTR
View Answer
C
Q39: Which function in SQL is used to round a number to a specified number of decimal places?
- A: ROUND
- B: TRUNC
- C: LENGTH
- D: INSTR
View Answer
A
Q40: Which SQL function would you use to truncate a number without rounding it?
- A: ROUND
- B: TRUNC
- C: LENGTH
- D: INSTR
View Answer
B