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 […]

SQL – Restricting and Sorting Data Questions 1. Which of the following clause is used to limit the number of rows retrieved from a SELECT query? LIMIT WHERE AND FROM Answer: B. The WHERE clause is used to restrict the number of rows returned from a SELECT query. 2. Choose the database elements whose values […]

SQL – Using Manipulating Data Oracle provide Data Manipulation Language commands to exercise data operations in the database.Data operations can be populating the database tables with the application or business data,modifying the data and removing the data from the database,whenever required. Besides the data operations,there are set of commands which are used to control these […]