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

WHERE clause is used to restrict groups

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?

Identify the MANDATORY sections of a PL/SQL block

%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

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

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?

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