Is this exam completely free?

ExamCademy offers a free preview for every exam, covering around 20% of the total questions. Full access to all questions is available for free by signing up for an account. Optional supporters unlock AstroTutor (AI tutor) and advanced study modes.

Can I practice IT certification exams from Microsoft, AWS, or CompTIA?

Yes! ExamCademy supports a wide range of IT certification exams including Microsoft Azure, AWS Cloud Practitioner, and CompTIA A+ and Security+.

How accurate are the mock exams?

Our practice questions are community-created and moderator-reviewed to align with realistic exam objectives, style, and difficulty.

1z0-149 by Oracle - Page 1 | ExamCademy

Mode Selection

Question 1

Question 2

Question 3

Which two are true about collections and RECORD types? (Choose two.)

A A variable of RECORD type can contain fields of another RECORD type or any collection type.
B Only associative arrays and nested tables can have elements of RECORD type.
C All collections and RECORD types can be defined in PL/SQL blocks, packages, or at the schema level.
D Collections and RECORD types are always dense.
E All collections and RECORD types can be stored in table columns.
F VARRAYS, nested tables and each field in %ROWTYPE type variables have a default value of null.

Question 4

Examine this table in the SH schema:

Question 5

Examine this row of data from the EMPLOYEES table:

Question 6

Examine this table in the SH schema:

Question 7

User ORA41 executes these statements successfully:

Question 8

Which two are true about exception handling? (Choose two.)

A Internally defined exceptions can be handled only by the OTHERS exception handler.
B All declared exceptions are raised implicitly by the runtime system.
C User-defined exceptions can be defined in the declarative part of any PL/SQL anonymous block, subprogram, or package.
D Only predefined exceptions and user-defined exceptions can have a user-declared name associated with them.
E Predefined exceptions are globally declared in the standard package.

Question 9

Examine these statements:

Question 10

Examine the EMPLOYEES table structure:

Question 11

Sequence S and table PRODUCTS exist in your schema.
Examine the table description:

Question 12

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

A The ACCESSIBLE BY clause can be used only for procedures.
B In a function, every execution path must lead to a RETURN statement.
C Both can have only constants as actual parameters for IN mode parameters.
D Both can be invoked from within SQL statements.
E In a procedure the RETURN statement cannot specify an expression.
F In a function every RETURN statement must specify an expression.

That's the end of the Preview

Create a free account to unlock all questions for this exam.

Log In / Sign Up

Page 1 of 3 • Questions 1-25 of 59

1 2 3

→

Know a question that should be here? Contribute to this exam

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

Which three are valid PL/SQL variable names? (Choose three.)

A printer_name#
B 1to7number
C yesterday's_date
D leap$year
E Number_of_days_between_March_and_April
F #printer_name
G v_fname

User SH executes this code:

The program must terminate with a user-defined message and no rows displayed if more than one product's price is 1000.
With which option must “---placeholder” be replaced?

A
B
C
D
E

Now, examine this block of code which executes successfully:

What is the value of v_commission?

A 5000
B 15000
C 2500
D 10000

Now, examine this code:

Which two changes are required to ensure that PDT_REPORT executes successfully? (Choose two.)

A In line 1, change IN OUT mode to IN mode.
B In line 2, change IN OUT mode to IN mode.
C In line 3, replace CUR_PRICE with P_PDT_PRICE in the query condition.
D In line 1, add the default parameter DEFAULT 2000.
E In line 6, replace P_PDT_PRICE parameter name with CUR_PRICE.
F In line 2, add the default parameter DEFAULT 2000.

Now, examine this statement which is executed successfully by user ORA61 after a successful login:
EXECUTE ora41.update_emp_proc(100,25000);
Which two are true? (Choose two.)

A The salary will be changed for employee 100 in the EMPLOYEES table owned by ORA41.
B No update happens even though the procedure executes successfully.
C The salary will be changed for employee 100 in the EMPLOYEES table owned by ORA61.
D The UPDATE privilege on ORA41.EMPLOYEES is not inherited by ORA61 through the procedure.
E ORA61 will have been granted the UPDATE privilege explicitly on ORA41.EMPLOYEES before executing the statement.

Which is true?

A It will result in a compilation error for protected_proc because calling_proc does not exist.
B It will result in a compilation error for protected_proc because calling_proc must be prefixed with the schema name.
C It will result in a successful compilation because objects referenced in an ACCESSIBLE BY clause are not checked at compile time.
D With adequate privileges, PROTECTED_PROC procedure can be called by other programs apart from CALLING_PROC.