There are certain packages that allow people to define data items, place these items in particular records, combine the records into designated files and then manipulate and retrieve the stored data. What are they called?

Database management system (DBMS)

Which two files are used during operation of the DBMS?

data dictionary and query language

data manipulation language and query language

data dictionary and transaction log

data dictionary and query language

To have a file hold a list, it is necessary to

identify the records in the list

identify the name, width and type of the fields of each record.

decide which fields will be used as sort or index keys

An-owner-member set in the CODASYL specifications may have

only one member but many member occurrence

only one owner but many owner occurrences

only one member but many member occurrence

more than one member but only one occurrence per member

A computer file can be best described as

a random collection of data items

a general collection of data items

an orderly collection of data items

a random collection of data items

In order to use a DBMS, it is important to understand

all sub-schemas that the system supports

Data encryption techniques are particularly useful for

reducing storage space requirements

protecting data in data communication systems

Sophisticated report generators can

selectively retrieve and print portions of a list

The PROJECT command will create new table that has

more fields than the original table

more rows than the original table

In SQL, the CREATE TABLESPACE is used

to create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace

to add/rename data files, to change storage

If a calculation is embedded in a form

the result of the calculations are printed in report

the result of the calculations are stored with the form

the calculations are stored with the form

the result of the calculations are printed in report

A multiple-form file management system

allow you to entry data in all the forms

lets you define different forms for different operations

lets you create a look-up form with an associated read-only password to prevent access by unauthorized users

allow you to entry data in all the forms

can be accessed only by data processing professionals

can accept English language commands

allows non-programmers to access information stored in a database

can be accessed only by data processing professionals

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

There is common sharing of data among the various applications

Programs are dependent on the files

A list consists of last names, first names, addresses, and pin codes if all people in the list have the same last and the same pin code, a useful key would be

a compound key consisting of the first name and the last name

appears on the computer monitor during data entry

is used during report generation to format data

Which of the following is true of a network structure?

It is a physical representation of the data

It allows a many-to-many relationship

It will be the dominant data base of the future

A data dictionary is a special file that contains

the names of all fields in all files

the data types of all fields in all files

the widths of all fields in all files

When using a database management system, the first thing that you must do is to

keep a floppy disk in readiness

load the software into your micro¬¨computer

keep a floppy disk in readiness

A database management system

allows simultaneous access to multiple files

can do more than a record management system

is a collection of programs for managing data in a single file

When you have finished entering information into a form

the contents of the form can be printed

the template is written to the data file

the contents of the form are written to the data file

the contents of the form can be printed

In SQL, GRANT command is used to

choose auditing for specific SQL commands

grant system privileges, roles, and object privileges to uses and roles

choose auditing for specific SQL commands

Sort/report generators

do not need to sort before generating a report

are faster than index/report generators

require more disk space than index/report generators

do not need to sort before generating a report

Data security threats include

fraudulent manipulation of data

155 + Mcqs in Database Systems in Computer Science Page 3 McqOptions

101.	There are certain packages that allow people to define data items, place these items in particular records, combine the records into designated files and then manipulate and retrieve the stored data. What are they called?
A.	Data storage system
B.	Database management system (DBMS)
C.	Batch processing system
D.	Data communication package
Answer» C. Batch processing system

Discussion

102.	Embedded pointer provide
A.	a secondary access path
B.	a physical record key
C.	an inverted index
D.	All of the above
Answer» B. a physical record key

Discussion

103.	Which two files are used during operation of the DBMS?
A.	query language and utilities
B.	data manipulation language and query language
C.	data dictionary and transaction log
D.	data dictionary and query language
Answer» D. data dictionary and query language

Discussion

104.	To have a file hold a list, it is necessary to
A.	identify the records in the list
B.	identify the name, width and type of the fields of each record.
C.	decide which fields will be used as sort or index keys
D.	All of the above
Answer» E.

Discussion

105.	An-owner-member set in the CODASYL specifications may have
A.	only one owner but many owner occurrences
B.	only one member but many member occurrence
C.	more than one member but only one occurrence per member
D.	All of the above
Answer» B. only one member but many member occurrence

Discussion

106.	A computer file can be best described as
A.	a single data item
B.	a general collection of data items
C.	an orderly collection of data items
D.	a random collection of data items
Answer» D. a random collection of data items

Discussion

107.	In order to use a DBMS, it is important to understand
A.	the physical schema
B.	all sub-schemas that the system supports
C.	one subschema
D.	both (a) and (b)
Answer» D. both (a) and (b)

Discussion

108.	Data encryption techniques are particularly useful for
A.	reducing storage space requirements
B.	improving data integrity
C.	protecting data in data communication systems
D.	All of the above
Answer» D. All of the above

Discussion

109.	Sophisticated report generators can
A.	print row-oriented reports
B.	perform arithmetic operations
C.	selectively retrieve and print portions of a list
D.	All of the above
Answer» E.

Discussion

110.	The PROJECT command will create new table that has
A.	more fields than the original table
B.	more rows than the original table
C.	both (a) and (b)
D.	all the fields of master table
Answer» E.

