Home › Quizzes › Oracle Database & Data Warehousing Fundamentals

Oracle Database & Data Warehousing Fundamentals

Quiz covering Oracle database administration topics including undo tablespaces and PGA management, along with data warehousing concepts including schemas, dimensions, facts, and ETL processes.

20 Questions Published
Play Quiz Practise this topic out loud

Questions

Question 1 Multiple Choice (Single Answer)

______ facts that cannot be summed up for any of the dimensions present in the fact table. For Example, temparature,bill number...etc

  1. Additive facts
  2. semi-additive facts
  3. Non-additive facts
  4. Fact less fact
Question 2 Multiple Choice (Single Answer)

The dimension tables in a star schema data mart that adhere to a common structure, and therefore allow queries to be executed across star schemas is called _______. (Note: For example, the Calendar dimension)

  1. Degenerated dimension
  2. Slowly changing dimensions
  3. Conformed dimensions
  4. Junk dimension
Question 3 Multiple Choice (Single Answer)

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

  1. Time - Variant
  2. Non Volatile
  3. Integrated
  4. Process Oriented
Question 4 True/False

Data Warehouse's are highly normalized for better query perfomance

  1. True
  2. False
Question 5 True/False

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
Question 6 Multiple Choice (Single Answer)

Data Cleansing is mainly done at which phase of Data Warehouse Development

  1. Extract
  2. Transform
  3. Load
  4. None of the Above
Question 7 True/False

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

  1. True
  2. False
Question 8 Multiple Choice (Single Answer)

Which one of the following is not a dimension

  1. Sales
  2. Audit
  3. Degenarate
  4. Person
Question 9 Multiple Choice (Single Answer)

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
Question 10 Multiple Choice (Single Answer)

What is a virtual data warehouse

  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
Question 11 True/False

A Data Warehouse can have multiple FACT Tables

  1. True
  2. False
Question 12 Multiple Choice (Single Answer)

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

  1. Star
  2. Snow Flake
  3. Both of the Above
  4. None of the Above
Question 13 Multiple Choice (Single Answer)

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.
Question 14 Multiple Choice (Single Answer)

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
Question 15 Multiple Choice (Single Answer)

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.
Question 16 Multiple Choice (Multiple Answers)

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.
Question 17 Multiple Choice (Single Answer)

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
Question 18 Multiple Choice (Single Answer)

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.
Question 19 Multiple Choice (Single Answer)

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
Question 20 Multiple Choice (Single Answer)

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.
← Back to Quizzes