Amazon
Avaya
Checkpoint
Cisco®
CompTIA
CrowdStrike
EC-Council
EXIN
Fortinet
Google
ISC
ISC2
ITIL®
Juniper
Microsoft
MuleSoft
Okta
Oracle
Palo Alto Networks
Salesforce
All Vendors
  1. Home
  2. Oracle
  3. 1z0-149

Oracle 1z0-149 Exam (page: 1)
Oracle Database Program with PL/SQL
Updated on: 28-Sep-2025

Viewing Page 1 of 10
1z0-149 PDF 65 Questions

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

  1. PACKAGES
  2. VARIABLES
  3. ANONYMOUS BLOCK
  4. TRIGGER BODY
  5. DATABASE LINKS

Answer(s): A,E



Which three are true about functions and procedures? (Choose three.)

  1. The ACCESSIBLE BY clause can be used only for procedures.
  2. In a function, every execution path must lead to a RETURN statement.
  3. Both can have only constants as actual parameters for IN mode parameters.
  4. Both can be invoked from within SQL statements.
  5. In a procedure the RETURN statement cannot specify an expression.
  6. In a function every RETURN statement must specify an expression.

Answer(s): B,E,F



Which two are true about Conditional Compilation in PL/SQL using $IF, $ELSE, $END, and $ERROR? (Choose two.)

  1. PL/SQL code can be compiled and executed based on different versions of the operating system.
  2. PL/SQL code can be compiled and executed based on different versions of Oracle.
  3. It is newer syntax that works the same way as 'IF , ELSEIF , ELSE, and END IF'.
  4. Conditional compilation is disabled by default.
  5. The PL/SQL compiler can conditionally include selected parts of a program.

Answer(s): B,E



Which three are true about the NOCOPY hint, the PARALLEL ENABLE hint, and the DETERMINISTIC clause? (Choose three.)

  1. The PARALLEL_ENABLE clause can be used only in the CREATE FUNCTION statement.
  2. The NOCOPY hint asks the compiler to pass the actual parameters by reference.
  3. A deterministic function's results always depend on the state of session variables.
  4. The NOCOPY hint asks the compiler to pass the actual parameters by value.
  5. A function is deterministic if it always returns the same result for a specific combination of input values.
  6. The PARALLEL_ENABLE clause can be specified for a nested function.
  7. A function defined with the PARALLEL_ENABLE clause may be executed in parallel in a SELECT statement or a subquery in a DML statement.

Answer(s): B,E,G



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

  1. The index can be integer or string.
  2. The index can be integer only.
  3. INDEX-BY table types can be created in PL/SQL blocks only.
  4. INDEX-BY table types can be created both with the CREATE TYPE statement and in PL/SQL blocks.
  5. INDEX-BY table types can be created with the CREATE TYPE statement.

Answer(s): A,C



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

  1. Named subprograms cannot be called from other packages.
  2. PROCEDURE subprograms can accept parameters.
  3. A FUNCTION subprogram must return one or more values.
  4. Anonymous blocks cannot use packaged variables.
  5. Named subprograms are stored in the database server.
  6. Anonymous blocks must always start with the Declare keyword.
  7. FUNCTION subprograms must be called and passed through one or more parameters.

Answer(s): B,C,E



Which two statements are true about using the OR REPLACE clause when creating named subprograms? (Choose two.)

  1. Function based indexes remain usable when replacing the function on which the index depends.
  2. Object privileges to execute a replaced function must be regranted to those users who had the privilege.
  3. This clause can be used only for procedures and functions.
  4. A function definition can be modified without dropping and re-creating it.
  5. Object privileges to execute a replaced function are retained by those users who had the privileges.

Answer(s): D,E



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?

  1. Error in inner block
  2. Error in inner block Error in outer block
  3. Error in inner block Error in calling block
  4. Error in inner block Error in outer block Error in calling block

Answer(s): A



Viewing Page 1 of 10



Share your comments for Oracle 1z0-149 exam with other users:

Ankit S 11/13/2023 3:58:00 AM

