FA1 - Sheet1 (1)

Question 1

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

Answer 1

INTO

Question 2

The use of INTO clause in PL/SQL select statement is to specify the name of ________.

Answer 2

VARIABLE

Question 3

The INTO clause occurs between the SELECT and _______ clauses.

Answer 3

FROM

Question 4

The DML statement: INSERT, DELETE, ________ make changes to the database.

Answer 4

UPDATE

Question 5

Which SQL statements cannot be used directly in PL/SQL?
Group of answer choices

DDL, DCL

DML

TCL

DML, TCL

Answer 5

DDL, DCL

Question 6

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

DECLARE

v_sal_increase employees.salary%TYPE := 800;

BEGIN

UPDATE copy_emp

SET salary = salary + v_sal_increase

WHERE job_id = ‘ST_CLERK’;

END;

Group of answer choices

WHERE section

Variable declaration

No error

SET section

Answer 6

No error

Question 7

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

DECLARE

v_sal_increase employees.salary%TYPE = 800;

BEGIN

UPDATE copy_emp

SET salary = salary + v_sal_increase

WHERE job_id = ‘ST_CLERK’;

END;

Group of answer choices

SET section

No error

WHERE section

Variable declaration

Answer 7

Variable declaration

Question 8

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

Answer 8

Cursor

Question 9

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

Answer 9

False

Question 10

Applying the logical operator NOT to a null yields FALSE.

Answer 10

False

Question 11

The type of loop where the statement inside the loop must execute at least once.

Answer 11

BASIC

Question 12

In BASIC and WHILE loop, the iteration will terminate when the counter is > than the upper bound.
Group of answer choices

True

False

Question 13

In BASIC and WHILE loop, initialization of counter variable is necessary.

Answer 13

t

Question 14

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

Answer 14

SQL%NOTFOUND

Question 15

The DDL and _______ SQL statements cannot be used directly in PL/SQL.

Answer 15

DCL

Question 16

The _______cursor are automatically defined by Oracle.

Answer 16

IMPLICIT

Question 17

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

DECLARE

v_salary employees.salary%TYPE;

BEGIN

SELECT salary INTO v_salary

FROM employees;

DBMS_OUTPUT.PUT_LINE(‘ Salary is : ‘ || v_salary);

END;

Answer 17

Query returns more than 1 row

Question 18

The _______ statement selects rows from one table to update and/or insert into another table.
Group of answer choices

DML

COMBINE

MERGE

SELECT, INSERT, UPDATE

Answer 18

MERGE

Question 19

What is missing in the given code below?

DECLARE

v_salary employees.salary%TYPE;

BEGIN

SELECT salary INTO ________

FROM employees where employee_id = 100;

DBMS_OUTPUT.PUT_LINE(‘ Salary is : ‘ || v_salary);

END;

Answer 19

V_SALARY

Question 20

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)

INTO v_sum_sal FROM employees WHERE department_id = v_deptno;

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

END;

Answer 20

No error

Question 21

Consider the given code fragment below. The condition will return a false value.

  A:=null; B:=null;

If A = B then . . . . .

Answer 21

t

Question 22

The BASIC LOOP control structures are statements that enable you to execute statements in a PL/SQL block repeatedly.
Group of answer choices

True

False

Answer 22

t

Question 23

In for loop, counter must be explicitly declared.
Group of answer choices

True

False

Answer 23

False

Question 24

In BASIC and WHILE loop, the iteration will terminate when the counter is < than the upper bound.

Answer 24

False

Question 25

The INTO clause occurs between the _______ and FROM clauses.

Answer 25

SELECT

Question 26

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

Answer 26

IMPLICIT CURSOR

Question 27

Which DML statement make changes to the database? Group of answer choices INSERT DELETE All the options UPDATE

Answer 27

All the options

Question 28

The code below must print the number of rows updated, what is the missing part of the code? Declare v_cal_increase employees.salary%type := 800; begin update copy_emp set salary = salary + v_sal_increase where job_id = ‘ST_CLERK’; dbms_output.put_line(_____________ || ‘ rows updated.’); end;

Answer 28

SQL%ROWCOUNT

Question 29

