Chapter:

1200+ more mcqs Solved MCQs

in DataBase Management System (DBMS)

These multiple-choice questions (MCQs) are designed to enhance your knowledge and understanding in the following areas: Computer Science Engineering (CSE) , Bachelor of Science in Computer Science FY (BSc CS) , Bachelor of Science in Computer Science SY (BSc CS) , Bachelor of Science in Information Technology SY (BSc IT) , Bachelor of Computer Applications (BCA) .

Chapters

Take a Test

51.	How many types of keys in Database Design?
A.	foreign key
B.	all of the options
C.	candidate key
D.	primary key
Answer» B. all of the options

52.	Which of the following is based on Multi Valued Dependency?
A.	third
B.	fourth
C.	first
D.	second
Answer» B. fourth

53.	Which of the following is the structure of the Database?
A.	table
B.	none of these
C.	schema
D.	relation
Answer» C. schema

54.	The minimal set of super key is called
A.	primary key
B.	secondary key
C.	foreign key
D.	candidate key
Answer» D. candidate key

55.	______________ is a classical approach to database design?
A.	bottom – up approach
B.	top – down approach
C.	left – right approach
D.	right – left approach
Answer» B. top – down approach

56.	_____________ refers to the correctness and completeness of the data in a database?
A.	data independence
B.	data integrity
C.	data security
D.	data constraint
Answer» B. data integrity

57.	A table that displays data redundancies yields ____________ anomalies
A.	insertion
B.	deletion
C.	update
D.	all of the options
Answer» D. all of the options

58.	A lock that allows concurrent transactions to access different rows of the same table is known as a
A.	row-level lock
B.	database-level lock
C.	field-level lock
D.	table-level lock
Answer» C. field-level lock

59.	A type of query that is placed within a WHERE or HAVING clause of another query is called
A.	multi-query
B.	sub query
C.	super query
D.	master query
Answer» B. sub query

60.	A form defined
A.	none of the options
B.	where data is placed on the screen
C.	the width of each field
D.	both where data is placed on the screen and the width of each field
Answer» B. where data is placed on the screen

61.	If a piece of data is stored in two places in the database, then
A.	in can be more easily accessed
B.	both storage space is wasted and changing the data in one spot will cause data inconsistency
C.	storage space is wasted
D.	changing the data in one spot will cause data inconsistency
Answer» B. both storage space is wasted and changing the data in one spot will cause data inconsistency

64.	An audit trail
A.	none of the options
B.	is the recorded history of operations performed on a file
C.	is used to make backup copies
D.	can be used to restore lost information
Answer» B. is the recorded history of operations performed on a file

65.	One approach to standardization storing of data?
A.	codasyl specification
B.	none of the options
C.	mis
D.	structured programming
Answer» A. codasyl specification

66.	Report generators are used to
A.	store data input by a user
B.	answer queries
C.	both retrieve information from files and answer queries
D.	retrieve information from files
Answer» C. both retrieve information from files and answer queries

67.	Which of the following is true of a network structure?
A.	it will be dominant data base of the future
B.	it allows a many-to-many relationship
C.	it is a physical representation of the data
D.	it is conceptually simple
Answer» B. it allows a many-to-many relationship

62.	Which of the following is a problem of file management system?
A.	data redundancy and program dependence
B.	all of the options
C.	difficult to update
D.	lack of data independence
Answer» B. all of the options

63.	Which of the following is not an advantage of the database approach
A.	elimination of data redundancy
B.	ability of associate deleted data
C.	increased security and program/data independence
D.	all of the above
Answer» D. all of the above

68.	A record management system
A.	can handle many files of information at a time
B.	always uses a list as its model
C.	both can handle many files of information at a time and always uses a list as its model
D.	can be used to extract information stored in a computer file
Answer» D. can be used to extract information stored in a computer file

69.	One data dictionery software package is called
A.	db/dc dictionary
B.	datapac
C.	total
D.	access
Answer» A. db/dc dictionary

70.	The function of a database is ...
A.	to check all input data
B.	to output data
C.	to collect and organize input data
D.	to check all spelling
Answer» C. to collect and organize input data

71.	A command that lets you change one or more fields in a record is
A.	none of the options
B.	modify
C.	insert
D.	lookup
Answer» B. modify

