Answer Posted / namita s

Schema is the way in which the database is designed. One
can view the same through schema diagrams. The common
examples of schemas are star schema and snow-flake schema.

What does sharding mean?

993

---

How to use attributes of the implicit cursor in oracle?

1006

---

Explain the use of grant option in exp command.

1061

---

Point out the difference between user tables and data dictionary?

978

---

How to find out what oracle odbc drivers are installed?

1038

---

What is a read write transaction in oracle?

1083

---

How to start your 10g xe server from command line?

1069

---

Can you drop an index associated with a unique or primary key constraint?

1017

---

Is it possible to set second Primary Key Constraint in a table in Oracle Database ?

1141

---

What is format trigger?

2065

---

Explain the difference between a procedure and a function?

1165

---

What is where clause in oracle?

1023

---

What is materialized view in Oracle?

1072

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

4519

---

How to create a new tablespace in oracle?

982

---