what is the difference between first normal form & second
normal form?
Answer Posted / senthilkumar.a
FIRST normal form does not allow multi-valued attributes
which leads to the redundancy of data
SECOND normal form where EVERY non-prime attributes is
fully functionally dependent of ALL prime attributes
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
How to convert characters to numbers in oracle?
What is the difference between postgresql and oracle?
Give the advantages and disadvantages of clusters.
Can multiple columns be used in group by in oracle?
How to write an inner join with the where clause in oracle?
How to count duplicated values in a column in oracle?
Compare and contrast between sql and sql server and explain its various functions?
Explain how you would restore a database using RMAN to Point in Time?
Explain the use of rows option in imp command.
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
HI, Please let me know the syllabus for Oracle OCA and OCP Certification
what is meant by magic query
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
How to insert multiple rows with one insert statement in oracle?
How to execute the package in oracle?