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.)

What is the difference between count (*), count (expression), count (distinct expression)?

556

---

What is the quickest way to fetch the data from a table?

564

---

what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?

2042

---

Why do you create or replace procedures rather that drop and recreate.

543

---

candidate key is subset of super key but not vice-verse explain

1577

---

---

How to drop an existing table in oracle?

589

---

What is blob data type in oracle?

555

---

How to create a single index for multiple columns?

558

---

What do you mean by a database transaction & what all tcl statements are available in oracle?

549

---

What is the difference between substr and instr?

517

---

How to declare a local variable?

592

---

Explain the characteristics of oracle dba?

636

---

What is the implicit cursor in oracle?

562

---

if you ctreate table identity

1843

---

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

4013

---