Questions
Which of the following data models comprises a set of rules according to which databases can be constructed?
- Structural part
- Manipulative part
- Set of integrity rules
- Logical design
- Physical design
Which of the following physical design structures comprises one or more data files, which are physical structures with the operating system one is using?
- Structural part
- Table spaces
- Partitioned tables
- Views
- None of these
__________________ is the process of modelling and formalising data requirements in an intrinsic part of the database design process.
- Data cube
- Indexing
- Physical storage
- Data modelling
- Parallelism
Which physical design structure is used to enforce business rules associated with one's database and to prevent having invalid information in the table?
- Materialized views
- Data segment compression
- Indexing
- Integrity constraints
- Views
Which of the following applications of RAID technology takes data that needs to be stored, and distributes it evenly between two or more hard drives?
- Mirroring
- Data stripping
- Parity checking
- Partitioned tables
- None of these
Which of the following refers to delibrate splitting of a table and its index data into manageable parts?
- Data parallelism
- Physical design
- Data partitioning
- Logical design
- None of these
____________________ should be used with highly redundant data, such as tables with many foreign keys. It can also speed up query execution.
- Integrity constraints
- Views
- Materialized views
- Table spaces
- Data segment compression
_____________ is the idea of breaking down a task so that, instead of one process doing all the work in a query, many processes do part of the work at the same time.
- Parallelism
- Data segment compression
- Table spaces
- Physical design
- Structural part
Which of the following tasks in data transformation includes a large variety of rudimentary conversions of single fields for two primary reasons; one to standardise among data extractions from disparate source systems, and the other to make the fields usable and understandable to the users?
- Selection
- Splitting / Joining
- Conversion
- Summarization
- Enrichment
___________ are most commonly used in a data warehouse to index unique or near-unique keys.
- B-tree indexes
- Materialized views
- Manipulative part
- Physical design
- None of these
_________________ allows data to be modelled and viewed in multiple dimensions.
- Data cube
- Data loading
- Data transformation
- Data quality
- None of these
Which of the following is referred to as the state of completeness, validity, consistency, timeliness and accuracy that makes data appropriate for a specific use?
- Data modelling
- Physical storage
- Data partitioning
- Data quality
- Data stripping
Which of the following is widely used in data warehousing environment, which typically have large amounts of data and ad hoc queries, but a low level of concurrent DML transactions?
- B-tree index
- Bitmap index
- View
- Clustered index
- B+-tree
_______________ task is the rearrangement and simplification of individual fields to make them more useful for the data warehouse environment.
- Splitting / Joining
- Enrichment
- Selection
- Data extraction
- Conversion
__________ is the operation of extracting data from a source system for further use in a data warehouse environment.
- Enrichment
- B-tree index
- Data loading
- Data segment compression
- Data extraction