Answer Posted / raghuramu

select rownum from emp
where rownum<=10;

What is a data definition language?

564

---

Lookups are a key component in sql server integration services (ssis). Explain its purpose?

554

---

What is cursor and its types?

569

---

What is the difference between row level and statement level trigger?

530

---

Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?

544

---

---

What is cross join sql?

511

---

Explain raise_application_error.

651

---

Can we alter stored procedure?

555

---

Explain what is sql?

616

---

What problem one might face while writing log information to a data-base table in pl/sql?

566

---

How to write a single statement that concatenates the words ?hello? And ?world? And assign it in a variable named greeting?

656

---

what are sequences

1109

---

what is commit? : Sql dba

625

---

what is top in tsql? : Transact sql

553

---

What does the file extension accdb stand for?

556

---