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

Which three are true about DDL triggers? (Choose three.)

• A.They fire only when a DDL statement is executed by the owner of the trigger.
• B.They can be fired either before or after a DDL statement executes.
• C.They can be fired when a table is truncated.
• D.They can be fired when a privilege is granted to a user.
• E.They must be created in an enabled state.
• F.They must be created in a disabled state.
• G.They cannot include the WHEN clause.

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

• A.In CBAC, the ADMIN and DELEGATE options cannot both be granted to the same user.
• B.You can use CBAC to attach database roles to a PL/SQL function or procedure only.
• C.In a multitenant environment, the DELEGATE option of CBAC cannot be used.
• D.CBAC roles can be granted to a program unit only if they are directly granted to its owner.
• E.You can use CBAC to attach database roles to a PL/SQL function, procedure, or package.
• F.CBAC cannot be used to secure definer's rights.
• G.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.

Which block of code displays the error message "Incorrect price value"?

• A.
• B.
• C.
• D.

Which statement is true about user-defined records?

• A.Field types must match column types.
• B.Field names must match selected column names.
• C.They can be returned from a function.
• D.The number of fields must match the number of columns in a table.

Which two are true about the PLSQL_CODE_TYPE parameter? (Choose two.)

• A.If set to NATIVE, programs are stored in a PL/SQL bytecode format.
• B.Changing the parameter setting automatically changes the setting for existing PL/SQL library units.
• C.The default value is NATIVE.
• D.It can use the REUSE SETTINGS clause to recompile a program unit without changing to the current session settings.
• E.If set to NATIVE, programs are stored in platform dependent machine code.