Search Header Logo

PLSQL QUIZZ

Authored by William Lawrence

Professional Development

Professional Development

Used 229+ times

PLSQL QUIZZ
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

30 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

1. Which Command will remove the Function?

DROP gen_email_name;

REMOVE gen_email_name;

DELETE gen_email_name;

DROP FUNCTION gen_eamil_name;

2.

MULTIPLE SELECT QUESTION

2 mins • 1 pt

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

WRONG

RIGHT

3.

MULTIPLE SELECT QUESTION

2 mins • 1 pt

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

4.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

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

SHOW FUNCTION_ERROR

SHOW USER_ERRORS

SHOW ERROR

SHOW ALL_ERRORS

5.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

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

VARCHAR2

BOOLEAN

OUT

IN

6.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

The name given for Implicit cursor is?

PLSQL

SQL

CURSOR

NONE

7.

MULTIPLE CHOICE QUESTION

2 mins • 1 pt

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

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?

Discover more resources for Professional Development