databases Online Quiz - 204

Description: databases Online Quiz - 204
Number of Questions: 20
Created by:
Tags: databases
Attempted 0/20 Correct 0 Score 0

When WORKAREA_SIZE_POLICY is set to AUTO, the work areas are sized to accomplish which two goals? (Choose two)

  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

Which one the following occurs when the extract phase of the ETL is going on

  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

Which one of the primary keys are most commonly used for a fact table

  1. Single Field

  2. Composite

  3. Index Based

  4. Finite State

Correct Option: B

Which one of the query languages are specialized for Data mining models

  1. Structured Query Language

  2. XQuery

  3. Data Mining Extensions

  4. Multi dimensional Expressions

Correct Option: C

Expand MOLAP

  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

If you are using a validation which looks for similar matches in data when cleansing data. Which one the following types of validation works

  1. Balloon

  2. Fuzzy

  3. Strict

  4. Cloud

Correct Option: B

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

Which is NOT TCL Statements ?


  2. GRANT



Correct Option: B

Which is Single Row Function?


  2. MOD

  3. ROUND


Correct Option: A,B,C,D

Normalization: which is automatic NORMAL form? (NF=normal form)

  1. 1NF

  2. 2NF

  3. 3NF

  4. 4NF

Correct Option: A
  1. What is VOB
  1. Versioned Object

  2. Versioned Object Base

  3. Version Objects

  4. Versioned Objects

Correct Option: A,B,C,D

Choose All Approriate About Clear Case

  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

After an element is added to a directory "Add to Source Control" need to done to give control to the clearcase over that element

  1. True

  2. False

Correct Option: A

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

Which is the most commonly used type of table?

  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