Download App

IT Set 6 — Information Technology STD 10 — Question

CBSE BoardEnglish MediumSTD 10Information TechnologyIT Set 64 Marks
Question
Yuan is learning about databases. But, he didn’t understand the concept of fields, records, and tables. Answer to him the following queries: 
(i) How are fields, records, and a table related to each other? Explain with the help of an example.
(ii) What are the main purposes of a database system?
✓

Answer

(i) Fields are a type of information. A record contains logically related fields.
A table contains logically related records.

Image
In table Emp, EmpNo, Name, and Salary are three different fields. 1, Shridhar, 20,000 represents one complete record.
(ii) The main purposes of a DBMS are
  • Storage of information
  • Retrieval of information quickly.
  • Sorting, selecting data that satisfies certain and readable format,
  • Produce the report in some standardized and readable format.

Need a full question paper?

Generate a complete, print-ready paper with questions like this in minutes — across 16+ boards, with answer keys.

Start Generating Free

Explore more

More "4 Marks Quetions" from IT Set 6→IT Set 6 — all question types→Information Technology STD 10 question papers→CBSE Board STD 10 question papers→CBSE Board question paper generator→

Similar questions

Reema has been appointed as an SME in an IT-based company. Tell her the following:
(i) What is a workplace emergency?
(ii) Name the workplace emergencies that may happen.
→
Rita is working on a spreadsheet. She wants to know about the use of the following terms:
(a) Quick Sort
(b) Filtering Data
→
Simran wants to know about Subtotal. Answer the given questions for her.
(i) What is the SUBTOTALO function?
(ii) Names of any 5 functions with their function index number.
→
How to resize an image?
→
Explain any four data types of DBMS
→
Riddhima wants to know about mailing labels in a word processor. Help her to find the answers to the given questions.
(a) What is a mailing label?
(b) What are the ways to prepare and print mailing labels?
→
Samarjit wants to know about the template. Tell him the definition of the template and also the steps to create a document using it.
→
Sonia had heard about the various types of ISPs. She had some doubts. Answer her queries to clear her doubts.
(a) What is an ISP?
(b) Name any two ISPs of India.
(c) Name any two connection types that home users use.
(d) What is a satellite?
→
Shubham is learning about DBMS. He wants to know about the following:
(a) The purpose of DBMS
(b) Any two uses of DBMS
→
Consider the following table: SummerCamp.
Image
(i) How many fields and records are there in the table SummerCamp?
(ii) Write SQL queries for the following:
(a) Display all the records of table SummerCamp whose DOB is between 02/02/09 and 06/03/10.
(b) Display all the records having Gender F.
(c) Display all the records according to the First Name.
 
→