Answer / Leelendra Kumar Gangwar

Normalization in SQL refers to the process of organizing a database to minimize redundancy and dependency, thereby improving data integrity and efficiency.

What is the location of pre_defined_functions.

1 Answers  

---

What is difference between function and trigger?

1 Answers  

---

What is a self join ?

6 Answers   BirlaSoft,

---

Can we relate two different tables from two different users in ORACLE,PL/SQL?

4 Answers  

---

what is a relationship and what are they? : Sql dba

1 Answers  

---

what are the authentication modes in sql server? : Sql dba

1 Answers  

---

there are 2 variables called x and y ,x contains 1,2 and y contains 3,4 we have to swap the values from x to y and y to x with out using dummy variables and it can be done only by using a single statement ? how?

12 Answers   Oracle,

---

how to select alphabets in a one column , for this the table name is PA_TASKS and column name is TASK_NUMBER, In TASK_NUMBER the data like this 1.1.3NN,1.1.4NN,1.5.1NN,1.3.2NE,1.5NN,1NN,1.2NE,1CE , For this i need to disply output as NN,NN,NN,NE,NN,NN,NE,CE, Its some urgent requirement ,thanks in advance

6 Answers  

---

Write a query to find five highest salaries from EMP table. (there is a column SALARY)

24 Answers   Cap Gemini, iNautix,

---

is it mandatory to select all the column in a view then what columns should be selected

2 Answers  

---

Explain character-manipulation functions?

1 Answers  

---

write a pl/sql function if enter a value=0 then output value=1 and vise verse with out using if and case statements.

3 Answers   Zensar,

---