NEW
Font size
WorksheetsDatabase
Total questions: 20
Worksheet time: 10mins
It refers to database applications that look for patterns in already created databases.
Data Mining
Data Warehouse
Data Mart
Database
It is refers to a collection of data designed to support decision making.
Data Mining
Data Warehouse
Data Mart
Database
A subset or smaller focus databases designed to help managers make strategic decisions is a data mart.
Data Mining
Data Warehouse
Data Mart
Database
This refers to selecting the fields for displaying in the search results
Exact Match
Pattern
Range
Selecting Fields
Search finds only entries that are an exact match for a specified word.
Exact Match
Pattern
Range
Selecting Fields
It permits the use of wildcards in place of character
Pattern
Exact Match
Range
Selecting Fields
It provides records that include both terms on either side of the AND.
AND
OR
NOT
NEAR
It provides records that have either term.
NOT
AND
OR
ADJACENT
IT provides records that exclude the term following NOT.
OR
AND
NEAR and ADJACENT
NOT
Is a collection of files and is like a file cabinet and it holds related drawers of records.
Data
Data Types
Database
Database Management System
Raw facts consisting of numbers, letters, characters and dates are data. They are contents of fields.
Data
Data Types
Field
Record
It refers to the description of what data to expect in a field.
Data
Data Types
Field
Record
Is a space within a file with a predefined location and length (Attribute).
Field
Record
File
Database
A collection of fields related or associated with a focal point.
Field
Record
File
Database
Are collections of related records.
File
Database
Database Management System
Record
It is a relationship means that each record in Table A relates to one, and only one, record in Table B, and each record in Table B relates to one, and only one, record in Table A.
One to One
One to Many
Many to Many
It is a relationship means a record in Table A can relate to zero, one, or many records in Table B.
One to One
One to Many
Many to Many
This is a complex relationship in which many records in a table can link to many records in another table.
One to One
One to Many
Many to Many
Is a logical association between tables based on the values in corresponding fields.
Link
Key Field
Table
Database
Is the structure that is used to store the data.
Table
Link
Key Field
File
