1Z0-148 Online Practice Questions and Answers

You issue the following command to create the PRINT_MEDIA table.

CREATE TABLE print_media

(product_id NUMBER(3),

ad_sourcetext CLOB,

ad_photo BLOB);

Evaluate the following INSERT statements:

INSERT INTO print_media VALUES (1, empty_clob(),empty_blob());

INSERT INTO print_media VALUES (2,'This is a One Line Story',null);

INSERT INTO print_media VALUES (3,'This is another One Line Story',empty_blob());

INSERT INTO print_media VALUES (4,empty_clob(),to_blob('This is new Story'));

Which of the above INSERT statements are valid?

A. Only the first statement is valid.

B. All the statements are valid.

C. Only the first and fourth statements are valid.

D. Only the first and second statements are valid.

E. Only the first, second and third statements are valid.

Which two statements are true about the initialization of internal LOBs? (Choose two.)

A. The EMPTY_CLOB() and EMPTY_BLOB() functions can be used to initialize only null internal LOBs.

B. The EMPTY_CLOB() and EMPTY_BLOB() functions can be used to initialize only non- NULL internal LOBs.

C. The EMPTY_CLOB() and EMPTY_BLOB() functions can be used to initialize both null and non-NULL internal LOBs.

D. The CLOB and BLOB columns can be initialized only by using the EMPTY_CLOB() and EMPTY_BLOB () functions, respectively.

E. The CLOB and BLOB columns can be initialized with a character or raw string, respectively, provided they are less than 4000 bytes in size.

View the Exhibit.

How do you reduce the chances of SQL injection for the procedure?

A. Execute the SQL statement in V_STMT as dynamic SQL.

B. Remove the default value for the arguments in the procedure.

C. Convert the condition in the WHERE clause to be accepted from the user and concatenated.

D. Convert the SELECT statement to static SQL, placing the value of P_EMAIL into a local variable.

The user OE is working on an application that needs to call an external C program multiple times in a single session. However, the extproc.exe file on the server gets accidentally deleted after the OE user connected and made calls to the external C program. Which statement is true about the current session by the OE user?

A. The session can continue calling the external C program.

B. The session can call the external C program after republishing it.

C. The session receives an error for the next call to the external C program.

D. The session terminates during the subsequent call to the external C program.

You have an OE_ACCESS_ORDERS_POLICY security policy implemented on the ORDERS table in the OE schema. The user sessions are able to access only the desired rows. The database administrator (DBA) uses the following command:

SQL> EXECUTE DBMS_RLS.ENABLE_POLICY('OE','ORDERS','OE_ORDERS_ACCESS_POLICY',FALSE );

Which statement is true about user sessions that are connected currently?

A. The security policy remains in effect till the end of the current session.

B. The subsequent queries on the ORDERS table produce an ORA-01031: insufficient privileges error.

C. The subsequent queries on the ORDERS table within the current session are not controlled by the security policy.

D. The subsequent queries on the ORDERS table produce an ORA-28112: failed to execute policy function error.

Identify two methods for immunizing PL/SQL code against SQL injection attacks. (Choose two.)

A. Use bind arguments.

B. Validate all input concatenated to dynamic SQL.

C. Use dynamic SQLs constructed using concatenation of input values.

D. Use subprograms as part of packages instead of stand-alone subprograms.

Which two statements are true about BFILES? (Choose two.)

A. BFILES support only sequential reads.

B. BFILES can be used as attributes in an object type.

C. When LOB is deleted, the corresponding physical file is automatically deleted.

D. The RMAN backup automatically backs up the BFILE locators and the corresponding physical files.

E. The physical file corresponding to a BFILE locator must reside on the file system that is accessible from the server where the database exists.

Which is the correct method for releasing unused money after deleting elements of a collection?

A. Flush the shared pool using the ALTER SYSTEM command.

B. Use the TRUNCATE method on the collection.

C. Execute DBMS_SHARED_POOL.UNKEEP.

D. Execute DBMS_SESSION.FREE_UNUSED_USER_MEMORY.

Which statement describes the plshprof command-line utility?

A. It produces HTML output from raw profiler output.

B. It executes a script to create hierarchical profiler tables in the database.

C. It produces raw profiler output for the most recently executed PL/SQL block.

D. It produces HTML output from hierarchical profiler tables in the database.

E. It stores hash values in hierarchical profiler tables in the database.

Examine this function that is using the RESULT_CACHE clause: After executing the function twice, passing 100 and 150 as input parameters, the LOCATIONS table is updated for LOCATION_ID = 100.

Which statement is correct if the function is called again, passing 150 as the input parameter?

A. The function is executed again because the database checks for changes to the LOCATIONS table each time the function is called.

B. The results are retrieved from the results cache because the LOCATIONS table was not updated for LOCATION_ID = 150.

C. The results are retrieved from the results cache because not enough rows of the LOCATIONS table were modified to cause invalidation.

D. The function is executed again because the result cache was invalidated when the LOCATIONS table was updated.