Tag: databases

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

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

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?