what are the type of locks ? : Sql dba

0 Answers  

---

can i write pl/sql code in a package

2 Answers  

---

Explain what is dbms?

0 Answers  

---

SQL Tuning, Oracle Server 10g: Why is the following hint invalid? SELECT /*+ first_rows parallel(table_name,paral_number)*/

1 Answers   Accenture,

---

What is a unique key and primary key and foreign key?

0 Answers  

---

what are the differences between binary and varbinary? : Sql dba

0 Answers  

---

What is a dynamic query?

0 Answers  

---

what is the difference between truncate and drop statements? : Sql dba

0 Answers  

---

What is the clause we need to add in function body to return variable?

0 Answers  

---

What is ON DELETE CASCADE?

3 Answers  

---

Which one of the following is a reason that an INSERT statement might cause an error instead of executing correctly? 1. The INSERT statement was attempting to insert a record into a view that was created from more than one table. 2. The INSERT statement was attempting to insert a record using a combination of constants and values from an existing table. 3. The INSERT statement was attempting to insert a record with a non-NULL value into a table that has that column defined as NULL. 4. The INSERT statement was attempting to insert a record into a table by selecting a record from that same table. 5. The INSERT statement was attempting to insert a record into a view rather than a table.

1 Answers   Sonata,

---

What is the difference between left and left outer join?

0 Answers  

---