Hartron Syllabus Important Question Part 9
9 a) What are the security and privacy issues on Internet ?
Ans:-
Privacy concerns exist wherever uniquely identifiable data relating to a person or persons are collected and stored, in digital form or otherwise. In some cases these concerns refer to how data are collected, stored, and associated. In other cases the issue is who is given access to information. (Hartron Syllabus)
Internet Privacy Issues: Tracking, Hacking, Trading
Search engines. Google, tech giant, the biggest and most used search engine collects a lot of information about its users. From basic information like name and birthday to complete history of our searches, clicks, locations, and devices we use to login.
Identity theft. Millions of people were victims of identity theft which led to financial loss and even legal problems. Almost every website that asks for registration wants our name and birthdate, which is more than enough for experienced hackers to breach our privacy and create damage. Even secured banking applications suffered breaches. Therefore, should be careful when and where we leave data.
Tracking. Every website you visit uses cookies. They are now obliged to notify users about it, so we have to click on “Ok” “Accept” or “Agree” in order to continue. Cookies store a certain amount of data specific to a particular client and website. With this information, server can deliver a specially tailored page for the mentioned user. Privacy concerns exist wherever uniquely identifiable data relating to a person or persons are collected and stored, in digital form or otherwise. In some cases these concerns refer to how data are collected, stored, and associated. In other cases the issue is who is given access to information. (Hartron Syllabus)
9 b) What is the difference between primary key and foreign key?
Ans:–
Primary key
1 Primary key uniquely identify a record in the table
2 Primary Key can not accept null values.
3 We can have only one Primary key in a table.
4 Primary key is clustered index and data in the database table is physically organized in the sequence of clustered index.
Foreign key
1 Foreign key is a field in the table that the is primary key in another table.
2 Foreign key can accept multiple null value.
3 We can have more than one foreign key in a table.
4 Foreign key do not automatically create an index, clustered or non-clustered. You can manually create an index on foreign key.
What is the difference between LAN, WAN,MAN?
Ans:-
LAN
1 LAN stands for Local Area Network
2 A network that connects a group of computers in a small geographical area.
3 Ownership of Network is Private.
4 It is easy to Design and Maintain.
5 Its speed is High.
6 Network Congestion is Less.
MAN
1 stands MAN for Metropolitan Area Network.
2 It covers relatively large region such as cities, towns.
3 Ownership of Network is Private or Public.
4 It is difficult to Design and Maintain.
5 Its speed is Moderate.
6 Network Congestion is More.
WAN
1 WAN stands for Wide Area Network.
2 It spans large locality and connects countries together. Example Internet.
3 Ownership of Network is Private or Public.
4 It is difficult to Design and Maintain.
5 Its speed is Low.
6 Network Congestion is More.