Semester 2 Final Exam

Semester 2 Final Exam

A row trigger has been created which is fired by UPDATE ON employees. A user now executes a single SQL statement which updates four rows of the EMPLOYEES table. How many times will the row trigger fire?

                                                                               

                                               

                One time

                                               

                Two times

Semester 2 Midterm Exam

Semester 2 Midterm Exam

How would you invoke the constant km_to_mile from the global_consts bodiless package at VARIABLE A?

SELECT trail_name, distance_in_km * VARIABLE A

FROM trails

WHERE park_name = 'YOSEMITE';

                                                                               

                                               

                global_consts (km_to_mile)

                                               

                km_to_mile.global_consts

                                               

                km_to_mile (global_consts)

Answer Section 15 Quiz Database Programming with PL/SQL 2019 Learner - English

Section 15

The two statements below are equivalent. True or False?

DBMS_WARNING.ADD_WARNING_SETTING_CAT

    ('INFORMATIONAL','ENABLE','SESSION');

and

ALTER SESSION

    SET PLSQL_WARNINGS = 'ENABLE:INFORMATIONAL';                                                                

                                               

                True (*)

                                               

                False

Answer Section 14 Quiz Database Programming with PL/SQL 2019 Learner - English

Section 14

A change in a remote referenced subprogram is automatically recorded as invalid if its base object changes and that new status is relayed to the dependent object's status and automatically marked as invalid. True or False?    

                                                                               

                                               

                True

Answer Section 13 Quiz Database Programming with PL/SQL 2019 Learner - English

Section 13

There are 3 employees in department 90 and 5 employees in department 50. The following trigger has been created:

CREATE TRIGGER upd_emp_trigg

AFTER UPDATE ON employees

FOR EACH ROW

BEGIN

...

Answer Section 12 Quiz Database Programming with PL/SQL 2019 Learner - English

Section 12

The following procedure adds a column of datatype DATE to the EMPLOYEES table. The name of the new column is passed to the procedure as a parameter.

CREATE OR REPLACE PROCEDURE addcol

    (p_col_name IN VARCHAR2) IS

    v_first_string VARCHAR2(100) := 'ALTER TABLE EMPLOYEES ADD (';

    v_second_string VARCHAR2(6) := ' DATE)';

BEGIN

    ... Line A

END;

Answer Section 11 Quiz Database Programming with PL/SQL 2019 Learner - English

Section 11

The DBMS_OUTPUT.PUT procedure places text in a buffer but does not display the contents of the buffer. True or False?  

                                                                               

                                               

                True (*)

                                               

                False

  

Answer Section 10 Quiz Database Programming with PL/SQL 2019 Learner - English

Section 10

Which two of these declarations cannot be in the same package specification?

PROCEDURE myproc (p1 NUMBER, p2 VARCHAR2);

PROCEDURE myproc (p1 VARCHAR2, p2 NUMBER);

Semester 1 Final Exam

Semester 1 Final Exam

Consider the following code:

DECLARE

 TYPE dept_info_type IS RECORD

  (department_id departments.department_id%TYPE,

  department_name departments.department_name%TYPE);

 TYPE emp_dept_type IS RECORD

Answer Section 9 Quiz Database Programming with PL/SQL 2019 Learner - English

Section 9

Which of the following is found in a function and not a procedure?  

                                                                               

                                               

                Return statement in the header (*)

                                               

                An exception section

Answer Section 8 Quiz Database Programming with PL/SQL 2019 Learner - English

Section 8

When creating a procedure, where in the code must the parameters be listed? 

                                               

                After the keyword IS or AS

   

Answer Section 7 Quiz Database Programming with PL/SQL 2019 Learner - English

Section 7

While a PL/SQL block is executing, more than one exception can occur at the same time. True or False? 

                                                                               

                                               

                TRUE

Answer Section 6 Quiz Database Programming with PL/SQL 2019 Learner - English

Section 6

Which of the following successfully declares an INDEX BY table of records which could be used to store copies of complete rows from the departments table? 

                                                                               

                                               

                DECLARE

    TYPE t_depttab IS INDEX BY TABLE OF departments%ROWTYPE

    INDEX BY BINARY_INTEGER;

  

Answer Section 5 Quiz Database Programming with PL/SQL 2019 Learner - English

Section 5

Which of the following cursor attributes is set to the total number of rows returned so far?  

                                                                               

                                               

                %NOTFOUND

                                               

                %FOUND

Semester 1 Midterm Exam

Semester 1 Midterm Exam

Which of the following can be done using PL/SQL?

                                                                               

                                               

                Manage database security

                                               

                All of these can be done (*)

                                               

                Develop Web applications using the Web Application Toolkit

Answer Section 4 Quiz Database Programming with PL/SQL 2019 Learner - English

Section 4

Examine the following code::

DECLARE

   v_count NUMBER := 0;

   v_string VARCHAR2(20);

BEGIN

   LOOP

     v_string := v_string || 'x';

     IF LENGTH(v_string) > 10 THEN

Answer Section 3 Quiz Database Programming with PL/SQL 2019 Learner - English

Section 3

Which SQL statements can be used directly in a PL/SQL block? (Choose two.)

                                               

                SELECT * INTO ... (*)

                                               

                ALTER TABLE employees ...

                                               

                REVOKE SELECT ON ...

Answer Section 2 Quiz Database Programming with PL/SQL 2019 Learner - English

Section 2

Code is easier to read if you declare one identifier per line. True or False? 

                                               

                True (*)

                                               

                False

Answer Section 1 Quiz Database Programming with PL/SQL 2019 Learner - English

Section 1

Which sections of a PL/SQL block are optional?  

                                                                               

                                               

                Exception only