0

databases Online Quiz - 205

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

Which one of the following is not a feature of a Data Warehouse

  1. Time - Variant

  2. Non Volatile

  3. Integrated

  4. Process Oriented


Correct Option: D

Data Warehouse's are highly normalized for better query perfomance

  1. True

  2. False


Correct Option: B

Data Marts are designed by ETL Developers to break the data into chuncks so that data retrival is easy for Business Analysts

  1. True

  2. False


Correct Option: B

The Facts in a Data Warehouse should always be numeric and nothing else

  1. True

  2. False


Correct Option: B

Which one of the following is not a dimension

  1. Sales

  2. Audit

  3. Degenarate

  4. Person


Correct Option: A

What kind of tools are available in the market for creating reports from a data warehouse

  1. OLAP

  2. OLTP

  3. ETL

  4. None of the Above


Correct Option: A
  1. A Very huge data data warehouse

  2. A Data Warehouse implemented using distributed databases

  3. A set of phyisical databases for a single subject

  4. A datawarehouse with only historic data


Correct Option: C
  1. Star

  2. Snow Flake

  3. Both of the Above

  4. None of the Above


Correct Option: C

What is true if you want to switch undo tablespaces from the current one, called UNDO1, to a new one called UNDO2?

  1. It is NOT possible to switch unless no active transaction exists in UNDO1.

  2. It is possible to switch to UNDO2, but current active transactions will abort.

  3. It is possible to switch to UNDO2; current active transactions will be automatically migrated to UNDO2.

  4. It is possible to switch to UNDO2; only current active transactions will continue to execute inside UNDO1.


Correct Option: D

What should you look at first to compute the number of undo blocks that are consumed and estimate the size of the undo tablespace needed to handle the workload on your system?

  1. UNDOSTAT

  2. ROLLSTAT

  3. TRANSACTION

  4. DBA_UNDO_EXTENTS

  5. DBA_ROLLBACK_SEGS


Correct Option: A

Your database contains at least one undo tablespace. You attempt to start an instance in Automatic Undo Management mode, but without specifying an undo tablespace in the initialization parameter file. What happens?

  1. The instance will not start.

  2. The instance starts up and uses the SYSTEM rollback segment for all undo entries.

  3. The instance starts up and uses the SYSTEM tablespace for the automatic undo segments.

  4. The instance starts up and uses the first available undo tablespace for the automatic undo segments.


Correct Option: D

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

What is true if you want to switch undo tablespaces from the current one, called UNDO1, to a new one called UNDO2?

  1. It is NOT possible to switch unless no active transaction exists in UNDO1.

  2. It is possible to switch to UNDO2, but current active transactions will abort.

  3. It is possible to switch to UNDO2; current active transactions will be automatically migrated to UNDO2.

  4. It is possible to switch to UNDO2; only current active transactions will continue to execute inside UNDO1.


Correct Option: D

Your database contains at least one undo tablespace. You attempt to start an instance in Automatic Undo Management mode, but without specifying an undo tablespace in the initialization parameter file. What happens?

  1. The instance will not start.

  2. The instance starts up and uses the SYSTEM rollback segment for all undo entries.

  3. The instance starts up and uses the SYSTEM tablespace for the automatic undo segments.

  4. The instance starts up and uses the first available undo tablespace for the automatic undo segments.


Correct Option: D
- Hide questions