Latest Success Metrics For Actual 1z1-149 Exam (Updated 67 Questions) [Q13-Q29]

Rate this post

Latest Success Metrics For Actual 1z1-149 Exam (Updated 67 Questions)

Genuine 1z1-149 Exam Dumps Free Demo Valid QA’s

Passing the Oracle 1z1-149 exam provides several benefits to professionals in the database technology field. It demonstrates a high level of expertise and knowledge in PL/SQL programming and Oracle Database 19c, which can lead to career advancement and higher salaries. It also validates the candidate’s skills and knowledge to potential employers, making them more marketable in the job market.

QUESTION 13
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.

QUESTION 14
Which two are true about exception handling? (Choose two.)

Internally defined exceptions can be handled only by the OTHERS exception handler.

All declared exceptions are raised implicitly by the runtime system.

User-defined exceptions can be defined in the declarative part of any PL/SQL anonymous block, subprogram, or package.

Only predefined exceptions and user-defined exceptions can have a user-declared name associated with them.

Predefined exceptions are globally declared in the standard package.

QUESTION 15
Examine these statements which execute successfully:

Which anonymous block executes successfully?

QUESTION 16
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.”

QUESTION 17
Examine these statements:

Which is true?

It will result in a compilation error for protected_proc because calling_proc does not exist.

It will result in a compilation error for protected_proc because calling_proc must be prefixed with the schema name.

It will result in a successful compilation because objects referenced in an ACCESSIBLE BY clause are not checked at compile time.

With adequate privileges, PROTECTED_PROC procedure can be called by other programs apart from CALLING_PROC.

QUESTION 18
Examine these statements from a block of code:

Which two are true? (Choose two.)

The lock acquired when executing the OPEN c1 command will be released only after a COMMIT or ROLLBACK statement is issued.

Only the PRICE column can be updated in the PRODUCTS table.

The FOR UPDATE OF clause can be used only if the WHERE CURRENT OF clause is used in the executable part of the block.

The WHERE CURRENT OF clause can be used only if the FOR UPDATE clause is used in the cursor definition.

An OPEN c1 command will acquire a lock only on the PRICE column in the PRODUCTS table.

QUESTION 19
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.

QUESTION 20
Which three are true about anonymous blocks and subprograms? (Choose three.)

Named subprograms cannot be called from other packages.

PROCEDURE subprograms can accept parameters.

A FUNCTION subprogram must return one or more values.

Anonymous blocks cannot use packaged variables.

Named subprograms are stored in the database server.

Anonymous blocks must always start with the Declare keyword.

FUNCTION subprograms must be called and passed through one or more parameters.

QUESTION 21
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.

QUESTION 22
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.

QUESTION 23
User ORA41 executes these statements successfully:
Now, examine this statement which is executed successfully by user ORA61 after a successful login:
EXECUTE ora41.update_emp_proc(100,25000);
Which two are true? (Choose two.)

The salary will be changed for employee 100 in the EMPLOYEES table owned by ORA41.

No update happens even though the procedure executes successfully.

The salary will be changed for employee 100 in the EMPLOYEES table owned by ORA61.

The UPDATE privilege on ORA41.EMPLOYEES is not inherited by ORA61 through the procedure.

ORA61 will have been granted the UPDATE privilege explicitly on ORA41.EMPLOYEES before executing the statement.

QUESTION 24
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.

QUESTION 25
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.

QUESTION 26
Which is true about the PLSCOPE_SETTINGS parameter?

It is deprecated in Oracle 12c.

It can be used to obtain information about all identifiers when compiling a procedure.

It can be used to control execution of specific portions of the PL/SQL code conditionally.

It can be used to control a user’s privileges on PL/SQL objects at run time.

QUESTION 27
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.

QUESTION 28
For which three SYSTEM EVENTS can triggers be created? (Choose three.)

DDL

AFTER AUDIT

BEFORE ANALYZE

SHUTDOWN

SERVERERROR

STARTUP

BEFORE GRANT

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

PACKAGES

VARIABLES

ANONYMOUS BLOCK

TRIGGER BODY

DATABASE LINKS

Loading …

1z1-149 Practice Test Give You First Time Success with 100% Money Back Guarantee!: https://www.prepawaytest.com/Oracle/1z1-149-practice-exam-dumps.html

Leave a Reply Cancel reply