Question 1. 1. TCO 7 - Which of the following is an acceptable error number for

Question

Question 1.1. TCO 7 - Which of the following is an acceptable error number for the RAISE_APPLICATION_ERROR function? (Points : 1)        -21,000
       -20,002
       -19,000
       -18,000 Question 2.2. TCO 7 - A(n) ____ is used to accomplish one or more tasks, return none or many values, and can be used only in PL/SQL statements. (Points : 1)        application
       function
       procedure
       database trigger Question 3.3. TCO 7 - To reference a host variable in PL/SQL, a preceding ____ must be used with the host variable name. (Points : 1)        colon
       :=
       =>
       semicolon Question 4.4. TCO 7 - The term ____ refers to program code that resides on the user machine. (Points : 1)        client-side
       client/server
       two-tier
       server-side Question 5.5. TCO 5 - Which of the following is identified with a set of acronyms that indicate the restrictions on using the function? (Points : 1)        Compiler hint
       Purity level
       Pass by reference
       Pass by value Question 6.6. TCO 5 - Functions used in SQL statements must meet all of the following requirements, except ____. (Points : 1)        Must be a stored database object
       Can use only OUT parameters
       Return data types must be a database data type
       Cannot issue ALTER SESSION or ALTER SYSTEM commands Question 7.7. TCO 5 - All of the following are purity level acronyms, except ____. (Points : 1)        WNPS
       RINDS
       WNPS
       RNPS Question 8.8. TCO 5 - Which of the following statements is true? (Points : 1)        A function is part of an expression.
       A function can serve as an entire statement.
       A procedure cannot serve as an entire statement.
       A procedure is part of an expression. Question 1.1. TCO 7 - Which of the following is an acceptable error number for the RAISE_APPLICATION_ERROR function? (Points : 1)        -21,000
       -20,002
       -19,000
       -18,000

Explanation / Answer

my answer is 1)C 2)C 3)A 4)D 5)C 6)B 7)B 8)A

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

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