Technical Interview Questions and Answers :: SQL

    1 / 103

    What are differences between delete and truncate statement ?
    Answer:

    Delete is an DML statement.When we delete the data that data can't delete permenently without we give commit command.But Truncate is an DDL statement.When we truncate the data that can be deleted perminently without given commit command also.  

    Please Login First :

    Tags:Sapient

    2 / 103

    How many types of Views are there?
    Answer:

    They are two types of views .1)Simple view. 2)Complex View

    Please Login First :

    Tags:No Tags on this question yet!

    3 / 103

    What is Materialized View?
    Answer:

    materialized view is a database object that contains the results of a query.

    Please Login First :

    Tags:No Tags on this question yet!

    4 / 103

    What is Deterministic Function?
    Answer:

    A function is considered deterministic if it always returns the same result for a specific input value. 

    Please Login First :

    Tags:No Tags on this question yet!

    5 / 103

    What is PRAGMA_Exception_Init?
    Answer:

    The un-named system exceptions can be assigned with a name explicitly by using the pragma compiler Exception_init. Exception_init will associate the Oracle predefined error code to a user defined name

    Please Login First :

    Tags:No Tags on this question yet!

    6 / 103

    What is Autonomous Transaction?
    Answer:

    The term "automous transaction" refers to the ability of PL/SQL temporarily suspend the current transaction and begin another, fully independent transaction (which will not be rolled-back if the outer code aborts).  The second transaction is known as an autonomous transaction. The autonomous transaction functions independently from the parent code.

    Please Login First :

    Tags:No Tags on this question yet!

    7 / 103

    Wha is difference between DDL and DML command?
    Answer:

    DDL stands for Data Definition Language. DML stands for Data Manipulation Language. DDL commands are used to create,alter,truncate,drop,rename etc. Where DML are used to insert,update,delete,merge etc.,

    Please Login First :

    Tags:TCS

    8 / 103

    How we can see all the tables in one Schema?
    Answer:

    Oracle db: We can see all tables in a scheme for curent user by using query 'select * from user_tables'. Dba user can see tables for all users by using query 'select * from all_tables'. Second query will return owner of table too.

    Please Login First :

    Tags:No Tags on this question yet!

    9 / 103

    What is Force View?
    Answer:

    A view can be created even if the defining query of the view cannot be executed. We call such a view as view with errors.

    Please Login First :

    Tags:No Tags on this question yet!

    10 / 103

    For Query Optimization, what methods you can use?
    Answer:

    1. Cost based Optimization (Physical)

    This is based on the cost of the query. The query can use different paths based on indexes, constraints, sorting methods etc.

    Please Login First :

    Tags:No Tags on this question yet!




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.