Answer Posted / ram

create table <table name> [<columns> datatype];

What is set operator oracle?

740

---

Explain enable novalidate constraint.

831

---

When do you get a .pll extension in oracle? Explain its importance

806

---

How to drop an index in oracle?

830

---

What are the general rules on data consistency?

793

---

What is ordinary table in oracle?

853

---

How many anonymous blocks can be defined?

836

---

What are the differences between date and timestamp in oracle?

813

---

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

1921

---

State and explain the different types of data models?

745

---

Explain oracle instance.

924

---

What is oracle sid?

702

---

How to use "in out" parameter properly?

823

---

Where do you use decode and case statements?

777

---

Can we convert a date to char in oracle and if so, what would be the syntax?

798

---