Answer Posted / suresh somayajula
Normalization is the process of organizing the table to
remove redundancy.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
Name the different types of indexes in sql and define them.
What are the types of operators available in sql?
What is cost in sql execution plan?
what are all the different types of indexes? : Sql dba
What are commit, rollback, and savepoint?
Explain the methods used to protect source code of pl/sql.
What sql does db2 use?
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc
Explain the purpose of %type and %rowtype data types with the example?
How can I tell if sql is running?
what are set operators in sql? : Sql dba
List the different type of joins?
Is pl sql a programming language?
How does join work in sql?
what is the difference between inner and outer join? Explain with example. : Sql dba