Regular practice of SSLC IT Theory Questions and Class 10 IT Chapter 9 To the Information Storehouse Questions and Answers Notes prepares students for objective and descriptive examinations.
Class 10 IT Chapter 9 Question Answer
SSLC IT Chapter 9 Theory Questions
InText Questions and Answers
Question 1.
The table below has been prepared in LibreOffice Calc with some information related to the Cricket World Cup.
Can you find the answers to the following questions from this table?
a) Which country won the Cricket World Cup in 2003?
b) The best plater in the tournament (2003) and his country:
c) How many times has the player from the country’ that won the Cricket World Cup been the best player in that tournament?
d) Which New Zealanders have been the tournament’s best player?
Answer:
a) Australia
b) Sachin Tendulkar: India
c) 4 times (1996,2007,2011,2015)
d) Martin Crowe (1992) and Kane Williamson (2019)
Question 2.
Some SQL statements to retrieve information from the Player table are given below. Run and complete the table.
Answer:
| SQL Statement | Use |
| 1. select Player_Name from Player where Total_Runs>300; | To get the names of all the players who have scored more than 300 runs. |
| 2. select Player_Name from Player where Total_Runs between 200 and 400; | To get the names of all the players who have scored between 200 and 400 runs. |
| 3. select Player_ID, Player Name from Player where Country_ID=’C103’; | To get the ID and names of all the players who belong to the country with ID C103. |
| 4. select * from Player; | To get all the details from the Player table |
| 5. select Player_ID, Player_Name from Player where Country_ID in (‘C103’,’C105’); | To get the IDs and names of all the players who belong to the countries with IDs C103 or C105. |
| 6. select Player_Name from Player where Total_Runs<400; | To get the names of the players who have scored less than 400 runs. |
Class 10 IT Chapter 9 Let’s Assess
Question 1.
Which one is used to distinguish the records of a table from the others?
a) primary key
b) foreign key
c) fields
d) private key
Answer:
a) Primary key
Question 2.
SQL means …………………… ?
a) Systematic Query Language
b) Structured Query Language
c) Structured Questions Language
d) Sequenced Query Language
Answer:
b) Structured Query Language
Std 10 IT Chapter 9 Extended Activities
Question 1.
We have understood the need to control internet usage and screen time. Beloew is a table containing the data collected from a survey conducted among students regarding screen time.
Create a database called Screen_Usage and prepare the tables as shown below.
Answer:
| App_ID | App_Name | App_Category | Usage_Duration (Minutes) |
| 100 | Samagra AI | Education | 60 |
| 101 | Social Media | 32 | |
| 102 | Youtube | Social Media | 15 |
| 103 | E-cube English | Education | 25 |
| 104 | G-Combris | Education | 20 |
| 105 | Messaging | 35 | |
| 106 | G-pay | Banking | 10 |
| 107 | Maps | Navigation | 5 |
Now, try writing and executing the following SQL statements from the Apps table.
a) Which all Educational Apps are made available?
b) Which all Apps are being used more than 30 minutes in a day?
c) To which category does the SAMAGRA AI App belong?
Answer:
a) SELECT App_Name FROM Screen_Usage WHERE App_Category = ‘Education’;
Output:
Samagra AI
E-cube English
G-Combris
b) SELECT App_Name FROM Screen_Usage WHERE Usage_Duration > 30;
Output:
Samagra AI
Facebook
Whatsapp
c) SELECT App_Category FROM Screen_Usage WHERE App_Name = ‘Samagra AI’;
Output:
Education
SSLC IT To the Information Storehouse Questions and Answers
Question 1.
Which software is used to create the database in this chapter?
a) Oracle
b) MySQL
c) DB Browser for SQLite
d) MS Access
Answer:
c) DB Browser for SQLite
Question 2.
What does DBMS stand for?
a) Database Making System
b) Database Management System
c) Data Backup Management Software
d) Digital Base Management Source
Answer:
b) Database Management System
Question 3.
Which of the following is NOT a DBMS software?
a) Oracle
b) MySQL
c) SQL Server
d) Photoshop
Answer:
d) Photoshop
Question 4.
In a table, each column is called a:
a) Record
b) Field
c) Key
d) Cell
Answer:
b) Field
Question 5.
Each row in a table is known as a:
a) Record
b) Column
c) Field
d) Index
Answer:
a) Record
Question 6.
Which key uniquely identifies each record in a table?
a) Foreign Key
b) Duplicate Key
c) Primary Key
d) Main Key
Answer:
c) Primary Key
Question 7.
The field that connects two tables is known as:
a) Linked Field
b) Foreign Key
c) Compound Key
d) Record Key
Answer:
b) Foreign Key
Question 8.
SQLite database is stored as:
a) A folder
b) A single file on disk
c) Multiple files in cloud
d) Temporary memory
Answer:
b) A single file on disk
Question 9.
Who developed SQLite?
a) Dennis Ritchie
b) D. Richard Hipp
c) Charles Babbage
d) Tim Berners-Lee
Answer:
b) D. Richard Hipp
Question 10.
Which tab in DB Browser for SQLite is used to view data?
a) Edit Table
b) Browse Data
c) Execute SQL
d) New Database
Answer:
b) Browse Data
Question 11.
Which SQL statement is used to retrieve data from a table?
a) FETCH
b) VIEW
c) SELECT
d) SHOW
Answer:
c) SELECT
Question 12.
In SQL, which keyword is used to filter rows based on conditions?
a) FROM
b) WHERE
c) HAVING
d) FILTER
Answer:
b) WHERE
Question 13.
Which clause is used to sort query results?
a) SORT BY
b) ARRANGE BY
c) ORDER BY
d) GROUP BY
Answer:
c) ORDER BY
Question 14.
Which datatype should be used for storing letters and numbers together like C101?
a) Integer
b) Text
c) Float
d) Number
Answer:
b) Text
Question 15.
Which datatype is suitable for storing total runs of a player?
a) Text
b) Date
c) Integer
d) Image
Answer:
c) Integer
Question 16.
Which SQL statement displays all records from the Player table?
a) SELECT Player;
b) SELECT * FROM Player;
c) SHOW Player;
d) RETRIEVE Player;
Answer:
b) SELECT * FROM Player;
Question 17.
In DB Browser, which option is used to add a new field?
a) Create Field
b) Add
c) Insert Column
d) Include Field
Answer:
b) Add
Question 18.
What symbol represents any number of characters in SQL LIKE clause?
a) #
b) %
c) _
d) *
Answer:
b) %
Question 19.
Which SQL clause is used to remove duplicate entries from results?
a) UNIQUE
b) DISTINCT
c) DIFFERENT
d) SINGLE
Answer:
b) DISTINCT
Question 20.
What is the main advantage of organizing information into multiple tables?
a) Faster typing
b) Avoids data repetition
c) Adds more graphics
d) Reduces database size
Answer:
b) Avoids data repetition
(Select two correct answers from the options)
Question 21.
Which of the following are examples of DBMS software?
a) Oracle
b) MySQL
c) MS Word
d) PowerPoint
e) SQL Server
Answer:
a) Oracle, b) MySQL
Question 22.
Which operations can be done using SQL?
a) Select data
b) Modify tables
c) Draw charts
d) Insert data
e) Export photos
Answer:
a) Select data, d) Insert data
Question 23.
Common clauses used in SQL data retrieval are:
a) SELECT
b) ORDER BY
c) PRINT
d) CALCULATE
e) WHERE
Answer:
a) SELECT, e) WHERE
Question 24.
Which types of data can be stored in a database field?
a) Numbers
b) Text
c) Audio
d) Animations
e) Images
Answer:
a) Numbers, b) Text
Question 25.
Advantages of using DBMS include:
a) Easy data retrieval
b) Data redundancy
c) Security and backup
d) Manual entry
e) High error rate
Answer:
a) Easy data retrieval, c) Security and backup
Question 26.
Which are valid SQLite data types?
a) TEXT
b) IMAGE
c) NUMBER
d) INTEGER
e) PICTURE
Answer:
A) TEXT, D) INTEGER
Question 27.
A Primary Key must be:
a) Unique
b) Repeated
c) Empty
d) Not Null
e) Hidden
Answer:
a) Unique, d) Not Null
Question 28.
A Foreign Key is used to:
a) Link tables
b) Sort columns
c) Identify unique data
d) Connect records
e) Delete tables
Answer:
a) Link tables, d) Connect records
Question 29.
To create a new database in DB Browser, you must:
a) Click “New Database”
b) Enter database name
c) Draw tables manually
d) Save file
e) Add records automatically
Answer:
a) Click “New Database”, b) Enter database name
Question 30.
Common database fields in this chapter include:
a) Player_ID
b) Player_Name
c) Country_Name
d) Total_Runs
e) Match_Score
Answer:
a) Player_ID, c) Country_Name
Question 31.
Which tabs are used in DB Browser for SQLite?
a) Database Structure
b) Execute SQL
c) Edit Picture
d) Browse Data
e) Design Page
Answer:
a) Database Structure, b) Execute SQL
Question 32.
A table contains:
a) Fields
b) Records
c) Folders
d) Charts
e) Keys
Answer:
a) Fields, b) Records
Question 33.
Examples of queries with conditions include:
a) Using WHERE
b) Using ORDER BY
c) Using FILTER
d) Using DISTINCT
e) Using LIMIT
Answer:
a) Using WHERE, b) Using ORDER BY
Question 34.
Which SQL statements retrieve specific data?
a) SELECT
b) DELETE
c) UPDATE
d) WHERE
e) INSERT
Answer:
a) SELECT, d) WHERE
Question 35.
In a database, tables are related by:
a) Keys
b) Charts
c) Relationships
d) Foreign Keys
e) Templates
Answer:
a) Keys, d) Foreign Keys
Question 36.
To execute an SQL query, you use:
a) Execute SQL tab
b) Browse Data tab
c) View menu
d) Run button
e) Save button
Answer:
a) Execute SQL tab, d) Run button
Question 37.
DBMS allows users to:
a) Store large amounts of data
b) Retrieve data quickly
c) Edit photos
d) Design slides
e) Delete unnecessary data
Answer:
a) Store large amounts of data, b) Retrieve data quickly
Question 38.
Important advantages of database tables include:
a) Organized structure
b) Data duplication
c) Easy updates
d) Unclear records
e) Systematic storage
Answer:
a) Organized structure, e) Systematic storage
Question 39.
The “WHERE” clause is used to:
a) Filter records
b) Sort data
c) Set conditions
d) Create tables
e) Update columns
Answer:
a) Filter records, c) Set conditions
Question 40.
The SQL command ‘SELECT * FROM table_name;’ means:
a) Retrieve all data
b) Create new data
c) Update records
d) Display all columns
e) Delete table
Answer:
a) Retrieve all data, d) Display all columns
SSLC IT Chapter 9 Notes
Class 10 IT Chapter 9 To the Information Storehouse Notes
DBMS Software
A Database Management System (DBMS) is a software tool that helps store, organize, retrieve, and manage large amounts of related information efficiently.
Functions of a DBMS
- Store and retrieve data quickly
- Add, edit, or delete records
- Relate data from different tables
- Provide data security and integrity
Examples of DBMS Software
- Oracle
- MySQL
- SQL Server
- SQLite
Database
A database is a collextion of tables in which interrelated information are recorded in a systematic manner.
- Data types define the kind of data that can be stored in each column of a table. Every column in a database table must have a specific data type.
- The fields added to identify each record in each table from others are called Primary key.
Sqlite
Sqlite is a DBMS that is completely a free software. This system can be used in desktop software, mobile apps, and web applications. In Sqlite, the database is stored as a single file on disk. Therefore, the database can be easily managed and configured.
Sqlite was developed by D.Richard Hipp, a software engineer.
1. Creating a Database using SQLite
- Open DB Browser for SQLite
- Click: “New Database” → Name the Database → Save
2. Prepare a Table in DB Browser for SQLite:
- Open the Edit Table Definition window.
- Enter the table name.
- Click the Add button to create a field.
- Rename Field1 with the desired field name.
- Add the remaining fields in the same away.
- Click on the field which has to be set as the Primary Key.
3. Adding Data into Tables
- Select tab Browse Data
- Choose table
- Click “Insert new record to current table”
- Type each record manually
- Click Write Changes to save.
Structured Query Language (SQL)
DBMS use a special language called SQL (Structured Query Language) to communicate. It is simple and similar to English. Using SQL, we can create, modify, select, insert, edit, and delete data in tables. In some DBMSs, all these operations are done only through SQL.
Retrieving Information Using SQL
To view or extract information stored in a table, the SELECT statement is used.
Syntax: SELECT column_name(s) FROM table_name WHERE condition;
Common Clauses in Data Retrieval
- FROM: Specifies the table name.
- WHERE: Sets conditions to filter records.
- ORDER BY: Sorts the output in ascending (ASC) or descending'(DESC) order.
- DISTINCT: Removes duplicate entries from results.
- BETWEEN: Selects values within a specific range.
- IN: Matches multiple specific values
- LIKE: Finds values using wildcard patterns
%: Represents any number of characters. E.g. LIKE ‘S%’ find words starting with S
_ : Represents a single character. E.g. LIKE ‘_an’ finds 3-letter words ending with “an”.
Retrieving Data Using Conditions
- = Equal to
- > Greater than
- < Less than
- >= Greater than or equal to
- <=Less than or equal to
- <> or != Not equal to
- AND, OR, NOT used to combine conditions
Syntax: SELECT column 1, column2 FROM table_name WHERE conditionl AND condition2;
Retrieving Data from Multiple Tables
Identify the Relationship
- Locate the field that connects the two tables.
- The connecting field in one table is called a Foreign Key.
- It refers to the Primary Key of another table.
Methods to Retrieve Data
- Write a query to get the related field (for example, an ID) from the first table.
- Use that field as a condition in a second query to get information from the second table.
- Combine both queries using parentheses.
Syntax: SELECT column_name FROM Table2 WHERE key_field = ( SELECT key_field FROM Table1 WHERE condition );
Using a JOIN Statement
- Identify the common field between both tables.
- Use the INNER JOIN clause to connect them.
- Retrieve the desired columns from both tables.
Syntax: SELECT Table 1 .column_name, Table2.column_name FROM Table 1 INNER JOIN Table2 ON Table 1 .key_field = Table2.key_field WHERE condition;
Steps to Execute in DB Browser for SQLite
- Open the database in DB Browser for SQLite.
- Click the Execute SQL tab.
- Type the SQL statement (subquery or JOIN).
- Click Run / Execute SQL to display the result.
- Review the output in the results pane.