. TCO 1 - ____ is a basic tool available with the Oracle server that allows a us

Question

. TCO 1 - ____ is a basic tool available with the Oracle server that allows a user to enter SQL and PL/SQL directly to the database server for processing. (Points : 4)        OTN
       Procedure Builder
       SQL*Plus
       TOAD Question 2.2. TCO 1 - Which of the following code fragments contains a host variable? (Points : 4)        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 3.3. TCO 1 - All of the following are components of the application model, except ____. (Points : 4)        Screens
       Programming logic
       Database
       Programming language Question 4.4. TCO 2 - Which of the following is a mechanism to trap an error that occurs in processing? (Points : 4)        EXCEPTION
       UPDATE
       Exception handler
       GOTO Question 5.5. TCO 2 - Which of the following returns the Oracle error number? (Points : 4)        TOO_MANY_ROWS
       WHEN OTHERS
       SQLERRM
       SQLCODE Question 6.6. TCO 2 - Which of the following refers to an attempted violation of a unique or primary key column constraint? (Points : 4)        NO_DATA_FOUND
       TOO_MANY_ROWS
       DUP_VAL_ON_INDEX
       CASE_NOT_FOUND Question 7.7. TCO 3 - A(n) ____ trigger fires whenever the event occurs, regardless of the schema in which it occurs. (Points : 4)        row level
       system level
       Instead-Of
       database level Question 8.8. TCO 3 - The CREATE TRIGGER statement includes an optional ____ clause that can check a condition to determine if the trigger should be executed. (Points : 4)        WHEN
       WHERE
       FROM
       UPDATE Question 9.9. TCO 3 - Row level options are only applicable for ____ events. (Points : 4)        CREATE
       INSERT
       DECLARE
       UPDATE and DELETE . TCO 1 - ____ is a basic tool available with the Oracle server that allows a user to enter SQL and PL/SQL directly to the database server for processing. (Points : 4)        OTN
       Procedure Builder
       SQL*Plus
       TOAD

Explanation / Answer

1)  SQL*Plus

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

3) Screens

4)EXCEPTION

5) TOO_MANY_ROWS

6) CASE_NOT_FOUND

7) Instead-Of

8) WHEN

9)UPDATE and DELETE

Related Questions

Navigate

• Browse (All)
• Browse #
• Subjects

---

---

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