Oracle Meter Data Management – MDM MCQ Quiz – Part 3

Oracle Meter Data Management – MDM MCQ

This Oracle Meter Data Management – MDM MCQ Quiz contains few questions as a online practice test.

1. The —– returns the actual error message for the last error encountered

a) SQLERROR
b) SQLCODE
c) SQLMSG
d) SQLERRM

2. which Pl/SQL collection method will return NULL for nested tables and associative arrays

a) Count
b) Exists
c) Limit
d) Extends

3. How many Riders can created in a single Rate Schedule

a) 100
b) 10
c) 20
d) 1000

4. which function is used to open an Work Queue in Rules Language

a) WQ_CREATE
b) CREATE_WQ
c) WQ_OPEN
d) OPEN_WQ

5. Which is not a oracle package?

a) DBMS_OUT
b) DBMS_PIPE
c) DBMS_JOB
d) UTL_FILE