Question 1. 1. TCO 1 - The ____ allows the construction and compilation of progr

Question

Question 1.1. TCO 1 - The ____ allows the construction and compilation of program units that will test the syntax of PL/SQL program units. (Points : 1)        SQL Editor
       Procedure Builder Editor
       PL/SQL Editor
       SQL Programmer Question 2.2. TCO 1 - The ____ section of a PL/SQL block contains code that creates variables, cursors, and types. (Points : 1)        DECLARE
       BEGIN
       EXCEPTION
       END Question 3.3. TCO 1 - Which of the following typically returns only one value? (Points : 1)        Procedure
       Function
       Database trigger
       Package Question 4.4. TCO 1 - Which of the following code fragments contains a host variable? (Points : 1)        WHERE customer = shopper
AND orderplaced = 0;
       WHERE customer := shopper
AND orderplaced = 0;
       WHERE customer = :shopper
AND orderplaced = 0;
       WHERE customer := ;shopper
AND orderplaced = 0; Question 5.5. TCO 1 - The only required sections of a PL/SQL block are the ____ sections. (Points : 1)        BEGIN & DECLARE
       DECLARE & EXCEPTION
       BEGIN & END
       EXCEPTION & END Question 6.6. TCO 1 - FOR i IN 1..tbl_roast.COUNT LOOP
lv_tot_num := lv_tot_num + tbl_roast(i);
END LOOP;
In the above code fragment, which of the following holds the value of the current iteration number? (Points : 1)        tbl_roast
       i
       COUNT
       lv_tot_num Question 7.7. TCO 1 - Which of the following statements about the three-tier application model is true? (Points : 1)        Application code is loaded onto the client machine.
       Application code is not loaded onto the client machine.
       All the application code resides on a database server.
       All the application code is stored in a package. Question 8.8. TCO 1 - Which of the following statements is unique to the three-tier application model? (Points : 1)        It is referred to as a client/server application.
       In this model, an executable program or application is loaded onto the user's computer that contains the user screens and some programming logic.
       Application code resides on the application server.
       Processing can take place on the client-side. Question 1.1. TCO 1 - The ____ allows the construction and compilation of program units that will test the syntax of PL/SQL program units. (Points : 1)        SQL Editor
       Procedure Builder Editor
       PL/SQL Editor
       SQL Programmer

Explanation / Answer

1) PL/SQL Editor

2)      BEGIN

3)    Function

4) WHERE customer := ;shopper
AND orderplaced = 0;

5) DECLARE & EXCEPTION

6)    tbl_roast

7)   Application code is not loaded onto the client machine.

8)   In this model, an executable program or application is loaded onto the user's computer that contains the user screens and some programming logic.

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.