DBSkool Header Image Background

Tag: database design

Creating Database

1. Which privilege is required to create a database? A. DBA B. SYSDBA C. SYSOPER D. RESOURCE Answer: B 2. You are logged on to a client. You…

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…

Understanding Data Warehouse Database Modeling

1. What is meant by surrogate key in a data warehouse? Used as a replacement or substitute for a descriptive primary key, allowing for better control , better…

Advance Relational Database Modeling

1. What does it mean by Demoralization? De-normalization is most often the opposite of normalization, more commonly used in data warehouse or reporting environments. It decreases granularity by…