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

When does a view get populated?

  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

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

  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

An SGA is

  1. tablespace

  2. to store data and control information

  3. datafile

  4. instance


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?

  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.


Correct Option: D
  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

This reduces the processing time used for parsing and execution

  1. buffer cache

  2. library cache

  3. data dictionary cache

  4. none of the above


Correct Option: B

Which two statements are true about the working of fine-grained access? (Choose two.)

  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

Examine the code in the following PL/SQL block: DECLARE TYPE NumList IS TABLE OF INTEGER; List1 NumList := NumList(11,22,33,44); BEGIN List1.DELETE(2); DBMS_OUTPUT.PUT_LINE ( 'The last element# in List1 is ' || List1.LAST || ' and total of elements is '||List1.COUNT); List1.EXTEND(4,3); END; / Which two statements are true about the above code? (Choose two.)

  1. LAST and COUNT give different values.

  2. LAST and COUNT give the same values.

  3. The four new elements that are added contain the value 33.

  4. The four new elements that are added contain the value 44.


Correct Option: A,C

Examine the structure of the DEPARTMENTS table. Name Null? Type ----------------------------- ------------ ---------- DEPARTMENT_ID NOT NULL NUMBER(4) DEPARTMENT_NAME NOT NULL VARCHAR2(30) LOCATION_ID NUMBER(4) View the Exhibit and examine the code that you plan to use for creating a package to obtain the details of an employee using a host variable on the client side. In SQL*Plus, you plan to use the following commands: SQL> VARIABLE x REFCURSOR SQL> EXECUTE emp_data.get_emp(195,:x) SQL> PRINT x Which statement is true about the above scenario?

  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

Which two statements are true about associative arrays and varrays? (Choose two.)

  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 two values from v$session view are used to terminate a user session

  1. SID

  2. USer ID

  3. Serial #

  4. Sequence #


Correct Option: A,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

What is the prefix for dynamic performance tables

  1. DBA_

  2. V_$

  3. X$

  4. V#


Correct Option: B

Which script creates the CHAINED_ROWS table

  1. catproc.sql

  2. utlchain.sql

  3. catchain.sql

  4. utlproc.sql


Correct Option: B
- Hide questions