NEW
Font size
WorksheetsClass 10th DBMS
Total questions: 23
Worksheet time: 17mins
Which one of the following is not an example of DBMS?
PostgresSQL
SQLite
FoxPro
Impress
Which of the following is not the advantage of database?
Sharing of Data
Reduce Data Redundancy
Increase Data Inconsistency
Data Security
Which of the following field of table "Book" can act as Primary Key?
Book_number
Subject
price
Author_name
When Primary Key is made up of two or more columns then it is called................ key.
reference key
Duplication of data is called ................................
Inconsistency
Consistency
Redundancy
Foreign Key
............... are dedicated computers that hold the actual databases and run only DBMS and related Software.
Main Server
Web Server
Database Server
Non Database Server
.................... are the basic building blocks of a database.
Tables
Record
Fields
All of these
By default the length of Varchar data type is ...................
20
40
50
By default the name of the table is ....................... ( when you create a new table in DB).
a. Tab 1
b. Table 1
c First Table
d. Untitled 1
................................ are used to identify which type of data we are going to store in the database.
a. Datatype
b. Record
c Table
d. Attributes
Which data type will be appropriate to store information such as Salary, Fees, Price, etc.?
a. Alphanumeric Data types
b. Numeric Data type
c. Binary Data types
d. Date Time
Which of the following is not a numeric data type?
a. Tinyint
b. Smallint
c. Float
d. Date
In which view data can be entered in table?
a. Datasheet view
b. Design view
c. Both a. and b.
d. None of these
By default data is arranged in ............................ order using order by clause.
a. ascending
c. Primary Key
b. descending
. None of these
Relationship between tables can be created from .... ........... menu.
a. View
b. Insert
c. Windows
d. Tools
hich language help to extract/fetch data from table?
a. MySQL
b. Python
c. OpenOffice Base
d. HTML
We can create query (in OpenOffice Base) .....................
a. In design view
b. Using wizard
c Both a. and b.
d. None of these
Which of the following property to be turned "yes" so that value will be auto incremented?
a. Default
b. Format
c. Auto value
d. Length
Sorting means to arrange data in ...................... order.
a. increasing
b. decreasing
c. increasing or decreasing
d. None of the above
In Base data can be linked between two or more tables with the help of.................................
a. Primary Key
b. Forelgn Key
c. Primary and Foreign Key
d. None of the above
Select "salary" from emp;
a. will display all the records of table emp
b. will display only particular columns of table emp:
c. will display only salary column of table emp:
d. None of the above
What is the purpose of a Foreign Key in a database?
d. To create a backup of the database
c. To store large amounts of data
b. To link two tables together
a. To uniquely identify a record
Which of the following is a characteristic of a relational database?
c. Data cannot be queried
b. Data is organized in tables
d. Data is stored in a single format
a. Data is stored in files
