Note 1

Take Note:

Take a note while surfing.





Note With Ink

Give your Note a Colorful Tag.




Easy to Access

Stay on same information and in Sync wherever you are.

Note 2

Take Note:

Organize your information,It may take Shape.





Think With Ink

Differ your Content by Color.




Easy to Access

Easy to pull up your content from anywhere anytime.

Note 3

Take Note:

Don't Let information to miss,Because it take shape





Note With Ink

Simple an Easy Way to take a note.




Easy to Access

Get the same in next visit.


Please wait...

Technical Interview Questions and Answers :: SQL

    Question :: 1
    What is Magic Table in SQL?
    Answer:

    : The insert and Delete commands are known as magic tables in SQL.

    Please Login First :

    Tags:No Tags on this question yet!

    Question :: 2
    Can Primary key is a Foreign Key on the same table?
    Answer:

    Yes, Consider a category table in a e-commerce web site.
    Category_Id, Category_Name, Parent_Category_ID. In this table all the parent categories are also categories. When we create a self join category id will be treated as foreign key to the same table.

    Please Login First :
    Question :: 3
    What is Normalization?
    Answer:

    Nnormalization is step by step process of spiliting the bigger table into smaller table without changing any functionality. This wil improve the performance.



    There are some way to normalize table 



    A. 1nf



    B.2nf



    C.3nf



     

    Please Login First :
    Question :: 4
    What are the advantages and disadvantages of Normalization?
    Answer:

    There are several advantages of normalization as under:
    * Faster sorting and index creation.
    * A larger number of clustered indexes.
    * Narrower and more compact indexes.
    * Fewer indexes per table, which improves the performance of INSERT, UPDATE, and DELETE statements
    * Fewer null values and less opportunity for inconsistency, which increase database compactness.

    Beside the above benefits there are few disadvantages as well:
    * Increased amount of Normalization increases the amount of complexity of joins between tables and that hinders the performance.

    Please Login First :
    Question :: 5
    What are the conditions to achieve the normalization?
    Answer:

    There are few conditions to achieve the normalization:
    * There should be a unique row identifier.
    * A table should store only data for a single type of entity. For e.g. details for book’s publisher and book’s author should be saved under different table.
    * A table should avoid columns which can be null-able.
    * A table should avoid duplication of data and columns.

    Please Login First :

    Tags:No Tags on this question yet!

    Question :: 6
    What is a Clustered Index?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    Tags:No Tags on this question yet!

    Question :: 7
    What is a Non-Clustered Index?
    Answer:

    The data rows are not stored in any particular order, and there is no particular order to the sequence of the data pages. In a clustered index, the physical order of the rows in the table is not same as the logical (indexed) order of the key values.

    Please Login First :

    Tags:No Tags on this question yet!

    Question :: 8
    Describe the three levels of data abstraction?
    Answer:

    The are three levels of abstraction:
    * Physical level: The lowest level of abstraction describes how data are stored.
    * Logical level: The next higher level of abstraction, describes what data are stored in database and what relationship among those data.
    * View level: The highest level of abstraction describes only part of entire database

    Please Login First :

    Tags:Virtusa

    Question :: 9
    What is DDL (Data Definition Language)?
    Answer:

    A data base schema which is specified by a set of definitions expressed by a special language is called DDL. Data Definition Language (DDL) is used to define and manage all the objects in an SQL database.

    Please Login First :
    Question :: 10
    What is DML?
    Answer:

    It is a special language used to manipulate the Data. Data Manipulation Language (DML), which is used to select, insert, update, and delete data in the objects defined using DDL.

    Please Login First :

Looking to grab a job as a Database Developer or Administrator? You can easily find SQL technical interview questions and answers on this page. All the questions have been previously asked during the technical rounds in IT companies. You can test your SQL database knowledge by solving these questions and compare your chances of fetching the job with a top IT company.

Are you targeting a specific IT company like Adobe? You can filter the question set by the company name easily. If you are not sure about a specific answer, you can easily click and read the answer along with the explanation. So, check these SQL technical interview questions and answers to prepare for your dream job.