Tag: databases

Questions Related to databases

This reduces the processing time used for parsing and execution
technology databases

  1. buffer cache

  2. library cache

  3. data dictionary cache

  4. none of the above

Show answer
Correct Option: B

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

  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.

Show answer
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.)
technology databases

  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.

Show answer
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?

technology databases

  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

Show answer
Correct Option: D

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

  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

Show answer
Correct Option: A,B

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

  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.

Show answer
Correct Option: A,B

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

  1. function index

  2. B tree

  3. Bitmap

  4. Primary key

Show answer
Correct Option: C

Which two values from v$session view are used to terminate a user session
technology databases

  1. SID

  2. USer ID

  3. Serial #

  4. Sequence #

Show answer
Correct Option: A,C

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

  1. STARTUP FORCE

  2. SHUTDOWN FORCE

  3. SHUTDOWN START

  4. No single command available

Show answer
Correct Option: A

What is the prefix for dynamic performance tables
technology databases

  1. DBA_

  2. V_$

  3. X$

  4. V#

Show answer
Correct Option: B