SQL Interview Questions and Answers for Experienced - 1
Question: 1
What is the difference between UNIQUE and PRIMARY KEY?
- The UNIQUE KEY column restricts entry of duplicate values but entry of NULL value is allowed.
- In case of PRIMARY KEY columns entry of duplicate as well as value is also restricted.
Question: 2
What is a cursor?
- An entity that maps over a result set and establishes a position on a single row within the result set.
- After the cursor is positioned on a row, operations can be performed on that row, or on a block of rows starting at that position.
- The most common operation is to fetch (retrieve) the current row or block of rows.
Question: 3
What is a view?
- A view is a database object that is a logical representation of a table.
- It is derived from a table but has no storage space of its own and often may be used in the same manner as a table.
Question: 4
What is a pre-requisite for connection pooling?
Multiple processes must agree that they will share the same connection, where every parameter is the same, including the security settings.
Question: 5
Which are the default databases get installed with the MSSQL installation?
- Master
- Model
- msdb
- Northwind
- Pubs
- tempdb
Related Questions
- Top 100+ SQL Query Interview Questions and Answers
- SQL Interview Questions and Answers for Freshers
- Best 100+ SQL Interview Questions and Answers 2020-21
- SQL Interview Questions and Answers for Experienced
- Top 100+ Advanced SQL Interview Questions 2020-2021
- SQL Interview Questions with Answers for Freshers
- Complex SQL Interview Questions and Answers Pdf
Recent Articles
Gross Domestic Product and Its Growth Class 10 Questions Pdf More
Industrial Cluster in Tamil Nadu TNPSC Questions Pdf More
Food and Security TNPSC Questions Pdf More
Economics Food Security and Nutrition Class 10 Questions Pdf More
Class 10th Social Indian Constitution Pdf More
TNPSC Indian Constitution Questions and Answers Pdf More
February-17-2025
| Meritnotes
Industrial Cluster in Tamil Nadu TNPSC Questions Pdf More
February-17-2025
| Meritnotes
Food and Security TNPSC Questions Pdf More
February-17-2025
| Meritnotes
Economics Food Security and Nutrition Class 10 Questions Pdf More
February-17-2025
| Meritnotes
Class 10th Social Indian Constitution Pdf More
February-16-2025
| Meritnotes
TNPSC Indian Constitution Questions and Answers Pdf More
February-16-2025
| Meritnotes
Trending Posts
Measurement and Instrumentation Question Bank More
Signals and Systems MCQ Questions and Answers Pdf More
1000+ Logical Puzzles Questions and Answers More
PHP Interview Questions and Answers More
History The Age of Revolutions Class 9 Questions Pdf More
1000+ Advanced C Programming Interview Questions & Answers More
February-22-2023
| Meritnotes
Signals and Systems MCQ Questions and Answers Pdf More
April-24-2024
| Meritnotes
1000+ Logical Puzzles Questions and Answers More
October-03-2020
| Meritnotes
PHP Interview Questions and Answers More
August-29-2019
| Meritnotes
History The Age of Revolutions Class 9 Questions Pdf More
February-03-2025
| Meritnotes
1000+ Advanced C Programming Interview Questions & Answers More
September-24-2022
| Meritnotes