Oracle SQL/PLSQL

1. What is the result if the query executes(SAL=3000,COMM=NULL): SELECT SAL+COMM FROM EMP WHERE EMPNO=7654;

• Error

• 3000

• NULL

• None

1. Which of the following Statement will cancel the SAVEPOINTS

• iNSERT

• UPDATE

• DELETE

• COMMIT

1. How many join condition will exists if we join 100 tables

• 100

• 99

• 1

• 10

1. Where do Sub Query Reside

• FROM

• WHERE

• SELECT LIST

• ALL THE ABOVE

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

• VARCHAR2

• CHAR

• BOOLEAN

• IN

The function used to capture the Error Message

• SQLERRM

• SQLERR

• SQLERROR

• SQL

The dictionary view used to view the Source code of a Procedure

• USER_PROCEDURES

• USER_SOURCE

• USER_FUNCTIONS

• USER_PROCEDURE

We can have a RETURN statement in a Procedure Body

• TRUE

• FALSE

Which object is used to implement DB Logic

• PROCEDURE

• FUNCTION

• PACKAGE

• ANONYMOUS BLOCK

Name 4 attributes of explicit cursors

• %FOUND,%NOTFOUND,%ROWCOUNT,%ISOPEN

• %FOUND,%NOTFOUND,%ISCLOSE,%ISOPEN

• %FOUND,%OPEN,%ROWCOUNT,%ISOPEN

• NONE