SQL Server SQL Server Database Fundamentals Interview Questions May 6, 2016912 views0 Share By IG Share SQL Server Database Fundamentals Interview Questions cover the basics of a relational database engine independent of a vendor. This is just to get you started with the interview questions. This could be a good starting point before delving into more detailed scenarios. These questions form the base for Database concepts, and knowing them is critical for any data related job opportunities. SQL Server Database Fundamentals Interview Questions Question 1: What is a Database? A database is a collection of information organized in rows and columns in most cases. The data is stored in an optimized way for a computer application to quickly and efficiently select data in a desired presentable format. The primary storage mechanism of a database is in an electronic format stored on a computer file-system. With multiple abbreviations like DB, Data, Records etc. The primary job of a Database is to store data. Databases can be organized by fields, records, and files. A good example is a Telephone Directory which contains a collection of records, each of which consists of different fields like name, address, and telephone number. QUESTION 2: WHAT IS A DBMS? Database management system is an Application which enables you to extract, select, insert, update and delete data. These systems vary in size and functionality to address different needs. For example, an app can store user data locally on a phone, whereas a banking system can store data on an enterprise DBMS running on mainframe computers. Internally, a DBMS can store data in a variety of ways like Flat Files, Relational, Hierarchical or non-structured. There can be different systems to manage data for Transactional processing or reporting. In DBMS, the Application developer is responsible for maintaining ACID properties and data consistency. Examples: Flat Files, Excel Spreadsheets, Microsoft Access. QUESTION 3: WHAT IS AN RDBMS? RDBMS or Relational Data Base Management Systems are a type of DBMS (Database management systems) that records and maintains data with indices in the tables. You can create Relationships based upon assumptions about how data is related and will be extracted from the database. One of the notable features of relational systems is that a single database can be spread across several tables. In a relational database, relationships are created between tables. These interdependencies are created by data values rather than by pointers. These are created to maintain data consistency and referential integrity with ACID properties. Examples: Microsoft SQL Server, Oracle Database, IBM DB2, Sybase etc. Question 4: What are the Properties of the Relational Tables? RDBMS have six properties and are as follows: Values are atomic. Column values are of the same kind. Each row is unique. The sequence of columns is insignificant. The sequence of rows is insignificant. Each column must have a unique name. Question 5: What is Normalization? Database normalization is a technique of organizing the data in the database using a design methodology to reduce or minimize Data Redundancy and the process is called normalization. Generally while performing a Normalization process you would ideally need to divide a database into two or more tables and define relationships between the tables. By doing this, it allows Users and Applications to isolate data such that any additions, deletions, and data modifications of a row or a column can be made in one table and then propagated through the rest of the database based on the defined relationships. Normalization allows you to avoid data loss possibilities during Insert, Update and Deletion and avoid any Anomalies. Question 6: What are the normalization rules? There are four types of normalization forms: 1 First Normal Form (1NF): This rule tells that you must Eliminate Repeating Groups by making a separate table for each set of related attributes, and give each table a primary key. Each field contains at most one value from its attribute domain. 2. Second Normal Form (2NF): In order to remove redundant data, If an attribute depends on only part of a multi-valued key, then remove it to a separate table. 3. Third Normal Form (3NF): The Third Normal form applies to tables where you should Eliminate Columns Not Dependent On Key, else remove then to a separate table. 4. Boyce and Codd Normal Form (BCNF): This is an enhanced version of the Third Normal form where if there are non-trivial dependencies between candidate key attributes, then separate them out into distinct tables. Other Normalization Forms: 5NF: Isolate Semantically Related Multiple Relationships ONF: Optimal Normal Form DKNF: Domain-Key Normal Form Hope these questions on SQL Server Database Fundamentals Interview Questions was helpful. If you have any questions or suggestions, please use the comment section down below. Disclaimer: The Questions and Answers provided on https://www.gigxp.com are for general information purposes only. We make no representations or warranties of any kind, express or implied, about the completeness, accuracy, reliability, suitability or availability with respect to the website or the information, products, services, or related graphics contained on the website for any purpose. Share What's your reaction? Excited 0 Happy 0 In Love 0 Not Sure 0 Silly 0 IG Website Twitter
TSQL How to Effectively split a string using STRING_SPLIT function in SQL server By DataGeekApril 15, 2019
SQL Server SQL Server 2019 System Requirements – Hardware & Software Prereqs In this article, we will be sharing the SQL Server 2019 System Requirements based on ...
Interview Questions T-SQL Performance Tuning on Bulk Load Data in SQL Server 2017 In this article, we are going to talk about a specific scenario where T-SQL Performance ...
SQL Server How To Check & Fix Index Fragmentation on SQL Server via Script & ssms Before we learn to fix Index fragmentation on SQL Server, let us understand why this ...
SQL Server Fixing SQL Server Max Worker Threads: error: 35217, severity: 16, state: 1 If you try fixing SQL Server Max Worker Threads for errors such as: “The thread pool ...