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

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
  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
  1. ADD_MONTHS

  2. NEXT_DAY

  3. LAST_DAY

  4. NEXT_MONTHS


Correct Option: B

Which is NOT TCL Statements ?

  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

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