q15. answer is b. simple
UNITED STATES


S. R 12/8/2023 9:41:00 AM

great practice
FRANCE


Mungara 3/14/2023 12:10:00 AM

thanks to this exam dumps, i felt confident and passed my exam with ease.
UNITED STATES


Anonymous 7/25/2023 2:55:00 AM

need 1z0-1105-22 exam
Anonymous


Nigora 5/31/2022 10:05:00 PM

this is a beautiful tool. passed after a week of studying.
UNITED STATES


Av dey 8/16/2023 2:35:00 PM

can you please upload the dumps for 1z0-1096-23 for oracle
INDIA


Mayur Shermale 11/23/2023 12:22:00 AM

its intresting, i would like to learn more abouth this
JAPAN


JM 12/19/2023 2:23:00 PM

q252: dns poisoning is the correct answer, not locator redirection. beaconing is detected from a host. this indicates that the system has been infected with malware, which could be the source of local dns poisoning. location redirection works by either embedding the redirection in the original websites code or having a user click on a url that has an embedded redirect. since users at a different office are not getting redirected, it isnt an embedded redirection on the original website and since the user is manually typing in the url and not clicking a link, it isnt a modified link.
UNITED STATES


Freddie 12/12/2023 12:37:00 PM

helpful dump questions
SOUTH AFRICA


Da Costa 8/25/2023 7:30:00 AM

question 423 eigrp uses metric
Anonymous


Bsmaind 8/20/2023 9:22:00 AM

hello nice dumps
Anonymous


beau 1/12/2024 4:53:00 PM

good resource for learning
UNITED STATES


Sandeep 12/29/2023 4:07:00 AM

very useful
Anonymous


kevin 9/29/2023 8:04:00 AM

physical tempering techniques
Anonymous


Blessious Phiri 8/15/2023 4:08:00 PM

its giving best technical knowledge
Anonymous


Testbear 6/13/2023 11:15:00 AM

please upload
ITALY


shime 10/24/2023 4:23:00 AM

great question with explanation thanks!!
ETHIOPIA


Thembelani 5/30/2023 2:40:00 AM

does this exam have lab sections?
Anonymous


Shin 9/8/2023 5:31:00 AM

please upload
PHILIPPINES


priti kagwade 7/22/2023 5:17:00 AM

please upload the braindump for .net
UNITED STATES


Robe 9/27/2023 8:15:00 PM

i need this exam 1z0-1107-2. please.
Anonymous


Chiranthaka 9/20/2023 11:22:00 AM

very useful!
Anonymous


Not Miguel 11/26/2023 9:43:00 PM

for this question - "which three type of basic patient or member information is displayed on the patient info component? (choose three.)", list of conditions is not displayed (it is displayed in patient card, not patient info). so should be thumbnail of chatter photo
Anonymous


Andrus 12/17/2023 12:09:00 PM

q52 should be d. vm storage controller bandwidth represents the amount of data (in terms of bandwidth) that a vms storage controller is using to read and write data to the storage fabric.
Anonymous


Raj 5/25/2023 8:43:00 AM

nice questions
UNITED STATES


max 12/22/2023 3:45:00 PM

very useful
Anonymous


Muhammad Rawish Siddiqui 12/8/2023 6:12:00 PM

question # 208: failure logs is not an example of operational metadata.
SAUDI ARABIA


Sachin Bedi 1/5/2024 4:47:00 AM

good questions
Anonymous


Kenneth 12/8/2023 7:34:00 AM

thank you for the test materials!
KOREA REPUBLIC OF


Harjinder Singh 8/9/2023 4:16:00 AM

its very helpful
HONG KONG


SD 7/13/2023 12:56:00 AM

good questions
UNITED STATES


kanjoe 7/2/2023 11:40:00 AM

good questons
UNITED STATES


Mahmoud 7/6/2023 4:24:00 AM

i need the dumb of the hcip security v4.0 exam
EGYPT


Wei 8/3/2023 4:18:00 AM

upload the dump please
HONG KONG