NEW
Font size
WorksheetsQuiz 1 - DBMS
Total questions: 35
Worksheet time: 18mins
Collection of data organized in a manner that allows access, retrieval, and use of that data
Database
Data
Information
Character
Collection of unprocessed items Text, Numbers, Images, Audio and Video.
Database
Data
Information
Character
Processed data Organized, Meaningful and Useful.
Database
Data
Information
Character
Create a computerized database. Add, modify, and delete data. Sort and retrieve data. Create forms and reports from the data.
Database
Data
Information
DBMS
Create a computerized database. Add, modify, and delete data. Sort and retrieve data. Create forms and reports from the data.
Database
Data
Information
DBMS
Which of the following uniquely identifies each record in a database?
Foreign key
Character key
Primary key
Secondary key
What is a data file?
A single piece of data
A collection of related records
A type of database
A computer program
What is the purpose of file maintenance?
To delete files from the system
To create files in the system
To keep data current
To corrupt data intentionally
What does validation do?
Deletes all data
Copies data to a new location
Compares data with a set of rules or values
Creates new data files
Which of the following is a benefit of the database approach?
Increased data redundancy
Reduced data integrity
Improved data integrity
Isolated data
What is the purpose of a form in a database?
To summarize data in a graphical format
To conduct performance benchmarks
To provide areas for entering or modifying data
To export data to another format
What does a data dictionary contain?
Passwords for database access
Data about each file and field in the database
A list of all queries made to the database
The history of database access by users
What is SQL used for?
To create viruses
To play video games
To manage, update, and retrieve data
To encrypt data
What is the goal of project management during system development?
To ensure the project is not completed
To make the system less efficient
To plan, schedule, and control activities
To increase project costs
What is project management in the context of system development?
The process of playing, scheduling, and controlling activities
A technique for marketing analysis
A tool for database administration
A method for software piracy prevention
What is the role of a systems analyst?
To perform data entry tasks
To design and develop an information system
To manage the company's finances
To provide technical support to users
What is the main goal of system development?
To decrease the efficiency of information processing
To build an information system
To sell software products
To conduct market research
What is an information system composed of?
Only hardware and software
Only data and procedures
Hardware, software, data, people, and procedures
Only people and operations
A record is a single character in a database.
True
False
A primary key can sometimes duplicate across records.
True
False
File processing systems encourage data redundancy.
True
False
The database approach isolates data between departments.
True
False
A query allows users to request specific data from the database.
True
False
SQL is used for designing graphical interfaces.
True
False
A form is used for entering or modifying data in a database.
True
False
The design phase includes developing the details of the new system.
True
False
Parallel conversion involves using the old and new systems simultaneously.
True
False
Economic feasibility focuses on the technical aspects of a project.
True
False
A data dictionary only contains information about users of the database.
True
False
A query cannot modify data in the database.
True
False
SQL is only used for creating databases, not managing them.
True
False
Forms in a database are exclusively used for data entry, not data modification.
True
False
Report writers can only display data, not print it.
True
False
An information system includes both hardware and people as components
True
False
The system development life cycle (SDLC) does not include a planning phase.
True
False
