Answer Posted / voota durga prasad
Normalization is the process of designing a data model to
efficiently store data in a database. The end result is that
redundant data is eliminated, and only data related to the
attribute is stored within the table.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
How do we select distinct values from a table?
Which database is faster?
1. How many nodes you are using project? 2. What is configuration file? 3. What is modules partition? How it is work in project? 4. What is Environment Variable? How it is use? 5. What is sequence? 6. How do you execute parallel jobs in projects? 7. If you run a job in job sequencer individually without any comments? 8. How many jobs did in your project? 9. How to schedule the job in Data stage 7.5 X2? 10. If you have 10 jobs in PX2, shall you run all jobs at a time? 11. I have 5 jobs (1-5), I connect with each other, but I want to run from 3-5 only how? 12. What is same partition? 13. If you have 40GB hard disk in I have 30GB data how I configure the nodes for partition? 14. Did you write any code for Data stage project? 15. Did you write any code for parallel job execution in your project? 16. Will you schedule all jobs at a time?
What are the ways to tune reporting services?
Single File Database: Develop a student record management program, which uses single file as its database. It is not supposed to create additional files at any part of the project and should never rewrite total content. It must be capable of storing 100000's of records. It should support variable length records to be added, deleted, modified, listed.
Have you heard about sixth normal form?
What is database in simple language?
What is procedure in database?
Mention a query to calculate the even and odd records from a table
Explain the different types of database keys?
What do you mean by fill factor concept with respect to indexes?
What is an optimization and performance tuning and how does it really work in practical projects?
Can you explain insert, update and delete query?
Why dbms is used?
What is index and also explain types of indexing in dbms?
