150+ Basics of Database Management System (DBMS) Solved MCQs

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 Information Technology SY (BSc IT) , Bachelor of Computer Applications (BCA) , Common Topics in Competitive and Entrance exams .

Take a Test

51.	Modules are
A.	selection of commands used to automate repetitive tasks
B.	programs written in Visual C++
C.	Object tabs
D.	Group of records
Answer» A. selection of commands used to automate repetitive tasks

52.	APPEND command is used to
A.	Add record to the end of active database file and starts full screen data entry
B.	Add Record to the start of active database file
C.	Add record to the start of active database file and starts full screen data entry
D.	Add record to the end of database file
Answer» A. Add record to the end of active database file and starts full screen data entry

53.	Append from command is used to
A.	Add records from information in an array
B.	Adds records from a file
C.	Add records from a variable
D.	Add records from stock
Answer» A. Add records from information in an array

54.	Examples of centralized multi-user databases are
A.	Barclays’ Bank customer accounts
B.	Supermarket stock control, organ donor database, client database
C.	Airline reservations and other national global booking systems
D.	None of above
Answer» C. Airline reservations and other national global booking systems

55.	New record is added using
A.	Append record from browse menu
B.	Append record into from browse menu
C.	Add record from edit menu
D.	All of above
Answer» A. Append record from browse menu

56.	When a customer makes an online hotel booking, the database is updated in
A.	Batch mode
B.	Pseudo real-time
C.	One month
D.	All of above
Answer» B. Pseudo real-time

57.	A database that contains tables linked by common fields is called a
A.	Centralized database
B.	Flat file database
C.	Relational database
D.	None of above
Answer» C. Relational database

58.	The use of integrated collections of database records and files for data storage and processing. The best fit for answer:
A.	Database management approach
B.	DBMS uses
C.	Database administrator
D.	Query language
Answer» D. Query language

59.	DBMS allows you to create, interrogate, and maintain a database, create reports, and develop application programs, select the best fit answer
A.	Database management approach
B.	DBBMS uses
C.	Database administrator
D.	Query language
Answer» D. Query language

60.	A specialist in charge of the database of an organization select the best fit for answer
A.	Database management approach
B.	DBMS uses
C.	Database administrator
D.	Query language
Answer» B. DBMS uses

61.	This DBMS feature allows users to easily interrogate a database. Select the best fit for answer
A.	Database management approach
B.	DBMS uses
C.	Database administrator
D.	Query language
Answer» C. Database administrator

62.	The ….. presents data in a way similar to an excel spreadsheet
A.	Datasheet view
B.	Design view
C.	Print preview
D.	Layout preview
Answer» C. Print preview

63.	It Is used to build and modify database objects and also to create new queries
A.	Datasheet view
B.	Design view
C.	Print preview
D.	Layout preview
Answer» C. Print preview

64.	It shows the appearance and layout of a report, table or form in order to confirm what will be printed.
A.	Datasheet view
B.	Design view
C.	Print preview
D.	Layout preview
Answer» B. Design view

65.	It examines a small portion or sample of your data in a report before printing it.
A.	Datasheet view
B.	Design view
C.	Print preview
D.	Layout preview
Answer» D. Layout preview

66.	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 above
Answer» B. Is used during report generation to format data

67.	Which of the following columns can not be found in the macro design window?
A.	Arguments column
B.	Comment column
C.	Conditions column
D.	Actions column
Answer» B. Comment column

68.	The ascending order of a data hierarchy ios:
A.	Bit, byte, field, record, file, database
B.	Bit, byte, record, field, file, database
C.	Byte, bit, field, record, file, database
D.	Byte, bit, record, field, file, database
Answer» A. Bit, byte, field, record, file, database

69.	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 prssing professionals
D.	Both (A) and (B)
Answer» B. Allows non-programmers to access information stored in a database

70.	How do you freeze a field a column or field in Microsoft Access?
A.	Click anywhere in the column and select Edit>Freeze Column form the menu
B.	Place an ice cube in the column
C.	Click anywhere in the column and click the freeze button on the toolbar
D.	Right click the column and select freeze columns from the shortcut menu
Answer» D. Right click the column and select freeze columns from the shortcut menu

71.	Within Table Datasheet view, how can you display associated records from another table?
A.	Click the expand indicator (+) next to a record
B.	Double click the record.
C.	Apply the filter by form command
D.	None of the above
Answer» A. Click the expand indicator (+) next to a record

72.	Which of the following is not a command to find specific word or phrases in a database?
A.	Click the find button on the toolbar
B.	Click the find button on the record navigation button area
C.	Press Ctrl+F
D.	Select Edit>Find from the menu.
Answer» B. Click the find button on the record navigation button area

73.	One of the type libraries that you can use to programmatically connect to Microsoft Access data is
A.	Collaborative Data Objects
B.	ActiveX Data Objects
C.	Dynamic Data Interfaces
D.	None of the above
Answer» B. ActiveX Data Objects

