Take FREE!! Online AMCAT Mock Test to Crack Wipro NLTH, Capgemini, etc.
Get Off-Campus Placement Jobs Info !!!
Practice Given Here Wipro NLTH Practice Q&A

Technical Interview Questions and Answers :: SQL

    31 / 106

    What is Magic Table in SQL?
    Answer:

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

    Please Login First :

    32 / 106

    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 :

    33 / 106

    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 :

    34 / 106

    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 :

    35 / 106

    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 :

    36 / 106

    What is a Clustered Index?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    37 / 106

    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 :

    38 / 106

    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 :

    39 / 106

    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 :
    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.