Latest Oracle 1z1-149 Dumps for success in Actual Exam Oct-2023 [Q40-Q57]

Rate this post

Latest Oracle 1z1-149 Dumps for success in Actual Exam Oct-2023]

Realistic 1z1-149 100% Pass Guaranteed Download Exam Q&A

The Oracle 1z1-149 exam consists of 80 multiple-choice questions, and candidates have two hours to complete it. The questions are designed to test the candidate’s knowledge of PL/SQL fundamentals, program structure, control structures, error handling, and database interaction. Candidates are expected to demonstrate their ability to write efficient PL/SQL code, debug and troubleshoot programs, and optimize performance.

NEW QUESTION 40
Which two statements are true about using the OR REPLACE clause when creating named subprograms? (Choose two.)

Function based indexes remain usable when replacing the function on which the index depends.

Object privileges to execute a replaced function must be regranted to those users who had the privilege.

This clause can be used only for procedures and functions.

A function definition can be modified without dropping and re-creating it.

Object privileges to execute a replaced function are retained by those users who had the privileges.

NEW QUESTION 41
Examine this DECLARE section:

Which line will cause an error upon execution?

line 5

line 3

line 2

line 4

line 6

NEW QUESTION 42
Examine these facts:
Table EMP exists in schema USERA with columns SALARY and EMP_ID.
EMP_ID is the primary key with values ranging from 1 to 100.
USERA now executes these statements successfully:

USERA then grants execute privilege on procedure MYPROC to USERB.
USERB exists in the database identified by pdb1 but does not have select privilege on USERA.EMP.
USERB now executes these statements:
conn userB/userB@pdb1
execute userA.myproc;
Which is true?

It results in an error because Authid Current_User is missing from MYPROC.

It results in an error because Authid Definer is missing from MYPROC.

It results in an error because USERB doesn’t have select privilege on USERA.EMP.

It executes successfully.

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

Changing the parameter setting automatically changes the setting for existing PL/SQL library units.

The default value is NATIVE.

If set to NATIVE, programs are stored in platform dependent machine code.

It can use the REUSE SETTINGS clause to recompile a program unit without changing to the current session settings.

If set to NATIVE, programs are stored in a PL/SQL bytecode format.

NEW QUESTION 44
Which three statements are true about passing parameters to subprograms? (Choose three.)

PL/SQL assigns values to actual parameters in subprograms with unhandled exceptions.

IN parameters passed to subprograms act like constants, to which values cannot be assigned by the subprogram.

IN OUT parameters pass initial values to subprograms and return values updated by subprograms to the caller.

The actual parameter must be a variable when calling a subprogram with an OUT parameter.

IN parameters passed to subprograms act like variables, to which values can be assigned by the subprogram.

OUT parameters returning values to calling subprograms act like constants in the called subprogram.

Actual parameters corresponding to IN OUT formal parameters can be constants or expressions.

NEW QUESTION 45
In which type of trigger can :OLD and :NEW identifiers be used?

ROW

AFTER SUSPEND

AFTER STATEMENT

BEFORE STATEMENT

NEW QUESTION 46
Which three statements are true about Implicit Cursor and Explicit Cursor? (Choose three.)

Implicit cursor returns only one record.

Explicit cursor can return more than one record.

%Isopen, %Rowtype, %Notfound, and %Found are the attributes of Explicit Cursor.

%Isopen, %Rowcount, %Notfound, and %Found are the attributes of Explicit Cursor.

%Isopen, %Type, %Notfound, and %Found are the attributes of Explicit Cursor.

%Isopen is always false in Explicit Cursor.

%Isopen is always false in Implicit Cursor.

NEW QUESTION 47
Examine these statements issued by user SH which execute successfully:

DBMS_OUTPUT.PUT_LINE(p_price(i)); END LOOP; END; END products_pkg; /
Now, examine this anonymous block executed by SH:

Which is true about the anonymous block?

It will execute successfully only if PriceList is removed from the DECLARE section and defined as a standalone collection type.

