CBSE Class 9 Computer Science Database Management System MCQs

Question. ROLLBACK in a database is ________ statement ?
a) TCL
b) DCL
c) DML
d) DDL

Answer : A

Question. A prescribed set of well-defined instructions for solving mathematical problems is called __________ ?
a) a compiler
b) a code
c) a description
d) an algorithm

Answer : D

Question. Data independency in DBMS is known as ?
a) Data modeling
b) Data hiding
c) Data capturing
d) Data consistency

Answer : A

Question. Periodically adding, changing and deleting file records is called file ?
a) updating
b) upgrading
c) restructiring
d) renewing

Answer : A

Question. __________ represents raw facts, whereas __________ is data made meaningful ?
a) Information, reporting
b) Data, information
c) Information, bits
d) Records, bytes

Answer : B

Question. External database is ?
a) Database created in EXCEL
b) Database created using DBMS package
c) Database created in MS-Word
d) All of the above

Answer : D

Question. Forms that are used to organize business data into rows and columns are called __________ ?
a) transaction sheets
b) registers
c) business forms
d) spreadsheets

Answer : D

Question. A collection of conceptual tools for describing data, relationships, semantics and constraints is referred to as ?
a) ER model
b) Data base
c) Data Model
d) DBMS

Answer : C

Question. What refers to a set of characters of a particular design ?
a) keyface
b) formation
c) calligraph
d) typeface

Answer : D

Question. The method of file organization in which data records in a file are arranged in a specified order according to key filed is known as the ?
a) Direct access method
b) Queuing method
c) Predetermined method
d) Sequential access method

Answer : D

Question. Which of the following statements best describes the batch method of input ?
a) Data is processed as soon as it is input
b) Data is input at the time it is collected
c) Data is collected in the form of source documents, placed into groups, and then input to the computer
d) Source documents are not used

Answer : C

Question. Which of these is considered intelligent CASE tool ?
a) Toolkit
b) Methodology companion
c) Workbench
d) Upper CASe

Answer : C

Question. A data dictionary doesn’t provide information about ?
a) where data is located
b) the size of the disk storage disk
c) who owns or is responsible for the data
d) how the data is used

Answer : B

Question. Collecting personal information and effectively posing as another individual is known as the crime of __________ ?
a) spooling
b) identity theft
c) spoofing
d) hacking

Answer : A

Question. Files are organised by storing them in _________ ?
a) tables
b) databases
c) folders
d) graphs

Answer : C

Question. The issues that deals with the collection and use of data about individuals is ?
a) access
b) publicity
c) accuracy
d) privacy

Answer : D

Question. The database administrator is, in effect, the coordinator between the _____ and the _____ ?
a) DBMS; database
b) application program; database
c) database, users
d) application programs; users

Answer : C

Question. The main purpose(s) of a database management program is to ?
a) allow users to retrieve and analyze stored records.
b) provide a way to store information about specified entities.
c) make it possible for users to store information as interrelated records.
d) a, b, and c above

Answer : D

Question. Files are organised by storing them in ?
a) tables
b) databases
c) folders
d) graphs

Answer : C

Question. Numbers in table columns are usually ?
a) right-aligned
b) left-aligned
c) justified
d) centered

Answer : A

Question. A telephone number, a birth date, and a customer name are all examples of ?
a) a record
b) data
c) a file
d) a database

Answer : D

Question. Example of non-numeric data is ?
a) Employee address
b) Examination score
c) Bank balance
d) All of these

Answer : A

Question. Databases overall structure is maintained in a file called ?
a) Redolog file
b) Data file
c) Control file
d) All of the above

Answer : C

Question. The following are components of a database except ________ ?
a) user data
b) metadata
c) reports
d) indexes

Answer : C

Question. An application where only one user accesses the database at a given time is an example of a(n) ________ ?
a) single-user database application
b) multiuser database application
c) e-commerce database application
d) data mining database application

Answer : A