Kerala SSLC IT Theory Questions and Answers Chapter 8 Database – An Introduction

You can Download Database – An Introduction Questions and Answers, Kerala SSLC 10th IT Theory Questions and Answers Chapter 8 help you to revise complete Syllabus and score more marks in your examinations.

Kerala Syllabus SSLC IT Theory Questions and Answers Chapter 8 Database – An Introduction

Database – An Introduction Questions and Answers

Section -1

Question 1.
A systematic collection of data is called
a) Python
b) Database
c) Quantum GIS
d) GIMP
Answer:
b) Database

Question 2.
Which form is used to record the data in database?
a) Picture
b) Chart
c) Tables
d) File
Answer:
c) Tables

Question 3.
How many tables can include in a database?
a) One
b) Two
c) One or more than one
d) Zero
Answer:
c) One or more than one

Question 4.
Give an example for database management systems
a) MySQL
b)GIM
c) Sampooma
d) Database
Answer:
a) MySQL

Question 5.
Which is a correct statement
a) A data from a database for one application software
b) A data from a database for other application software
c) No data to any software
d) No data form a database is in need for an application.
Answer:
b) A data from a database for other application software

Question 6.
Which can store and use data as required is an integral part of any software
a) System
b) Table
c) MS
d) DBMS
Answer:
d) DBMS

Question 7.
Which software is used to prepare DBMS in your computer
a) Libreoffice base
b) LibreOffice cale
c) Libreoffice writer
d) Quantum GIS
Answer:
a) Libreoffice base

Question 8
Select a suitable pair, for field name and field type to the define fields of a database table
Field Name — Field type
a) Name — Date: [Date]
b) Name — Decimal [DECIMAL]
c) Name — Text [VARCHAR]
d) Name — Number [NUMBERIC]
Answer:
c) Name — Text [VARCHAR]

Question 9.
The value of a primary key is.
a) Number
b) Unique
c) Decimal
d) Name
Answer:
b) Unique

Question 10.
To set the primary key, right-click on the left-hand side of the field having unique value and select.
a) cut
b) Delete
c) primary key
d) insert rows
Answer:
c) primary key

Question 11.
What technology incorporated in the database management system to enter data
a) Tables
b) Forms
c) Queries
d) Reports
Answer:
b) Forms

Question 12.
Enter the data to the table through a form in Libre office database. Each row in table is known as
a) Table
b) Forms
c) Record
d) Panel
Answer:
c) Record

Question 13.
The database recognizes each records based on the
a) Primary key
b) size
c) Field
d) DBMS
Answer:
a) Primary key

Question 14.
All details of the students in our public schools are contained in Software
a) Register.
b) Class register
c) Sampooma
d) School
Answer:
c) Sampooma

Question 15.
Who helps to do the works of sampooma software
a) Database
b) form
c) Table
d) System
Answer:
a) Database

Question 16.
Who acts as a link between the database and the user or application software?
a) system analysis
b) form
c) DBMS
d) Table
Answer:
c) DBMS

Question 17.
Where does appears the forms, labels, queries, and reports created by LibreOffice database?
a) Task panel
b) Work area
c) Database panel
d) Layer panel
Answer:
b) Work area

Question 18.
What is the difference to create, a new data base file libreoffcie base
a) Create a new database file and save it.
b) No facility forsaving the file
c) Automatically file saves
d) Save before creating a new database file
Answer:
d) Save before creating a new database file

Question 19.
Opening a saved file in database to create a table. What option to be selected from task panel?
a) Create view
b) Use wizard to create table
c) Create table in design view
d) Table-1
Answer:
c) Create table in design view

Question 20.
A facility to get data with certain conditions from database is called,
a) Tables
b) Reports
c) Queries
d) Forms
Answer:
c) Queries

Question 21.
The queries created and saved by query wizard in database where do you see the queries
a) Work area
b) Task area
c) Back area
d) Panel
Answer:
a) Work area

Question 22.
According to you, what is the biggest advantage of database management system?
a) We can made one report
b) can’t make a report
c) We can make different types of reports
d) We can’t save the reports
Answer:
c) We can make different types of reports

Question 23.
Where did you get a newly created report
a) System analysis
b) form
c) work area
d) Table
Answer:
c) work area

