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

Identify the correct output --- select CONCAT('ORACLE' || 'BASICS') 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

An application developer wants to query row count of a table, ORDERS which has millions of records. ORDERS table has composite PRIMARY KEY on (ORDER_ID, CUSTOMER_ID) columns and those two columns appear at position 1 and 2 respectively in the ORDERS table. Which query will be more efficient?

%ROWTYPE attribute is used to declare a variable and associate it's data type with the TABLE/CURSOR object.

Within a PL/SQL block, which commands are allowed? Choose all that apply

IF-THEN-ELSE-ENDIF construct is used for conditional control in a PL/SQL block. What happens if the condition in IF-THEN-ELSE-ENDIF block evaluates to NULL?