Answer / Imran Khan

In SQL Server, database files (.mdf for the data file, .ldf for the log file) are stored in the Data folder of the SQL Server installation directory by default. The exact location can be changed during setup or afterward.

Is full outer join same as cross join?

1 Answers  

---

Explain uses of cursor.

1 Answers  

---

How can the performance of a trigger be improved?

1 Answers  

---

Why do we use %rowtype & %type in plsql?

1 Answers  

---

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

24 Answers   Accenture, HCL, Infosys,

---

Is pl sql useful?

1 Answers  

---

How to make a copy values from one column to another in sql?

1 Answers  

---

What is a REF CURSOR? Compare strong and week ref cursor types.

6 Answers  

---

Are ddl triggers fired for ddl statements within a pl/sql code executed using the dbms.sql package?

1 Answers  

---

Can we use SQL%ISOPEN in implicit cursors? Does this attribute works properly in Implicit Curosors?

3 Answers  

---

What does count (*) mean in sql?

1 Answers  

---

What is difference between rank () row_number () and dense_rank () in sql?

1 Answers  

---