Answer Posted / sudheer kumar mikkilineni

select dbms_metadata.get_ddl('TABLE','DEPT','SCOTT') from
dual;

Can two tables have same primary key?

540

---

What is the purpose of a secondary key?

520

---

Can a primary key be a foreign key?

583

---

What is sql and explain its components?

611

---

What are local and global variables and their differences?

601

---

---

What is the left table in sql?

525

---

what are the type of locks ? : Sql dba

539

---

What is sql clause?

553

---

Difference between global and parameter variables?

1466

---

Name the different types of indexes in sql and define them.

580

---

What is denormalization in a database?

602

---

What is sql basics?

596

---

what are the nonstandard string types? : Sql dba

620

---

What does := mean in pl sql?

568

---

How do I write a cron which will run a sql query and mail the results to agroup?

533

---