 |
| Creating and Refining Tables During the Design Phase |
1. Performance is exclusively a programming or implementation activity; it should no be included in analysis and design.
A. True
B. False
Answer: B
2. When considering how to build fact and dimensional table structures in a data warehouse database model, we should consider-
A. How reports will be structured.
B. How long those reports will take to run
C. Who will use the data warehouse
D. Where the warehouse is placed.
Answer: A, B
3. Relational model design includes –
A. Refine database model
B. Finding out the company operations
C. Finalization and approval
D. All of above
Answer: A, C
4. What is true about design?
A. Design stage is the next stage following the implementation stage.
B. Design stage is the next stage following the analysis stage.
C. Design is a process of figuring out how to implement what was discovered during the analysis stage.
D. In this stage one should think about a database model from the perspective of how application will use that database.
E. Design does not include technical specification.
Answer: B, C, D
5. According to the 1st normal form easy way, which one of the following is true?
A. It removes repeating values in new tables.
B. It removes repeating fields in new tables.
C. It creates primary key in both tables, where the detail table have composite primary key.
D. It creates primary key in both tables, where the parent table have composite primary key.
Answer: B, C
6. No partial dependencies are allowed in _
A. 1st normal form easy way
B. 1st normal form academic way.
C. 2nd normal form easy way.
D. 2nd normal form academic way
Answer: D
7. What is the problem with de normalization?
A. It degrades the performance.
B. It is very expensive.
C. It requires extensive application knowledge.
D. All of above
Answer: C
8. The soundness of queries and application depends upon
A. The experience of the programmer.
B. The duration of the development of the application.
C. The soundness of the underlying database.
D. The type of the application.
Answer: C
9. Views are not same thing as materialized view.
A. True
B. False
Answer: A
10. Demoralization isn’t always opposite of normalization
A. True
B. False
Answer: A
11. All strings and numbers values are ------------------
A. Fixed Length
B. Variable Length
C. All of the above
D. None of the above
Answer: A
12. Demoralization 3nf forms to eliminate what arte called ------------
A. Transitive Dependences
B. Cyclic Dependencies
C. Multi-valued Dependencies
D. None of the above
Answer: A
13. Transitive dependency directly determined by the primary key
A. True
B. False
Answer: B
14. To act use of demoralization 2nf removing which type of values?
A. Static value.
B. Dynamic Values
C. None of the above
D. All of the above
Answer: A
15. Shareable hardware structures are known as --------
A. Concurrency
B. Parallel Processing
C. All of the above
Answer: A
16.To make together in database what key is needed? -----
A. Surrogate key.
B. Primary Key
C. Foreign key
D. None of the above
Answer: A
17. A single hierarchical level used in ----
A. Star
B. Snowflake
C. None of the above
D. All Of the above
Answer: A
18. Fact table foreign keys are called ----?
A. Primary Key
B. Surrogate key
C. Foreign Key
D. None of the above
Answer: B
19. Database tuning must be done _______.
A. During the design phase.
B. Before any development is complete.
C. During Construction Phase
D. None of the above
Answer: A, B
20. A materialized views allows______.
A. Physical copy of table data.
B. Logical copy of table data
C. Both of the above
D. None of the above
Answer: A
21. The quality of SQL code depends completely on_____.
A. The quality of database model design.
B. The quantity of database model
C. None of the above
D. Both of the above
Answer: A
22. Which are correct? [Choose two]
A. Database model design supports SQL code.
B. SQL code supports application.
C. None of the above
D. All of the above
Answer: A, B
23. What are the advantages for using shorter alias name at table?
A. SQL code more easily readable.
B. Having to make future changes.
C. Less prone to error.
D. Easier to tune properly & easier to handle.
E. None of the above
Answer: A, B, C, D
24. The where clause can be used either to ______?
A. Include wanted records or exclude unwanted records or both.
B. Exclude wanted records or include unwanted or both
C. All of the above
D. None of the above
Answer: A
25. Which are true for “Like” operator?
A. Usually involves a full scan of a table & ignore indexing.
B. Extremely inefficient searching for a small no. of records.
C. All of the above
Answer: C
0 Comments