Answer Posted / sureshkumar.somayajula

Explain Plan determines the execution plan for SQL
Statements.

Syntax:

expalin paln
set statement_id= ' Text '
schemaname.Table_name@Databaselink
for Statement.

Which are the different types of indexes in sql?

1096

---

explain normalization concept? : Sql dba

1082

---

What are the uses of sysdate and user keywords?

1146

---

What are the features of pl sql?

1107

---

Can triggers stop a dml statement from executing on a table?

1155

---

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

1157

---

what is acid property in database? : Sql dba

1061

---

Explain ddl statements in pl/sql?

1042

---

What is sql rowcount?

1065

---

What is embedded sql in db2?

1058

---

Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql

1037

---

What does the argument [or replace] do?

1122

---

What are operators available in sql?

1093

---

Write a program that shows the usage of while loop to calculate the average of user entered numbers and entry of more numbers are stopped by entering number 0?

2332

---

How to create an array in pl/sql?

1115

---