WorksheetsInformation Management 1 (LAB)
Total questions: 25
Worksheet time: 13mins
Which term best describes a collection of information organized and presented to serve a specific purpose?
Spreadsheet
Algorithm
Database
Directory
Which term refers to the designated space within a database for the name of a record?
Key Field
Index Field
Title Field
Field Name
Which term refers to the various formats in which data can be stored and manipulated within a database?
Data Categories
Data Structures
Data Types
Data Format
Which term describes a collection of computer programs enabling storage, modification, and extraction of information from a database?
Database
Data Warehouse
Data Mining
DBMS (Database Management System)
Which term encompasses the process of defining the problem, researching the topic, examining related systems, and studying their solutions?
Analysis
Design
Development
Testing
Which phase of the software development process involves delivering and installing the program to address the identified problem?
Design
Testing
Implementation
Analysis
Which term refers to the aspect of a database model that defines a collection of objects with shared attributes and describes the properties of those attributes?
Data Modeling
Entity-Relationship Diagram
Attribute Definintion
Structural Aspect
Which term best describes a grouping of individuals, locations, or items that share common attributes within a database?
Relations
Instances
Entities
Elements
Which term best describes the characteristics or properties of an entity within a database?
Instances
Relations
Entities
Attributes
Which term describes a property ensuring that an attribute in a database references only existing attributes?
Data Integrity
Attribute Validation
Referential Integrity
Entity Consistency
Which database structure physically stores all data and metadata within a single entity?
Hierarchical Database
Network Database
Relational Database
Object-oriented Database
Which term describes an attribute that serves as a unique identifier for a record in a database?
Foreign Key
Secondary Key
Index Key
Primary Key
Which term refers to the number of associated entities or participants in a relationship within a database model?
Cardinality
Modularity
Degree
Normativity
Which term describes the association or connection between entities in a database relationship?
Cardinality
Degree
Connectivity
Integrity
Which term denotes the specific number of occurrences of one entity associated with one occurrence of a related entity in a database relationship?
Connectivity
Degree
Cardinality
Modularity
Which term describes custom screens designed to facilitate data entry and viewing in a table or query within a database?
Query
Report
Form
Macro
Which database component stores data in rows (records) and columns (fields)?
Queries
Forms
Tables
Reports
Which database feature assists in automating routine tasks by condensing them into a single command?
Tables
Queries
Macros
Forms
Which data type in databases permits a combination of letters and numbers with a maximum length of 255 characters per field record?
Text
Memo
Number
Hyperlink
Which data type in Microsoft Access automatically assigns a unique integer to each record in a field?
Yes/No
AutoNumber
Text
Memo
Which properties in properties pane is used to determine the maximum number of characters allowed in a text or number field?
Field Properties
Field Size
Format
Description
Which term in a database represents information about one person, place, or thing?
Database
Table
Field
Record
What symbol in Text and Memo Data Types does need to forces all characters to uppercase?
@
>
<
&
What symbol in Text and Memo Data Types does need to forces all characters to lowercase?
@
>
&
<
Which term in database management specifies how data is displayed in a table and printed?
Index
Query
Format
Filter
