PLSQL QUIZZ

1. Which Command will remove the Function?

• DROP gen_email_name;

• REMOVE gen_email_name;

• DELETE gen_email_name;

• DROP FUNCTION gen_eamil_name;

1. SELECT JOB,AVG(SAL) FROM EMP GROUP BY DEPTNO;

• WRONG

• RIGHT

Which two statements about packages are true? (Choose two)

• Packages can be nested.

• Does Not Support Overloading

• Package methods is loaded into memory each time it is invoked.

• The contents of packages can be shared by many applications.

• You can achieve information hiding by making package

Which command can you issue to see the actual error message?

• SHOW FUNCTION_ERROR

• SHOW USER_ERRORS

• SHOW ERROR

• SHOW ALL_ERRORS

Which type of argument passes a value from a procedure to the calling environment?

• VARCHAR2

• BOOLEAN

• OUT

• IN

The name given for Implicit cursor is?

• PLSQL

• SQL

• CURSOR

• NONE

You are about to add a column to the EMP table.

Which dictionary view can you query to determine the names of the procedures and functions that are used by EMP table?

• USER_PROC_DEPENDS

• USER_DEPENDENCIES

• USER_REFERENCES

• USER_SOURCE

An Oracle-defined exception is raised?

• By the PL/SQL raise statement

• Automatically by Oracle

• In the PL/SQL exception handler

• By the user

A procedure declares a user-defined exception but does not raise it explicitly. Which of the following statements is true about this function?

• The user-defined exception will never be raised.

• The user-defined exception will be handled by a WHEN OTHERS exception handler

• The procedure will fail on compile

• Oracle will raise the user-defined exception

Is the Syntax right using the EMP Table in the DECLARE block

DECLARE

CURSOR C1(DNO OUT EMP.DEPTNO%TYPE) IS SELECT * FROM EMP

WHERE DEPTNO=DNO FOR UPDATE NOWAIT 5;

• RIGHT

• A. WRONG