0

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?

  1. ADD_MONTHS

  2. NEXT_DAY

  3. LAST_DAY

  4. NEXT_MONTHS


Correct Option: B
  1. SAVEPOINT

  2. GRANT

  3. ROLLBACK

  4. COMMIT


Correct Option: B
  1. CONCAT

  2. MOD

  3. ROUND

  4. CONVERSION FUNCTION


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