Tag: databases

Questions Related to databases

To which of the following resources can a lock NOT be applied?
technology databases

  1. Table Space

  2. Bufferpools

  3. Table

  4. Rows

Show answer
Correct Option: B

When does a view get populated?

technology databases

  1. When it is created

  2. When it is referenced in an INSERT statement

  3. The first time any executable SQL statement references it

  4. Any time an executable SQL statement references it

Show answer
Correct Option: D

If an application issues the same query more than once in the same unit of work,which isolation level will not permit this application to see additional rows inserted by other application?

technology databases

  1. Read stability (RS)

  2. Repeatable Read (RR)

  3. Uncommited Read (UR)

  4. Cursor Stability (CS)

Show answer
Correct Option: B

Which of the following DB objects is executable using SQL?

technology databases

  1. View

  2. Table

  3. Routine

  4. Package

Show answer
Correct Option: C

Which of the following resources can be explicitly locked?

technology databases

  1. Row

  2. Page

  3. Table

  4. Column

Show answer
Correct Option: C

A trigger can be created on which of the following objects?

technology databases

  1. View

  2. Catalog Table

  3. Stored Procedure

  4. Global Temprory Table

Show answer
Correct Option: A

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

technology databases

  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.

Show answer
Correct Option: A,C

An SGA is
technology databases

  1. tablespace

  2. to store data and control information

  3. datafile

  4. instance

Show answer
Correct Option: B

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?

technology databases

  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.

Show answer
Correct Option: D

Examine the structure of the LOB_STORE table. Name Null? Type ---------------- -------- ------------ LOB_ID NUMBER VIDEO_CLIP BLOB You create a 'DATA_FILES' directory object that contains the 'IMAGE1.GIF'operating system (OS) file. View the Exhibit and examine the LOAD_LOB procedure code that you execute for reading data from the OS file into the BLOB column. It is created with compilation errors. What is the reason?

technology databases

  1. V_BLOB should be initialized to EMPTY_BLOB().

  2. The WRITE routine of DBMS_LOB should be used instead of LOADFROMFILE.

  3. The return type of DBMS_LOB.FILEEXISTS is not compatible with the IF statement.

  4. OPEN, CLOSE, and READONLY routines of DBMS_LOB should be used instead of FILEOPEN, FILECLOSE, and FILE_READONLY.

Show answer
Correct Option: C