Oracle 12C SQL (ICT 3722) Exam with Questions and Answers

It covers key domains which include; Introduction to Relational Databases, Basic Data Retrieval (The SELECT Statement), Restricting and Sorting Data, Single-Row Functions and Aggregating Data Using Group Functions. A SQL developer is evaluating the following expression in an Oracle 12c SELECT statement: SELECT 1000 + 200 * 2 FROM dual; What will be the result of the expression? a) 2400 b) 1400 c) 2000 d) 1200 Correct Answer: b) 1400 Rationale: In Oracle SQL, multiplication has higher precedence than addition. Therefore, 200 * 2 is evaluated first giving 400, then 1000 + 400 results in 1400. Consider the query: SELECT (1000 + 200) * 2 FROM dual; What value will be returned? a) 1400 b) 2000 c) 2400 d) 1600 Correct Answer: c) 2400 Rationale: Parentheses override operator precedence in Oracle SQL. The expression inside brackets is evaluated first: 1000 + 200 = 1200, then multiplied by 2 giving 2400.