1z1-149 무료 덤프문제 온라인 액세스

Which three are valid PL/SQL variable names? (Choose three.)

• A.yesterday's_date
• B.Number_of_days_between_March_and_April
• C.leap$year
• D.#printer_name
• E.printer_name#
• F.1to7number
• G.v_fname

Which two are true about INDEX-BY tables? (Choose two.)

• A.The index can be integer or string.
• B.INDEX-BY table types can be created in PL/SQL blocks only.
• C.INDEX-BY table types can be created both with the CREATE TYPE statement and in PL/SQL blocks.
• D.The index can be integer only.
• E.INDEX-BY table types can be created with the CREATE TYPE statement.

Which three are true regarding code based access control (CBAC)? (Choose three.)

• A.CBAC roles can be granted to a program unit only if they are directly granted to its owner.
• B.You can use CBAC to attach database roles to a PL/SQL function or procedure only.
• C.In CBAC, the ADMIN and DELEGATE options cannot both be granted to the same user.
• D.CBAC cannot be used to secure definer's rights.
• E.CBAC roles can be granted to a program unit only if they are the predefined roles automatically defined by the standard scripts as part of database creation.
• F.You can use CBAC to attach database roles to a PL/SQL function, procedure, or package.
• G.In a multitenant environment, the DELEGATE option of CBAC cannot be used.

Which two are valid MODIFIER values for the PLSQL_WARNINGS parameter? (Choose two.)

• A.ERROR
• B.SEVERE
• C.ALL
• D.DISABLE
• E.ENABLE

Which two are true about using the ACCESSIBLE BY clause? (Choose two.)

• A.It must be specified in the heading of a package specification.
• B.It can be used for individual procedures and functions declared in a package specification.
• C.The check is enforced by this clause for direct access and access through dynamic SQL.
• D.It can be used in the declaration of object types.
• E.It must be specified in the heading of a package body.