Discussion

111.	In a relational schema, each tuple is divided into fields called
A.	Relations
B.	Domains
C.	Queries
D.	All of the above
Answer» C. Queries

Discussion

112.	In SQL, which command(s) is(are) used to enable/disable a database trigger?
A.	MODIFY USER
B.	CHANGE USER
C.	ALTER TRIGGER
D.	All of the above
Answer» D. All of the above

Discussion

113.	Data item characteristics that are important in data management include
A.	punctuation
B.	language
C.	spelling
D.	width
Answer» E.

Discussion

114.	In SQL, the CREATE TABLESPACE is used
A.	to create a place in the database for storage of scheme objects, rollback segments, and naming the data files to comprise the tablespace
B.	to create a database trigger
C.	to add/rename data files, to change storage
D.	All of the above
Answer» B. to create a database trigger

Discussion

115.	In SQL, which command(s) is(are) used to create a synonym for a schema object?
A.	CREATE SCHEMA
B.	CREATE SYNONYM
C.	CREATE SAME
D.	All of the above
Answer» C. CREATE SAME

Discussion

116.	A number of related records that are treated as a unit is called
A.	file
B.	field
C.	data
D.	batch
Answer» B. field

Discussion

117.	If a calculation is embedded in a form
A.	the result of the calculations are stored with the form
B.	the calculations are stored with the form
C.	the result of the calculations are printed in report
D.	All of the above
Answer» C. the result of the calculations are printed in report

Discussion

118.	A multiple-form file management system
A.	lets you define different forms for different operations
B.	lets you create a look-up form with an associated read-only password to prevent access by unauthorized users
C.	both (a) and (b)
D.	allow you to entry data in all the forms
Answer» D. allow you to entry data in all the forms

Discussion

119.	The designer of a form includes
A.	filed designators
B.	prompts
C.	data
D.	both (a) and (b)
Answer» E.

Discussion

120.	A good query system
A.	can accept English language commands
B.	allows non-programmers to access information stored in a database
C.	can be accessed only by data processing professionals
D.	both (a) and (b)
Answer» C. can be accessed only by data processing professionals

Discussion

121.	Which of the following is not true of the traditional approach to information processing?
A.	There is common sharing of data among the various applications
B.	It is file-oriented
C.	Programs are dependent on the files
D.	It is inflexible
Answer» B. It is file-oriented

Discussion

122.	A list consists of last names, first names, addresses, and pin codes if all people in the list have the same last and the same pin code, a useful key would be
A.	the pin code
B.	the last name
C.	a compound key consisting of the first name and the last name
D.	All of the above
Answer» D. All of the above

Discussion

123.	Information can be transferred between the DBMS and a
A.	spreadsheet program
B.	word processor program
C.	graphics program
D.	All of the above
Answer» E.

Discussion

124.	In SQL, which command is used to make permanent changes made by statements issue since the beginning of a transaction?
A.	ZIP
B.	PACK
C.	COMMIT
D.	SAVE
Answer» D. SAVE

Discussion

125.	The main idea behind computer files is that it is convenient to
A.	arrange them
B.	store information together
C.	create them
D.	access them
Answer» C. create them

Discussion

126.	The logical data structure with a one-to-many relationship is a :
A.	network
B.	tree
C.	chain
D.	relational
Answer» C. chain

Discussion

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

Discussion

128.	A report form
A.	appears on the computer monitor during data entry
B.	is used during report generation to format data
C.	both (a) and (b)
D.	All of the above
Answer» C. both (a) and (b)

Discussion

129.	A database management system might consist of application programs and a software package called
A.	FORTRAN
B.	AUTOFLOW
C.	BPL
D.	TOTAL
Answer» D. TOTAL

Discussion

130.	What is the language used by most of the DBMSs for helping their users to access data?
A.	High level language
B.	Query language
C.	SQL
D.	4GL
Answer» C. SQL

Discussion

131.	What is the name given to the database management system which is able to handle full text data, image data, audio and video?
A.	Full media
B.	Graphics media
C.	Multimedia
D.	Hypertext
Answer» D. Hypertext

Discussion

132.	Which command is used to remove an index from the database in SQL?
A.	DELETE INDEX
B.	DROP INDEX
C.	REMOVE INDEX
D.	ROLL BACK INDEX
Answer» C. REMOVE INDEX

Discussion

133.	Periodically adding, changing and deleting file records is called file
A.	Updating
B.	upgrading
C.	restructuring
D.	renewing
Answer» B. upgrading

Discussion

134.	If you want to organize a file in multiple ways, it is better to _____ the data rather than to sort it.
A.	Delete
B.	Update
C.	Sort Key
D.	Index
Answer» E.

Discussion

135.	The model for a _____ resembles the hierarchical model in many respects.
A.	Network database
B.	Relational database
C.	Distributed database
D.	Hierarchical database
Answer» B. Relational database

Discussion

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

Discussion

137.	A _____ DBMS distributes data processing tasks between the workstation and a network server.
A.	Network
B.	Relational
C.	Client Server
D.	Hierarchical
Answer» D. Hierarchical

