NEW
Font size
WorksheetsQuiz 1
Total questions: 29
Worksheet time: 15mins
Which of the following options best describes what a database is?
A set of stored files without relation
A set of related data with a logical meaning
A program to store information
A random collection of data
What is a DBMS?
A language for creating diagrams
A set of related tables
Software that allows creating and manipulating databases
A conceptual model
The term miniworld or Universe of Discourse refers to:
The server where the database is stored
The set of users of the system
The aspect of the real world that the database represents
The physical schema of the database
Which of the following is NOT an advantage of the DBMS approach?
Control of redundancy
Security and access control
Strong dependency between programs and data
Multi-user support
Who is the main responsible person for authorizing access and managing the database?
End user
Database designer
Database administrator (DBA)
Application developer
In the ER model, an entity represents:
An action of the system
An object of the real world with independent existence
A multivalued attribute
An SQL query
Which of the following is an example of a composite attribute?
Age
Salary
Address
Gender
An attribute that can have multiple values for the same entity is:
Derived
Key
Multivalued
Simple
The Age attribute, calculated from the date of birth, is an attribute:
Multiple
Composite
Key
Derived
What is the main function of a key attribute?
Describe an entity
Uniquely identify an entity
Relate entities
Represent a relationship
In an ER diagram, relationships are represented by:
Rectangles
Ovals
Diamonds
Double lines
A 1:N binary relationship indicates that:
One entity relates to a single entity
Many entities relate to many entities
One entity relates to many, but not vice versa
There is no cardinality restriction
What does total participation in a relationship indicate?
The relationship is optional
All entities must participate in the relationship
The cardinality is N:M
There is a weak entity
Which of the following situations best describes a weak entity?
It has multiple attributes
It has
Which of the following situations best describes a weak entity?
Has multiple attributes
Has its own key
Depends on another entity to exist
Participates in an N:M relationship
In an ER diagram, a weak entity is represented by:
A simple rectangle
A double oval
A double-lined rectangle
A diamond
An attribute that may not have a value for a specific entity is considered:
Derived
Null
Key
Multivalued
What is an example of an attribute of a relationship?
Employee's name
Date of birth
Hours worked on a project
Identification number
In a 1:N relationship, where is it correct to migrate the attributes of the relationship?
In any of the entities
In the entity on the 1 side
In the entity on the N side
They cannot be migrated
A database schema is characterized by:
Changing constantly
Representing data at a specific moment
Describing the structure of the database
Being the same as the initial state
The state of the database refers to:
The conceptual design
The data at a given moment
The DBMS used
User views
What language is used to define the structure of the database?
DML
VDL
SDL
DDL
What architecture clearly separates presentation, logic, and data?
Centralized
Client/Server
Three-tier
Monolithic
A parametric user is characterized by:
Designing the database
Occasionally using ad-hoc queries
Executing predefined repetitive transactions
Managing permissions
In a flight reservation system, what would be a good example of a mini-world?
The airline's server
The actual flight reservation process
The SQL language
The user's browser
Why is a random set of data not considered a database?
Because it does not use a DBMS
Because it has no users
Because it has no logical meaning or defined purpose
Because it is not normalized
What is the highest volcano in Costa Rica?
Arenal
Irazú
Poás
Rincón de la Vieja
Which was Metallica’s first studio album?
Ride the Lightning
Master of Puppets
Kill ’Em All
…And Justice for All
What is the longest river in the world?
Amazon
Yangtze
Nile
Mississippi
