Oracle PL/SQL Quiz

What will be the output of the following code snippet?

• Syntax error

• 200

• 200

  100

• 100

What will be the output of the following code snippet when performed on the EMPLOYEE table below?

• Error

• 
• 
• 

To produce a stored function, which statement is used?

• PRODUCE FUNCTION

• CREATE FUNCTION

• PRODUCE PROCEDURE

• CREATE PROCEDURE

What will happen when we execute on the table below?

• Error

• Price of mango = 25

• Price of mango = 10

• Price of mango = 50

How to call a stored procedure? For example: function1 (param1, param2)

• SELECT function1 (param1, param2) FROM DUAL;

• SELECT * FROM table1 WHERE attr1 = funtion 1 (param1, param2);

• EXECUTE function1 (param1, param2);

• UPDATE table1 SET attr1 = function1 (param1, param2) WHERE attr2 = value2;

You wish to define a procedure that accepts an incoming number, an incoming date, and a date that is brought in and returned after making changes to it if needed. In addition, a number is returned that is set by the procedure. Which code snippet best satisfies these requirements?

• CREATE PROCEDURE test (p1 IN number, p2 IN date, p3 OUT date, p4 OUT number) AS....

• CREATE PROCEDURE test (p1 OUT number, p2 INOUT date, p3 IN date, p4 IN number) AS....

• CREATE PROCEDURE test (p1 INOUT number, p2 INOUT date, p3 IN date, p4 IN number) AS....

• CREATE PROCEDURE test (p1 IN number, p2 INOUT date, p3 IN date, p4 IN number) AS....

1. A stored procedure is

• A sequence of PL/SQL statements to perform specific operations.

• Stored in compiled form in the database.

• A stored function but without a return value.

• All of the above.

1. Which of the following is NOT true about PL/SQL triggers?

• Triggers are stored programs.

• They are automatically executed when certain events occur.

• Triggers could be defined on table, view, schema, database with which the events are associated.

• None of the above.

1. Which can be triggering events?

• DML commands

• DDL commands

• DCL commands

• Database events

1. What will happen if we run the following code snippet?

• No change will be made, as the error “INVALID AGE INPUT!” will be thrown.

• The trigger will be triggered twice.

• Both the IF statement and the update operation will be executed normally for PERSON with SSN=12345.

• The operation inside the IF statement will be executed twice.