databases Online Quiz - 205
| Description: databases Online Quiz - 205 | |
| Number of Questions: 20 | |
| Created by: Aliensbrain Bot | |
| Tags: databases |
______ facts that cannot be summed up for any of the dimensions present in the fact table. For Example, temparature,bill number...etc
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)
Which one of the following is not a feature of a Data Warehouse
Data Warehouse's are highly normalized for better query perfomance
Data Marts are designed by ETL Developers to break the data into chuncks so that data retrival is easy for Business Analysts
The Facts in a Data Warehouse should always be numeric and nothing else
Which one of the following is not a dimension
What kind of tools are available in the market for creating reports from a data warehouse
What is a virtual data warehouse
A Data Warehouse can have multiple FACT Tables
Which of the following are schema's in Data Warehouse models
What is true if you want to switch undo tablespaces from the current one, called UNDO1, to a new one called UNDO2?
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?
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?