SQL – Using the Group Functions Questions 1. Which of the following is NOT a GROUP BY function? MAX MIN NVL AVG Answer: C. NVL is a general function used to provide alternate value to the NULL values. The functions MAX, MIN and AVG can be used as GROUP BY functions. 2. Which of the […]
Category Archives: sql Certificate
SQL – Restricting and Sorting Data The essential capabilities of SELECT statement are Selection, Projection and Joining. Displaying specific columns from a table is known as a project operation. We will now focus on displaying specific rows of output. This is known as a select operation. Specific rows can be selected by adding a WHERE […]
SQL – The SQL SELECT Statement Questions 1. Identify the capabilities of SELECT statement. Projection Selection Data Control Transaction Answer: A, B. The SELECT statement can be used for selection, projection and joining. 2. Determine the capability of the SELECT statement demonstrated in the given query. SELECT e.ename, d.dname FROM emp e, dept d WHERE […]