[2023] Pass Oracle 1Z0-149 Exam in First Attempt Easily [Q34-Q50]

Rate this post

[2023] Pass Oracle 1Z0-149 Exam in First Attempt Easily

The Most Efficient 1Z0-149 Pdf Dumps For Assured Success

Get to know about the best resource for the preparation of Oracle 1Z0-149:

There are several resources like certification guides, video tutorials, mock tests, study materials, mock papers, etc., which are available to help you in the preparation of the Oracle Database Administrator’s certification exam. You can read these materials to get an idea of the topics included in this exam. Moreover, you can refer to the papers, which are provided by Oracle. These resources will help you in preparing for the Oracle Database Administrator’s certification exam.

All the above resources could be used for the preparation of the Oracle 1Z0-149 Certification Exam, but the best resource for the preparation of the exam is practice exams of the TestKingFree. These 1Z0-149 exam dumps will help you in improving your skills, and they will help you to overcome any nervousness that you may have during the exam. You should use these questions to get a clear idea of the exam topics and concepts. You can also practice writing the questions, which are similar to the ones of the actual exam.

QUESTION 34
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 35
Which three statements can process a dynamic multi-row query? (Choose three.)

DECLARE

OPEN

INTO

OPEN-FOR

FETCH

WHEN

QUESTION 36
Which statement is true about user-defined records?

They can be returned from a function.

Field types must match column types.

The number of fields must match the number of columns in a table.

Field names must match selected column names.

QUESTION 37
SERVEROUTPUT is enabled.
Which code block will display the values from 1 to 10 in descending order?

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

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

The index can be integer or string.

The index can be integer only.

INDEX-BY table types can be created in PL/SQL blocks only.

INDEX-BY table types can be created both with the CREATE TYPE statement and in PL/SQL blocks.

INDEX-BY table types can be created with the CREATE TYPE statement.

QUESTION 40
Which two blocks of code display a numerical zero? (Choose two.)

QUESTION 41
Which block of code displays the error message “Incorrect price value”?

QUESTION 42
Examine these statements:

Which two are true? (Choose two.)

Neither table will have a row inserted and committed.

Both tables will have a row inserted and committed.

The transaction for the bank_activity_proc is independent of the bank_transaction_proc.

The bank_activity_proc will not compile because of the commit.

Only one table will have a row inserted and committed.

QUESTION 43
Examine this anonymous block of code:

Which two statements are true about the results of executing it? (Choose two.)

It will set all salaries to 0 if it executes successfully.

It will always return a compile time error because it lacks an EXCEPTION section.

It might return a run time error depending on who invokes it.

It will always automatically initialize v_raise.

It will set all salaries to NULL if it executes successfully.

It will always return a run time error because v_raise is not initialized.

QUESTION 44
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 45
Examine this code:
ALTER SESSION SET plsql_warnings=’ENABLE:ALL’;
/
You compile this function:

What happens when the function is created with PLSQL_WARNINGS set to ‘ENABLE: ALL’?

It fails compilation.

There are no compilation warnings or errors.

A severe compilation warning is generated.

A performance compilation warning is generated.

An information compilation warning is generated.

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

QUESTION 47
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?