databases Online Quiz - 204

Description: databases Online Quiz - 204
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0
  1. To tune memory using the existing *_AREA_SIZE parameters.

  2. To allocate memory to work areas in order to optimize throughput only.

  3. To allocate memory to work areas in order to optimize response time only.

  4. To allocate memory to work areas in order to optimize both throughput and response time.

  5. To ensure that the overall size of the PGA will never exceed the value of PGA_AGGREGATE_TARGET.

Correct Option: D,E

In what way are the two initialization parameters PGA_AGGREGATE_TARGET and WORKAREA_SIZE_POLICY related to each other?

  1. The default value for PGA_AGGREGATE_TARGET depends on the setting of WORKAREA_SIZE_POLICY.

  2. You must provide a non-default value for PGA_AGGREGATE_TARGET before setting

  3. The value of PGA_AGGREGATE_TARGET can only be changed dynamically (that is, when the instance is

  4. You must not provide a non-default value for PGA_AGGREGATE_TARGET before setting

Correct Option: B
  1. Data is collected from multiple data sources

  2. Data is loaded into data warehouse

  3. Meta data is built

  4. None of the above

Correct Option: A
  1. Single Field

  2. Composite

  3. Index Based

  4. Finite State

Correct Option: B
  1. Structured Query Language

  2. XQuery

  3. Data Mining Extensions

  4. Multi dimensional Expressions

Correct Option: C
  1. Multiple Dimensions Online Analytical Processing

  2. Multiple Dimensions Online Analysis Processing

  3. Multidimensional Online Analysis Processing

  4. Multidimensional Online Analytical Processing

Correct Option: D

which is Implicit data type Conversion?

  1. Char >> number

  2. Char >> date

  3. Number >> varchar2

  4. Date >> varchar2

Correct Option: A,B,C,D

Which is NOT Date function?





Correct Option: B

  2. GRANT



Correct Option: B

  2. MOD

  3. ROUND


Correct Option: A,B,C,D
  1. What is VOB
  1. Versioned Object

  2. Versioned Object Base

  3. Version Objects

  4. Versioned Objects

Correct Option: A,B,C,D
  1. provides parallel development

  2. provides versioning

  3. provides automation

  4. All the above

Correct Option: A,B,C,D

Using Clear Case what are all can be created

  1. Branches

  2. Labels

  3. Both 1 and 2

  4. All the above

Correct Option: A,B,C,D

You are developing SQL statements for the application. Which of the following SQL operations requires the use of a subquery?

  1. IN

  2. Between

  3. Exists

  4. Like

Correct Option: C
  1. Clustered

  2. Partitioned

  3. Regular

  4. Index organized

Correct Option: C

You are developing some code to handle transaction processing. Which signifies the beginning of a new transaction ?

  1. set transaction

  2. Opening a new session

  3. commit

  4. savepoint

Correct Option: A,B,C

An object in Oracle contains many columns, The object requires segments to be stored in areas of the database other than the data dictionary ?

  1. Sequence

  2. View

  3. Synonym

  4. Table

Correct Option: D
- Hide questions