Answer Posted / monty

if you have a table employee you can create duplicate
record using into statement

select *into backup_employee from employee

the above statement create new table backup_employee with
same data of employee

Is a secondary key the same as a foreign key?

953

---

What is the difference between delete and truncate statement in sql?

1008

---

Explain what is sql?

1058

---

What is recursive stored procedure?

1045

---

What are pl/sql cursor exceptions?

1035

---

How do you exit in sql?

1061

---

Are stored procedures faster than dynamic sql?

979

---

what is the functionality of the function htmlentities? : Sql dba

891

---

What is sqlite format?

1108

---

what are the types of subquery? : Sql dba

1048

---

What is the purpose of primary key?

965

---

Can you sum a count in sql?

954

---

When is the explicit cursor used ?

977

---

Can we declare a column having number data type and its scale is larger than pricesionex: column_name number(10,100),column_name numbaer(10,-84)

892

---

i have some prob lem to tell me about my self in interview first round ...

2114

---