WorksheetsDatabase Quiz 1
Total questions: 37
Worksheet time: 1hrs 14mins
Name
Class
Date
1.
DBMS access program is written separately with specific files such as data abstraction, this is a database characteristic, namely:
a)
Self-describing
b)
Isolation
c)
Multi-view
d)
Sharing data
e)
Multi-user transaction
2.
Allowing different users to get different database perspectives, this is a database characteristic, namely:
a)
Self-describing
b)
Isolation
c)
Multi-view
d)
Sharing data
e)
Multi-user transaction
3.
The following are people who have a direct role in the database, except:
a)
Database Administrators
b)
Database Designers
c)
End Users
d)
System Analysts
e)
DBMS Designers
4.
People who have task of defining user needs and developing specifications for transactions that meet user needs, are
a)
Database Administrators
b)
Database Designers
c)
End Users
d)
System Analysts
e)
DBMS Designers
5.
The following are not benefits of using a database:
a)
Speed
b)
Redudancy
c)
Acuracy
d)
Space
e)
Completeness
6.
Database users can be more than 1 user at the same time, it is a benefit of using a database, which is:
a)
Sharability
b)
Availability
c)
Security
d)
Accuracy
e)
Completeness
7.
Physical data is
a)
data that includes attribute names, data types (for example varchar, integer etc.)
b)
the concept of how detailed data description is stored in a computer
c)
size of the data
d)
database structure and data type used
e)
an attribute that signifies the key of an entity that is unique
8.
Relationship describe connection between
a)
two or more attributes
b)
two or several relationships
c)
two or more entities
d)
attribute with relationship
e)
attribute with entities
9.
Entity-Relationship Diagram (ERD) is
a)
diagram that illustrates the relationship between entities
b)
diagram that illustrates the relationship between attributes
c)
diagram that illustrates the relation between relationship
d)
diagram that illustrates the relation between multivalue attribute
e)
diagram that illustrates the relation between derivatife attribute
10.
Table is a collection of data arranged in
a)
row (record) and attributes format
b)
table and column (field or attribute)
c)
column (field or attribute) and relation
d)
column (field or attribute)
e)
row (record) and column (field or attribute) format
11.
Key attribute is
a)
attribute that can uniquely differentiate all data rows in a table
b)
attribute that has multiple values
c)
a technique that breaks data using certain methods to prevent the problem of processing data in a database
d)
one or a combination of several attributes
e)
attribute that consist of several attributes
12.
A fact about something in the real world (can be numbers, rows of characters, symbols and images) that can be recorded and stored on computer media is the definition of
a)
Information
b)
Data
c)
Database
d)
Database system
e)
Entity
13.
Data definition language (DDL) is a form of language in DBMS that is commonly used by:
a)
Programmer
b)
Analyst
c)
End user
d)
Network Engineer
e)
DBA
14.
The symbol that used to indicate the entity in the ER model is
a)
Ellipse
b)
Diamond
c)
Rectangle
d)
Double Ellipse
e)
Line
15.
The ellipse symbol on ER-model is used to illustrate
a)
Relationship
b)
Basic object
c)
Entity
d)
Attribute
e)
Enterprise
16.
The line symbol on ER model shows is used to illustrate
a)
Relationship
b)
Basic object
c)
Entity
d)
Attribute
e)
Enterprise
17.
Determining the number of entities that correspond to other entities is called
a)
Multivalue Atribut
b)
Relationship
c)
Mapping Cardinality
d)
Participant Constraint
e)
Entity Realtionship
18.
An example that showing the Participant Constraint is
a)
One Course has a Person in Charge
b)
One supplier can supply many items
c)
One item can be purchased in several transactions
d)
Not all employees lead a department
e)
Each department must be led by a manager
19.
Relation that occur between one or more entities are referred to
a)
Attribute
b)
Relationship
c)
Cardinality
d)
Entity
e)
Ternary Relationship
20.
Entity sets that are dependent on strong entity sets are described by
a)
Ellipse
b)
Rectangle
c)
Double Ellipse
d)
Double Rectangle
e)
Diamond
21.
A model in which data and relationships are represented by a number of tables, each consisting of several columns and rows, is:
a)
Binary Model
b)
Network Model
c)
Hierarchy Model
d)
Semantic Model
e)
Reltional Model
22.
A set of concepts to explain data, relationships and boundaries between data, is called
a)
View
b)
Entity
c)
Data Model
d)
Database
e)
Database System
23.
The example of entity is
a)
Patient
b)
Name
c)
Borrow
d)
NIM
e)
1:M
24.
The dashed elliptical symbol in the ER Diagram illustrates
a)
Attribute
b)
Attribute key
c)
Composite Attribute
d)
Derivatife Attribute
e)
Multivalue Attribute
25.
The example of multivalue attribute is
a)
ID Number
b)
Address
c)
Gender
d)
Education Degree
e)
Age
26.
Every data in Entity A can relate to a lot of data in Entity B, but the data in Entity B is maximally related only to a data in Entity A, which is a type of cardinality:
a)
One to one
b)
One to many
c)
Many to one
d)
Many to Many
e)
One or More
27.
The following are not included in the basic components of an ER-Diagram
a)
Attribute
b)
Relationship
c)
Cardinality
d)
Entity
e)
There is no right answer
28.
A relation on ER-Diagram has a property
a)
Attributes can have the same name in one table
b)
Each relation must have a unique name
c)
Every row doesn't have to be unique
d)
The order of the columns is significant
e)
The order of the row is significant
29.
In the case of lectures on campus, what is the form of cardinality of the relationship between the Student entity and the Course entity
a)
One to one
b)
One to many
c)
Many to one
d)
Many to Many
e)
One or More
30.
The example of composite attribute is
a)
Age
b)
Date of birth
c)
Address
d)
Telephone
e)
Education Degree
31.
The correct sequence for modeling bottom up data is:
a)
DB - Analisis - Existing System
b)
System Requirement - Analisis - DB
c)
DB - Analisis - System Requirement
d)
Existing System - Analisis - System Requirement
e)
Existing System - Analisis - DB
32.
1 candidate employee required must have 2 or more skills, it is an example of a relationship at Martin ERD, namely
a)
More than one
b)
Zero or one
c)
Zero, One, or More
d)
One or More
e)
Exactly One
33.
In a store information system, there are customers who have transaction at least 1x, more than 1x, and also customers who have never transacted, it is an example of a relationship at Martin ERD, namely
a)
More than one
b)
Zero or one
c)
Zero, One, or More
d)
One or More
e)
Exactly One
34.
Each lecturer must teach at least 1 course. They are not allowed to not teach at all, but may teach more than 1, it is an example of relationship at Martin ERD, namely
a)
More than one
b)
Zero or one
c)
Zero, One, or More
d)
One or More
e)
Exactly One
35.
Entity Relationship Diagram is one example of diagram in a type of data model:
a)
Logical Data Model
b)
Physical Data Model
c)
Network Data Model
d)
Conceptual Data Model
e)
Hierarchy Data Model
36.
Unary relationship is
a)
a relationship that connects several entities
b)
a relationship that connects an entity
c)
a relationship that connects two entities
d)
a relationship that connects three entities
e)
a relationship that connects four entities
37.
The lecturer heads up the department is an example of a relationship with cardinality:
a)
One to one
b)
One to many
c)
Many to one
d)
Many to Many
e)
One or More
100 %
