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

    Question :: 2
    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!

    Question :: 3
    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!

    Question :: 4
    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!

    Question :: 5
    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!

    Question :: 6
    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!

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

    Question :: 8
    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!

    Question :: 9
    What is Force View?
    Answer:

    No Discussion on this question yet!

    Please Login First :

    Tags:No Tags on this question yet!

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

    No Discussion on this question yet!

    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.