WorksheetsDatabase Management System Class 10 Quiz
Total questions: 76
Worksheet time: 38mins
Databases are being used to _.
Store
Manipulate
Manage
All of the above
In Database which type of data we can store.
All of the above
Text
Image
Audio and Video
Data is a collection of _.
Table
Database
Raw facts
None of the above
The facts may be related to __.
All of the above
Place
Any person
Activity or things
Data can be processed in the proper way to generate meaningful __.
None of the above
Data
Information
Database
Which of the following is known as an organized form of data.
Data
None of the above
Database
Information
A _ is a collection of logically related data items stored in an organized manner.
Data
Database
Information
None of the above
Which of the following software is used to retrieve, update and create data in a database.
Database Management System (DBMS)
Data Manager (DM)
Database Manager (DM)
None of the above
Which of the following is a common example of DBMS.
All of the above
Oracle or MySQL
OpenOffice or LibreOffice Base
MS Access
The data in the database is stored in an __.
None of the above
Both a) and b)
Tabular method
Organized manner
A __ helps to analyze the data based on certain criteria.
Database
None of the above
Digital Document
Impress
What do you mean by Data Redundancy?
Same data will not be repeated in several tables
It can create same data multiple times
Data can be shared to multiple users
None of the above
What do you mean by Data consistency?
Reliability of the data
Accuracy of the data
Uniformity of the data
All of the above
Database helps to maintain the same data across all the tables, this is known as _.
Data Consistency
Data Redundancy
Data Sharing
None of the above
Data redundancy and inconsistency can be minimized in a database which helps to increase.
Accuracy
None of the above
Security
Validity
The data is translated in such a manner in a database that unauthorized users are not able to read is known as _.
Consistency
None of the above
Validity
Encryption
The structure of the database is known as _.
Data
Data Base
Data Model
None of the above
Which of the following data models is used in the database.
Hierarchical data model
Relational data model
All of the above
Network data model
In which data model the data is organized into a tree-like structure.
Network data model
All of the above
Hierarchical data model
Relational data model
In which of the following data models are used to link multiple records to the master file.
Network data model
Hierarchical data model
All of the above
Relational data model
In which data model is based on the principle of setting relationships between two or more tables of the same database.
Relational data model
All of the above
Hierarchical data model
Network data model
Which of the following is the most commonly used database model in DBMS.
Hierarchical data model
All of the above
Network data model
Relational data model
The relational database model was proposed in __.
1970
1980
1990
2000
The relational database model is proposed by __.
E. F. Codd
John von Neumann
Linus Torvalds
M. K. Rose
In relational data models the data are stored in different tables made up of __.
None of the above
Both a) and b)
Rows
Columns
In which data model the relations are set between tables based on common fields.
All of the above
Relational data model
Network data model
Hierarchical data model
Which of the following is a real world object which stores the information in a database.
Entity
All of the above
Attribute
Field
The details associated with the entity are called __.
Attribute
Entity
Field
All of the above
A __ is a collection of logically related records.
Field
Table
Entity
Attribute
A _ is the smallest entity in the database.
Attribute
Field
Record
Database
A collection of fields in the table make a _.
Attribute
Field
Record
Database
A collection of records makes a _.
Attribute
Field
Record
Table
A collection of tables make a __.
Record
Field
Database
Attribute
_ hold the data values of one type of data.
Database
Attribute
Field
Record
The raw data represented in the form of alphanumeric, character or numeric data is known as _.
Attribute
Record
Data value
Field
A __ is the set of data values for all the fields related to a person or object.
Attribute
Database
Field
Record
A __ holds the data values of all the fields for a single person or object in a table.
Attribute
Field
Record
Database
A _ key is a field that uniquely identifies a row in a table.
Primary key
Candidate key
Foreign key
None of the above
In a table if more than one field identifies a record, it is known as _.
Composite key
Foreign key
None of the above
Primary key
__ key helps to build a relation between two or more tables in a database.
Foreign key
None of the above
Composite key
Primary key
If the field values that are eligible to be the primary key are known as _.
Primary key
Candidate key
Foreign key
None of the above
In the database table if candidate keys are not chosen as the primary key are called __.
Alternate key
Candidate key
None of the above
Foreign key
The __ key helps to build a relation between two tables.
Foreign key
None of the above
Candidate key
Alternate key
All the field values that are eligible to be the primary key are the __.
None of the above
Candidate key
Alternate key
Foreign key
Which of the following is suitable for candidate keys?
Candidate key field can be left blank
Candidate key field don’t have duplicate values
None of the above
Both a) and b)
If in the database table there are two field roll numbers and admission number both are uniquely identified fields, if roll number is made as primary key then admission number will be __.
Alternate key
Candidate key
Foreign key
None of the above
A structure or feature that is used to store, represent, or retrieve data is called __.
Database
None of the above
Object
Report
What are the different objects present in RDBMS?
Table
Queries
Form & Report
All of the above
__ is a feature of a database, which contains data from users and stored in a database table using a user-friendly manner.
None of the above
Queries
Form
Report
The form consists of _.
Check box
All of the above
Radio button & list box
Text boxes & Labels
The data entered through the forms is stored in _.
Table
None of the above
Forms
Queries
The necessary data is extracted from the database using _.
Queries
None of the above
Forms
Table
The output of a query can be displayed in the form of _.
Queries
Forms
Report
None of the above
_ helps to specify while creating the tables and check only valid data will be entered in the table.
None of the above
Data Type
Data Storage
Validation
__ refers to the type of data that will be stored in the particular field.
None of the above
Validation
Data Storage
Data Type
The memory size of the field varies according to its __.
None of the above
Data Type
Data Storage
Validation
The text data types are a combination of __.
Special Characters
All of the above
Numbers
Letters
No arithmetic calculations can be performed on _ data type.
Decimal Data type
Text Data type
Number Data type
None of the above
__ data type stores maximum length of the characters, data having more than 255 characters.
Text (Varchar)
None of the above
Text(fix) (Char)
Memo (Longvarchar)
_ data type stores exactly the length specified, this data type uses a fixed number of characters.
Text(fix) (Char)
Memo (Longvarchar)
Text (Varchar)
None of the above
__ data type allocated depends on the number of characters entered by the user.
None of the above
Text (Varchar)
Text(fix) (Char)
Memo (Longvarchar)
__ data type consists of number, integer, decimal, real or double type which can perform arithmetic calculation.
Binary Data type
Date Data type
Number Data type
Text Data type
_ data type is used to store decimal values in the database using a table.
Number
Tiny Integer
BigInt
Float
Which data type is used to store monetary values and can store currencies of various countries.
Boolean Data type
None of the above
Currency Data type
Date Data type
Which data type is used to store date and time both in the database.
Timestamp
Time
None of the above
Date
Which data type is used to store date data in the database table.
Date
Time
Timestamp
None of the above
Which data type is used to store time in the database table.
None of the above
Timestamp
Time
Date
In which data type you can store True/False, Yes/No, or On/Off in the database table.
Binary Data type
Text Data type
Number Data type
Boolean Data type
Which data type is used to store digital image, sound, video or file in the database table.
Text Data type
Boolean Data type
Number Data type
Binary Data type
What is the name of a method where you can create a new database using step by step procedure.
Database Wizard
Database Method
None of the above
New Database
In LibreOffice Base if you select the option “No, do not register the database” then what will happen.
Database will not open
Database will not share publicly
Database will not store the data
None of the above
What method is used to create tables in LibreOffice Base?
Both a) and b)
Using Design View
None of the above
Using Table Wizard
Which method is used to create a table in a flexible method.
Using Table Wizard
Using Design View
None of the above
Both a) and b)
In LibreOffice Base, If you want to describe the purpose of the field, it will not be a part of the database table but it helps the user to understand the purpose of the field.
Field Name
Field Type
Description
None of the above
Which of the following shortcut keys is used to save the table in the database.
Alt + S
Ctrl + S
Shift + S
None of the above
The data can be arranged in the table using _.
Arrangement
Sorting
Descending
Ascending
