Answer Posted / aysh

First normal form (1NF or Minimal Form) is a normal form
used in database normalization. A relational database table
that adheres to 1NF is one that is free of repeating
groups.Second normal form (2NF) is a normal form used in
database normalization,where a table that is in first
normal form (1NF) must meet additional criteria if it is to
qualify for second normal form. Specifically:a 1NF table is
in 2NF if and only if none of its non-prime attributes are
functionally dependent on a part (proper subset) of a
candidate key. (A non-prime attribute is one that does not
belong to any candidate key.)

Which are the five query types available in oracle?

894

---

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4290

---

Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.

2258

---

Give the various exception types.

938

---

What is clustered table in Oracle?

1103

---

What are the data types in oracle?

974

---

How to count groups returned with the group by clause in oracle?

1010

---

I have some query regarding Report generation from Oracle Apps "PO module". I have to generate a report where table columns are as below: Vendor_name Invoice No PO Number Item_Quantity Value of Goods Date of Shipping Name_of_the_transport Date_of_receipt_issued. Now my questions is :from which table/column I can get the information of "Name_of_the_transport" column. Thanks in advance.

3272

---

What is a trigger oracle?

1037

---

What happens internally when the user types userID/password@string in SQL PLUS Thanks-Bhaskar

4476

---

Explain what are synonyms used for?

978

---

How to use group functions in the select clause using oracle?

1020

---

Will you be able to store pictures in the database?

1061

---

What is the usage of analyze command in oracle?

1028

---

How to select some rows from a table in oracle?

1001

---