This test used to rate your Oracle skills
SELECT SUBSTR ('Hello',) FROM dual;
SELECT INITCAP (TRIM ('Hello World',1,1) FROM dual;
SELECT LOWER (SUBSTR ('Hello World',1,1) FROM dual;
SELECT LOWER (SUBSTR ('Hello World',2,1) FROM dual;
SELECT LOWER (TRIM ('H' FROM 'Hello World')) FROM dual;
INSTR returns the numeric position of a named character.
NVL2 returns the first non-null expression in the expression list.
TRUNCATE rounds the column, expression, or value to n decimal places
DECODE translates an expression after comparing it to each search value.
TRIM trims the heading of trailing characters (or both) from a character string.
The sort is in ascending by order by default.
The sort is in descending order by default.
The ORDER BY clause must precede the WHERE clause.
The ORDER BY clause is executed on the client side.
The ORDER BY clause comes last in the SELECT statement.
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
SELECT last_name FROM EMP WHERE last_ name LIKE '_A%';
SELECT last_name FROM EMP WHERE last name ='*A%'
SELECT last_name FROM EMP WHERE last name ='_A%';
SELECT last_name FROM EMP WHERE last name LIKE '*A%'
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;
SELECT TO_CHAR(SUBSTR(SYSDATE, 8,2),'yyyy') FROM dual;
SELECT COUNT (*) FROM employees WHERE last _name='smith';
SELECT COUNT (dept_id) FROM employees WHERE last _name='smith';
SELECT DISTINCT (COUNT (dept_id) FROM employees WHERE last _name='smith';
SELECT COUNT (DISTINCT dept_id) FROM employees WHERE last _name='smith';
SELECT UNIQE (dept_id) FROM employees WHERE last _name='smith';
No change is required to achieve the desired results.
SELECT ename, sal, 12* (sal+100) FROM emp;
SELECT ename, sal, (12* sal)+100 FROM emp;
SELECT ename, sal +100,*12 FROM emp;
SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA\_%'ESCAPE'\';
SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_';
SELECT employee_id, last_name, job_id FROM employees WHERE job_id LIKE '%SA_'ESCAPE'\';
SELECT employee_id, last_name, job_id FROM employees WHERE job_id '%SA_';
SELECT dear customer, customer_name, FROM customer;
SELECT "Dear Customer", customer_name, ||',' FROM customer;
SELECT 'Dear Customer' || customer_name ',' FROM customer;
SELECT 'Dear Customer' || customer_name || ',' FROM customer;
SELECT "Dear Customer" || customer_name || "," FROM customer;
WHERE lower(country_address) = "france"
WHERE lower(country_address) = 'france'
WHERE lower(country_address) IS 'france'
WHERE lower(country_address) = '%france%'
WHERE lower(country_address) LIKE %france%
The results are not sorted.
The results are sorted numerically.
The results are sorted alphabetically.
The results are sorted numerically and then alphabetically.
17000.00
17000*****
****17000
**17000.00
An error statement
25
5
2
1
None of the above