Q4. What are the things that you need to keep in mind while designing the fields for a table?
Ans. You need to decide the type and number of fields required for the tables in your database. Each table in a database contains data or information about a single entity. This information is inserted in the fields of the table. Read More …
Q3. What are the database elements that help to provide input for a report?
Ans. Data retrieved from one or two tables act as a input for a report.
Q2. What points do you need to remember while designing a database?
Ans. The points that you should keep in mind while designing the database are:
- Determining the purpose of your database: You have to decide why you need to create a database and how you intend to use it. You also need to know what type of information you want from your database.
- Determining the tables you require: Tables are one of the most important elements of a database. To create a well-organized database, you have to define the tables for it. Keep in mind the following points while determining your tables:
- Each table provides information about a single entity.
- A table does not contain duplicate values. Read More …
Q1. Explain the relationship between two tables through an example.
Ans. The Employees_Details table contains the following fields:
The Department table contains the following fields:
The relationship between these two tables is created on the basis of a common field named E_Code. A relationship between these tables is established to fetch any information from both the tables. Further, establishing a relationship among tables allows you to link them to get meaningful information.
Q24. Write a note on the history of the Internet.
Ans. Over the last two decades, the Internet has gained immense popularity and emerged as an important and efficient means of communication. In 1962, J.C.R. Licklider first proposed the development of a global network of computers. The same year, he moved to Defense Advanced Research Projects Agency (DARPA) to develop the network. Another scientist, Leonard Kleinrock, developed the theory of packet switching, which was used as a basis for the Internet connections. In 1969, the scientists at DARPA succeeded in networking two computers, known as ARPANET (Advanced Research Projects Agency Network), which was based on packet switching. ARPANET was developed as a means of Read More …
Q26. How is WWW different from the Internet?
Ans. WWW represents an information space where documents and other web resources resides. These documents are connected by hyperlinks and can be accessed by URLs using Internet. WWW makes up a large part of the Internet and consists of websites that have one or more Web pages. On the other hand, computers on the Internet are connected to each other with the help of various small networks. Read More …
Q25. Explain the working of the Internet.
Ans. The computers on the Internet are connected to each other with the help of various small networks. These networks are in turn connected through the gateways to the Internet backbone. There are various steps for transmitting data or information through the Internet.
These steps are described below:
- The source computer (the computer that is sending the data) Read More …
Q23. Why do organizations mostly use Intranet instead of the Internet to share information within its premises?
Ans. Intranet is generally used to link different computers in an
organization. The term Intranet is a combination of two words, intra and net. Intra means inside or within; therefore, an Intranet implies a network inside something (such as an organization).
Unlike the Internet, an Intranet is limited to a small area or organization. Organizations mostly use Intranet instead of the Read More …
Q22. Define ISP. Name some popular ISP companies of India.
Ans. ISP stands for Internet Service Provider; it provides the settings, such as username and password, which is needed to configure the Internet connection on the computer. The subscription for an Internet connection is done from an Internet Service Provider (ISP). The ISP to choose should be reliable and provide immediate help to any Internet connection problems. There are a number of ISPs, such as MTNL, Airtel, Reliance, etc. User should choose the ISP that provides a wide variety of Web services in the respective area.
Some popular ISP companies of India are as follows:
- Videsh Sanchar Nigam Ltd. (VSNL)
- Mahanagar Telephone Nigam Ltd. (MTNL)
Q21. What is e-learning? Explain its importance.
Ans. Electronic learning (e-learning) is the mode of acquiring knowledge by means of the Internet and computer-based training programs.
In this type of education, students learn and study on their own and communicate with their instructors and other students through e-mail messages, electronic forums, video-conferencing, chat rooms, bulletin boards, and messaging. Examples of e-learning comprise different forms of learning like Web-based and computer-based learning and virtual classrooms. E-learning employs a variety of media, such as audio, animation, text and streaming videos to impart learning or training. E-learning is said to be more effective than the traditional classroom learning methods.