Database Rev (May Possible na Mali)

The _____ statement selects rows from one table to update and/or insert into another table.

• Merge

• Clause

• Double

• Joint

The INTO clause occurs between the SELECT and _______ clauses.

• Into

• From

• Merge

• Insert

The ______ is a Boolean attribute that evaluates to TRUE if the most recent SQL statement did not return even one row.

• SQL%FOUND

• SQL%NOTFOUND

• SQL%BOOL

• SQL%TRUE

The memory area allocated by Oracle server to store the SQL statement and the data that it uses in known as __________.

• IMPLICIT CURSOR

• EXPLICIT CURSOR

• CLAUSE CURSOR

• DEFINE CURSOR

The ______ clause is used in DML statement to specify variable(s) that will hold the value(s) that SQL returns from the SELECT clause.

• INTO

• FROM

• SELECT

• FOUND

What could be the possible error of the given code below?

DECLARE

v_sum_sal NUMBER(10,2);

v_deptno  NUMBER NOT NULL := 60;

BEGIN

SELECT SUM(salary) FROM employees WHERE department_id = v_deptno;

DBMS_OUTPUT.PUT_LINE('Dep #60 Salary Total: ' || v_sum_sal);

END;

• NO ERROR

• MISSING SELECT CLAUSE

• MISSING INTO CLAUSE

• NO SEMICOLON

Boolean attribute that evaluates to TRUE if the most recent SQL statement did not return even one row. 

• SQL%RETURN

• SQL%NOTFOUND

• SQL%FOUND

• SQL%FALSE

The use of CASE statement to test conditions such as <, >, >=, <= is know as case expression.

• FALSE

• TRUE

• N/A

• MAYBE

Applying the logical operator NOT to a null yields FALSE.

• TRUE

• FALSE

• NOT IN OPTION

• HA?

A condition is an expression that returns true, false, or null.

• TRUE

• FALSE

• KEI POGI

• LABYU KEI