72.	What is the language used by most of the DBMSs for helping their users to access data?
A.	high level language
B.	4gl
C.	query language
D.	sql
Answer» C. query language

73.	Information can be transferred between the DBMS and a
A.	spreadsheet program
B.	word processor program
C.	graphics program
D.	all of the options
Answer» D. all of the options

74.	The relational database environment has all of the following components except
A.	users
B.	database
C.	query languages
D.	separate files
Answer» D. separate files

75.	The ascending order of a data hirerchy is:
A.	bit-byte-file-record-field-database
B.	bit-byte-field-record-file-database
C.	bit-byte-record-field-file-database
D.	byte-bit-field-record-file-database
Answer» B. bit-byte-field-record-file-database

1200+ more mcqs Solved MCQs

How many types of keys in Database Design?

Which of the following is based on Multi Valued Dependency?

Which of the following is the structure of the Database?

The minimal set of super key is called

______________ is a classical approach to database design?

_____________ refers to the correctness and completeness of the data in a database?

A table that displays data redundancies yields ____________ anomalies

A lock that allows concurrent transactions to access different rows of the same table is known as a

A type of query that is placed within a WHERE or HAVING clause of another query is called

A form defined

If a piece of data is stored in two places in the database, then

Which of the following is a problem of file management system?

Which of the following is not an advantage of the database approach

An audit trail

One approach to standardization storing of data?

Report generators are used to

Which of the following is true of a network structure?

A record management system

One data dictionery software package is called

The function of a database is ...

A command that lets you change one or more fields in a record is

What is the language used by most of the DBMSs for helping their users to access data?

Information can be transferred between the DBMS and a

The relational database environment has all of the following components except

The ascending order of a data hirerchy is:

Primitive operations common to all record management system include

Which of the following is not a relational database?

A top-to-bottom relationship among the items in a database is established by a

Choose the RDBMS which supports full fledged client server application development

The highest level in the hierarchy of data organization is called

The management information system (MIS) structure with one main computer system is called a

In the DBMS approach, application programs perform the

Which of the following is not true of the traditional approach to information processing

Batch processing is appropriate if

Large collection of files are called

A transparent DBMS

A file produced by a spreadsheet

The model for a record management system might be

Database management systems are intended to

The language used application programs to request data from the DBMS is referred to as the

A set of programs that handle a firm's database responsibilities is called

In a large DBMS

In a large DBMS

A Database Management System (DBMS) is

Which of the following is not a level of data abstraction?

Disadvantages of File systems to store data is:

In an Entity-Relationship Diagram Rectangles represents

Which of the following is not a Storage Manager Component?

Data Manipulation Language enables users to

Which of the following is not an Schema?

76.	Primitive operations common to all record management system include
A.	look-up
B.	all of the options
C.	print
D.	sort
Answer» A. look-up

77.	Which of the following is not a relational database?
A.	dbase iv
B.	foxpro
C.	reflex
D.	4th dimension
Answer» C. reflex

78.	A top-to-bottom relationship among the items in a database is established by a
A.	hierarchical schema
B.	all of the options
C.	network schema
D.	relational schema
Answer» A. hierarchical schema

79.	Choose the RDBMS which supports full fledged client server application development
A.	dbase v
B.	ingress
C.	oracle 7.1
D.	foxpro 2.1
Answer» C. oracle 7.1

80.	The highest level in the hierarchy of data organization is called
A.	data base
B.	data record
C.	data bank
D.	data file
Answer» A. data base

81.	The management information system (MIS) structure with one main computer system is called a
A.	decentralized mis structure
B.	centralized mis structure
C.	hierarchical mis structure
D.	distributed mis structure
Answer» B. centralized mis structure

82.	In the DBMS approach, application programs perform the
A.	storage function
B.	access control
C.	all of the options
D.	processing functions
Answer» D. processing functions

83.	Which of the following is not true of the traditional approach to information processing
A.	it is file oriented
B.	it is inflexible
C.	there is common sharing of data among the various applications
D.	programs are dependent on the file
Answer» C. there is common sharing of data among the various applications

84.	Batch processing is appropriate if
A.	only a few transactions are involved
B.	none of the options
C.	large computer system is available
D.	only a small computer system is avilbale
Answer» B. none of the options

85.	Large collection of files are called
A.	sectors
B.	database
C.	fields
D.	records
Answer» B. database