A.SELECT INITCAP(TRIM('H' FROM 'Hello World')) FROM DUAL;

B.SELECT LOWER (SUBSTR('Hello World, 2, 1)) FROM DUAL;

C.SELECT LOWER(TRIM('H' FROM 'Hello World')) FROM DUAL;

D.SELECT LOWER (SUBSTR('Hello World', 2)) FROM DUAL;

E.SELECT SUBSTR('Hello world', 2) FROM DUAL;

A.The USING clause can be used.

B.The SQL:1999 compliant ANSI join syntax must be used.

C.The Oracle join syntax can be used.

D.Table aliases must be used.

E.The ON clause can be used.

A.SELECT last_name,salary
FROM employees
ORDER BY salary
FETCH FIRST 3 ROWS ONLY;

B.SELECT last_name,salary
FROM employees
FETCH FIRST 3 ROWS ONLY
ORDER BY salary;

C.SELECT last_name, salary
FROM employees
WHERE ROWNUM<=3

D.SELECT last_name,salary
FROM employees
WHERE ROWNUM<=3
ORDER BY (SELECT salary FROM employees);

E.SELECT last_name,salary
FROM (SELECT * FROM employees ORDER BY salary)

A.INSERT INTO (SELECT order_id, order date, customer_id FROM orders) VALUES (1,
'09-mar-2007"101);

B.INSERT INTO orders (order id, order_date, order mode, order_total)VALUES (1'10-mar-2007','online', 1000)

C.INSERT INTO orders VALUES (1, '09-mar-2007', 'online',' ',1000);

D.INSERT INTO orders (order_id, order_date, order mode,customer_id, order_total) VALUES (1, TO_DATE (NULL),'online',101, NULL) ;

E.INSERT INTO orders VALUES('09-mar-2007'DEFAULT,101, DEFALLT);

A.SELECT SUBSTR(join date, 1, 2)- 10 FROM employees;

B.SELECT join date 11.'11 salary FROM employees;

C.SELECT join date + 20 FROM employees;

D.SELECT salary + 120.50 FROM employees;

E.SELECT join date FROM employees where join date > *10-02-2018*;