Exam 1z0-149 topic 1 question 5 discussion

A $ C ARE CORRECT

DECLARE -- 1. Define the TYPE: Stores VARCHAR2 indexed by PLS_INTEGER TYPE EmpNameArray IS TABLE OF VARCHAR2(100) INDEX BY PLS_INTEGER;

A is missleading , literaly it can be indexed by PLS Integer and string , remember than now IZ0-149 is validated against 19 version of database. Table 5-1 PL/SQL Collection Types , so the Associative array/indexed by table caan be deffined in In PL/SQL block or package In PL/SQL block or package

But why A as long as the index for an INDEX-BY table must be of type integer (BINARY_INTEGER or PLS_INTEGER)? B&C are correct in this case

A.C TESTED

My bad, didn't check. D is not true. Checked in Oracle DB 12.1.0.2.0 Compilation errors for TYPE APPS.PHONEBOOK Error: PLS-00355: use of pl/sql table not allowed in this context Line: 1 Text: CREATE OR REPLACE TYPE PhoneBook AS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER Error: PL/SQL: Compilation unit analysis terminated Line: 1 Text: CREATE OR REPLACE TYPE PhoneBook AS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER A and C is true.

A and D. You can create type INDEX BY, example from ChatGPT: CREATE TYPE PhoneBook AS TABLE OF VARCHAR2(100) INDEX BY BINARY_INTEGER; After creating this type, you can use it to declare variables or columns in tables. For instance, you might use it within PL/SQL code like this: DECLARE -- Declare a variable of type PhoneBook myContacts PhoneBook; BEGIN -- Assign values to the INDEX-BY table myContacts(1) := 'John Doe'; myContacts(2) := 'Jane Smith'; -- Accessing elements DBMS_OUTPUT.PUT_LINE('First contact: ' || myContacts(1)); DBMS_OUTPUT.PUT_LINE('Second contact: ' || myContacts(2)); END;

A AND D , C IS NOT BEC (ONLYE)

A and C are TRUE!