Most Recent Oracle 1Z0-149 Exam Questions & Answers

Prepare for the Oracle Database 19c: Program with PL/SQL exam with our extensive collection of questions and answers. These practice Q&A are updated according to the latest syllabus, providing you with the tools needed to review and test your knowledge.

QA4Exam focus on the latest syllabus and exam objectives, our practice Q&A are designed to help you identify key topics and solidify your understanding. By focusing on the core curriculum, These Questions & Answers helps you cover all the essential topics, ensuring you're well-prepared for every section of the exam. Each question comes with a detailed explanation, offering valuable insights and helping you to learn from your mistakes. Whether you're looking to assess your progress or dive deeper into complex topics, our updated Q&A will provide the support you need to confidently approach the Oracle 1Z0-149 exam and achieve success.

The questions for 1Z0-149 were last updated on Nov 20, 2024.

Viewing page 1 out of 13 pages.
Viewing questions 1-5 out of 65 questions

Get All 65 Questions & Answers

Question No. 1

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

AIt can be used in the declaration of object types.

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

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

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

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

Show Answer

Correct Answer: A, D

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

Question No. 2

Examine these statements:

Which two are true? (Choose two.)

ANeither table will have a row inserted and committed.

BBoth tables will have a row inserted and committed.

CThe transaction for the bank_activity_proc is independent of the bank_transaction_proc.

DThe bank_activity_proc will not compile because of the commit.

EOnly one table will have a row inserted and committed.

Show Answer

Correct Answer: C, E

Question No. 3

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?

ADEP_VU must be manually recompiled to successfully run this code.

BIt will run successfully producing a result of 4.

CIt will result in an error because table depts has been altered.

DIt will run successfully producing a result of 5.

Show Answer

Correct Answer: B

Question No. 4

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

ACall HR.HELPER.H1 from the HR schema.

BCall HR.HELPER.H1 from the SH schema.

CCall HR.API.P1 from the HR schema.

DCall HR.API.P1 from the SH schema.

ECreate and call a package procedure API.H1 in the SH schema, which calls HR.HELPER.H1.

Show Answer

Correct Answer: B, D

Question No. 5

Which two are true about named notations in a PL/SQL subprogram? (Choose two.)

AThe actual parameters must be specified in the same order as the formal parameters are declared.

BSpecifying actual parameters in the wrong order results in the subprogram terminating with an exception.

COnly trailing optional parameters can be omitted in the invocation call.

DThe subprogram invocations must be changed when the formal parameter list acquires new required parameters.

EAny optional parameters can be omitted in the invocation call.

Show Answer

Correct Answer: A, E

Unlock All Questions for Oracle 1Z0-149 Exam

Full Exam Access, Actual Exam Questions, Validated Answers, Anytime Anywhere, No Download Limits, No Practice Limits

Get All 65 Questions & Answers