Answer Posted / anjali

select min(column_name) from table where column in(select
top n
column_name from table order by column_name desc)

What is data control language?

526

---

What are % type and % rowtype?

566

---

What does bitemporal mean?

589

---

Why do we use triggers?

510

---

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

525

---

---

What is sqlerrd?

521

---

what are the disadvantages of mysql? : Sql dba

565

---

How would you convert date into julian date format?

587

---

What do you mean by query optimization?

541

---

What is sql analyzer?

531

---

What are two statement types in sql?

533

---

What are hotfixes and patches?

519

---

Does view store data in sql?

525

---

What is transaction control language (tcl)?

627

---

Explain the advantages and disadvantages of stored procedure?

639

---