It will execute successfully only if PriceList is defined as an associative array in the package and anonymous block.

It will fail at lines 6 and 7.

It will fail only at line 7.

NEW QUESTION 48
Examine this DECLARE section:

Which two lines are valid? (Choose two.)

line 5

line 6

line 7

line 4

line 3

line 2

NEW QUESTION 49
Which three are true about PL/SQL subprograms? (Choose three.)

Results of a subprogram can be cached in the SGA such that sessions connected to the same instance can reuse these results when available.

Users granted execute privilege on a procedure compiled with definer’s rights require grants to access objects belonging to the definer that are referenced in the procedure.

Subprograms are cached by default and shared among users, thereby reducing memory requirements.

Reuse of parsed PL/SQL code from the shared SQL area reduces parsing overhead.

A subprogram’s session state is retained even if any of the session’s instantiated subprograms are invalidated and revalidated.

Host variables can be referenced inside any PL/SQL subprogram.

A PL/SQL procedure can invoke an external code block written in a different programming language.

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

They cannot include the WHEN clause.

They must be created in an enabled state.

They can be fired when a table is truncated.

They fire only when a DDL statement is executed by the owner of the trigger.

They can be fired either before or after a DDL statement executes.

They can be fired when a privilege is granted to a user.

They must be created in a disabled state.

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

In a multitenant environment, the DELEGATE option of CBAC cannot be used.

CBAC roles can be granted to a program unit only if they are directly granted to its owner.

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.

You can use CBAC to attach database roles to a PL/SQL function or procedure only.

In CBAC, the ADMIN and DELEGATE options cannot both be granted to the same user.

You can use CBAC to attach database roles to a PL/SQL function, procedure, or package.

CBAC cannot be used to secure definer’s rights.

NEW QUESTION 52
Which three are true about user-defined functions? (Choose three.)

They can be used in ORDER BY and GROUP BY clauses.

They can be executed as standalone commands.

They must be defined with at least one parameter.

They need not return any values.

They can appear in the select list of a SELECT statement.

Functions can call only other functions.

They can be used in CONNECT BY and START WITH clauses.

NEW QUESTION 53
Which three are true about functions and procedures? (Choose three.)

The ACCESSIBLE BY clause can be used only for procedures.

In a function, every execution path must lead to a RETURN statement.

Both can have only constants as actual parameters for IN mode parameters.

Both can be invoked from within SQL statements.

In a procedure the RETURN statement cannot specify an expression.

In a function every RETURN statement must specify an expression.

NEW QUESTION 54
Which two are true about lexical units? (Choose two.)

Character literals are case-sensitive.

Spaces can be embedded in delimiters.

Identifiers include labels.

A character literal with zero characters has the BOOLEAN value NULL.

All user-defined identifiers must start with an alphabet.

NEW QUESTION 55
Examine the structure of the ora1.depts table:

Now, examine these statements issued by user ora1 which execute successfully:
Create or replace view dep_vu as select * from depts;
Alter table depts add dep_email varchar2(20);
Finally, examine this block of code executed by user ora1:

Which is true?

DEP_VU must be manually recompiled to successfully run this code.

It will run successfully producing a result of 4.

It will result in an error because table depts has been altered.

It will run successfully producing a result of 5.

NEW QUESTION 56
Which two are true about collections and RECORD types? (Choose two.)

A variable of RECORD type can contain fields of another RECORD type or any collection type.

Only associative arrays and nested tables can have elements of RECORD type.

All collections and RECORD types can be defined in PL/SQL blocks, packages, or at the schema level.

Collections and RECORD types are always dense.

All collections and RECORD types can be stored in table columns.

VARRAYS, nested tables and each field in %ROWTYPE type variables have a default value of null.

NEW QUESTION 57
Sequence S and table PRODUCTS exist in your schema.
Examine the table description:

Now, examine this block of code:

Which two lines each result in a compilation error? (Choose two.)