Font size
WorksheetsDATABASE QUIZ
Total questions: 35
Worksheet time: 6mins
It is a collection of information organized to provide efficient retrieval.
Database
DBMS
data
_________ IN THE DATABASE ARE LIKE THE FOLDERS IN THE DRAWER
-THEY DEAL WITH DIFFERENT ASPECT OF THE DATABASE.
table
record
database
RECORD IS COMPOSED OF ________.
field
table
data
ELECTRONIC DATABASE WERE FIRST USED IN THE ______.
1950
1960
1970
He is the one who PUBLISHED AN ACADEMIC PAPER ON RELATIONAL DATABASES.
DR. EDGAR F. CODD
DR. EDGAR F. COD
DR. GARRY F. CODD
_________ IS A WAY OF GIVING THE COMPUTER INSTRUCTIONS ON HOW TO HANDLE LARGE VOLUMES OF DATA.
TABLE
DATA
SQL
the earliest widely used database product for the microcomputer was __________.
bdata
dBase
Bdata
It is a database management system (DBMS) from Microsoft that combines the relational Access Database Engine (ACE)
MS Excel
MS Access
MS Publisher
It is a computerized system for storing data and presenting information.
Database
Database System
DBMS
contain data stored in the database.
forms
tables
fields
Allow the user to create a program for manipulating the data.
modules
macros
pages
allow for short but often used command sequences.
modules
macros
pages
It is composed of group of interrelated data, as well as a collection of programs that are used to retrieve and manipulate the said data.
DBMS
DMS
Database
It is a separate component called JET (Joint Engine TEchnology.)
Database power
database engine
engine
JET Stands for?
Join Engine Technology
Joint Engine Technology
Joint Exchange Technology
This is the part of the DBMS that the users see.
Application Interface
Database Engine
"tuples" means?
row
columns
cell
Identifies a record uniquely
Foreign Key
composite Key
Primary Key
It is a piece of information in a table.
Field
Records
Data
It represents the connection of one entity to another.
Identity
Relationship
Connection
It means that one record in the first table can be related to many records in the second table, but records in the second table can be related to only one record in the first table.
(a)
IT IS A SET OF ATTRIBUTES BEING THE ONE NORMALLY SEEN.
(a)
REQUIRES A DIGIT FROM 0-9
(a)
REQUIRES A LETTER TO BE ENTERED.
(a)
ACCEPTS ANY LETTER OR DIGITS.
(a)
checks the validity of an input value for the field.
(a)
can take values of Yes or No only.
(a)
indicates the maximum number of characters that can be entered in the Text field.
(a)
appears when the cursor is in the corresponding attribute. it means MS Access can help specify the value for this field.
(a)
determines the number of digits to the right of the decimal point.
(a)
mean the same thing, and so are used interchangeably.
(a)
It is relationships that one record in the first table can be related to only one record in the second table; a country, for instance can have only one capital.
(a)
It is a primary key in another table
(a)
Present information possibly summarized from the data.
(a)
THE DOCUMENTS IN A FOLDER ARE LIKE THE RECORDS IN A DATABASE.
(a)
