NEW
Font size
WorksheetsMake up CAT DBMS ICT(5)23S
Total questions: 20
Worksheet time: 16mins
DBA stands for
Data Bank Access
Database Access
Data Bank Administration
Database Administrator
Data items grouped together for storage purposes are called a :
Record
title
list
string
What is a database?
A collection of files stored on a computer
A structured collection of data
A software used to create spreadsheets
None of the above
What is a database management system (DBMS)?
Software used to manage databases
A file system for storing data
A hardware used to store data
A programming language used for data analysis
Which of the following is an example of a popular DBMS?
Microsoft Excel
Google Drive
MySQL
Adobe Photoshop
Which of the following is not a type of database management system?
Relational database management system
Hierarchical database management system
Network database management system
None of the above
Which of the following is a primary key in a database table?
A foreign key
A field that uniquely identifies each record in the table
A field that can have duplicate values
None of the above
Which of the following is a primary key in a database table?
A foreign key
A field that uniquely identifies each record in the table
A field that can have duplicate values
None of the above
Which of the following is not a data manipulation operation in a database?
Insert
Update
Delete
Join
A database management system (DBMS) is a collection of programs that enables users to
create a database
manipulate a database
both create and manipulate a database
for storing data only
The database definition or descriptive information is also stored by the DBMS in the form of a _______________
Data catalog
excel file
document file
pdf file
The database and DBMS software together is called a ________________
Database system
Data Model
Application Program
System software
The attribute refers to a _____ of a table
Record
Foreign key
Primary key
Field
The term _____ is used to refer a row
Record
Primary key
Foreign key
Field
Consider attributes ID, CITY and NAME. which one of these can be considered as a primary key?
NAME
ID
CITY
ID, NAME
Which one of these cannot be taken as a primary key?
ID
registration no
Department ID
Street
Which one of the following is NOT an advantage of DBMS
Increased data consistency
Reduced data redundancy
Improved data security
Increase data isolation
Who is responsible for user authentication
Database Administartor
Naive User
Sophisticated user
Data Analyst
Database is a collection of
unrelated data
related data
Not known data
NULL data
