DBSkool Header Image Background

Category: BDD_ExpressivePage 1 of 2

Beginning Database Design

1. A collection of information preferably related information and organized as known as —— Database 2. The database contains both ——and —– Metadata and row data 3. A…

Advance Database Structure and Hardware Resources

1. What is called view? A logical overlay containing a query, executed whenever the view is accessed. 2. What is meant by index? Usually a copy of a…

Business Rules and Field Settingd

1. What is meant by default option for table? A setting used as an optional value for a field in a record, when a value is not specified….

Creating and Refining Tables During the Design Phase

1. What does it mean by insert check based on referential integrity? A record can’t be added to a child table unless the parent record exists in the…

Planning and Preparation through Analysis

1. Write the steps of creating Database Model. The steps of creating database model are as follows: 1. Analysis 2. Design 3. Construction 4. Implementation 2. What are…

Building Fast-Performing Database Modeling

1. Write the primary characteristics of OLTP database? Characteristics of OLTP database are as follows:  Large user population  Very high concurrency  Large database size …

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…

Reading & Writing Data with SQL

1. What does it mean by SQL? SQL is a non-procedural language used for accessing field and record values in relational database table. 2. What does it mean…

Understanding Normalization

1. Define functional and transitive dependency? Functional dependency: If the value of Y is determined by X then Y is functionally dependent on X. Y=X+1 Transitive dependency: When…