Online Access Free 1z0-148 Practice Test

Which two PL/SQL blocks give the output "this is a test message"?

• A.BEGINDBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME (' "this is a test message"
  ', TRUE));END;
• B.BEGINDBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME ('this is a test message', TRUE));END;
• C.BEGINDBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME (' "this is a "test" message" ', TRUE));END;
• D.BEGINDBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME ('this is a " "test" " message', TRUE));END;
• E.BEGINDBMS_OUTPUT.PUT_LINE (DBMS_ASSERT.ENQUOTE_NAME ('this is a test message ', FALSE));END;

Examine this code:

Execute this PL/SQL block:

Which is the correct category of SQL injection attack?

• A.Incorrect type handling
• B.Lateral Injection
• C.First Order Attack
• D.Second Order Attack

Select a valid reason for using VARRAYS.

• A.As a column in a table when you want to store no more than 10 elements in each row's collection.
• B.As a column in a table when you want to retrieve the collection data for certain rows by ranges of values.
• C.When you want to delete elements from the middle of the collection.
• D.When the amount of data to be held in the collection is widely variable.

Identify the two correct scenarios where a function can be optimized using the function result cache feature.

• A.A function which inserts multiple records into a DEPARTMENTS table as part of one-time data setup for an HR application.
• B.A function which deletes all the records from an EMPLOYEES_AUDIT table based on their LOG_DATE.
• C.A function which accesses multiple tables and calculates the commission to be given to a sales representative based on the number of products sold by that representative.
• D.A function which calculates the factorial of a given number without accessing any table.
• E.A function which updates the SALARY of all the employees in an EMPLOYEES table by a fixed percentage based on their DESIGNATION.

Which two statements are true about PL/SQL AOIs for SecureFiles?

• A.DBMS_LOB can be used to compress SecureFiles columns.
• B.An online redefinition of SecureFiles by DBMS_REDEFINIITON can be performed with PDML (Parallel DML).
• C.If a BasicFiles LOB locator is passed to DBMS_LOB.ISSECUREFILE, an exception will be raised.
• D.When using DBMS_DATAPUMP, if SecureFiles LOB data needs to be encrypted then ENCRYPTION=ALL must be specified.