0

databases Online Quiz - 67

Description: databases Online Quiz - 67
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  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


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?

  1. Read stability (RS)

  2. Repeatable Read (RR)

  3. Uncommited Read (UR)

  4. Cursor Stability (CS)


Correct Option: B

Which of the following DB objects is executable using SQL?

  1. View

  2. Table

  3. Routine

  4. Package


Correct Option: C

Which of the following resources can be explicitly locked?

  1. Row

  2. Page

  3. Table

  4. Column


Correct Option: C
  1. View

  2. Catalog Table

  3. Stored Procedure

  4. Global Temprory Table


Correct Option: A

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.


Correct Option: A,C
  1. tablespace

  2. to store data and control information

  3. datafile

  4. instance


Correct Option: B
  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.


Correct Option: C
  1. buffer cache

  2. library cache

  3. data dictionary cache

  4. none of the above


Correct Option: B
  1. Security policies can be associated only with tables, but not with views.

  2. Different policies can be used for SELECT, INSERT, UPDATE, and DELETE statements.

  3. User statements are dynamically modified by the Oracle server through a security policy function.

  4. Fine-grained access control policies always remain in effect until they are dropped from a table or view.


Correct Option: B,C
  1. The package executes successfully and passes the required data to the host variable.

  2. The package specification gives an error on compilation because cursor variable types cannot be defined in the specification.

  3. The package specification gives an error on compilation because the cursor variable parameter was specified before you defined it.

  4. The package executes successfully, but does not pass the required data to the host variable because the cursor is closed before the


Correct Option: D

Which two types of query results cannot be stored in the query result cache? (Choose two.)

  1. subquery results

  2. results of a query having the SYSDATE function

  3. results of a query having the GROUP BY clause

  4. results of a query having the DATE data type in the WHERE clause


Correct Option: A,B
  1. Only varrays must start with the subscript 1.

  2. Only varrays can be used as column types in database tables.

  3. Both associative arrays and varrays must start with the subscript 1.

  4. Both associative arrays and varrays can be used as column types in database tables.


Correct Option: A,B

Which index is best suited in case of a table having redundant data

  1. function index

  2. B tree

  3. Bitmap

  4. Primary key


Correct Option: C

Which Command will bounce the database, that is shut down and start the database in one command

  1. STARTUP FORCE

  2. SHUTDOWN FORCE

  3. SHUTDOWN START

  4. No single command available


Correct Option: A
  1. catproc.sql

  2. utlchain.sql

  3. catchain.sql

  4. utlproc.sql


Correct Option: B
- Hide questions