Immediately after the SELECT clause

After the ORDER BY clause

After the WHERE clause

Before the WHERE clause

SELECT SUBSTR( ‘Hello World’,1) FROM dual;

SELECT INITCAP(TRIM (‘Hello World’, 1,1)) FROM dual;

SELECT LOWER(TRIM (‘H’ FROM ‘Hello World’)) FROM dual;

SELECT LOWER(SUBSTR(‘Hello World’, 2, 1) FROM dual;

SELECT ename, salary*12 ‘Annual Salary’ FROM employees;

SELECT ename, salary*12 “Annual Salary” FROM employees;

SELECT ename, salary*12 AS Annual Salary FROM employees;

SELECT ename, salary*12 AS INITCAP(“ANNUAL SALARY”) FROM employees

ORDER BY SALARY > 5000

GROUP BY SALARY > 5000

HAVING SALARY > 5000

WHERE SALARY > 5000

MAX

MIN

SUM

TOTAL

SELECT TO_CHAR(SYSDATE,'yyyy') FROM dual;

SELECT TO_DATE(SYSDATE,'yyyy') FROM dual;

SELECT DECODE(SUBSTR(SYSDATE, 8), 'YYYY') FROM dual;

SELECT DECODE(SUBSTR(SYSDATE, 8), 'year') FROM dual;

You want to identify the most senior employee in the company.

You want to find the manager supervising the largest number of employees

You want to identify the person who makes the highest salary for all employees.

You want to rank the top three sales representatives who have sold the maximum

46 and 45

46 and 45.93

50 and 45.93

50 and 45.9

Data dictionary

Data marts

Data sets

Nodes

Help

Run

Explain

complie

True

False

Null

dropped

have duplicates

All of the above

NODE

clique

Bynet

PE

True

False

SSAS

SSIS

SSRS

SQL RDBMS

A method of storing and presenting key enterprise data

Allows End users to analyze data to understand business results

To accurately forecast future results

All of the above

SSAS

SSIS

SSRS

SQL RDBMS

The cursor is moved to another row

The row the cursor is on is deleted by the application

The row the cursor is on is deleted by another application

The row the cursor is on needs to be updated by another application

-810

-801

-805

-825

Space Issues

Data Issues

No records found while querying the table

Both a & b