[2023] 1Z0-149 PDF Questions – Perfect Prospect To Go With ExamCost Practice Exam [Q33-Q48]

5/5 - (2 votes)

[2023] 1Z0-149 PDF Questions – Perfect Prospect To Go With ExamCost Practice Exam

Oracle 1Z0-149 Pdf Questions – Outstanding Practice To your Exam

Oracle 1z1-149 exam is an excellent opportunity for individuals who are interested in programming with PL/SQL using Oracle Database 19c. It provides a comprehensive assessment of candidates’ knowledge and skills in this area and can help them demonstrate their expertise to potential employers. With proper preparation and study, candidates can pass 1Z0-149 exam and earn a valuable certification that can help them excel in their careers.

NO.33 Examine these statements and output:

The procedure is created successfully.

User ora2 has password ora2 in pdb1.
Which script will execute successfully?

NO.34 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.35 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.36 Examine these statements which execute successfully:

Which anonymous block executes successfully?

NO.37 Which three PL/SQL-only data types can be used in queries and native dynamic SQL issued from PL/SQL in the server? (Choose three.)

a record declared in an anonymous block

a record declared in a procedure

an associative array indexed by PLS_INTEGER

a record declared in a package specification

a predefined PL/SQL-only data type like BOOLEAN

an associative array indexed by VARCHAR2

NO.38 Examine the SH.PRODUCTS table:

A row exists in SH.PRODUCTS with PDT_ID = 1.
Now, examine this code and output executed by SH:

Now, examine this block of code:

Which error message(s) does it display on execution by user SH?

Error in inner block

Error in inner block Error in outer block

Error in inner block Error in calling block

Error in inner block Error in outer block Error in calling block

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

PACKAGES

VARIABLES

ANONYMOUS BLOCK

TRIGGER BODY

DATABASE LINKS

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

https://docs.oracle.com/database/122/LNPLS/ACCESSIBLE-BY-clause.htm

NO.41 For which three SYSTEM EVENTS can triggers be created? (Choose three.)

DDL

AFTER AUDIT

BEFORE ANALYZE

SHUTDOWN

SERVERERROR

STARTUP

BEFORE GRANT

NO.42 Which two blocks of code display a numerical zero? (Choose two.)

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

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

NO.45 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.46 Examine this DECLARE section:

Which two lines are valid? (Choose two.)

line 5

line 6

line 7

line 4

line 3

line 2

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

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

Loading …

Preparing for the Oracle 1Z0-149 exam requires a solid understanding of PL/SQL programming concepts and hands-on experience with PL/SQL programming. Candidates can prepare for the exam by taking Oracle training courses, practicing with sample questions and exercises, and gaining practical experience with PL/SQL programming.

Online Questions – Outstanding Practice To your 1Z0-149 Exam: https://www.examcost.com/1Z0-149-practice-exam.html