Technical Interview Questions and Answers :: SQL
1. What are differences between delete and truncate statement ?| | |
2. What is bulk sql?| | |
3. What is bulk collect clause?| | |
4. How many types of Exception Handling are there ?| | |
5. What is ref cursor?| | |
6. How many types of Views are there?| | |
7. What is Materialized View?| | |
8. What is Deterministic Function?| | |
9. What is PRAGMA_Exception_Init?| | |
10. What is Autonomous Transaction?| | |
delete is DML and truncate is DDL.
Delete is slow and truncate is faster.
Using Delete we can delete specific records where as truncate cannot.
Delete can be used inside the function or procedures directly but not truncate(only with Dynamic SQL).
bulk insert or bulk delete or bulk fetch of data is called bulk sql
Oracle bulk collect, the SQL engine retrieves all the rows and loads them into the collection and switches back to the PL/SQL engine. When rows are retrieved using Oracle bulk collect, they are retrieved with only two context switches.
There are mainly two types of exceptions: checked and unchecked where error is considered as unchecked exception.
Ref cursor is a varible, type of cursor. It points to or references a cursor result. One of the advantages ref cursor has over a plain cursor is that it can be passed to other procedures as a variable.
They are two types of views .1)Simple view. 2)Complex View
No Discussion on this question yet!
A function is considered deterministic if it always returns the same result for a specific input value.
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
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.
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.