Oracle 1Z0-149 – Verified Dumps PDF and Exam Questions for Success

Oracle 1Z0-149 Exam Dumps

Certification Exams

Downloadable PDF versions

100% Confidential

Updated Regularly

Advanced Features

Number Of Questions: 65

$59.00

Exam Details

Exam Name:

Oracle Database 19c: Program with PL/SQL

Exam Code:

1Z0-149

Total Questions in Exam:

Demo Questions

Q1. Which statement is true about user-defined records?

A.They can be returned from a function.

B. Field types must match column types.

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

D. Field names must match selected column names.

Answer

Correct Answer: C

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

A.PACKAGES

B. VARIABLES

C. ANONYMOUS BLOCK

D. TRIGGER BODY

E. DATABASE LINKS

Answer

Correct Answer: A, E

Q3. Which three statements are true about Implicit Cursor and Explicit Cursor? (Choose three.)

A.Implicit cursor returns only one record.

B. Explicit cursor can return more than one record.

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

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

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

F. %Isopen is always false in Explicit Cursor.

G. %Isopen is always false in Implicit Cursor.

Answer

Correct Answer: B, C, G

Q4. Which three are true about user-defined functions? (Choose three.)

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

B. They can be executed as standalone commands.

C. They must be defined with at least one parameter.

D. They need not return any values.

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

F. Functions can call only other functions.

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

Answer

Correct Answer: A, E, G

Answer

$59.00

Reviews

There are no reviews yet.

Be the first to review “Oracle 1Z0-149 Exam Dumps”

Oracle 1Z0-149 Exam Dumps

Certification Exams

Downloadable PDF versions

100% Confidential

Updated Regularly

Advanced Features

Number Of Questions: 65

Exam Details

Demo Questions

Q1. Which statement is true about user-defined records?

A.They can be returned from a function.

B. Field types must match column types.

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

D. Field names must match selected column names.

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

A.PACKAGES

B. VARIABLES

C. ANONYMOUS BLOCK

D. TRIGGER BODY

E. DATABASE LINKS

Q3. Which three statements are true about Implicit Cursor and Explicit Cursor? (Choose three.)

A.Implicit cursor returns only one record.

B. Explicit cursor can return more than one record.

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

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

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

F. %Isopen is always false in Explicit Cursor.

G. %Isopen is always false in Implicit Cursor.

Q4. Which three are true about user-defined functions? (Choose three.)

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

B. They can be executed as standalone commands.

C. They must be defined with at least one parameter.

D. They need not return any values.

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

F. Functions can call only other functions.

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

Reviews

Quick Links

Contact Us