What is true about MERGE command? Choose all that apply.

Select TYPES of JOINS. Choose all that apply.

Choose the MANDATORY clauses of SELECT SQL statement

ALIAS can be used for TABLE as well as COLUMN to simplify interpretation of SQL query

Identify the correct output select INITCAP('ORACLE BASICS') from dual;

Identify the correct output --- select CONCAT('ORACLE' || 'BASICS') from dual;

Identify the correct output --- select SUBSTR('ORACLE BASICS',-6,5) from dual;

Identify the correct output --- select TRUNC(TO_DATE('01-SEP-1995', 'DD-MON-YYYY'),'YEAR') from dual;

Identify the correct output --- select ADD_MONTHS(TO_DATE('01-SEP-1995', 'DD-MON-YYYY'), 6) from dual;

Identify the correct output --- select LAST_DAY(TO_DATE('01-SEP-1995', 'DD-MON-YYYY')) from dual;

Which functions mentioned below are GROUP functions? Choose all that apply

One can NOT delete a row from the VIEW if view definition contains ... Choose all that apply

Identify the MANDATORY sections of a PL/SQL block

INSERT, UPDATE, DELETE commands when used in a PL/SQL block, should contain INTO clause to hold the data returned by SQL statement

Identify the ITERATIVE control constructs in PL/SQL. Choose all that apply