NEW
Font size
S
M
L
XL
WorksheetsPlacement Examination
Total questions: 75
Worksheet time: 3hrs 30mins
Name
Class
Date
1.
Which of these is the largest planet in the Solar System?
a)
Earth
b)
Mars
c)
Mercury
d)
Jupiter
e)
Pluto
2.
It is a system integrated collection of related files, along with the details of the interpretation of the data.
a)
Management System
b)
Database System
c)
Software System
d)
Information System
3.
It is a software system or program that allows access to data contained in a database.
a)
Data Base Management System
b)
Information System
c)
Data Analysis
d)
Record Management System
4.
What is the plural word of Data?
a)
Datus
b)
Data
c)
Datum
d)
Datas
5.
It is a processed, organized data presented in a given context and is useful to humans.
a)
Data
b)
Informaion
c)
Process Data<br />
d)
Unprocessed Data
6.
It means that the information is free from errors, and it clearly and accurately reflects the meaning of data on which it is based.
a)
Accuracy
b)
Timeless
c)
Relevancy
d)
Facts
7.
It means the usefulness of the piece of information for the corresponding persons.
a)
Accuracy
b)
Timeless
c)
Relevancy
d)
Facts
8.
It means that the recipients receive the information when they need it and within the required time frame.
a)
Accuracy
b)
Timeless
c)
Relevancy
d)
Facts
9.
It is the data describe objects in the database and makes easier for those objects to be accessed or manipulated. It is a data about the data.
a)
Metta
b)
Metta Data
c)
Mita Data
d)
Meta Data
10.
What are the three main types of meta data?
a)
Descriptive, Structural, Administrative
b)
Descriptive, Structure, Administrative
c)
Descriptive, Structural, Administration
d)
Descriptive, Structural, Administration
11.
It describes a resource for purpose such as discovery and identification.
a)
Descriptive meta data
b)
Structure meta data
c)
Structural meta data
d)
Administrative meta data
12.
It describes how compound objects are put together. The example is how pages are ordered to form chapters.
a)
Descriptive meta data
b)
Structure meta data
c)
Structural meta data
d)
Administrative meta data
13.
It provides information to help manage a resource, such as when and how it was created, file type and other technical information, and who can access it.
a)
Administration meta data
b)
Structure meta data
c)
Structural meta data
d)
Administrative meta data
14.
It’s contains information of the data stored in the database and is consulted by the DBMS before any manipulation operation on the database.
a)
Active Data Dictionary
b)
Meta Data Dictionary
c)
Passive Data Dictionary
d)
Data Dictionary
15.
1. It is used only for documentation purposes and the data about fields, files and people are maintained into the dictionary for cross references.
a)
Active Data Dictionary
b)
Meta Data Dictionary
c)
Passive Data Dictionary
d)
Data Dictionary
16.
It is managed automatically by the database management system (DBMS) and are always consistent with the current structure and definition of the database.
a)
Active Data Dictionary
b)
Meta Data Dictionary
c)
Passive Data Dictionary
d)
Data Dictionary
17.
It is a collection of interrelated data stored together with controlled redundancy to serve one or more applications in an optimal way.
a)
Database System
b)
Database
c)
System Integration
d)
System Architecture
18.
It is the smallest unit of the data that has meaning to its users and is also called data item or data element.
a)
Fields
b)
Files
c)
Records
d)
Data
19.
A file is a collection of related records.
a)
Fields
b)
Files
c)
Records
d)
Data
20.
A record is a collection of logically related fields and each field is possessing a fixed number of bytes and is of fixed data type.
a)
Fields
b)
Files
c)
Records
d)
Data
21.
What are the four components of database?
a)
Data item, Relation, Constrains, Schema
b)
Database item, Relationships, Constrains, Schema
c)
Data item, Relationships, Constrains, Schema
d)
Data item, Relation, Constrains, Schema
22.
It represents a correspondence between various data elements.
a)
Relationships
b)
Relation
c)
Schema
d)
Database
23.
It describes the organization of data and relationships within the database.
a)
Shema
b)
Data item
c)
Relationships
d)
Relation
24.
These are the predicates that define correct database states.
a)
Shema
b)
Data item
c)
Constraints
d)
Relation
25.
It is defined as a distinct piece of information and is explained in the previous section.
a)
Shema
b)
Data item
c)
Relationships
d)
Relation
26.
It performs the function of entering the data into the database through an input device (like data screen, or voice activated system) with the help of the user.
a)
Output Data
b)
Input Data
c)
Data
d)
Process Data
27.
It performs the function of manipulation and processing of the data stored in the database using the DML.
a)
Output Data
b)
Process Data
c)
Input Data
d)
Data
28.
The DBMS establishes the logical relationships among different data elements in a database and defines schemas and subschemas using the DDL.
a)
Output Data
b)
Define and organize a database
c)
Process Data
d)
Define, create and organize a database
29.
It allows limited access of the database to authorized users to maintain data integrity and security.
a)
Output Data
b)
Maintain data integrity and security
c)
Define and organize a database
d)
Maintain data integrity
30.
It provides information to the decision makers that they need to make important decisions.
a)
Output Data
b)
Input Data
c)
Process Data
d)
Query database
31.
This software provides the facility of controlled access of the database by the users, concurrency control to allow shared access of the database and a recovery control system to restore the database in case of hardware or software failure.
a)
Software for Controlled Access of Database
b)
Data Manipulation Language (DML)
c)
Data System Language (DSL)
d)
Data System Language (DSL)
32.
It allows users to insert, update, delete and retrieve data from the database.
a)
Software for Controlled Access of Database
b)
Data Manipulation Language (DML)
c)
Data Definition Language (DDL),
d)
Data System Language (DSL)
33.
It allows the users to define the database, specify the data types, data structures and the constraints on the data to be stored in the database.
a)
Data Definition Language (DDL)
b)
Data Manipulation Language (DML)
c)
Software for Controlled Access of Database
d)
Data System Language (DSL)
34.
This is the first database model to serve data processing for business application at the time when the might of computers is yet at the bottom of the pit.
a)
Flat file database model
b)
Network database model
c)
Relational database model
d)
Hierarchical model
35.
This model had been introduced by IBM (International Business Machine) late 50’s and early 60’s which followed the flat file model ways of thinking.
a)
Network database model
b)
Relational database model
c)
Hierarchical model
d)
Flat file database model
36.
This model was introduced in late 60’s and early 70’s by IBM, many have thought that the difficulty of the Hierarchical model is over.
a)
Network database model
b)
Relational database model
c)
Hierarchical model
d)
Flat file database model
37.
This type of DBMS defines the database relationships in forms of tables also known as relations. Unlike the network model, Relational database does not support many to many relationships.
a)
Network database model
b)
Relational database model
c)
Hierarchical model
d)
Flat file database model
38.
This model support storage of new data types. Under this model the data to be stored is always in the form of objects.
a)
Object-oriented database model
b)
Relational database model
c)
Hierarchical model
d)
Flat file database model
39.
It is a status of a relation resulting from the simple application of rules regarding relationships between fields.
a)
Normal form
b)
First normal form
c)
Second normal form
d)
Third normal form
40.
It aims to remove and separate repeating fields or group of fields for the purpose of maintaining a single-valued report.
a)
First Normal Form (1NF)
b)
Second Normal Form (2NF)
c)
Third Normal Form (3NF)
d)
None of the above
41.
It aims to remove and separate partial dependencies. At this stage the primary key began to emerge but it rules together with some none-key fields.
a)
First Normal Form (1NF)
b)
Second Normal Form (2NF)
c)
Third Normal Form (3NF)
d)
None of the above
42.
It aims to separate and remove transitive dependencies. At this stage the primary key rules to the exclusions of others.
a)
First Normal Form (1NF)
b)
Second Normal Form (2NF)
c)
Third Normal Form (3NF)
d)
None of the above
43.
It is assigned to uniquely identify each of the record in the table.
a)
Primary key
b)
Setting up a primary key
c)
Candidate primary key
d)
Primary key for each table
44.
It is a mentioned of the field official receipts number which would have been used as primary key.
a)
Primary key
b)
Setting up a primary key
c)
Candidate primary key
d)
Primary key for each table
45.
It describes raw facts about any person, event, place, or thing.
a)
Data
b)
Information
c)
System
d)
Metadata
46.
A collection of figures and facts, and is raw, unprocessed, and unorganized.
a)
Data
b)
Information
c)
System
d)
Metadata
47.
It is processed, organized, or summarized data.
a)
Data
b)
Information
c)
System
d)
Metadata
48.
It is the data about the data.
a)
Data
b)
Information
c)
System
d)
Metadata
49.
It is a process of decomposing and regrouping of common data into separate tables.
a)
Normalization
b)
Regrouping tables
c)
Retrieving data
d)
None of the above
50.
__________is a database software application that can use to make new databases, or add, delete, modify, or search for data in the already existing bases.
a)
MS ACCESS
b)
SQL
c)
MySQL
d)
All of the above
51.
It is a grouping of related data organized in fields (columns) and records (rows) on a datasheet
a)
Table
b)
Field
c)
Record
d)
Primary Key
52.
It is a column on a datasheet and defines a data type for a set of values in a table.
a)
Table
b)
Field
c)
Record
d)
Primary Key
53.
It is a row on a datasheet and is a set of values defined by fields.
a)
Table
b)
Field
c)
Record
d)
Primary Key
54.
It is one fields or a combination of fields that holds only unique values and can identify a particular record.
a)
Table
b)
Field
c)
Record
d)
Primary Key
55.
It provides the tools for creating fields in a table.
a)
Design View
b)
Datasheet View
c)
Field Name
d)
Data Type
56.
It allows you to update, edit, and delete information(records) from a table.
a)
Design View
b)
Datasheet View
c)
Field Name
d)
Data Type
57.
This is the name of the field and should represent the contents of the field.
a)
Design View
b)
Datasheet View
c)
Field Name
d)
Data Type
58.
Type of data that allows any combination of letters and numbers up to a maximum of 255 characters per field record.
a)
Text
b)
Memo
c)
Number
d)
Data/Time
59.
Relationship Mapping: Company-to-employee
a)
1:N
b)
N:N
c)
1:1
d)
1:M
60.
Relationship Mapping: Employee-manages-department
a)
1:1
b)
1:N
c)
M:M
d)
1:M
61.
A text type that stores up to 64,000 characters.
a)
text
b)
memo
c)
Number
d)
Time/Date
62.
Type of data that any number can be stored.
a)
Number
b)
Memo
c)
Text
d)
Date/Time
63.
A date, time, or combination of both.
a)
Number
b)
Date/Time
c)
Memo
d)
Text
64.
Type of data that it stores monetary values that can be set up to automatically include a dollar sign ($) and correct decimal and comma positions.
a)
Currency
b)
AutoNumber
c)
YES/NO
d)
OLE Object
65.
Use this option for True/False, Yes/No, On/Off, or other values that must be only one of two.
a)
Currency
b)
AutoNumber
c)
YES/NO
d)
OLE Object
66.
Use this data type to embed an OLE object or link to the object in the database.
a)
Currency
b)
OLE Object
c)
YES/NO
d)
AutoNumber
67.
A hyperlink will link to an Internet or Intranet site, or another location in the database.
a)
Hyperlink
b)
Description
c)
Field Properties
d)
Field Size
68.
Select any pertinent properties for the field from the bottom pane.
a)
Field Properties
b)
Hyperlink
c)
Description
d)
Field Size
69.
It is used to set the number of characters needed in a text or number field.
a)
Field Properties
b)
Description
c)
Hyperlink
d)
Field Size
70.
Field size that has a positive integer between 1 and 255.
a)
Byte
b)
Integer
c)
Long Integer
d)
Single
71.
Field size that has a positive and negative integer between -32,768 and 32,768
a)
Byte
b)
Integer
c)
Long Integer
d)
Single
72.
Field size that has larger positive and negative integers between -2 billion and 2 billion.
a)
Byte
b)
Interger
c)
Long Integer
d)
Single
73.
Single-precision floating-point number.
a)
Byte
b)
Integer
c)
Long Integer
d)
Single
74.
Double-precision floating-point number.
a)
Double
b)
Integer
c)
Long Integer
d)
Single
75.
Allows for Precision and Scale property control.
a)
Double
b)
Integer
c)
Single
d)
Decimal
Reset
