What is a relational database system.

Q5. What is a relational database system?

Ans. Relational Database refers to a database in which data is stored in multiple tables. these tables are linked to one another through common fields.

A Relational Database.

A relational database is shown in figure. in figure , you can see a database that contains several tables. these tables are linked to each other through a common fields.

Define DBMS and its functioning.

Q2. Define DBMS and its functioning.
Ans. DBMS is a program that controls the creation, maintenance, and use of a database. In DBMS, data is stored centrally. This allows users to easily access and share data as a common resource. DBMS helps in the integration of stored data by preventing inconsistencies and duplicate data. In addition, accessing, retrieving, and modifying the stored data is easy. DBMS also allows multiple users to access the data at the same time. Moreover, the access to the database is controlled. In other words, unauthorized users are prevented from accessing the database.

PRACTICE QUESTIONS

Practice Questions

Q1. Identify the software that helps you in sending and receiving an e-mail:

  1. MS-Office
  2. Internet Explorer
  3. MS-Outlook
  4. None of these

Ans. (c)

Read More …

Web browser and Web server.

Q7.

  1. What do you understand by the terms Web browser and Web server?
  2. Expand the following domain name extensions used with the Web address:
    • .com
    • .gov

Ans.

  1. A Web browser is an application that is used to access or retrieve information or resources from the Internet. On the other hand a Web server is a computer or a group of computers that stores Web documents. In other words, a Web server can be defined as a package or container that contains a huge amount of information.
    • .com – Commercial organizations
    • .gov – Government organizations

 

Two advantages of Internet.

Q6.

  1. Write two advantages of using the Internet.
  2. What is a Web server?

Ans.

  1. Two advantages of using the Internet are:
    • Helps in research and homework.
    • Helps in shopping.
  2. A Web server is a computer or a group of computers that stores Web documents. In other words, a Web server can be defined as a package or container that contains a huge amount of information.

Solved Questions-I

Q1. A software used to open Web pages on the Internet is called a ____.

  1. Browser
  2. Portal
  3. Surfer
  4. Provider

Ans. a. Browser

Q2.

  1. What is Home Page? Explain briefly.
  2. abc@mnc.co.in represents a ____.
  3. Give one advantage of Electronic Mail over ordinary mailing method.
  4. What is a Web Server and how is it related to a web page?
  5. Name one Internet Service Provider in India.
  6. What is the function of FTP.
  7. Give the full form of the following terms:
  8. Lal owns a factory which manufactures automobile spare parts. Suggest him the advantages of having a web page for his factory. Read More …

Home Page.

Q2.

  1. What is Home Page? Explain briefly.
  2. abc@mnc.co.in represents a ____.
  3. Give one advantage of Electronic Mail over ordinary mailing method.
  4. What is a Web Server and how is it related to a web page?
  5. Name one Internet Service Provider in India.
  6. What is the function of FTP.
  7. Give the full form of the following terms:
    • HTTP
    • url
  8. Lal owns a factory which manufactures automobile spare parts. Suggest him the advantages of having a web page for his factory.

Ans.

  1. The first or main page of a website is known as Home page.
  2. Email address. Read More …

Primary Key With Example.

Q9. Explain the primary key with the help of an example.
Ans. Primary key refers to a key that helps us to uniquely identify a record in a table. The primary key is used to avoid duplicate data. In other words, a column which a primary key will not contain duplicates information in any of its records. For example, the Employee_Details table, we can set the primary key in the Emp_Code column, which contains the employee code. In this case, duplicate values are not possible in the column.

DBMS ensure data security.

Q3. How does DBMS ensure data security.
Ans. DBMS provides security for data by ensuring that only authorized users are able to access the database. Authorized users are doors users whose credentials are verified through security checks.

The data that is stored in a database may contain valuable or sensitive information. For example, the database of an organization can contain personal information about its employees or information about the financial deals made with other organizations. Such type of information is highly sensitive and may damage the organization or its goodwill if it were to fall in wrong hands. Therefore, it is important that such information should be provided adequate security. DBMS provides security for data by ensuring that only authorized users are able to access the database. Authorized users have the rights or permission to access or change the database. This not only helps keep track of the users who access and make changes in the database, but also preventsothers without right credentials to access the database.