Answer Posted / arnab bhui

Using Oracle........

create table emp
( id number(10),
sal numeric(10,5)
);

SQL> select max(sal) from (( select sal from emp ) minus ( select sal from emp where sal >= all ( select sal from emp )));

Give main differences between "Truncate" and "Delete".

775

---

What is the synonym of join?

688

---

Tell me what is use of except clause? How it differs from not in clause?

705

---

What are the acid properties?

725

---

my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

1712

---

---

What is service broker?

768

---

Do you know the isolation level that sql server support?

710

---

What are logical/boolean operations in ms sql server?

728

---

Describe how to use the linked server?

809

---

Explain datetimeoffset data type in sal server 2008?

693

---

How to count groups returned with the group by clause in ms sql server?

741

---

In which format does an image save in SQL Server database ?

787

---

Define self join?

790

---

What does null mean?

755

---

What is the difference between stored procedure and user defined functions?

856

---