Which of the following ensures database integrity security & recoverability:
Correct answer: C. Normalization
- A. Logical Design
- B. File organization
- C. Normalization
- D. Physical design
Explanation
This is the process of organizing database tables to minimize redundancy and improve data integrity. By eliminating duplicate data and enforcing data dependencies, normalization helps to ensure that data is accurate and consistent. In conclusion, normalization is the technique that specifically ensures database integrity, security, and recoverability by reducing data redundancy and enforcing data dependencies.
Last updated
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.
Exams that ask Computer Science and IT questions like this
Computer Science and IT is on 40 papers prepared for on TestUstad, and all of them draw the same bank, so this question is worth knowing for every one of them.