Nest 0 Cart
Nest Account
Popular Exams
All Categories...
Nest
Nest 0
Contact
Log In / Sign Up
Copyright 2024 © store. All rights reserved.
Home Oracle 1z0-149

Oracle 1z0-149 Exam Practice Questions (P. 3)

  • Full Access (65 questions)
  • Six months of Premium Access
  • Access to one million comments
  • Seamless ChatGPT Integration
  • Ability to download PDF files
  • Anki Flashcard files for revision
  • No Captcha & No AdSense
  • Advanced Exam Configuration
Get Contributor Access
Question #11
Which two are true about collections and RECORD types? (Choose two.)
  1. A
    A variable of RECORD type can contain fields of another RECORD type or any collection type.
  2. B
    Only associative arrays and nested tables can have elements of RECORD type.
  3. C
    All collections and RECORD types can be defined in PL/SQL blocks, packages, or at the schema level.
  4. D
    Collections and RECORD types are always dense.
  5. E
    All collections and RECORD types can be stored in table columns.
  6. F
    VARRAYS, nested tables and each field in %ROWTYPE type variables have a default value of null.

Correct Answer:
BF

Question #12
Examine this table in the SH schema:

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?
  1. A
  2. B
  3. C
  4. D
  5. E

Correct Answer:
A

Question #13
Examine this row of data from the EMPLOYEES table:

Now, examine this block of code which executes successfully:

What is the value of v_commission?
  1. A
    5000
  2. B
    15000
  3. C
    2500
  4. D
    10000

Correct Answer:
C

Question #14
Examine this table in the SH schema:

Now, examine this code:

Which two changes are required to ensure that PDT_REPORT executes successfully? (Choose two.)
  1. A
    In line 1, change IN OUT mode to IN mode.
  2. B
    In line 2, change IN OUT mode to IN mode.
  3. C
    In line 3, replace CUR_PRICE with P_PDT_PRICE in the query condition.
  4. D
    In line 1, add the default parameter DEFAULT 2000.
  5. E
    In line 6, replace P_PDT_PRICE parameter name with CUR_PRICE.
  6. F
    In line 2, add the default parameter DEFAULT 2000.

Correct Answer:
BD

Question #15
User ORA41 executes these statements successfully:

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.)
  1. A
    The salary will be changed for employee 100 in the EMPLOYEES table owned by ORA41.
  2. B
    No update happens even though the procedure executes successfully.
  3. C
    The salary will be changed for employee 100 in the EMPLOYEES table owned by ORA61.
  4. D
    The UPDATE privilege on ORA41.EMPLOYEES is not inherited by ORA61 through the procedure.
  5. E
    ORA61 will have been granted the UPDATE privilege explicitly on ORA41.EMPLOYEES before executing the statement.

Correct Answer:
CD

Previous Questions Next Questions

All Pages