Answer / Arun Kumar Sharma

A temporary table is a table that is created for the duration of a session or transaction. After the session or transaction ends, the temporary table is automatically dropped.nnExample:nIn SQL: CREATE GLOBAL TEMPORARY TABLE temp_table (column1 datatype, column2 datatype);

What is primary key and foreign key?

1 Answers  

---

Can we alter stored procedure?

1 Answers  

---

How is a process of pl/sql compiled?

1 Answers  

---

When we give SELECT * FROM EMP; How does oracle respond?

24 Answers   Accenture, HCL, Infosys,

---

how to concatenate two character strings? : Sql dba

1 Answers  

---

Explain the insert into statements in sql?

1 Answers  

---

Explain the difference in execution of triggers and stored procedures?

1 Answers  

---

How do we tune the code?

2 Answers  

---

Give which cursor is better for better performance means type of cursors?

2 Answers  

---

What is normalization and types of normalization?

22 Answers   Etisbew, F-TEC, Microsoft, TechProcess,

---

which command using query analyzer will give you the version of sql server and operating system? : Sql dba

1 Answers  

---

What is trigger and how to use it in sql?

1 Answers  

---