Tag: technology

Quizzes (307) Questions (36705)

Questions Related to technology

Multiple choice technology databases

Which two statements correctly describe the features of SecureFiles? (Choose two.)

  1. Compression does not entail table or index compression and vice-versa.

  2. Encryption stores the encryption keys for the LOB columns inside the database.

  3. Encryption stores the encryption keys for the LOB columns outside the database.

  4. Compression stores identical data occurring two or more times in the same LOB column as a single copy for the table.
Reveal answer Fill a bubble to check yourself
A,C Correct answer
Full explanation
Multiple choice technology databases

DATA_FILES is a directory object that contains the DETAILS.TXT text file. You have the required permissions to access the directory object. You create a table using the following command: CREATE TABLE clob_tab(col2 CLOB); View the Exhibit and examine the PL/SQL block that you execute for loading the external text file into the table that currently has no rows. The PL/SQL block results in an error. What correction must be done to ensure the PL/SQL block executes successfully?

  1. The L_OUT variable must be initialized to an empty locator.

  2. The L_OUT variable has to be declared as a temporary LOB.

  3. The A_CLOB variable has to be declared as a temporary LOB.

  4. The clause RETURNING col2 INTO a_clob should be added to the INSERT statement to correctly initialize the locator.
Reveal answer Fill a bubble to check yourself
D Correct answer
Full explanation