Answer / kamala k n

it will store dropped data base objects

What are internal user account in oracle?

0 Answers  

---

What is a sub query? Describe its types?

0 Answers  

---

Table Has C1 And C2 Column If Exits any record in c1 then Update c2 record Otherwise insert new record in the C1 And C2 (Using Procedure)

4 Answers   Thermotech,

---

how will I find the first 5 highest salaried employees in each dept in oracle.

22 Answers   IBM,

---

Calculate difference between 2 date / times in oracle sql?

0 Answers  

---

---

Display Odd/ Even number of records?

3 Answers  

---

10)In an RDBMS, the information content of a table does not depend on the order of the rows and columns. Is this statement Correct? A)Yes B)No C)Depends on the data being stored D)Only for 2-dimensional tables

6 Answers   Mind Tree,

---

Please help me how to write a Query to change the primary key constraint from 1 attribute to another attribute in a table

3 Answers  

---

What is data block in Oracle?

0 Answers   MCN Solutions,

---

WHAT IS THE DIFFERENCE BETWEEN PRIMARY KEY(PK) CONSTRAINT AND UNIQUE KEY(UK) + NOT NULL(NN) CONSTRAINT ASSIGN TO A COLUMN ? INSTEAD OF ASSIGNING PK ,WE CAN ASSIGN UK + NN TO A COLUMN. WHAT ARE THE MARRITS AND DEMARITS BETWEEN THE ABOVE TWO?THE ABOVE TWO ARE SAME,THEY DON'T ALLOW DUPLICATE AS WELL AS NULL VALUES.

3 Answers  

---

Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15

2 Answers  

---

What is mean by Program Global Area (PGA) ?

9 Answers   Bajaj,

---