Font size
WorksheetsPrelim Exam
Total questions: 40
Worksheet time: 25mins
It is an organized collection of structured data to make it easily accessible, manageable and update. In simple words, you can say, its a place where the data is stored.
(a)
It defines WHAT the system contains. This model is typically created by Business stakeholders and Data Architects. The purpose is to organize, scope and define business concepts and rules.
High-level
Low-level
Representational
None of the above
It is the language of love for database
(a)
Year when relational databases became very popular, which was followed by object-oriented databases later on.
(a)
This consists of a set of physical electronic devices such as I/O devices, storage devices and many more. It also provides an interface between computers and real-world systems.
(a)
This is the set of programs that are used to control and manage the overall Database. It also includes the DBMS software itself. The Operating System, the network software being used to share the data among the users, the application programs used to access data in the DBMS.
(a)
Which of these are component of database
Data
Procedure
Hardware
Relationship
Software
These are software which enable users/apps to access, manipulate and report on data stored in database
(a)
Another term for DBMS Software
Database engine
Database machine
Usually used for E-Commerce
1 Tier
2 Tier
3 Tier
N Tier
Also known as transactional data
Small data
Big data
SQL means
Structured Queue language
Structured Query language
Standard Query language
Secured Query language
This kind of data is operated 24/7
Small Data
Big Data
It is also called “Multi-Tier Architecture”
1 Tier
2 Tier
3 Tier
N Tier
Which of the following is a common database program?
InDesign
Photshop
Access
Excel
Which is not a DBMS?
Oracle
Postgre
IBM
Excel
It is the simplest one as it is equivalent to running the application on the personal computer.
1 tier
2 tier
3 tier
N tier
Usually used by designers and programmers.
1 Tier
2 Tier
3 Tier
N Tier
Which is not a career in database?
Administrator
Developer
Network Engineer
Analyst
A thing a that exists either physically or logically. It can be a real-world object.
(a)
The association between two different entities is called (a) .
One entity from entity set A can be associated with more than one entities of entity set B however an entity from entity set B, can be associated with at most one entity.
One to one
One to many
Many to one
Many to Many
In this data model, The date and relationships are represented by collection of interrelated tables. Each table is a group of columns and rows, where column represents attribute of an entity and rows represent records.
Hierarchical Model
Relational Model
Network Model
Characteristics of an entity is called.
(a)
Data is organized into a tree like structure. The data is stored as records which are connected to one another through links
Hierarchical Model
Relational Model
Network Model
More than one entities from entity set A can be associated with at most one entity of entity set B, however an entity from entity set B can be associated with more than one entity from entity set A.
One to one
One to many
Many to one
Many to Many
This kind of model is a systematic way of describing and defining a business process.
Hierarchical Model
Relational Model
Entity-Relationship Model
This attributes do not exist in the physical database, but their values are derived from other attributes present in the database.
Multivalued Attributes
Derived Attributes
Composite Attributes
One entity from entity set A can be associated with at most one entity of entity set B and vice versa.
One to One
One to Many
Many to One
Many to many
In the entity customer, which attribute is the primary key.
(a)
In the entity customer, which attribute is the derived key.
(a)
Data is the heart and soul of business.
True
False
Today we have cloud databases and self-driving databases that are creating a new ground when it comes to how data is collected, stored, managed, and utilized.
True
False
Database is the center of the technology world.
True
False
Data redundancy or duplication of data is just fine and it has a little impact on the system.
True
False
Application and websites are the biggest consumers of database.
True
False
Proverbs 22:29 NIV
Do you see someone (a) in their work? They will serve before kings; they will not serve before officials of low rank.
Ps 100:5 says "For the Lord is good and his love endures (a) ; his faithfulness continues through all generations."
Proverbs 29:18 says:
Where there is no (a) , people cast off restraint (excuses);
1 CORINTHIANS 15:33...Bad company (environment) (a) good character.
