PL/SQL Section 6 Quiz

 

Section 6

(Jawab semua pertanyaan di bagian ini)
1. 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
  (first_name employees.first_name%TYPE,
  last_name employees.last_name%TYPE),
  dept_info dept_info_type);

 v_dept_info_rec dept_info_type;
 v_emp_dept_rec emp_dept_type;

How many fields can be addressed in v_dept_info_rec?


(1) Point
2. The following code declares a PL/SQL record with the same structure as a row of the departments table. True or False?

DECLARE
    v_dept_rec departments%ROWTYPE;
...


(1) Point
3. You can use %ROWTYPE with tables and views.

(1) Point
4. You can store a whole record in a single variable using %ROWTYPE or by creating your own record structure as a type and then declaring a variable of that type.

(1) Point
5. Which of the following will successfully create a record type containing two fields, and a record variable of that type?

(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