Tag: databases

Questions Related to databases

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

  1. OLAP

  2. OLTP

  3. ETL

  4. None of the Above

Show answer
Correct Option: A

What is a virtual data warehouse
technology databases

  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

Show answer
Correct Option: C

A Data Warehouse can have multiple FACT Tables
technology databases

  1. True

  2. False

Show answer
Correct Option: B

Which of the following are schema's in Data Warehouse models
technology databases

  1. Star

  2. Snow Flake

  3. Both of the Above

  4. None of the Above

Show answer
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?
technology databases

  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.

Show answer
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?

technology databases

  1. UNDOSTAT

  2. ROLLSTAT

  3. TRANSACTION

  4. DBA_UNDO_EXTENTS

  5. DBA_ROLLBACK_SEGS

Show answer
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?
technology databases

  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.

Show answer
Correct Option: D

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

  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.

Show answer
Correct Option: D,E

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

  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

Show answer
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?
technology databases

  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.

Show answer
Correct Option: D