TECHNICAL INTERVIEW QUESTION ANSWERS OF CGI FOR FRESHERS OF SQL

 TECHNICAL INTERVIEW QUESTION ANSWERS OF CGI FOR FRESHERS OF SQL


Q1. What is the purpose of Database Systems ?
Ans : The purpose of Database Systems which was developed was to handle the difficulties of the typical file-processing systems which was supported by conventional operating systems. The difficulties were : 
1) Data redundancy and inconsistency.
2) Difficulty in accessing data.
3) Data isolation - multiple files and formats.
4) Integrity problems.
5) Atomicity of updates.
6) Concurrent access by multiple users.
7) Security problems.

Q2. State the difference between Security and Integrity ?
Ans : Security - Data Security basically deals with the protection of data.
Integrity - Data Integrity basically deals with the validity of data.

Q3. Define Normalisation ?
Ans : Normalisation - Normalisation is the process of reorganizing data in a database so that it can meet two basic requirements. The two basic requirements are : 
1) There is no redundancy of data.
2) Data dependencies are logical.

Q4. What is a Linked Server ?
Ans : Linked Server - Linked Server allows us to connect to other database instances on the same server or on another machine or remote servers.

Q5. What is Collation ?
Ans : Collation - Collation specially specifies how data is sorted and compared in a database. It provides the sorting rules, case and accent sensitivity properties for the data in the database.

Q6. Define Unique Key ? 
Ans : Unique Key - Unique Key is a set of one or more than one fields/columns of a table that uniquely identify the record in a database table.

Q7. What are the different types of Collation Sensitivity ?
Ans : The different types of Collation Sensitivity are as follows :
1) Case Sensitivity - It is A and a, B and b, etc.
2) Accent Sensitivity - It is a and a', o and o',etc.
3) Kana Sensitivity - When Japanese Kana Characters Hiragana and Katakana are treated differently it is known as Kana Sensitivity.
4) Width Sensitivity - It is a single-byte character and the same character represented as a double-type character are treated differently than it is known as width sensitivity.  

Q8. What is a synonym ?
Ans : Synonym - Synonym is an alternative name for objects such as Tables, Views, Sequences, Stored Procedures, and other database objects.

Q9. Define Primary Key ?
Ans : Primary Key - Primary Key is a constraint which uniquely identifies each record in a table. It must contains unique values but it cannot contain null values.

Q10. What is the difference between normalization and denormalization ?
Ans : Normalization - It's data integrity is maintained. It's redundancy is eliminated. Here the number of tables increases. 
Denormalization - It's data integrity may not be retain. It's redundancy is added. Here the number of tables decreases. 

Q11. What is an Integrity Constraints ?
Ans : Integrity Constraints - Integrity Constraints are a set of rules. It is used to maintain the quality of information.  


   


   

Comments

Post a Comment

Popular posts from this blog

C Programming Mini Project On Puzzle Game

Image
 Puzzle  Programming #include<stdio.h> (#include is the inclusion of stdio, stdio.h is known to contain the input and output operations like "printf" or "scanf" & "h" extension means the header file) #include<conio.h> (# include is a preprocessor directive  used to paste the code of given file to the current file and conio.h is a non standard header file) #include<ctype.h> (ctype.h is the header file which declares several functions that are useful for testing and mapping characters) #include<stdlib.h> (stdlib.h is the header file which defines four variable types i.e. size_t, wchar_t, div_t & Idiv_t, several macros & various functions for performing general functions) #include<string.h> (h is the header file required for string functions. This function appends not more than n characters from the string pointed to by src to the end of the string pointed to by dest plus a terminating Null-character) void show_record...
Read more

Oxygen Cylinders Suppliers For Covid - 19 In India

Oxygen Cylinders Suppliers For Covid - 19 In Patna  1) Oxygen Bank - +91 9334206111 2) Vidya - +91 9835420734 3) Sanjay Sarkar - +91 8809989999 4) Amresh - +91 8797348700 5)  Ramesh Mahajan - +91 9334486903 6)  Ajay Tiwari - +91 7257804224 7) Ronit Ranjan - +91 9015780787 8) TN Singh - +91 9934716122 9) Santosh Mishra - +91 9835287776 10) S P Verma - +91 9534771419 11) Gaurav Singha - +91 9308409095 12) Dr. Saki - +91 7679758811 13) Fehad - +91 9334101941 14) Atif - +91 6204867980 15) Gangotri - +91 9608791349 Oxygen Cylinders Suppliers For Covid - 19 In Ghaziabad  1) Apsolabs Pvt. Ltd. - +91 8840886102 2) Aliya Health Care Group Pvt. Ltd. - +91 9899019007 3) Oxygen Concentrator In Ghaziabad - +91 9310719082 Oxygen Cylinders Suppliers For Covid - 19 In Noida 1) Oxygen Cylinder Rental - +91 9810475170 2) Oxygen Concentrator For Rent - +91 7838948874 3) Mittal Air Products - +91 9899390876 Oxygen Cylinders Suppliers For Covid - 19 In Mumbai 1) Maharashtra Health Care -...
Read more

TOP 10 IT COMPANIES IN INDIA

Image
  TOP 10 IT COMPANIES IN INDIA 1) TATA CONSULTANCY SERVICES Tata Consultancy Services It is one of the biggest Indian multinational IT Service and Consultancy company which is headquarted in Mumbai, Maharashtra, India. The FOUNDER of TCS is RATAN NAVAL TATA,MD and CEO of TCS is RAJESH GOPINATHAN and it's CHAIRMAN is NATARAJAN  CHANDRASEKARAN. It is a supplement of Tata Group. It operates in 149 locations across 46 countries. It is one of the largest Indian Company by Market Capitalisation. It is founded in 1968 by Tata Sons. It has 285 offices across 46 countries and 147 delivery centers in 21 countries. It is one of the most valuable IT Services brands worldwide. In 2016-2017, Tata Sons owned 20% Of TCS. TCS and its 67 subsidiaries provide a wide range of IT related products and services which includes Application Development And Maintenance which is 43.80%, Assurance Services which is 7.70%, Business Process Outsourcing which is 12.50%, Consulting which is 2%, Industrial And...
Read more