PL/SQL Section 11 Quiz

 1. Which of the following exceptions can be raised ONLY when using the UTL_FILE package? (Choose two.)


(1) Point
2. The UTL_FILE package can be used to read and write binary files such as JPEGs as well as text files. True or False?

(1) Point
3. The DBMS_OUTPUT gives programmers an easy-to-use interface to see, for instance, the current value of a loop counter, or whether or not a program reaches a particular branch of an IF statement. (True or False?)

(1) Point
4. Which DBMS_OUTPUT package subprogram places text into the buffer at Line 1? (Choose one)

  IF v_bool1 AND NOT v_bool2 AND v_number < 25 THEN
    --Line 1
  ELSE
    ...
  END IF;
  DBMS_OUTPUT.NEW_LINE;

(1) Point
5. The UTL_FILE package contains several exceptions exclusively used in this package. Which are they? (Choose 3)

(1) Point

1. Using the FOPEN function, you can do which actions with the UTL_FILE package? (Choose 2)


(1) Point
2. Which general exceptions may be handled by the UTL_FILE package? (Choose 2)

(1) Point
3. The UTL_FILE package can be used to read and write binary files such as JPEGs as well as text files. True or False?

(1) Point
4. What will be displayed when the following code is executed?

BEGIN
    DBMS_OUTPUT.PUT('I do like');
    DBMS_OUTPUT.PUT_LINE('to be');
    DBMS_OUTPUT.PUT('beside the seaside');
END;


(1) Point
5. The DBMS_OUTPUT gives programmers an easy-to-use interface to see, for instance, the current value of a loop counter, or whether or not a program reaches a particular branch of an IF statement. (True or False?)

(1) Point
11. A package's state is initialized when the package is first loaded. True or False?

(1) Point
12. In the following example, which statement best fits in Line 1? (Choose 1)

DECLARE
 v_more_rows_exist BOOLEAN := TRUE;
BEGIN
 -- Line 1
 LOOP
   v_more_rows_exist := curs_pkg.fetch_n_rows(3);
  DBMS_OUTPUT.PUT_LINE('-------');
   EXIT WHEN NOT v_more_rows_exist;
 END LOOP;
 curs_pkg.close_curs;
END;


(1) Point
13. Users A and B call the same procedure in a package to initialize a global variable my_pkg.g_var. What will be the value of my_pkg.g_var for User A at Point A?

User A: my_pkg.g_var is 10
User B: my_pkg.g_var is 10
User A: my_pkg.g_var is 50
User B: my_pkg.g_var is 25
Point A


(1) Point
14. A cursor's state is defined only by whether it is open or closed and, if open, how many rows it holds. True or False?

(1) Point

15. Package CURSPACK declares a global cursor in the package specification. The package contains three public procedures: OPENPROC opens the cursor; FETCHPROC fetches 5 rows from the cursor's active set; CLOSEPROC closes the cursor.

What will happen when a user session executes the following commands in the order shown?
    curspack.openproc; -- line 1
    curspack.fetchproc; -- line 2
    curspack.fetchproc; -- line 3
    curspack.openproc; -- line 4
    curspack.fetchproc; -- line 5
    curspack.closeproc; -- line 6


(1) Point

1. The UTL_FILE package can be used to create binary files such as JPEGs as well as text files. True or False?


(1) Point
2. What will be displayed when the following code is executed?

BEGIN
    DBMS_OUTPUT.PUT('I do like');
    DBMS_OUTPUT.PUT_LINE('to be');
    DBMS_OUTPUT.PUT('beside the seaside');
END;


(1) Point
3. The UTL_FILE package contains several exceptions exclusively used in this package. Which are they? (Choose 3)

(1) Point
4. The DBMS_OUTPUT package is useful for which of the following activities? (Choose two)

(1) Point
5. The SEND procedure is for sending messages without attachments. True or False?

(1) Point

1. DBMS_OUTPUT.PUT_LINE can be invoked from inside a private packaged function. True or False?


(1) Point
2. Which of the following exceptions can be raised ONLY when using the UTL_FILE package? (Choose two.)

