Answer Posted / selvaraj v

In Oracle 10g :
---------------

Create New Table in another table with same data's:
---------------------------------------------------

copy from coeot1a2/coeot1a2@coeau to scott/tiger@coeau
CREATE s11 using select * from major_list;

Insert data's into another table with same data's:
---------------------------------------------------

copy from coeot1a2/coeot1a2@coeau to scott/tiger@coeau
INSERT s11 using select * from major_list;

Append data's into another table with same data's:
---------------------------------------------------

copy from coeot1a2/coeot1a2@coeau to scott/tiger@coeau
APPEND s11 using select * from major_list;

Replace data's into another table with same data's:
---------------------------------------------------

copy from coeot1a2/coeot1a2@coeau to scott/tiger@coeau
REPLACE s11 using select * from major_list;

what is bcp? When is it used?

1101

---

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1102

---

What is a primary key? Explain

965

---

What is the advantage of nosql?

1054

---

Explain what is an index?

1047

---

Is oracle and sql same?

999

---

how do you know the version of your mysql server? : Sql dba

996

---

State some properties of relational databases?

1046

---

What is rownum in sql?

1027

---

What is Histogram?

1554

---

Why do we use procedures in pl sql?

1017

---

explain the options of myisamchk to improve the performance of a table. : Sql dba

1001

---

Can we create table in function?

954

---

how can we encrypt and decrypt a data present in a mysql table using mysql? : Sql dba

1179

---

How to use distinct and count in sql query? Explain

1010

---