74.	The data in a Pivot Table report is categorized using
A.	Column headings
B.	Items from the Pivot Table field list
C.	Header rows
D.	All of above
Answer» B. Items from the Pivot Table field list

75.	Records are deleted using
A.	DELETE command followed by pack
B.	DELETE command without pack
C.	DELETE command followed by zap
D.	DELETE command without zap
Answer» A. DELETE command followed by pack

150+ Basics of Database Management System (DBMS) Solved MCQs

Modules are

APPEND command is used to

Append from command is used to

Examples of centralized multi-user databases are

New record is added using

When a customer makes an online hotel booking, the database is updated in

A database that contains tables linked by common fields is called a

The use of integrated collections of database records and files for data storage and processing. The best fit for answer:

DBMS allows you to create, interrogate, and maintain a database, create reports, and develop application programs, select the best fit answer

A specialist in charge of the database of an organization select the best fit for answer

This DBMS feature allows users to easily interrogate a database. Select the best fit for answer

The ….. presents data in a way similar to an excel spreadsheet

It Is used to build and modify database objects and also to create new queries

It shows the appearance and layout of a report, table or form in order to confirm what will be printed.

It examines a small portion or sample of your data in a report before printing it.

A report form

Which of the following columns can not be found in the macro design window?

The ascending order of a data hierarchy ios:

A good query system

How do you freeze a field a column or field in Microsoft Access?

Within Table Datasheet view, how can you display associated records from another table?

Which of the following is not a command to find specific word or phrases in a database?

One of the type libraries that you can use to programmatically connect to Microsoft Access data is

The data in a Pivot Table report is categorized using

Records are deleted using

You can enter data in a table in

Creating a data file means

In a large DBMS

Each individual data items of record is called a

A large collections of files are called

Memo field in database file is used to

Applications that rely on databases are

Which of the following is not a Access database object ?

Data owners must protect their data against corruption or loss. One sensible method to achieving this is to

Facilities offered by databases are

Users who store data about real people for marketing purposes must register the data and its potential use with

When you double click a query object, you open

Checks that are added to databases to detect unsuitable data on inpt are called

Auto Report allows you to

Auto Form allows you to

The asterisk (*) is sometimes used in database queries. This character is then called a

When performing a look-up operation using a form

Which custom date format displays the numeric day of the year when a date is entered?

When you save an Access project, what file format do you use?

Which of the following criterion would find records whose personality field does not equal “Nice”?

What is the maximum character field size you can set for a field that has a text data type?

Which of the following fields would not make a suitable primary key ?

Auto reports can contain each of the following elements except

What is the abbreviation used for a software package that permits the user to create, retrieve and maintain records in a database?

77.	Creating a data file means
A.	Designing base and defining the structure of the database
B.	Getting the information about database
C.	Selecting data from database
D.	Deleting data from database
Answer» A. Designing base and defining the structure of the database

78.	In a large DBMS
A.	each user can “see” only a small part of the entire database
B.	each user can access every subschema
C.	each subschema contains every field in the logical schema
D.	none of the above is true
Answer» A. each user can “see” only a small part of the entire database

79.	You want to keep track of addresses, phone numbers, parent/guardian names as well as class attendance, average and grades. Every so often you want to send reports home that select failing grades and excessive absences. The following of the Microsoft Office suit used in this course is best suited for this kind of information
A.	Excel
B.	PowerPoint
C.	Access
D.	Word
Answer» C. Access

80.	Each individual data items of record is called a
A.	Field
B.	Data type
C.	Comment
D.	All of the above
Answer» B. Data type

81.	A large collections of files are called
A.	Fields
B.	Records
C.	Databases
D.	File system
Answer» B. Records

82.	Memo field in database file is used to
A.	Store lengthy number
B.	Store images
C.	Store audio files
D.	Store long textual information
Answer» D. Store long textual information

83.	Applications that rely on databases are
A.	Supermarket stock control, theater bookings and payroll
B.	Accounts, online banking, PowerPoint presentations
C.	Internet shopping, robotics, computer games
D.	None of above
Answer» A. Supermarket stock control, theater bookings and payroll

84.	Which of the following is not a Access database object ?
A.	table
B.	form
C.	query
D.	datasheet
Answer» D. datasheet

85.	Data owners must protect their data against corruption or loss. One sensible method to achieving this is to
A.	Take regular backups
B.	Keep a hardcopy printout of all data
C.	Keep fingers crossed at all times
D.	None of above
Answer» A. Take regular backups

86.	Facilities offered by databases are
A.	The ability to store a large amount of data in a structured format, easy update, sort, query, production of reports
B.	Easy editing, spell check, perform calculations, library of mathematical functions, replication
C.	The ability to rotate images, copy and paste, fill scale
D.	None of above
Answer» A. The ability to store a large amount of data in a structured format, easy update, sort, query, production of reports