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;

Print the number of rows deleted

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

Conditional CASE Expression (I THINK)

Help

Options

focusNode

Didn't know it?
click below

Knew it?
click below

Don't Know

Remaining cards (0)

Know

retry

shuffle

restart

0:00

Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.

Normal Size Small Size show me how

Data endmin F-1

Question	Answer
The DML statement: INSERT, DELETE, ________ make changes to the database.	UPDATE
The _____ is an integer value that represents the number of rows affected by the most recent SQL statement.	@@ROWCOUNT
The _______cursor are automatically defined by Oracle.	IMPLICIT
The memory area allocated by Oracle server to store the SQL statement and the data that it uses in known as __________.	SHARED POOL
The ______ is a Boolean attribute that evaluates to TRUE if the most recent SQL statement did not return even one row.	SQL%NOTFOUND (I THINK)
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;	No error
The memory area allocated by Oracle server to store the SQL statement and the data that it uses in known as:
The _______ statement selects rows from one table to update and/or insert into another table.	MERGE
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;	Print the number of rows deleted
An integer value that represents the number of rows affected by the most recent SQL.	SQL%ROWCOUNT
Applying the logical operator NOT to a null yields FALSE. T or F	False
Consider the given code fragment below. The condition will return a true value. A:=null; B:=null; If A = B then . . . . . T or F	False
Refer to M1S2-code reference#3, data type for vmesg variable must be CHAR.	False (VARCHAR)
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;	True
Refer to M1S2-code reference#1, what is the correct condition that must be supplied in the IF statement?	vpop < 1000000000
Refer to M1S2-code reference#3, what is missing in the creation of the implicit cursor?	Airports
The ______ is the symbol used for the assignment operator. = :=	:=
Refer to M1S2-code reference#3, what must be displayed in the dbms_output? VMESG V_APORT	VMESG
The use of CASE statement to test conditions such as <, >, >=, <= is know as:	Conditional CASE Expression (I THINK)
Refer to M1S3-code reference#1, what is missing in the creation of the implicit cursor inside the loop body? _______	INTO(I THINK)
In for loop, counter variable is declared _______.	IMPLICITLY
All counter variables must be declared at the declaration section.	False
efer to M1S3-code reference #4, the ‘>’ is the missing operator in the EXIT section.	True
A loop structure must have an exit clause.	True
In for loop, counter must be explicitly declared.	False

Created by: user-2021111

"Know" box contains:
Time elapsed:
Retries: