Explain cascading triggers.

0 Answers  

---

12 RULES OF RDBMS

1 Answers  

---

What is the function of Redo Log ?

1 Answers  

---

What are set operators?

0 Answers  

---

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

0 Answers  

---

What is an oracle recycle bin?

0 Answers  

---

Explain the concept of the DUAL table.

2 Answers  

---

How do we know whether an index is created on a table ???

2 Answers   TCS,

---

How to speed up webrick?

0 Answers  

---

5. Display full details from the ORDER_LINE table where the item number is (first condition) between 1 and 200 (no > or < operators) OR the item number is greater than 1000 AND (second condition) the item cost is not in the list 1000, 2000, 3000 OR the order number is not equal to 1000.

3 Answers   Wipro,

---

Create table Employee ( Employee_Id varchar2(8) Constraint emp_id_pk primary key, FirstName varchar2(50), LastName varchar2(50), DeptID Number(5) Constraint dept_id_fk Foreign Key(DeptId) References Department(DeptId) ) Error I am getting: Constraint specification are not allowed here

2 Answers  

---

Explain oracle’s system global area (sga).

0 Answers  

---