Question 1. 1. TCO 4 - Which of the following actions used in an explicit cursor

Question

Question 1.1. TCO 4 - Which of the following actions used in an explicit cursor processes the query and creates an active set of rows available in the cursor?(Points : 1)        DECLARE
       OPEN
       FETCH
       CLOSE Question 2.2. TCO 4 - Which of the following code fragments correctly uses a record variable to hold the row of data queried for a shopper? (Points : 1)        DECLARE
rec_shopper bb_shopper%ROWTYPE;
BEGIN
SELECT*
INTO rec_shopper
FROM bb_shopper
WHERE idshopper = :g_shopper;
DBMS_OUTPUT.PUT_LINE(rec_shopper.lastname);
DBMS_OUTPUT.PUT_LINE(rec_shopper.address);
DBMS_OUTPUT.PUT_LINE(rec_shopper.email);
END;
       DECLARE
rec_shopper bb_shopper%ROW;
BEGIN
SELECT*
INTO rec_shopper
FROM bb_shopper
WHERE idshopper = :g_shopper;
DBMS_OUTPUT.PUT_LINE(rec_shopper.lastname);
DBMS_OUTPUT.PUT_LINE(rec_shopper.address);
DBMS_OUTPUT.PUT_LINE(rec_shopper.email);
END;
       DECLARE
rec_shopper bb_shopper%TYPE;
BEGIN
SELECT*
INTO rec_shopper
FROM bb_shopper
WHERE idshopper = :g_shopper;
DBMS_OUTPUT.PUT_LINE(rec_shopper.lastname);
DBMS_OUTPUT.PUT_LINE(rec_shopper.address);
DBMS_OUTPUT.PUT_LINE(rec_shopper.email);
END;
       DECLARE
rec_shopper bb_shopperROWTYPE;
BEGIN
SELECT*
INTO rec_shopper
FROM bb_shopper;
WHERE idshopper = :g_shopper;
END; Question 3.3. TCO 4 - Which of the following clauses ensures that only rows meeting a specific criteria are retrieved? (Points : 1)        INTO
       SELECT
       WHERE
       DECLARE Question 4.4. TCO 4 - A(n) _____ represents a work area or section of memory in which an SQL statement is being processed in the Oracle server. (Points : 1)        collection
       variable
       cursor
       nested table Question 5.5. TCO 2 - Which of the following refers to a SELECT statement in a PL/SQL block that retrieves more than one row? (Points : 1)        NO_DATA_FOUND
       ZERO_DIVIDE
       CASE_NOT_FOUND
       TOO_MANY_ROWS Question 6.6. TCO 2 - Which of the following returns the Oracle error number? (Points : 1)        TOO_MANY_ROWS
       WHEN OTHERS
       SQLERRM
       SQLCODE Question 7.7. TCO 2 - The _____ section of a PL/SQL block addresses two situations: Either an Oracle error is raised, or a user-defined error is raised. (Points : 1)        DECLARE
       BEGIN
       EXCEPTION
       UPDATE Question 8.8. TCO 2 - Which of the following is a mechanism to trap an error that occurs in processing? (Points : 1)        EXCEPTION
       UPDATE
       Exception handler
       GOTO Question 1.1. TCO 4 - Which of the following actions used in an explicit cursor processes the query and creates an active set of rows available in the cursor?(Points : 1)        DECLARE
       OPEN
       FETCH
       CLOSE

Explanation / Answer

1. OPEN
2. DECLARE
rec_shopper bb_shopper%ROWTYPE;
BEGIN
SELECT*
INTO rec_shopper
FROM bb_shopper
WHERE idshopper = :g_shopper;
DBMS_OUTPUT.PUT_LINE(rec_shopper.lastname);
DBMS_OUTPUT.PUT_LINE(rec_shopper.address);
DBMS_OUTPUT.PUT_LINE(rec_shopper.email);
END;

3. WHERE
4. CURSOR
5. TOO_MANY_ROWS
6. SQLCODE
7. EXCEPTION
8. EXCEPTION

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---

---

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