(1) Point
3. The UTL_FILE package contains several exceptions exclusively used in this package. Which are they? (Choose 3)

(1) Point
4. Which DBMS_OUTPUT package subprogram places text into the buffer at Line 1? (Choose one)

  IF v_bool1 AND NOT v_bool2 AND v_number < 25 THEN
    --Line 1
  ELSE
    ...
  END IF;
  DBMS_OUTPUT.NEW_LINE;

(1) Point
5. The UTL_FILE package can be used to read and write binary files such as JPEGs as well as text files. True or False?

(1) Point

Komentar

Posting Komentar

Postingan populer dari blog ini

PL/SQL Section 15 Quiz

  1.  You can define variables and assign values to them using PLSQL_CCFLAGS. Then test the values of the variables using inquiry directives. True or False? Tandai untuk Ditinjau (1)  Point True  (*) False Correct 2.  How would you determine the current Oracle database version? Tandai untuk Ditinjau (1)  Point DBMS_DB_VERSION.VERSION  (*) DBMS_DB_VERSION.RELEASE DBMS_DB_VERSION.VER_LE_11 DBMS_DB_VERSION.VER_LE_10 Correct 3.  Identify the selection directives used in conditional compilation. Tandai untuk Ditinjau (1)  Point $$IF $$THEN $$ELSE $$ELSIF $$END $IF $THEN $ELSE $ELSIF $END (*) $IF $THEN $ELSE $END $CCFLAG $IF $THEN $ELSE $ELSIF $ENDIF $$IF $$THEN $$ELSE $$END $$DEBUG Incorrect. Refer to Section 15 Lesson 3. 4.  Conditional compilation allows you to include extra code to help with debugging, which can be removed once errors are resolved. True or False? Tandai untuk Ditinjau (1)  Point True  (*) False Correct 5.  O...
Baca selengkapnya

PL/SQL Section 13 Quiz

1.  Which command would you use to see if your triggers are enabled or disabled? Tandai untuk Ditinjau (1)  Point SELECT trigger_name, status FROM USER_TRIGGERS;  (*) SELECT trigger_name, trigger_type FROM USER_TRIGGERS; SELECT object_name, status FROM USER_OBJECTS WHERE object_type = 'TRIGGER'; DESCRIBE TRIGGER Incorrect. Refer to Section 13 Lesson 5. 2.  After the following SQL statement is executed, all the triggers on the DEPARTMENTS table will no longer fire, but will remain in the database. True or False? ALTER TABLE departments DISABLE ALL TRIGGERS; Tandai untuk Ditinjau (1)  Point True  (*) False Correct 3.  A user creates the following trigger: CREATE OR REPLACE TRIGGER emp_trigg AFTER DELETE ON employees BEGIN     ... END; The user now tries to drop the EMPLOYEES table. What happens? Tandai untuk Ditinjau (1)  Point Both the table and the trigger are dropped.  (*) The table is dropped and the trigger is disabled. The ...
Baca selengkapnya

PL/SQL Section 14 Quiz

1.  Which of the following statements will show whether procedure myproc is valid or invalid? Tandai untuk Ditinjau (1)  Point SELECT * FROM deptree; SELECT status FROM USER_PROCEDURES WHERE procedure_name = 'MYPROC'; SELECT status FROM USER_OBJECTS WHERE object_type = 'PROCEDURE' AND object_name = 'MYPROC';  (*) SELECT valid FROM USER_OBJECTS WHERE object_type = 'PROCEDURE' AND object_name = 'MYPROC'; Incorrect. Refer to Section 14 Lesson 1. 2.  A single procedure can be both a referenced object and a dependent object. True or False? Tandai untuk Ditinjau (1)  Point True  (*) False Correct 3.  A single PL/SQL subprogram such as a procedure can be both a referenced object and a dependent object. True or False? Tandai untuk Ditinjau (1)  Point True  (*) False Correct 4.  View dept_view is based on a select from table departments. Procedure show_dept contains code which selects from dept_view. Which of the following statements are true? (C...
Baca selengkapnya