[Aug 02, 2024] New 1Z0-149 Exam Dumps with High Passing Rate [Q33-Q57]

5/5 - (2 votes)

[Aug 02, 2024] New 1Z0-149 Exam Dumps with High Passing Rate

Get 1Z0-149 Braindumps & 1Z0-149 Real Exam Questions

To prepare for the Oracle 1z1-149 exam, candidates can take advantage of a variety of resources, including official Oracle study guides, training courses, and practice exams. These materials provide a comprehensive overview of the exam topics and offer hands-on exercises that allow candidates to practice their skills. Additionally, candidates are encouraged to gain practical experience by working on real-world PL/SQL projects, which will help them to better understand the language and prepare for the exam.

NO.33 Which three are true about the NOCOPY hint, the PARALLEL ENABLE hint, and the DETERMINISTIC clause? (Choose three.)

The PARALLEL_ENABLE clause can be used only in the CREATE FUNCTION statement.

The NOCOPY hint asks the compiler to pass the actual parameters by reference.

A deterministic function’s results always depend on the state of session variables.

The NOCOPY hint asks the compiler to pass the actual parameters by value.

A function is deterministic if it always returns the same result for a specific combination of input values.

The PARALLEL_ENABLE clause can be specified for a nested function.

A function defined with the PARALLEL_ENABLE clause may be executed in parallel in a SELECT statement or a subquery in a DML statement.

NO.34 Which three statements can process a dynamic multi-row query? (Choose three.)

DECLARE

OPEN

INTO

OPEN-FOR

FETCH

WHEN

NO.35 Which code will successfully create a BODILESS PACKAGE to standardize CONSTANTS and EXCEPTIONS declarations?

NO.36 Examine the EMPLOYEES table structure:

Now, examine this code:

Which statement is true about the result of executing this block?

It will execute successfully provided the salary of EMP_ID 200 does not exceed the value 99999.

It will return an error at line 2.

It will return an error at line 3.

It will return an error at line 8.

It will execute successfully by rounding up the salary of EMP_ID 200 to the appropriate value.

NO.37 Which is true about counter variables in a FOR loop?

It is accessible outside the body of the loop.

It cannot be NULL.

It must explicitly be declared.

It can be modified in the body of the loop.

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

It can be used in the declaration of object types.

It must be specified in the heading of a package specification.

The check is enforced by this clause for direct access and access through dynamic SQL.

It can be used for individual procedures and functions declared in a package specification.

It must be specified in the heading of a package body.

NO.39 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.

NO.40 Examine this statement which executes successfully:
SQL> SET SERVEROUTPUT ON;
Now, examine this code which is executed:

What is true about the result?

It returns an error in line 2.

It returns an error in line 4.

It returns an error in line 9.

It executes and displays output.

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

printer_name#

1to7number

yesterday’s_date

leap$year

Number_of_days_between_March_and_April

#printer_name

v_fname

NO.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.

NO.43 Which three SQL statements, embedded in PL/SQL, typically benefit from using variables declared with %ROWTYPE? (Choose three.)

CREATE

DROP

UPDATE

SELECT

DELETE

ALTER

INSERT

NO.44 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.

NO.45 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.

NO.46 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.

NO.47 Which two are true about Conditional Compilation in PL/SQL using $IF, $ELSE, $END, and $ERROR? (Choose two.)

PL/SQL code can be compiled and executed based on different versions of the operating system.

PL/SQL code can be compiled and executed based on different versions of Oracle.

It is newer syntax that works the same way as ‘IF , ELSEIF , ELSE, and END IF’.

Conditional compilation is disabled by default.

The PL/SQL compiler can conditionally include selected parts of a program.

NO.48 In which type of trigger can :OLD and :NEW identifiers be used?

ROW

AFTER SUSPEND

AFTER STATEMENT

BEFORE STATEMENT

NO.49 Which two are true about implicit data type conversion? (Choose two.)

RAW data types are always implicitly converted to a CLOB when used in a query.

Collections can be implicitly converted to records.

ROWIDS are always implicitly converted to a number when used in a query.

Comparison between character value and a number value always implicitly converts the character value to the number data type.

Implicit data type conversion can negatively impact performance.

NO.50 Examine this code:

What will be the outcome?

It will execute successfully and will display the user-defined error message.

It will result in an error as the range of the error code can only be from “-20000 to -20999.”

It will result in an error as the range of the error code can only be from “-1000 to -2000.”

It will result in an error as the range of the error code can only be from “-2000 to -2999.”

NO.51 Examine this table definition in the SH schema.

A row with PDT_ID = 1 exists. Which two blocks of code will execute successfully by user SH and give the same output? (Choose two.)

NO.52 Which block of code displays the error message “Incorrect price value”?

NO.53 Which two are true about packages? (Choose two.)

Variables and cursors defined in a package specification are visible to all subprograms in the same schema that has the package.

Modifications to a packaged procedure’s body automatically cause recompilation of subprograms that invoke the procedure.

Package specifications can be compiled without their bodies.

Standalone subprograms that reference a package can be compiled only after both the package specification and body are compiled.

A package definition must have a specification and body.

NO.54 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.

NO.55 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.

NO.56 In one of your databases, table HR.EMPLOYEES includes the columns FIRST_NAME and EMPLOYEE_ID.
A row exists with EMPLOYEE_ID 201.
Examine these packages created by user HR:

EXECUTE privilege is granted to user SH, on the HR.API and HR.HELPER packages.
Which two will execute successfully? (Choose two.)