PL/SQL - продължението

Xamine the following code. At Line A, we want to assign a value of 25 to the outer block’s variable (V1). What must we do? DECLARE v_myvar NUMBER; — This is V1 BEGIN DECLARE v_myvar NUMBER := 8; BEGIN — Line A END; END;

CREATE TRIGGER emp_trigg — Line A BEGIN INSERT INTO log_table VALUES (USER, SYSDATE); END; Which of the following can NOT be coded at Line A?

Procedure TESTPROC accepts one parameter P1, whose value is up to 1000 characters in length. Which one of the following declares this parameter correctly?

He following anonymous block of code is run: BEGIN INSERT INTO countries (id, name) VALUES ('XA', 'Xanadu'); SAVEPOINT XA; INSERT INTO countries (id, name) VALUES ('NV','Neverland'); COMMIT; ROLLBACK TO XA; END; What happens when the block of code finishes?

User ALICE owns a procedure show_emps which references table employees. Which of the following will generate information that shows this dependency?

Whenever an employee’s JOB_ID is updated, we want to insert a row into a logging table to record the employee_id and the new value of JOB_ID. We create a row trigger whose body includes the following code: BEGIN INSERT INTO logging_table (emp_id, job_id) VALUES — Point A END; At point A, which of the following will insert the correct data into the logging table? (Choose two.)

Examine the following code: DECLARE v_score NUMBER(3); v_grade CHAR(1); BEGIN CASE v_score -- Line A .... The CASE statement must convert a numeric score to a letter grade: 90 -> A, 80 -> B, 70 -> C and so on. What should be coded at Line A?

You can reference explicit cursor attributes directly in a SQL statement. True or False?

How many INSERTs can you have in one transaction?

Which implicit cursor attribute identifies the number of rows updated in the following statement? DBMS_OUTPUT.PUT_LINE(__________ || ' rows updated.');

Which of the following statements is true? (1) Points

The following are the steps involved in creating, and later modifying and re-creating, a PL/SQL procedure in Application Express. Which step is missing? Type the procedure code in the SQL Commands window Click on the “Save” button and save the procedure code Retrieve the saved code from “Saved SQL” in SQL Commands Modify the code in the SQL Commands window Execute the code to re-create the procedure

Which of the following is a valid naming convention for an identifier? (Choose two.) (1) Points (Choose all correct answers)

PL/SQL can be used not only with an Oracle database, but also with any kind of relational database. True or False? (1) Points

Which of the following best describes a database transaction?

Examine the following code: BEGIN FOR I IN 1..5 LOOP FOR j IN 1..8 LOOP EXIT WHEN j = 7; DBMS_OUTPUT.PUT_LINE(i || j); END LOOP; END LOOP; END; How many lines of output will be displayed when this code is executed?

When multiple SQL statements are combined into PL/SQL blocks, performance improves. True or False? (1) Points

The fact that PL/SQL is portable is a good thing because: (1) Points

In a FOR loop, an explicitly declared counter is automatically incremented by 1 for each iteration of the loop. True or False? (1) Points

The UTL_MAIL package allows sending email from the Oracle database to remote recipients. Mark for Review (1) Points

A cursor FOR loop using a subquery can shorten code length when compared to an explicit cursor declaration. True or False?

Which of the following tools can NOT be used to develop and test PL/SQL code?

Which statement best describes when a FOR loop should be used?

What will be the value of variable c after the following code is executed? DECLARE a BOOLEAN := TRUE; b BOOLEAN := NULL; c NUMBER; BEGIN IF a AND b THEN c := 2; ELSIF a OR b THEN c := 0; ELSE c := 1; END IF; END; (1) Points

Which of the following variable declarations does NOT use a number data type?

Which of the following is NOT allowed when using multiple cursors with parameters?

Examine the following code: DECLARE v_salary NUMBER(6); v_constant NUMBER(6) := 15000; v_result VARCHAR(6) := 'MIDDLE'; BEGIN IF v_salary != v_constant THEN v_result := 'HIGH'; ELSE v_result := 'LOW'; END IF; END; What is the final value of v_result? (1) Points

1.Using parameters with a cursor, you can open and close the cursor several times in a block, returning a different active set each time. True or False?

What will be displayed when the following block is executed?: DECLARE x NUMBER(6) := 0 ; BEGIN FOR I IN 1..10 LOOP FOR j IN 1..5 LOOP x := x+1 ; END LOOP; END LOOP; DBMS_OUTPUT.PUT_LINE(x); END;

When using multiple nested cursors, what kinds of loops can you use?

Which of the following are valid identifiers? (Choose two.) (1) Points (Choose all correct answers)

Look at this SQL statement: MERGE INTO old_trans ot USING new_trans nt ON (ot.trans_id = nt.trans_id) .... ; OLD_TRANS is the source table and NEW_TRANS is the target table. True or false?

What will be displayed when this block is executed? DECLARE v_bool1 BOOLEAN := NULL; v_bool2 BOOLEAN := NULL; v_char VARCHAR(10) := 'Start'; BEGIN IF (v_bool1 = v_bool2) THEN v_char:='Equal'; ELSE v_char:='Not equal'; END IF; DBMS_OUTPUT.PUT_LINE(v_char); END; (1) Points

Which of the following statements about PL/SQL and SQL is true? (1) Points

Place the following statements in the correct sequence: OPEN my_curs; CLOSE my_curs; CURSOR my_curs IS SELECT my_column FROM my_table; FETCH my_curs INTO my_variable;

We want to create a log record automatically every time any DML operation is executed on either or both of the EMPLOYEES and DEPARTMENTS tables. What is the smallest number of triggers that must be create to do this?

Using Oracle Application Express, you can create Web applications that include PL/SQL. True or False? (1) Points