Question 24.
Which button is used to create forms
a) Tables
b) Reports
c) Queries
d) forms
Answer:
d) forms

Question 25.
Select a software belongs to the library management system
a) Koha
b) Alexandria
c) Oracle
d) opals
Answer:
c) Oracle

Question 26.
Which button is used to create reports
a) Table
b) Reports
c) Queries
d) forms
Answer:
b) Reports

Question 27.
Which button is used to create queries
a) Table
b) Reports
c) queries
d) forms
Answer:
c) queries

Question 28.
Select a software not belongs to library management system using cloud technology.
a) Insignia software
b) Libramatie
c) world share
d) GIMP
Answer:
d) GIMP

Question 29.
The databases of all the people of India is called.
a) Big data
b) short data
c) medium data
d) simple data
Answer:
a) Big data

Question 30.
Pick out the odd one
a) Aadharcard
b) sampooma
c) WhatsApp
d) Wikipedia
Answer:
b) sampooma

Question 31.
An example fora big data is
a) sampoorna
b) Aadhar card
c) School identify card
d) move
Answer:
b) Aadhar card

Section – II

Question 32.
System analysis is associated with the field of computerization. Select two correct statements related to system analysis.
a) To study in detail in the field of computerization
b) To study the software used in the field of computerization
c) To understand in detail in the field of computerization
d) Does not understand the field of computerization
Answer:
a) To study in detail in the field of computerization
and
c) To understand in detail in the field of computerization

Question 33.
What are the uses of the data in Sampoorna?
a) To DBMS
b) To prepare the applications for school Youth festival
c) To know the school
d) To the distribution of scholarships for the student
Answer:
b) To prepare the applications for school Youth festival
and
d) To the distribution of scholarships for the student

Question 34.
Correct statements related to DBMS are
a) To know the data
b) To delete the data
c) To store the data
d) To use the data
Answer:
c) To store the data
and
d) To use the data

Question 35.
What are the panel seen by opening LibreOffice base main
a) layer panel
b) database panel
c) Table
d) Task panel
Answer:
b) database panel and
d) Task panel

Question 36.
What are the means to enter the data to the DBMS
a) By properly designed application software
b) By typing the data’
c) Through the form in DBMS
d) Through the queries in DBMS
Answer:
a) By properly designed application software
and
c) Through the form in DBMS

Question 37.
Examples for query languages used to communicate with database are
a) C++
b) Java
c) SQL
d) MY SQL
Answer:
c) SQL
and
d) MY SQL

Question 38.
Open the libre office base from main menu. Select two correct arrangements to create a new database file using database wizard
a) Select the database option and click the back
b) Select the database option and click the finish button
c) A window appears to save the file with a name in your folder
d) A window appears to create the file.
Answer:
b) Select the database option and click the finish button
and
c) A window appears to save the file with a name in your folder

Question 39.
What are the fields seen in the window for define fields?
a) Field name
b) Textvarchar
c) Field type
d) Rows
Answer:
a) Field name
and
c) Field type

Question 40.
What are the activities can conduct through queries
a) To add records
b) To create tables
c) To change the records
d) To create a database file
Answer:
a) To add records
and
c) To change the records

Question 41.
Select two softwares handling big data
a) Spark
b) Android
c) Handoop
d) Linux
Answer:
a) Spark
and
c) Handoop

Question 42.
A database can do many activities. A list of activities are given below. Select one correct activity from each set.

Set -1

a) Data is not safe
b) Can’t store the data
c) No proper arrangements for the data
d) store the data safely
Answer:
d) store the data safely

Set – II

a) can’t add or delete a data
b) Adding a new data and delete unnecessary data
c) Adding a new data and not able delete it
d) Not able to adding a new data and can delete the – data
Answer:
b) Adding a new data and delete unnecessary data

Set III

a) To easy to handle data
b) Using the required data
c) Not able to analyze the data
d) Not able to use the date
Answer:
b) Using the required data

Set IV

a) To make change in several times
b) Not able to change in several times
c) To make change in one time
d) Not able to change in database file
Answer:
a) To make change in several times

Question 43.
Where are the utilities on the database panel of LibreOffice base main window?

Set-I

