Answer Posted / rajiv singh

select max(department_id) from departments where
department_id <(select max(department_id) from departments);

Does inner join remove duplicates?

1005

---

Can a foreign key be null?

1144

---

How can we solve sql error: ora-00904: invalid identifier?

1295

---

How do you take the union of two tables in sql?

1033

---

What are predefined functions in sql?

1109

---

Do stored procedures prevent sql injection?

1015

---

What is the size of partition table?

1093

---

Can a select statement fire a trigger?

1211

---

What are types of exception?

963

---

which tcp/ip port does sql server run on? : Sql dba

1085

---

What are the 3 types of behavioral triggers?

1314

---

What is pl/sql table? Why is it used?

1095

---

What are schema-level triggers?

1155

---

How many types of keys are there in sql?

1089

---

Does sql backup shrink transaction log?

1045

---