The code below must print the number of rows updated. Which part of the code must be changed to satisfy the output? Declare v_sal_increase employees.salary%type := 800; begin update copy_emp set salary = salary + v_sal_increase where job_id = ‘ST_CLERK’; dbms_output.put_line(SQL%FOUND || ‘ rows updated.’); end;

Answer 29

SQL%FOUND

Question 30

Consider the given code fragment below. The condition will return a true value. A:=null; B:=null; If A = B then . . . . .

Answer 30

False

Question 31

Applying the logical operator NOT to a null yields NULL. Group of answer choices True False

Answer 31

True

Question 32

In for loop, counter variable is declared _______.

Answer 32

IMPLICITLY

Question 33

Without the EXIT statement, the loop would never end (an infinite loop).

Answer 33

True

Question 34

All counter variables must be declared at the declaration section. Group of answer choices True False

Question 35

An EXIT statement is used in order to come out of from the outer loop within an inner loop. Group of answer choices True False

Answer 35

False

Question 36

The _________ SQL Rule: queries must return only one row.

Answer 36

EMBEDDED

Question 37

The _____ is an integer value that represents the number of rows affected by the most recent SQL statement.

Answer 37

SQL%ROWCOUNT

Question 38

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

Answer 38

MERGE

Question 39

The ______ are automatically declared variables that allow you to evaluate what happened when a cursor was last used. Group of answer choices Explicit attributes Cursor attributes Attributes Implicit attributes

Answer 39

Cursor attributes

Question 40

What could be the possible error of the given code below? DECLARE v_salary employees.salary%TYPE; BEGIN SELECT salary INTO v_salary FROM employees where employee_id = 100; DBMS_OUTPUT.PUT_LINE(' Salary is : ' || v_salary); END; Group of answer choices VARIABLE ERROR Query returns more than 1 row TABLE ERROR NO ERROR

Answer 40

NO ERROR

Question 41

A counter variable is an expression that returns true, false, or null. Group of answer choices True False

Answer 41

False

Question 42

What is missing in the given WHILE loop syntax? ________ WHILE condition statement1; statement2; . . . END ;

Answer 42

LOOP

Question 43

A loop structure must have an exit clause. Group of answer choices True False

Answer 43

True

Question 44

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; Group of answer choices Group function error Query returns more than 1 row Variable error Missing INTO clause

Answer 44

Missing INTO clause

Question 45

Is there something missing in the given code? DECLARE v_myage NUMBER := 31; BEGIN IF v_myage < 11 DBMS_OUTPUT.PUT_LINE('I am a child'); END IF; END; Group of answer choices True False

Answer 45

True

Question 46

A ________ is used in order to come out of from the outer loop within an inner loop.

Answer 46

LOOP LABELS

Question 47

The lower and upper bound of a for loop must be a numeric literals. Group of answer choices True False

Answer 47

False

Question 48

The _________ cursors are defined by the PL/SQL programmer.

Answer 48

EXPLICIT

Question 49

What is the output of the given code below? DECLARE v_deptno copy_emp.department_id%TYPE := 50; BEGIN DELETE FROM copy_emp WHERE department_id = v_deptno; DBMS_OUTPUT.PUT_LINE(SQL%ROWCOUNT || ' rows deleted.'); END;

Answer 49

Print the number of rows deleted

Question 50

Control structures are used to change the logical flow of statements within the PL/SQL block. Group of answer choices True False

Answer 50

True

Question 51

Use the ______ loop when the statement inside the loop must execute at least once.

Answer 51

BASIC

Question 52

The use of INTO clause in PL/SQL select statement is to specify the name of: ____________. Group of answer choices VARIABLE CURSOR TABLE VIEW

Answer 52

VARIABLE

Question 53

The code below must print the number of rows deleted. What is missing in the given code to satisfy the output? DECLARE v_deptno copy_emp.department_id%TYPE := 50; BEGIN DELETE FROM copy_emp WHERE _____________ = v_deptno; DBMS_OUTPUT.PUT_LINE(SQL%ROWCOUNT || ' rows deleted.'); END; Group of answer choices DEPARTMENT_ID DEPARTMENTS JOBS JOB_ID

Answer 53

DEPARTMENT_ID

Question 54

Use a DO..WHILE loop when the statement inside the loop must execute at least once. Group of answer choices True False

Answer 54

False