SQL – Conversion Functions Questions 1. What will be the outcome of the following query? SELECT ROUND(144.23,-1) FROM dual; 140 144 150 100 Answer: A. The ROUND function will round off the value 144.23 according to the specified precision -1 and returns 140. Examine the structure of the EMPLOYEES table as given and answer the […]
Author Archives: user
SQL – Conditional Expressions Questions 1. What is true about data types in Oracle DB? They are given to columns for sorting purposes. They are given to columns for a structured representation in a table. They are given to columns to constrain the nature of the data it can store. They are not mandatory. Answer: […]
SQL – Using Single-Row Functions Questions 1. What will be the outcome of the following query? SELECT ROUND(144.23,-1) FROM dual; 140 144 150 100 Answer: A. The ROUND function will round off the value 144.23 according to the specified precision -1 and returns 140. Examine the structure of the EMPLOYEES table as given and answer […]