Exam 1z0-149 All QuestionsBrowse all questions from this exam
Question 1

Which two PL/SQL elements can be deprecated using the DEPRECATE pragma? (Choose two.)

    Correct Answer: A, B

    The DEPRECATE pragma in PL/SQL can be used to mark certain elements as deprecated. According to official documentation, the elements that can be deprecated include Subprograms, Packages, Variables, Constants, Types, Subtypes, Exceptions, and Cursors. Therefore, Packages and Variables are correct as they fit into these categories.

Discussion
trex_fcsOptions: AB

A & B are correct

abdullah_barhamOptions: AB

I think A, B Are true

vinhvvOptions: AB

https://docs.oracle.com/en/database/oracle/oracle-database/19/lnpls/DEPRECATE-pragma.html#GUID-D2DAD89D-C537-4666-A8A7-2836EB77A0E5 PL/SQL elements of these kinds may be deprecated: Subprograms Packages Variables Constants Types Subtypes Exceptions Cursors

PurpleStudioOptions: AB

Aand B are TRUE

abdullah_barhamOptions: AB

I think A, B Are true