Answer Posted / manojbatra071

create table backuptablename as select * from originaltablename;

What is a sql instance vs database?

586

---

Explain about various levels of constraint.

530

---

Does sql*plus have a pl/sql engine?

585

---

What is the advantage of index in sql?

551

---

how are mysql timestamps seen to a user? : Sql dba

572

---

---

How you improve the performance of sql*loader? : aql loader

584

---

How many types of cursors supported in pl/sql?

600

---

What is before and after trigger?

530

---

Can one improve the performance of sql*loader? : aql loader

595

---

What is the difference between inner join and left join?

552

---

What is the difference between stored procedure and view?

541

---

What is a database? Explain

606

---

Is not null in sql?

570

---

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

600

---

Can there be more than one function with a similar name in a pl/sql block?

559

---