a) Charts
b) Table
c) Column
d) Picture
Answer:
b) Table

Set – II

a) Quarries
b) Primary key
c) Textvarchar
d) Date
Answer:
a) Quarries

Set III

a) Forms
b) Data
c) Tasks
d) Panel
Answer:
a) Forms

Set IV

a) Design window
b) Data
c) Type
d) Reports
Answer:
d) Reports

Question 44.
What are the field name and field type for define fields of a table in database? Select a suitable field name and field type from each set.

Set-I

a) Book No – Number [NUMERIC]
b) Book No-Text [VARCHAR]
c) Book No- Date [DATE]
d) Book No- Decimal [DECIMAL]
Answer:
a) Book No-Number [NUMERIC]

Set -II

a) Author-Name
b) Author-Number [NUMERICAL]
c) Author- Decimal [DECIMAL]
d) Author-Text [VARCHAR]
Answer:
d) Author-Text [VARCHAR]

Set-III

a) Book Price – Date [DATE]
b) Book Price – Decimal [DECIMAL]
c) Book Price-Number [NUMERIC]
d) Book Price – Text [VARCHAR] ‘
Answer:
b) Book Price – Decimal [DECIMAL]

Set-IV

a) Book Name – Text [VARCAAR]
b) Book Name-Number [NUMERIC]
c) Book Name – Date [DATE]
d) Book name-Decimal [DECIMAL]
Answer:
a) Book Name-Text [VARCAAR]

Question 45.
What are the field types to choose in the window for define fields in Database? Select one from each set.

Set -I

a) file
b) field
c) primary key
d) number
Answer:
d) number

Set-II

a) Row
b) columns
c) Date
d) form
Answer:
c) Date

Set -III

a) Decimal
b) images
c) Panel
d) Reports
Answer:
a) Decimal

Set -IV

a) Text
b) Software
c) Data entry
d) Office writer
Answer:
a) Text

Question 46.
Select the order of activity to create a new database file in LibreOffice base

Set-I

a) Click the cancel button of the window for database wizard
b) Click the select database option of the window for database wizard
c) Click the reports option of the window for Database
d) Click the table option of the window for database
Answer:
b) Click the select database option of the window for database wizard

Set-ll

a) Select create a new database in database wizard
b) Select open an existing database file in database wizard
c) Select Connect to an existing database file in database
d) Click on OK button in database wizard
Answer:
a) Select create a new database in database wizard

Set-III

a) A window to create form will appear
b) A window to create report will appear
c) A window to save the file will appear
d) A window to cancel the file will appear
Answer:
c) A window to save the file will appear

Set – IV

a) Not sav6 the file
b) Not to pen the saved file
c) Give file name and save with proper folder
d) Don’t change in the window
Answer:
c) Give file name and save with proper folder

Question 47.
Which are available library management system software in use

Set-1

a) Sampooma
b) Koha
c) Evergreen
d) writer
Answer:
b) Koha

Set-II

a) Android
b) Linux
c) Evergreen
d) Writer
Answer:
c) Evergreen

Set-III

a) Gimp
b) L4U
c) Qgis
d)Inkscape
Answer:
b) L4U

Set -IV

a) opals
b) python
c) google
d) Database
Answer
a) opals

Question 48.
Which are the library management systems using cloud technology select correct answers to an each set?

Set-1

a) Writer
b) Cale
c) Database
d) Insignia software
Answer:
d) Insignia software

Set – II

a) Gimp
b) Libranaties
c) Inkscape
d) Qgis
Answer:

b) Libranaties

Set-III

a) World share
b) Sampooma
c) Spark
d) Android
Answer:
a) World share

Set-IV

a) Hadoop
b) Firewall
c) Alma
d) Sun clock
Answer
c) Alma

Question 49.
Name the challenging tasks to handle the database of a big data select one from each set

Set 1

a) Data collection
b) Small data
c) Reports
d) Aadhar card
Answer:
a) Data collection

Set II

a) Data
b)Sharing of data
c) form
d) news
Answer:
b)Sharing of data

Set III

a) data
b) images
c) data exchange
d) WhatsApp
Answer:
c) data exchange

Set – IV

a) spark
b) use
c) Big data
d) Data analysis
Answer:
d) Data analysis