In: Computer Science
35. Which of these is an open source operating system?
A.Open Office
B.Windows 10
C.Firefox
D.Linux
E.iOS
36.What happens when the tables are not normalized?
A.Nothing is affected.
B.The performance of querying tables is enhanced.
C.Taking a back-up of data becomes easy.
D.There is a data integrity problem.
E.Less number of records are loaded in tables.
ANS 35.
First we discuss, meaning of open source
Open Source: Any software or application is said to be open source, if it is free to download and use as well as any one can made changes in its source code to modify or enhance the working of application or software.
Operating system is also a software that manages the hardware and software resources to make a machine usable to the user.
Option D is correct
A. Open Office is a Word processor (Office Suit like Microsoft Office)
B. Windows 10 is an Operating System, but not open source it is proprietary software of Microsoft
C. Linux is an open source operating system. Number of developers made changes to Linux OS and made many distribution based on Linux OS (or we can say kernel). for Eg.- Ubuntu, Debian, Fedora, CentOS, Open Suse etc.
D. iOS is an Operating System for mobile phone (and only for iPhone), it is also proprietary software of Apple
ANS 36.
There are many problems when the tables are not normalized in DBMS
1. Data redundancy
2. Insertion anomaly
3. Deletion anomaly
4. Updation anomaly
etc.
here option D is correct
Most common problem with non-normalized table is Data integrity
If tables are not normalized, it means that the same data is stored in more than one location. and so it’s very possible that one of the values will be updated without updating all copies of the same value in other tables. When this happens, you have one part of your database indicating something different value than other parts.