DBSkool Header Image Background

Category: BDD_MCQPage 1 of 2

Advance Database Structure and Hardware Resources

1. 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:…

Business Rules and Field Setting

1. 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…

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…

Planning and Preparation through Analysis

1. The very beginning of database model design is A. Doing the code with the programmers B. Drawing up a specific analysis of what is needed C. Drawing…

Building Fast-Performing Database Modeling

1. Which of these apply to OLTP databases? A. Large Transaction B. High concurrency C. Frequent servicing opportunities D. Real-time response to end-users Answer: B 2. Which of…

Understanding Data Warehouse Database Modeling

1. Which type of database can consume large portion of RAM by transferring data between disk and memory. A. OLTP B. Client server C. Ware house Answer: C…

Advance Relational Database Modeling

1. Which of the following is true about De-normalization? A. De-normalization is often the opposite way of normalization. B. De-normalizing BCNF leads to poor performance. C. After De-normalizing…

Reading & Writing Data with SQL

1. SQL is a ____________ ? A. Procedural Language B. Non Query Language C. Non Procedural Language D. Unstructured Language Answer: C 2. Create, Alter, Drop is ________?…

Understanding Normalization

1. Which NF eliminates transitive dependencies? A. 1NF B. 2NF C. 3NF D. 4NF E. 5NF Answer: C 2. Which NF eliminates cyclic dependencies? A. 1NF B. 2NF…

Database Modeling Building Blocks

1. A constraint – A. Restricts the number of columns in database, B. Restricts the number of tables in database. C. Restricts the value in database D. Controls…