1.

Section #1 1 2 4 S 7 9 10 Next

Attempted: 0/40

Select an option
1

Question Revisit Later

& Clear Response

Analyze the procedures listed in the options and find which is the correct way to create a
procedure in PL/SQL? Select the correct answer from the given choices. DECLARE
pet _animal animal_p:=
animal_p (DOG, BONE'):
BEGIN
DBMS_ÖUTPUT.PUT_LINE (pet_animal.name):
END:

DECLARE

pet_animal animal_p:=
animal_p (DOG, 'BONE'):
BEGIN
DBMS_OUTPUT.PUT_LINE (pet_animal.name):
DBMS_OUTPUT.PUT_LINE (pet_animal.food):

END:

DECLARE
pet_animal:
1. Section #1 4 5 9 10 Next

Attempted: 0/40
BEGIN
Question 1 Revisit Later DBMS_OUTPUT.PUT_LINE (pet_animal.name):
DBMS_OUTPUT.PUT_LINE (pet_animal.food;

Analyze the procedures Iisted in the options and find which is the correct way to create a
procedure in PLSQL? Select the correct answer from the given choices. END:

DECLARE
pet_animal;
BEGIN
pet_animal := animal_p('DOG, 'BONE):
DBMS_OUTPUT.PUT_LINE (animal_p.name):
END:

DECLARE

petlanimal animal_p;
BEGIN
pet_animal.name = 'DOG:
DBMS OUTPUT.PUT_LINE (pet_animal.name):
END:

Need Help? Contact us: 1.(e00) 265-6038 91 80471-89190 Mercer mettl

Mettl Online Assessment 2021-2021 Powered By
1. Secton #1 1 3 4 5 6 7 8 10 Previous Next

Attempted: 0/40

Question 2 D Revisit Later Select an option Q Clear Response

What is the correct output of the given pl/sql code?

DELUMITER $$
O
Displays even numbers lesser than 10
CREATE PROCEDURE myProc
BEGIN
DECLARE int;
SET I 0:
O
Displays prime numbers lesser than 10
loop1: REPEAT
SET 1;
iit
MODG,2) <> 0 THEN PEven number
-
IF try againt/
Displays odd numbers greater than 10
SELECT CONCAT(,' is an odd number':
END IF:
>
UNTIL i 10
END REPEAT: Displays odd numbers lesser than 10
ENDSS
DELIMITER:

call myProcO:
Analyze the given options and select the correct answer.
ABDUL MUEED, +8
vo stri hai kuch bhi kr sakti hai

( Reply

Mett! Onlne Assessment 2021-2031 Need help? Contact us: 1

(800) 265-6038 +91 80471-89190 Powered Py Mercar meil
1. Section #1 1
2 3 4 9 10 Preenca

Atternpted: 0/40

Question 3 Cl Revisit Later Select an option

Assume there are triggers that may have created marny triggers. How can you perforn the
listed tasks:
O
[Link] show frorn AL_TRIGGERS:
1, List all triggers such that you can view all the related information that the user has created? from WN_TRIGGERS:
2. Using select
2. Include the owner column ith the above details?

Select the correct answer from the choices listed, O

[Link] select from TRIGGERS:
2. Using selectfrom OWNALL_TRIGGERS:

O 1. Using select *from USER_TRIGGERS:

2. Using select from ALL_TRIGGERS:
ABDUL MUEED, +8
AM Stree to tum bhi ho. toda sa
yar
O
1. Using select * from A_TRIGGERS:
Reply
2. Using select from DBA_TRIGGERS:

ABDUL MUEED, +8
PK mai ja rha hun chhod ke

U Reply

us: 80471-89 190

hetti Grline Aszessrnent 2021-2031 Need Help? Contact 1 (800) 265-6038 91 [Link] Mercer
1. Section #1 1 2 3 4 5 6 7 8 9 10 H Previous Next

Attempted: 0/40

Question 4 Revisit Later

Select an option & Clear Response

Consider that a salesman wants to calculate the total sales of a product he made on a
particular day. He has information on the total units of the product sold and the price per unit replace function Product(x in number. y in number)
item. From the given options, identify which is the function to calculate the total sales by return number
passing the no. of items sold and the unit price of the item as the parameters to the function? is
mult number(8):
begin
mult :=x*y:
return mult;
end:

O
create function Product(x in number. y in number)
return number
is
mult number(8):
begin
mult :=x"y:

end:

Cres+ funtian Draef in n

onnr
Mettí Onre Assessnernt & 2021-2031 tNeed Help? Contact us: a1 (800) 265-6038 91
80471-89190 Ponered By Mercer netti
1. Section #1 1 2 4 5 6 7 9 10 Previous Ne

Attempted: 0/40

Question 4 Revisit Later

end;

Consider that a salesman wants to calculate the total sales of a product he made on a
particular day. He has information on the total units of the product sold and the price per unit create function Product(x in number, y in number)
item. From the given options, identify which is the function to calculate the total sales by
is
passing the no. of items sold and the unit price of the item as the parameters to the function?
mult number(8):
begin
mult :=x*y:
return mult:
end:

create function Product(x in number, y in number)

return number

mult number(8):
begin
mult :=x"y:
return mult:
end:

Need Help? Contact us: +1 (800) 265-6038 91 80471-89190 Posered By Mercer m

Metti Onine Assessment © 2021-2031
1. Section #1 1 2 5 6 7 10 Preous Niext

Atternpted: 0/40

Question 5 A Pevisit Later Select an optíon e Clear Pesponse

Pefesting to the gven SQL staterment identify vhat ís the grade of the student with the
'studentid 10? Select the correct arswer fro the given [Link]
narks UMBER = 90
studertid NUMBER: 10
O B
PRDCEDURE student grade
(student jd IN NUMER grade IN VARCHAR2) IS
BEGIN
DEIAS_OUTPUTPUT LINE(Student_jd;
DEMS_OUTPUTPUTUNE(Grade):
END,

EEGIH
studert gradelstudentid,
CASE
WHEN narks > 90 THEN 'As"
WHEN marks 85 AND marks
VIHEN natks 75 AND marks
ses 90 THEN'A'e'
E5 THEN
VIHEN marks > s0 THEN C
ELSE D

fieed Hep? Contact u 1

(00) 2€S 032 9120471-89190
 1.
4tion 11 Preo Nest

Arsempte y4

Question 6 Select an option &Clear Response

Anavze the gen choices and 4dentify wtich opton is the esut of the givern code?
DECLARI
BEGIN
FORn N REVIRSt 1.3 3

DEMS OUTPUTPUINI (n): 5

END LOOP.
END

3
2

error wth "ORA-06550: line 3, column 13:

error at line 2. column 2:

Aetti Canke.
ASseSst 2021-2031
91
3047-a9190
1. Section #1 2 3 4 5 6 8 10 Previous Next

Attempted: 0/40

Question7 Revisit Later

Select an option Q Clear Response

Assume that you are required to calulate the average of the first ten natural numbers. Before
finding the average. you need to calculate the sum of all the ten numbers. DECLARE
num NUMBER := 1; sum NUMBER := 0:
Which PL/SQL block will you select from the listed choices to print the sum of the first 10 BEGIN
numbers? WHILE num <= 10
LOOP sum:= sum+ 1:

DBMS_OUTPUT.PUT_LINE(Sum):
num:= Num +1:
END LOOP:
END:

DECLARE
num NUMBER := 1: sum NUMBER:= O:

BEGIN
WHILE num <= 10
LOOP sum:= sum + num:
DBMS_OUTPUT.PUT_LINE(num):
num := num+1:
END LOOP:
END:

Metti Online Assessment 2021-2031 Need Help? Contact us: 1 (800) 265-6038 +91 80471-89190 Powered
y
Mercer metl
1. Section #1
<12 3 4 56 7 10 Previous Next

Attempted: 0/40

Question 7 Revisit Later

DECLARE
num NUMBER := 1; sum NUMBER:= 0;
Assume that you are required to calulate the average of the first ten natural numbers. Before BEGIN
finding the average, you need to calculate the sum of all the ten numbers. WHILE num <= 10
LOOP sum:= sum + num;
Which PLSQL block will you select from the listed choices to print the sum of the first 10 DBMS_OUTPUT.PUT LINE(sum):
numbers?
num := num+1;
END LOOP:
END;

DECLARE
num NUMBER := 1;
BEGIN
WHILE num <= 10
LOOP
DBMS_OUTPUT.PUT_LINE(num):
num := num+1:
END LOOP:
END:

us 265-6038 91 80471-89190
Mettl Online Assessnent 2021-2031 Need Help? Contact d(800) metti
Pawered By Mercer
1. Section #1 2 3 4 5 6 8 9 10 Previous Next

Attempted: 0/40

Question 8 A Revisit Later Select an option lear Response

A
database operator creates a table 'products' and declares a variable price number (4.2).

The operator then adds a value of 2545.25 to the price by using: () (a) Yes

INSERT INTO products (price) VALUES (2545.25). (b) While declaring the variable, the price has a precision of 4

(a) Willthe statement give an error?

(b) Why?
O
la) Yes

Analyze the given choices and select the correct set of answers. (b) The scale is set 2 for the variable price

(a) Yes

(b) The price should be of float type

(a) No
(b) There is no error

Mett! Online Assessment 2021-2031 Need Help? Contact us: 1(800) 265-6038 +91 80471-89190 Mercer
Povered By meltl
1. Section #1 2 3 6 7 Previous Next

Attempted: 0/40

Question 9 Revisit Later

1. SELECT FROM warnings where type like "Disabled"
2. SELECT FROM warnings where type like triggers":
in order to perform the given tasks, which are the options that are most suitable?
1. Find stored procedures that have the compile
time error disabled
2. Find stored procedures that are triggers
1. SELECT NAME. plsql_ warnings FROM settings WHERE type LIKE
Analyze the given choices and select the correct set of answers, "%DISABLE%:
2. SELECT NAME. plsql_warnings FROM settings WHERE type LIKE

"%TRIG%:

1. SELECT NAME, warnings FROM group WHERE plsql_warnings LIKE

"%DISABLE%:
2. SELECT NAME, warnings FROM group WHERE type LIKE %TRIG%:

1. SELECT NAME. plsql_warnings FROM user_plsql_object_settings

WHERE plsql_warnings LIKE '%DISABLE%:
2. SELECT NAME. plsql_warnings FROM
user_plsql_object_settings
WHERE type LIKE %TRIG%:

Mettt [Link] Asses senent 2021-2031

Neetl Help? Cyntact us:
1 (C00) 265-6030 91 80471-89190
Powered By Mercer mettl
1. Section #1 5 6 7 8 9 10 11 12 13 14 Previous Next

Attempted: 0/40

Question 10 Revisit Later

Select an option & Clear Response

Which exceptions are used for the given functions?

1. When you try to insert a new record that has a redundant value? O 1.STORAGE_ERROR
2. When there is a numerical or conversion problem? 2. VALUE ERROR

Analyze the given choices and select the correct set of answers.

1. DUP _VAL_ON_INDEX

2. VALUE ERROR

O 1. DUP_VAL_ON_INDEX

2. PROGRAM_ERROR

( 1. PROGRAM_ERROR
2. VALUE_ERROR

Metti Onine Assessment & 2021-2031 Need Help? Contact us; a 1 (800) 265-6038 +91 S0471-89190 Fcwerec Sy
Mercer mettl
1. Section #1 6 7 8 9 10 1 12 13 14 15 Previous Nex

Attempted: 0/40

Question 11 W Revisit Later Select an option Clear Response

What will be the output of the given code?

DECLARE 120.0
num number:
factnum number
FUNCTION factorial(val number)
RETURN Run time error
number

num number.
BEGIN
IF
Statement executed without any value
val=0 THEN
num := 1:
ELSE
num := val factorial(val-1): None of the above
END IF:
RETURN num:
END:

BEGIN
num:= 5:

dbms_output.put_line(factnum):
END:

Metti Online Assessment 2021-2031 Need Help? Contact us: 1 (800) 265-6038 91 80471-89190 9Mercer
n
1. Section #1 7 8 9 10 11 12 13 14 15 16 Previous Next

Attempted: 0/40

1. SELECT owner, name FROM all_ plsql_object _settingsWHERE

Question 12 A Revisit Later
plsql_optimize_level IN (1.0):

Assume that software developers are working on a project needed to check whether the 2. SELECT owner, name FROM user_plsqlLobject_settings WHERE
programs are efficently utilizing the optimizing compiler. Which is the option used to identify plsql_optimize_level IN (1.0):
programs that are not using an optimizing compiler efficiently?

Select the correct answer from the choices listed.

O
[Link] name FROM user_plsql_object_settings

2. SELECT name FROM plsql_object_settings

1. SELECT FROM user_plsql_object_settings WHERE

plsql_optimize_level IN (1.0):

2. SELECT* FROM allLplsql object_settings WHERE plsql_optimize_level

IN (1.0):

1. SELECT plsql_optimize_level IN (1.0):

FROM all_plsql_object_settings WHERE pisq optimize_level lN (1,0):

2. SELECT plsql optimize_level IN (1.0) FROM user_plsql_object_settings

us:
hiet Onhne Assessment 2027-2037 Need hielp? Contact 1 (800) 265-603s 91
80471-89190 Mercer mettl
Povered y
1. SectiOn #1 10 11 12 13
14 15 16 17 Previous Next

Attenpled: 0/40
Question 13 A Revisit Later
Select an option Q Clear Response

What is the commision based on the given code?

DECLARE
O 0.2
sales NUMBER:
commission NUMBER

BEGIN No Conmission
sales : 20000:

IF sales < 10000 THEN

commission:= 0,1: 0.0

elsif sales > 10000 AND sales < 20000 THEN
commission:= 0.2:
elsif sales >= 20000 THEN GOTO bonus:
0.3
commission:= 0.3:
ELSE

commission := 0:
END IF:

dbms_output.put_line (commission):
<<bonus>>
dbms_output.put_line (No commission):

END:
Select the correct answer from the choices listed.

Mettl Onine Assessment 2021-2031 INeed Help? Contact us: +1 (000) 265-6039 91 80471-89190 Mercer nett
Doveed Sy
1. Section #1 10 11 12 13 14 15 16 17 18 Previous Next

Attempted: 0/40
NAME 'success 0 return [Link]':
O

Question 14 Revisit Later

my_result:=success):
Ifthe given code uses the method 'success(0' from Progjava, what can the missing code be?
create or replace
FUNCTION SUccess RETURN VARCHAR2 AS
LANGUAGE JAVA
NAME '[Link] 0 return [Link]':
##MISSIING CODE
Decdare
#*MISSING CODE
my_resut varchar2(200 char): my_result:=success):

begn
dbms_output.put_line(my_result):
end: O
NAME 'success ) return [Link]':
Anayze the given choices and select the correct answer.

my_result =success0:

O
NAME 'success 0 return [Link]'

my_result = Prog.success0:

tieed Help? Contact us: 1

(200) 265 6038
Metti Grf ne kse:snert & 2C21-2021 •91 8047 1-89190 Merçer
1. Section #1 10 11 12 13 1 15 16 17 18 19 Previous Next

Attempted: 0/40

Question 15 DRevisit Later

Select an option Q Clear Response

What is the correct output of the given data retrieval code? Select the correct answer from the
grven choices.
CREATE TABLE EMPLOYEE(
empld iNTEGER PRIMARY KEY.

name TEXT NOT NULL

dept TEXT NOT NLL

INSERT INTO EMPLOYEE VALUES (1. 'Don. Sales):

INSERT INTO EMPLOYEE VALUES (2. 'Ravi, Accounts):

DEUMITER SS
CREATE PROCEDURE myProcfinid int) Exception
READS SQL DATA
BEGIN
SELECT [Link]
FROM EMPLOYEE
WHERE empld=in_ id:
ENDSS
DEUMITER:

cali myProc(2}:

Metti Onine Assessment 2021-2031 Need Help? Contact us: 1 (800) 265-6038 91 80471-89 190 Powered By
Mercer metti
1. Section #1 11 12 13 14 15 16 17 18 19 20 Previous Next

Attempted: 0/40

Question 16 ARevisit Later Select an option Q Clear Response

Assume that a software programmer has written the given code to find the sum. What will be
O 2147483648
the correct output of the given code snippet?
DECLARE
num1 PLS_INTEGER := 2147483647:
num2 PLS_INTEGER := 1:
sum PLS_NUMBER:
O
Error: Numeric Overflow
BEGIN
Sum := num1 + num2:
END; O
21474836471

Select the correct answer from the qiven choices.

O
2147483646

Need Help? Contact us: +1 (800) 265-6038

91
80471-89190 Mercer mettl
Mettl Online Assessment 2021-2031 Powered By
 1. Section #1 12 13 14 15 16 17 18 19 20 21 Previous Next

Attempted: 0/40

Revisit Later
Question 17 Select an option Q Clear Response

What is the correct output of the given dynamic SQL statement?

CREATE PROCEDURE MathOper
(
O
12.0
x NUMBER.
y NUMBER
z NUMBER )
16.0

BEGIN
DBMS_OUTPUT.PUT_LINE((X + y) * z):
END: O 0.0

DECLARE
a NUMBER := 2:
b NUMBER := 4; O
24.0
pisql_block VARCHAR2(100):
BEGIN
plsql_block:= 'BEGIN MathOper(x, :x
:y); END:':
EXECUTEIMMEDIATE plsql_block USING a, b:
END;
Analyze the listed options and select the correct answer.

Metti Online Assessment 2021-2031 Need Help? Contact us:E +1(800) 265-6038 +91 80471-89190 Povwered By Mercer metti
1.
Secton $1 13 14 15 16 17 18 19 20 21 22 Previous Next

Atternpted: 0/40
Refer to the gven code and compute the bonus for the employee:
DECLARE Select an option Q Cear Response
salary NUMBER := 400
yrperfom3nce NUMSER:=&
yrgrade NUMBER O
160000.0
bonus NUMSER

EEGIN
Fyrperformance = 1 80000.0
O

THEN yrgrde:= 025:

aSF yrperfomance =2
THEN ygrade := 05
ELSF yrperfomance = 3 ONo bonus
THEN yrgrade = 0.75:
ELSE
=
yrgrade
O
53000.0
END F
bonus := salary / yrgrade:
DEMS_OUTPUTPUT_UNE(Eonus for the year =" bonus):

ICEPTION
WHEN ZERO DVIDE THEN
DEMS_OUTPUT.PUT_LINE(No bonus:
yrgrase := NULL
END:
Select the correct answer from the grven choices.

us:
Met Onhne Aosessrert & 2021-2031 Need He'p? Contact 1 (800) 265-6038 91 80471-89190 owerad Dy
Mercer tnett
1. Section #1 14 15 16 17 18 19 20 21 22 23 Previous Next

Attempted: 0/40
What is the new salary of Manisha printed on the output screen? (Note that salary is
represented using the sal attribute) Select an option Q lear Response
CREATE TABLE EMPLOYEE (
KEY.
empld INTEGER PRIMARY
name TEXT NOT NULL
50000
sal INTEGER
comm INTEGER

INSERT INTO EMPLOYEE VALUES (1, 'Ravi, 30000,250):

INSERT INTO EMPLOYEE VALUES (2, 'Manisha',50000,0):
INSERT INTO EMPLOYEE VALUES (3, Alekhya'.60000,NULL);
select from EMPLOYEE:
O
55000
delimiter $S
CREATE PROCEDURE raise(0

BEGIN
UPDATE EMPLOYEE 45000
set sal =
sal+(10/100)"sal
WHERE comm IS NULL OR comm = 0;

ENDSS
delimiter:

call raise0:
select from EMPLOYEE:
Select the correct answer from the given choices.

Metti Onine Assessment 2021-2031 Need Help? Contact us: 1 (800) 265-6038 +91 80471-89190 3Mercer metti
Pcvered 3
1. Section #1 15 16 17 18 19 20 21 22 23 24 Previous Next

Attempted: 0/40

Question 20 Revisit Later

Select an option Q Clear Response

What is the correct output of the given data retrieval code?

CREATE TABLE EMPLOYEE (
O
Name dept
empld INTEGER PRIMARY KEY, Ravi Accounts
name TEXT NOT NULL
dept TEXT NOT NULL

: Name dept
INSERT INTO EMPLOYEE VALUES (1, 'Don', 'Sales');
INSERT INTO EMPLOYEE VALUES (2. 'Ravi, 'Accounts): Don Sales
Ravi Accounts

DELIMITER SS
CREATE PROCEDURE myProcin_id int) O
ID name dept
READS SQL DATA
2 Ravi Accounts
BEGIN
SELECT [Link]
FROM EMPLOYEE
WHERE empld=in_id:
ID name dept
ENDSS 1
Don Sales
DELIMITER:
2 Ravi Accounts

call myProc(2);:
Analyze the given options and select the correct answer.

Metti Onine Assessrrert 2021i-2031 Need Help? Contact us: +1 (800) 265-6038 +91 80471-89190 oweed Mercer metti
 1. Section #1 22
16 17 13 19 20 21 23 24 25 Previous Next

Attempted: 0/40

Question 21 R Revisit Later

O

[Link] package called sf_loop

2
Usually. there are functions that may acidentally include infinite loops instead of finite loops;
BEGIN
1. Which element in pl/sql is used for infinite loops in a function?
loop_killer.kill_after(100)
2 How do you use the above element in pl/sql to define it? LOOP
DBMS_OUTPUT.put ine(loop_killer, sf_loop:
Analyze the given choices and select the correct set of answers.
END LOOP:
END;

1. Using package called end_loop

2.
BEGIN
loop_killer.kill_after100)
LOOP
DBMS_OUTPUT.put_ line( current_count):
END LOOP:
END:

1. Using package called stop_loop

2
BEGIN

etti Groine Assessment & 2021-2021 Need Help? Contact us: 1 (800) 265-6038 91 8047 1-89190 Powered y 3Mercer metti
1. Secthn #1 16 17 18 20 21 21 2 24 25 Previous

Altempted: 0/40
LND;
Question 21 Revisit Later

tsualy, there are tunctons that may accdentally include intunite loops instead of tinite loops:; 1, Using package called stop_loop
1. Whih element n pl/sql is usevd tor intinite loops in a tunction?

2 How do you use the above element in p/sql to detine it? BEGIN
stop_loop.kill_after(100)
Anahe the given choices and select the conect set of answers, LOOP
DBMS_OUTPUT,put line(loop_killer, curretcount):
END LOOP:
END;

O
1. Using package called sf_Joop_killer
2
BEGIN
loop_killer.kill after(100)
LOOP
DBMS_OUTPUT.put line(loop_killer. curret_count):
END LOOP:
END:

ietti Onlne Assessment 2021-2031 Need Help? Contact us: 1 (800) 265-603s +91 8047 1-89 190 Poweract y OMerc
1. Section #1 17 18 19 20 21 22 23 24 25 26 Previous

Attempted: 0/40

Question 22 Revisit Later

Select an option Q Clear Resp

What is the correct output of the listed code? Select the appropriate answer from the given
choices. O Displays one student row

DECLARE
TYPE StuRec IS RECORD (
Displays only the student's name
Stu_id NUMBER(4) NOT NULL:= 1001,
Stu_name VARCHAR2(30) NOT NULL:= John',
Adm id NUMBER(6) := 800,
Addr_id NUMBER(4) := 1565 O
Displays two rows of students

Stu_rec StuRec
BEGIN Displays three rows of students
DBMS_OUTPUT.PUT_LINE(Student_id: I|Stu_rec.Stu_id):
DBMS_OUTPUT.PUT_LINE(Student_name:' || Stu_rec.Stu_name):
DBMS_OUTPUT.PUT_INECAdmission_id: '|| Stu_rec.Adm_id);
DBMS_OUTPUT.PUT_LINEÇAddress_id: | Stu_rec.Addr_id):
END:

Metti Online Assessment 2021-2031 Need Help? Contact us: a+1 (800) 265-6038 +91 80471-89190 Powered By AMereo
1. Section #1 18 19 20 21 22 23 24 25 26 27 Previous Next

Attempted: 0/40

Question 23 A Revisit Later Select an option Q Clear Response

is a student table as shown in the figure. Assume that you have to insert
Consider there a
CREATE TRIGGER St_age_trig
component such that the ages are allautomatically updated with a default value of 19
irrespective of the insert value. Which option from the given choices willperform this task FOR INSERT

appropriately? ON student
COMPOUND TRIGGER

STE SNAME ADORESS AGE GENOER BEFORE EACH ROW IS

addes
a BEGIN

atdes Femae :old_age=19;

20 END BEFORE EACH ROW:

emsl END st_age_trig:

CREATE TRIGGER St_age

ON student
COMPOUND TRIGGER

BEGIN

:[Link]:=19;
END BEFORE EACH ROW:
END St_age_trig

us:
Metti Online Assessment & 2021-2031 Need Help? Contact +1(800) 265-6038 +91 80471-89190 Bowered y Mercer mettl
1. Section #1 18 19 20 21 22 23 24 25 26 27 Previous

Attempted: 0/40

Question 23 D Revisit Later

CREATE TRIGGER st_age_trig FOR INSERT
ON student
Consider there is a student table as shown in the figure, Assume that you have to insert a
component such that the ages are allautomatically updated with a default value of 19
irrespective of the insert value. Which option from the given choices will perform this task
BEGIN
appropriately?
[Link]:=19;
END BEFORE EACH ROW:
STID SNAME ADORESS AGE ENDER
END st_age_trig:
ae
addrs

ddressl Fernale

ddies 20 ae
addrng.i ermal

CREATE TRIGGERst_age_trig

FOR INSERT
ON student
BEFORE EACH ROW IS
BEGIN
:[Link];=19:
END BEFORE EACH ROW:
END

Need Help? Contact us: +1 (800) 265-6038

Mettl Onine Assessment 2021-2031 S 91 80471-89190 Aowered By M
1. Section #1 19 20 21 22 23 24 25 26 27 28 Previous Next

Attempted: 0/40

Question 24 Revisit Later Select an option Q lear Response

What is the appropriate output of the given pl/sql code? Select the correct answer from the
2020 2
choices listed. O 3

Display the number of days per month a user has visited a Web page. 2020 1
2
CREATE TABLE cnt (year YEAR. month INT UNSIGNED,
day INT UNSIGNED):
INSERT INTO nt VALUES(2020,1,1),(2020,1,21).(2020,1,31).(2020,2.3). O
2020 1
1
(2020.2.24).(2020.2.24):
SELECT year,month.BIT_COUNT(BIT_OR(1<<day) AS days FROM cnt 2020 2 2
GROUP BY [Link]:

2020 2 2

2020 3

O
2020 13
2020 22

Metti Orirne Assessrnent 2021-2031 Need Help? Contact us: +1 (800) 265-6038 91 80471-89190 Povered Sy Mercer metti
1. Section #1 20 21 22 23 24 25 26 27 28 29 Previous Next

Attempted:
0/40elect an option 2 Clear Response

Question 25 Revisit Later

100
What is the correct output of the given code? Select the right answer from the given 102
[Link]
104
loopcounter NUMBER := 1:
106
loopresult NUMBER:
108
BEGIN
110
WHILE Ioopcounter <= 10
LOOP
loopresuit := loopcounter + 100:
dbms_outputput_line(loopresult): 100
loopcounter := loopcounter +2: 102
END LOOP:
104
END:
106
108

101
103
105
107
109

Need Help? Contact us: +1 (800) 265-6038 80471-89190

E 91
Metti Onhne Assessmert 2021-2031 Rowered Sy Mercer tmettl
1. Section #1 20 21 22 23 24 25 26 27 28 29 Previous Next

Attempted: 0/40

Question 25 Revisit Later

100
102
104
What is the correct output of the given code? Select the right answer from the given
[Link] 106

loopcounter NUMBER:= 1: 108

loopresut NUMBER
BEGIN
WHILE loopcounter <= 10
101
LOOP
:= 103
ioopresult loopcounter + 100;
dbms_outputput_lineloopresult): 105
107
loopcounter ;= loopcounter +2:
END LOOP: 109

END:

101
103
105
107
109
111

Metti Orine Assessment 2021-2031 Need Help? Contact us: 1 (800) 265-6030 91 30471-89190 Aowered By Mercer metti
1, Section #1 21 22 23 24 26 27 28 29 Previous Next

Attempted: 0/40
Question 26 Revisit Later

Select an option Q Clear Response

What is the correct output of the given code?

create table emp(
id iNI not null. Displays all the columns from emp
ename varchar(30).
city varchar(30)

insert into emp values(1, abc'.'delhi'); Displays no rows from emp

insert into emp values(2.'xyz mumbai'):

insert into emp values(3.'[Link]):
Displays all the rows from emp
delimiter S$
CREATE PROCEDURE myProc (emp_id INT)
BEGIN
DECLARE e_name VARCHAR(30):
Displays two columns from emp
DECLARE emp_id iNT:
DECLARE emp_city VARCHAR(30):
DECLARE emp_count INT:
DECLAREno_more_emp iNT:
DECLARE emp_csr CURSOR FOR
[Link], city
FROM emp:
DECLARE CONTINUE HANDLER FOR NOT FOUND SET no_more_emp=1;
SET no_more_emp=0:
OPEN emp_csr:
Pmn ionnWHII fínn mare emn=)D0
Need Help? Contact us; +1 (800) 265-6038 91 80471-89190
Metti Orine Assessnent 2021-2031 l Povverea By Mercer mettl
1. Section #1 21 22 23 24 25 26 27 28 29 30 Previous Next

btUIN Attempted: 0/40

DECLARE e name VARCHAR(30):
DECLARE emp id INT: Select an option Q lear Response
DECLARE emp_city VARCHAR(30):
DECLARE _emp_count INT;
DECLARE no_more_emp INT; O
Displays all the columns from emp
DECLARE emp_csr CURSOR FOR
SELECT id,ename, city
FROM emp:

DECLARE CONTINUE HANDLER FOR NOT FOUND SET no_more_emp=1; O

Displays no rows from emp
SET no_more_emp=0;
OPEN emp_csr:

emp_loop:WHILE(no_more_emp=0) DO
FETCH emp_csr INTO emp_id.e_name,emp_city,
O
Displays all the rows from emp
IF no_more_emp=1 THEN
LEAVE emp_loop:
END IF:
Displays two columns from emp
SET Lemp_cOunt=l_emp_count+ 1;
select emp_id.e_name,emp_city.
END WHILE emp_loop:

CLOSE emp_csr;

SET no_more_emp=0:
END SS

delimiter:

call myProc(2;
Select the correct answer from the given choices.

Need Help? Contact us:

Metti Online Assessment 2021-2031 E 1(800) 265-6038 91 80471-89190 Posered
By
Mercer me
1. Section #1 22 23 24 25 26 27 28 29 30 31 Previous Next

Attempted: 0/40

Question 27 Revisit Later

Select an option Q Clear Response

The given package accesses the code in C to find out the minimum number using external
procedural calling. What is the missing part of this code? AS LANGUAGE C
CREATE OR REPLACE PACKAGE Find_Min NAME "C_min"
AUTHID User LIBRARY util
AS WITH CONTEXT
PROCEDURE min_proc (x PLS_INTEGER y PLS_INTEGER, z PLS_INTEGER) PARAMETERS(CONTEXT, x INT. y INT, z INT;:
##MISSING CODE
END:
Analyze the given options and select the correct answer.
NAME "C_min"
LIBRARY util
WITH CONTEXT
PARAMETERS(CONTEXT, x INT, y INT, z INT);

AS LANGUAGE C
NAME "C_min
LIBRARY util

AS LANGUAGE C

NAME "C_min

Mettl Online Assessment 2021-2031 Need Help? Contact us: E +1 (800) 265-6038 91 80471-89190 Sy aMercer mett
owered
1. Section #1 22 23 24 25 2€ 27 28 29 30 31 Previous Next

Attempted: 0/40 NAME "C min"

LIBRARY util
Question 27 Revisit Later
WITH CONTEXT
PARAMETERS(CONTEXT, × INT, y INT, z INT):
The given package accesses the code in C to find out the minimum number using external
procedural calling. What is the missing part of this code?
CREATE OR REPLACE PACKAGE FindMin
AUTHID User NAME "C min

AS LIBRARY util
PROCEDURE min_proc (x PLS_INTEGER. y PLS_INTEGER, Z PLS_INTEGER) WITH CONTEXT
##MISSING CODE PARAMETERS(CONTEXT, x INT. y INT, z INT);:
END:
Analyze the given options and select the correct answer.

AS LANGUAGE C
NAME "C_min"
LIBRARY util

AS LANGUAGE C
NAME "C_min"
WITH CONTEXT
PARAMETERS(CONTEXT, x INT, y INT, z INT:

Metti Orine Assessment 2021-2021 Need Help? Contact us: +1 (800) 265-6038 91 80471-89190
cwered 5Mercer mett
1.
SetiN#1 23 24 25 26 27 20 29 30 31 32 Previous Noxt

Attemptet: 0/40

Revisit Later
Question 28 Select an option & lear Response

Refex to the givn cnte

O
(a) 1F-THEN-ELSEIF

(a) Speoty the conditional statement used (b) None of the abOve condition is true.
w
() What be the output? Grade is A
DECLARE

resut nunmber3) := 95
BEGIN
IF (resut = 40) THEN O
(a) IF-THEN-ELSE

dhms_outputput line('Grade is D]: (b) None of the above condtion is true.

ELSF (result = 50) THEN

dbms_outputput lneGrade is C
ELSE (result = 70) THEN
O
(a) F-THEN-ELSEIF
dbms_outputput lineGradeis B):
(b) Grade is A
ELSE

dbms_outputput line(Noneof the above condition is true.):

END IF
dbms_outputput line(Grade is A):
O
(a) IF-THEN-ELSE
END.
(b) None of the above condition is true.
Anayze the gven choices and select the correct set of answers.
Grade is A

Meti Onlne Assessment 2021-2031 Need Help? Contact us: +1 (800) 265-6038 S +91S0471-89 190 Sovered 3y ercer mettl
 1. Section #1 24 25 26 27 28 29 30 31 32 33 Previous Next

Attempled: 0/40

Revisit Later
Question 29 Select an option & Cear Response

What is the proper output of the given pl/sql code? Select the correct answer from the givern
choices. O 1 1

DECLARE
TYPE Ar_Type IS VARRAY(10) OF NUMBER:
v_Num Ar_Type ;= Ar_Type):
BEGIN O 3 2

v_Num.EXTENDI4):

v_Num (1) := 11;

v_Num (2) := 21; O 2 3

v_Num (3):= 31;

v_Num (4) := 41;
O
4 -1
DBMS_OUTPUT.PUT_ LINE(NVL(v_Num.prior (3400).-1):
DBMS_OUTPUT.PUT_LINE(NVL(v_Num.next (3400), -1):
END:
/

Mettl Online Assessnent 2021-2031 Need Help? Contact us: +1 (800) 265-6038 91 80471-89190 Mercer netti
1. Section #1 25 26 27 28 29 30 31 32 33 34 Previous Next

Attempted: 0/40

Question 30 N Revisit Later DECLARE

n number(1):

Which option from the choices listed will give the result as displayed alongside? BEGIN
<< outer_loop >>
count is: 2 FOR n IN 1.3 LOOP

count is: 3 IF n<2 THEN

CONTINUE:
END IF:
dbms_output.put_ line('count is: 'l|n):
Statement processed. END loop outer_loop:
END;

DECLARE
n number(1);

BEGIN
<< outer loop >>
WHILE (n<2)
IF
n<2 THEN
8REAK:
END IF:
dhms [Link] lineCcount islin):
etti Onine Assessent Need Help? Contact us:
91
80471-89190
2021-2031 1 (800) 265-603S POuened y
Mercer metti
1. Section #1 25 26 27 28 29 30 31 32 33 34 Previous Next

Attempted: 0/40
n number(1):
Question 30 D Revisit Later
BEGIN
<< outer_loop >>
Which option from the choices listed will give the result as displayed alongside?
WHILE (n<2)
IF n<2 THEN
count is: 2
BREAK:

count is: 3 END IF ;

dbms_output.put_ line(count is: 'lIn):

END loop outer loop:
END;
Statement. processed.

DECLARE
n number(1):

BEGIN
<< outer_loop >>
DO n IN 1..3 LOOP
WHILE(n<2) THEN
dbms_output.put_line('count is: ||n):
END loop outer_loop:
END;

Metti Online Assessnent 2021-2031 Need Help? Contact us: l +1 (800) 265-6038 +91 80471-89190 Powered By
Mercer metti
1. Section #1 25 26 27 28 29 30 31 32 33 34 Previous Next

Attempted: 0/40 DELLAKE

n number(1);
Revisit Later
Question 30
BEGIN

Which option from the choices listed will give the result as displayed alongside? << outer_loop >>
DO n IN 1..3 LOOP

countis: 2 WHILE(n<2) THEN

dbms_output.put_ line('count is: 'l|n):
count is: 3 END loop outer_loop:
END;

Statement processed.
DECLARE
n number(1):

BEGIN
<< outer_loop >>
FOR n IN 1..3 LOOP
IF n<2 THEN
EXIT;
END IF :

dbms_output.put_line('count is: '|n):

END loop outer_loop:
END;

Mettl Onlne Assessnent 2021-2031 Need Help? Contact us; +1 (800) 265-6038 +91 80471-99190 meitu
Powered By 3Mercer
1. Section #1 26 27 28 29 30 31 32 33 34 35 Previous Next

Attempted: 0/40

Question 31 D Revisit Later

Select an option Q Clear Response

Which code from the given options shows the results as indicated in the figure alongside for
the listed table? DECLARE
temp varchar(20):

BEGIN
SELECT stid into temp from student where sname='E:

exception
Analyze the given choices and select the correct option.
WHEN no_data_found THEN
dbms_output.put_line(ERROR):
end;

DECLARE
temp varchar(20):

BEGIN

SELECT Stid into temp from student where sname=E:

exception
WHEN TO0_MANY_ROWS THEN
dbms_output.put_ line('ERROR):

Need Help? Contact us: 1(800) 265-6038 91 80471-89190 Powered By Mercer netti
Mettl Online Assessment 2021-2031
1.
Section #1 2€ 27 2 29 30 31 32 33 34 35 Previous Next

Attempted: 0/40

Question 31 Revisit Later

DECLARE
temp varchar(20):
Which code from the given options shows the results as indicated in the fiqure alongside for
the listed table?
BEGIN
AXESS
SELECT stid into temp from student where sname=E:

exception
WHEN TOO MANY_ROWS THEN
dbms_output.put line(ERROR):
Analyze the given choices and select the correct option. end: Next

DECLARE
temp varchar(20):

BEGIN
SELECT stid into temp from student where sname=E:

exception
WHEN VALUE _ERROR THEN

dbms_output.put_ line(ERROR):
end:

Metti Onine Assessmerit G 2021-2031 Need Help? Contact us: +1 (800) 265-6038 91 30471-89 190
Poerec Sy Mercer metti
1. Secton #1 27
28
29 30 31 32 33 34 35 36 Previous Next

Attempted: 0/40

Consider the below block to get the output as Inside local_proc version2, p_par value:- TEST Select an option Q Clear Response

Choose the correct option to fill in the missing blank line.

P_par in varchar2
DECLARE

procedure local _procp_par in number)

( p_par in number
begin

dbms_output.put_ line(lnside local_proc version1, p_par value:- "llp_par):

P_par in integer
end:

procedure local_proc(
p_par in boolean

begin

dbms_outputput_line('Inside local_proc version2. P_par value:- "lp_par):

end:
begin

local_proc(TEST);
end:

thetti Online Assessnent G 2021-2031 Need Help? Contact us: 1 (800) 265-6038 C91 30471-89190
3Mercer tnetti
1. Section #1 28 29 30 31 32 33 34 35 36 37 Previous Next

Attempted: 0/40

Question 33 Revisit Later

CURSORc_emp IS

select *
*

Which of the given CURSOR Codes locks the rows of the active set of the cursor?
from emp
lock:

CURSORc_emp lS
select *
from emp
for each row:

CURSORc_emp lS
select*
from emp:

CURSOR c,emp IS
select *
from emp
for update:

Metti Online Assessment 2021-2031 Need Help? Contact us: +1 (800) 265-6038 91 80471-g9190 Powered By Mercer mettl
1. Section #1 Previous
29 30 31 32 33 34 35 36 37 38 Next

Attempted: 0/40

Question 34 Revisit Later

Select an option Q Clear Response

Fill in the blank of the given code DECLARE math PLS INTEGER:
MATH_ERROR
O

BEGIN
math := 100/0:
EXCEPTION
WHEN THEN O
ZERO_DIVIDE
DBMS_OUTPUT.PUT_LINE (Divide by zero is not allowed');
END:

Select the correct answer from the choices listed O

UNKNOW_ERROR

O
DIVIDE_BY_ZERo

Mett! Gnine Assessment 2021-2031 Need Help? Contact us: +1 (800) 265-6038 +91 80471-89190 Powerec Mercer petti
1. Section #1 30 31 32 33 34 35 36 37 38 39 Previous

Attempted: 0/40

What will be the output of the final PL/SQL block at the end after the scripts are executed Select an option Cear Resp
sequentially?

CREATE OR REPLACE PACKAGE my_pkg 1 O 100

as 100
var_1 NUMBER:=0;

END:
100
CREATE OR REPLACE PACKAGE mypkg2 NULL
as
PRAGMA SERIALLY REUSEABLE:
var_2 NUMBER:=0;
100
END:

BEGIN
my_pkg1.var_1:=100:
my.pkg2,var 2:=100:
END;

BEGIN
dbms_output.put_line(my_pkg1.var_1):
dbms_output.put_line{my_pkg2.var_2):
END;

Mettl Online Assessnent us:

2021-2031 Need Help? Contact a+1 (800) 265-6038 91
80471-89190 [Link] By Me
1. Section #1 31 32 33 34 35 36 37 38 39 40 Previous Next

Attempted: 0/40

Question 36 Revisit Later

Select an option Q Clear Response

Inthe given SQL statement, what is the output of the final select statement (SELECT FROM
Emplog?) O
No Data returned
CREATE TABLE Employee
(Empid NUMBER(10) NOT NULL
EmpName VARCHAR2(50) NOT NULL. )

Returns 1 row from Employee table

Salary NUMBER(10) NOT NULL
Dept NUMBER(3) NOT NULL
:
INSERT INTO Employee VALUES(1. Meenu',30000, 10):
Deletes 1 row from EmpLog table
INSERT INTO Employee VALUES(2.'ANIKA:45000, 10):
INSERT INTO Employee VALUES(3,JEFF.67500. 40):
COMMIT:

( Displays 2 rows from EmpLog table

CREATE TABLE Emplog
((Empid NUMBER(10) NOT NULL
IEmpName VARCHAR2(50) NOT NULL
IDept NUMBER(3) NOT NULL
):
CREATE OR REPLACE TRIGGER UtrigEmpLog
BEFORE DELETE ON Employee
FOR EACH ROW
BEGIN
INSERT INTO Emplog VALUES([Link]. [Link]. :[Link]:
FND:

Mettt Online Assessment 2021-2031 Need Help? Contact s: 9Nl1 (800) 265-5038 91 80471-89190 Pcvered By Mercer metii
1. Section #1 31 32 33 34 35 36 37 38 39 40 Previous Next

(tmpi NUMDEKIU) IVUI IVULL, Attempted: 0/40

EmpName VARCHAR2(50) NOT NULL
Salary NUMBER(10) NOT NULL Select an option Clear Response

Dept NUMBER(3) NOT NULL

):
INSERT INTO Employee VALUES(1, Meenu',30000, 10): O
No Data returned
INSERT INTO Employee VALUES(2.'ANIKA,45000, 10);
INSERT INTO Employee VALUES(3,JEFF,67500, 40):
COMMIT:
O
Returns 1 row from Employee table
CREATE TABLE Emplog
(Empid NUMBER(10) NOT NULL
IEmpName VARCHAR2(50) NOT NULL,
IDept NUMBER(3) NOT NULL
O
Deletes 1 row from EmpLog table
):
CREATE OR REPLACE TRIGGER UtrigEmpLog
BEFORE DELETE ON Employee
FOR EACH ROW
O
Displays 2 rows from EmpLog table
BEGIN
INSERT INTO Emplog VALUES(:[Link], :[Link], :[Link]);
END;

DELETE FROM Employee

WHERE dept = 10;
COMMIT:
SELECT * FROM EmpLog:"

Select the correct answer from the choices listed.

Metti Online Assessment 2021-2031 Need Help? Contact us: l +1 (800) 265-6038 +91 80471-89190
Rowered Sy Mercer mettl
1, Section #1 31 32 33 34 35 36 37 38 39 40 Previous Nezt

Attempted: 0/40
Question 37 Revisit Later

Sclect an option Q Clear Respoe

What willbe the output of the fnal PL/SQL block at the end after the scripts are cxecuted
sequentially?
O 100
CREATE OR REPLACE PACKAGE test_package_v1 100

var_1 NUMBER :=0:

END: O
100
NULL
CREATE OR REPLACE PACKAGE test_package_v2

var_2 NUMBER :=0;

100
END;

BEGIN
test_package_v1.var_1:=100;
test.package_v2.var_2:=100:
END:

BEGIN
dbms_output.put_Ine(test_package_v1.var_1);
dbms_output.put_line(test_package_v2.var_2):
END:

Mettl Ornline Assessment 2021-2031 Need Help? Contact us: l 1

(200) 265-6038 9180471-89190 3Mercer netii
1.
Section #1 31 32 33 34 35 36 37 38 39 40 Previous

Attempted: 0/40
CURSORc_emp IS
Question 38 W Revisit Later *
select
from emp
Which of the given codes can be used in the WHERE CURRENT OF clause? lock:

O
CURSOR C
empIS
select *

from emp
for each row:

CURSORC_emp IS

select *
from emp:

O
CURSOR C_emp IS
select *
from emp
for update:

Mettl Online Assessment 2021-2031 Need Help? Contact us: +1 (800) 265-6038 91 80471-89190 Povered By Merce
1. Section #1 31 32 33 34 35 36 37 38 40 Previous

Attempted: 0/40

Question 39 Revisit Later Select an option Q lear Respon

The table Employee has 10 rows. The following update trigger is associated with the table.
O 2
create or replace trigger MyTrigger
before update
on Employee
begin
DBMS_OUTPUT.PUT_LINE(Trigger Fired Before Update'):
end:

O 10

We run the below code to update the data of the table.

Update Employee Set salary = 5000 Where Employee_ d = 1000:
1

There is no record in the table with employee_ id = 1000. The output of the above code is: 0
Rows updated.

How many times is the trigger fired?

Metti Online Assessment 2021-2031 Need Help? Contact us: 1(800) 265-6038 91 80471-89190 Powerea By Merce
1. Section #1 31 32 33 34 35 36 37 38 39 40 Previous

Attempted: 0/40

Question 40 Revisit Later

create or replace
FUNCTION welcomeRETURN VARCHAR2 AS
Which option from the listed choices indicates the correct code that calls the given code and
LANGUAGE JAVA NAME [Link] 0 return [Link]'
prints the output as "Hi Welcome ALL".
public class Welcome
Declare
public static String greet) my_string varchar2(200 char);:
begin
return "Welcome ALL": my_string:=welcome0:
dbms_output.put_line('Hi"|| my_string):
end:

O
create or replace
FUNCTION welcome RETURN VARCHAR2 AS
LANGUAGE JAVA NAME [Link] 0 return [Link]':

Declare
my_string varchar2(200 char):
begin
dbms_output.put_line(my_string):
end:

Mett! Onine Assessment 2021-2031 Need Help? Contact us: +1 (800) 265-6038 +91 80471-89190 Powered By Mercer nettl
 1. Section #1 31 32 33 34 35 36 37 38 39 40 Previous

Attempted: 0/40

Question 40 Revisit Later

create or replace
FUNCTION welcome RETURN VARCHAR2 AS
Which option from the listed choices indicates the correct code that calls the given code and
prints the output as "Hi Welcome ALL".
LANGUAGE JAVA NAME [Link] 0:
public class Welcome
Declare
public static String greet) my_string varchar2(400 char):
begin
return "Welcome ALL"; my_string:=welcome0:
dbms_output.put line(my
string):
end:

create or replace
FÜNCTION welcome RETURN VARCHAR2 AS
LANGUAGE JAVA NAME
return [Link]':
Declare
mý _string varchar2(400 char):
begin

my_string:=welcome0:
dbms output.put_ line(Hi'|| my_string):
end:

Mettl Online Assessment 2021-2031 Need Help? Contact us: +1(800) 265-6038 +91 80471-89190
Powered B
SMercer mettl