🧪 Data Base Management System (DBMS) MCQ Quiz Hub

1. What is a fast way to adjust the width of a column?
Right click the left side of the column heading
Double click the left side of the column heading
Double click the right side of the column heading
Select tools>adjust column width from the menu

2. In a large DBMS
each user can “see” only a small part of the entire database
each user can access every subschema
each subschema contains every field in the logical schema
none of the above is true

3. The following command is used for inserting records
INSERT
ADD
Both of the above
None of the above

4. If you are entering data in a form, a quick way to copy a value from the previous record is to press
Ctrl+’
F6
Ctrl+D
None of the above

5. Which of the following is NOT a type of Microsoft Access database object?
Queries
Workbooks
Forms
Tables

6. What are the columns in a Microsoft Access table called?
Rows
Fields
cells
Records

7. When you save an Access project, what file format do you use?
adp
xm
mdb
All of above

8. A command that lets you change one or more fields in a record is
Insert
Modify
Look up
All the above

9. Users who store data about real people for marketing purposes must register the data and its potential use with
The computer misuse controller
The data protection controller
HM customs and excise
None of the above

10. The purpose of the Add-in Manager is to
Create macros and automate data processing
Add or remove data in an existing database
Add or remove templates, macros, and wizards
All the above

11. Examples of centralized multi-user databases are
Barclays’ Bank customer accounts
Supermarket stock control, organ donor database, client database
Airline reservations and other national global booking systems
None of the above

12. It examines a small portion or sample of your data in a report before printing it.
Datasheet view
Design view
Print preview
Layout preview

13. Which field allow to select items from drop down list?
An OLE field
An OLE field
A lookup Field
A hyperlink field

14. DBMS allows you to create, interrogate, and maintain a database, create reports, and develop application programs, select the best fit answer
Database management approach
Database administrator
DBBMS uses
Query language

15. A subset of characters within a data field is known as
Record
File
Data string
Byte

16. In a relational schema, each tuple is divided into fields called
Relations
Domains
Queries
All of the above

17. A field that uniquely identifies a record is called a
Main field
Header
Key field
None of the above

18. The arranging of data in a logical sequence is called
Sorting
summarizing
summarizing
summarizing

19. Records are deleted using
DELETE command followed by pack
DELETE command without pack
DELETE command followed by zap
DELETE command without zap

20. Auto Report allows you to
View a subset of your data
Create a simple report
Create a data entry form
Enter records

21. What do you mean by one to many relationship between Teacher and Class table?
One class may have many teachers
One teacher can have many classes
Many classes may have many teachers
Many teachers may have many classes

22. What are the different view to present a Table ?
Datasheet View
Design View
Pivote TableView
All Of Above

23. In one-to-many relationship the table on 'many' side is called _______
Parent
Child
Sister
Master

24. In which state one gathers and list all the necessary fields for the database design project.
Data Definition
Data Refinement
Establishing Relationship
None Of The Above

25. Which of the following enables us to view data from a table based on a specific criterion
Form
Query
Macro
Report

26. Which database object is ideal to view, change, andanalyze datain different ways ?
Table
Form
Query
Report

27. In one-to-many relationship the table in 'one' side is called _______
Child
Owner
Parent
Owner

28. Which data type allows alphanumeric characters and special symbols to be entered?
Text
Memo
Auto number
Mixed

29. It is used to establish an association between related tables.
Line
Relationship
Primary Key
Records

30. This key that uniquely identifies each record is called :
Primary Key
Key Record
Unique Key
Field Name

31. Which name must be unique within a database ? A.. C..
Table
Field
Record
Character

32. The third stage of designing a database is when we create___________ between tables
Relationship
Join
Query
None of These

33. Two tables can be linked with relationship to _____
.Ensure data entry
.Ensure data integrity
.Create Primary Key
.Ensure Foreign Key

34. In a database Table, the each category of information Is called __________
Tuple
Field
Record
all of these

35. Which of the following fields has width of 8 bytes?
Memo
Number
.Date/time
Hyperlink

36. which of the following is not a database object?
Tables
Queries
Relationships
Reports

37. Which one is the guideline of Referential integrity in a relationship ?
Do not enter a value in the primary key field of chield table if that value does not exist inthe primary key of the parent table
Do not enter a value in the foreign key field of a parent table if that value doesnot exist in the primary key of the child table
Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table
Do not enter a value in the foreign key field of child table if that value does not exist inthe foreign key of the parent table

38. Which of the following is not a database model
Network Database Model
Relational Database Model
Object Oriented Database Model
None

39. The overall description of a database is called______.
Data integrity
Data manipulation
Database schema
Data definition

40. A data dictionary is a repository that manages _____
Memory
Metadata
Spell Checker
Data Validator

41. A database is an organized collection of _______________.
data
Attributes
Record
none of the above

42. Which of the following software is appropriate to store data about school students?
MS-Access
Writer
Calc
Impress

43. Which of the following is not a database programs?
MySQL
Oracle
Writer
OObase

44. ________ store data in Single table.
Flat File
Relational
Single File
One File

45. ________ are dedicated computers that hold the actual databases and run only DBMS and related Software.
Main Server
Web Server
Database Server
Non Database Server

46. GUI act as front end and database server act as _____
Container
Back End
End
none of the above

47. Duplication of data is called _________
Inconsistency
Consistency
Redundancy
Foreign Key

48. Which of the following is not the advantage of database?
Sharing of Data
Reduce Data Redundancy
. Increase Data Inconsistency
Data Security

49. Which of the following will help to maintain unique record in the table?
Foreign Key
Primary Key
Composite Key
Alternate Key

50. Which of the following field of table “Book” can act as primary key?
Book_number
Subject
price
Author_name