CBSE Class 12 Computer Science Database Management System MCQs

Question. Dr. E.F. Codd represented ______ rules that a database must obey if it has to be considered truly relational ?
a) 10
b) 8
c) 12
d) 6

Answer : C

Question. A collection of unprocessed items is ________ ?
a) information
b) data
c) memory
d) reports

Answer : B

Question. Attributes can be defined for ?
a) entity
b) switch board
c) macro
d) pages

Answer : A

Question. ______ is one reason for problems of data integrity ?
a) Data availability constraints
b) Data inconsistency
c) Security constraints
d) Unauthorized access of data

Answer : B

Question. When data changes in multiple lists and all lists are not updated, this causes ?
a) data redundancy
b) information overload
c) duplicate data
d) data inconsistency

Answer : D

Question. A data warehouse ?
a) Contains numerous naming conventions and formats
b) Is organized around important subject areas
c) Contains only current data
d) Can be updated by end users

Answer : A

Question. How do businesses protect their databases ?
a) Security guards are hired to watch the databases at all times.
b) Databases are protected by file swapping.
c) Databases are naturally protected.
d) Databases are kept physically and electronically secure.

Answer : D

Question. _________ is used by public and private enterprises to publish and share financial information with each other and industry analysts across all computer platforms and the Internet ?
a) Extensible Markup Language (EML)
b) Extensible Business Reporting Language (XBRL)
c) Enterprise Application Integration (EAI)
d) Sales Force Automation (SFA) software

Answer : B

Question. A field that uniquely identifies which person, thing, or event the record describes is a ______ ?
a) file
b) data
c) field
d) key

Answer : D

Question. What is a database ?
a) It is a collection of data arranged in rows
b) It is a collection of data arranged in columns
c) It is a collection of data arranged in rows and columns
d) All of the above

Answer : C

Question. The path of creation of an executable is ?
a) coding, linking, compiling, parsing
b) coding, parsing, compiling, linking.
c) coding, compiling, parsing, linking
d) coding, compiling, linking, parsing.

Answer : D

Question. Meaningful filename helps in easy file ______ ?
a) Storing
b) Accessing
c) Identification
d) Printing

Answer : B

Question. Which of the following places the common data elements in order from smallest to largest ?
a) Character, file record, field, database
b) Character, record, field, file, database
c) Character, field, record, file, database
d) Bit, byte, character, record, field, file, database

Answer : D

Question. A collection of interrelated files in a computer is a _________ ?
a) file manager
b) field
c) record
d) database

Answer : D

Question. __________ increase the accuracy of a search by fine-tuning the keywords in the search ?
a) Indexes
b) Italics
c) Compounds
d) Links

Answer : A

Question. The first step in the transaction processing cycle is __________ ?
a) database operations
b) audit
c) data entry
d) user inquiry

Answer : C

Question. Which of the following contains permanent data and gets updated during the processing of transactions ?
a) Operating System File
b) Transaction file
c) Software File
d) Master file

Answer : D

Question. A relation (from the relational database model) consists of a set of tuples, which implies that ?
a) relational model supports multi-valued attributes whose values can be represented in sets.
b) for any two tuples, the values associated with all of their attributes may be the same.
c) for any two tuples, the value associated with one or more of their attributes must differ.
d) all tuples in particular relation may have different attributes.

Answer : C

Question. The DBMS that is most difficult to use is ________ ?
a) Microsoft’s SQL Server
b) Microsoft’s Access
c) IBM’s DB2
d) Oracle Corporation’s Oracle

Answer : D