Discussion

138.	A data dictionary is a special file that contains
A.	the names of all fields in all files
B.	the data types of all fields in all files
C.	the widths of all fields in all files
D.	All of the above
Answer» E.

Discussion

139.	When using a database management system, the first thing that you must do is to
A.	create a database file
B.	activate file editor
C.	load the software into your micro¬¨computer
D.	keep a floppy disk in readiness
Answer» D. keep a floppy disk in readiness

Discussion

140.	A database management system
A.	allows simultaneous access to multiple files
B.	can do more than a record management system
C.	is a collection of programs for managing data in a single file
D.	both (a) and (b)
Answer» E.

Discussion

141.	When you have finished entering information into a form
A.	the template is written to the data file
B.	the contents of the form are written to the data file
C.	the contents of the form can be printed
D.	All of the above
Answer» C. the contents of the form can be printed

Discussion

142.	In SQL, which command is used to select data in rows and column from one or more tables?
A.	CHOOSE
B.	SELECT
C.	LIST
D.	BROWSE
Answer» C. LIST

Discussion

143.	Each of data files has a _____ that describe the way the data is stored in the file.
A.	File structure
B.	Records
C.	Fields
D.	Database
Answer» B. Records

Discussion

144.	The files stored on a secondary stage device are composed of a hierarchy of data. What does a record in a file contain?
A.	Bits
B.	Characters
C.	Data field
D.	Schema
Answer» D. Schema

Discussion

145.	Primitive operations common to all record management systems include
A.	Print
B.	Sort
C.	Look-up
D.	All of the above
Answer» D. All of the above

Discussion

146.	In SQL, GRANT command is used to
A.	allow user to access databases
B.	allow user to create databases
C.	grant system privileges, roles, and object privileges to uses and roles
D.	choose auditing for specific SQL commands
Answer» D. choose auditing for specific SQL commands

Discussion

147.	If you want to group the records in the abc database, you could use the Jobcode as the _____.
A.	Delete
B.	Update
C.	Sort Key
D.	Index
Answer» D. Index

Discussion

148.	Sort/report generators
A.	are faster than index/report generators
B.	require more disk space than index/report generators
C.	do not need to sort before generating a report
D.	both (a) and (b)
Answer» C. do not need to sort before generating a report

Discussion

149.	Data security threats include
A.	hardware failure
B.	privacy invasion
C.	fraudulent manipulation of data
D.	All of the above
Answer» C. fraudulent manipulation of data

Discussion

150.	Which command is used to remove a table from the database in SQL?
A.	DELETE TABLE
B.	DROP TABLE
C.	ERASE TABLE
D.	UNATTACH TABLE
Answer» C. ERASE TABLE

Discussion

Explore topic-wise MCQs in Computer Science.

There are certain packages that allow people to define data items, place these items in particular records, combine the records into designated files and then manipulate and retrieve the stored data. What are they called?

Embedded pointer provide

Which two files are used during operation of the DBMS?

To have a file hold a list, it is necessary to

An-owner-member set in the CODASYL specifications may have

A computer file can be best described as

In order to use a DBMS, it is important to understand

Data encryption techniques are particularly useful for

Sophisticated report generators can

The PROJECT command will create new table that has

In a relational schema, each tuple is divided into fields called

In SQL, which command(s) is(are) used to enable/disable a database trigger?

Data item characteristics that are important in data management include

In SQL, the CREATE TABLESPACE is used

In SQL, which command(s) is(are) used to create a synonym for a schema object?

A number of related records that are treated as a unit is called

If a calculation is embedded in a form

A multiple-form file management system

The designer of a form includes

A good query system

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

A list consists of last names, first names, addresses, and pin codes if all people in the list have the same last and the same pin code, a useful key would be

Information can be transferred between the DBMS and a

In SQL, which command is used to make permanent changes made by statements issue since the beginning of a transaction?

The main idea behind computer files is that it is convenient to

The logical data structure with a one-to-many relationship is a :

The highest level in the hierarchy of data organization is called

A report form

A database management system might consist of application programs and a software package called

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

What is the name given to the database management system which is able to handle full text data, image data, audio and video?

Which command is used to remove an index from the database in SQL?

Periodically adding, changing and deleting file records is called file

If you want to organize a file in multiple ways, it is better to _____ the data rather than to sort it.

The model for a _____ resembles the hierarchical model in many respects.

Which of the following is true of a network structure?

A _____ DBMS distributes data processing tasks between the workstation and a network server.

A data dictionary is a special file that contains

When using a database management system, the first thing that you must do is to

A database management system

When you have finished entering information into a form

In SQL, which command is used to select data in rows and column from one or more tables?

Each of data files has a _____ that describe the way the data is stored in the file.

The files stored on a secondary stage device are composed of a hierarchy of data. What does a record in a file contain?

Primitive operations common to all record management systems include

In SQL, GRANT command is used to

If you want to group the records in the abc database, you could use the Jobcode as the _____.

Sort/report generators

Data security threats include

Which command is used to remove a table from the database in SQL?