All of the following are components of physical database design except?
Correct answer: C. Normalization of relations
- A. Data volume and usage analysis
- B. Data distribution strategy
- C. Normalization of relations
- D. File organization
- E. Schema refinement
Explanation
Normalization is a process of organizing data in a database to reduce redundancy and improve data integrity. It is a logical database design technique, whereas the other options are all physical database design techniques.
Report an error
The more specific you are, the faster it gets fixed. A source beats an opinion.
Prefer email? [email protected]
About Networking and Internet
Networking covers LAN, MAN, WAN and wireless networks, network topologies, transmission media, devices such as switches, routers and modems, and the OSI and TCP/IP models. Internet concepts include IP addresses, DNS, URLs, web browsers, email, protocols such as HTTP, HTTPS, FTP and SMTP, and basic network security.
Practise Networking and Internet
452 free Networking and Internet MCQs from Computer Science and IT, each with the correct answer and an explanation. Unlimited attempts, no account needed.
Discussion
Stuck on an option, or know a faster way to get there? Ask or explain it here.
No comments yet. Be the first to explain this one.
Exams that ask Computer Science and IT questions like this
Computer Science and IT is on 85 papers prepared for on TestUstad, and all of them draw the same bank, so this question is worth knowing for every one of them.
More Networking and Internet questions
Which refers to a method of database distribution in which different portions of the database reside at different nodes in the network?
Merge relation is important because
A physical database design decision must be made carefully because of impacts on:
Which of the following activities are involved in data analysis?
Which of the following represents the entities?
What refers to the minimum no of times an instance of one entity can be associated with an instance in the related entity?