Database Test 2 Computer Subject
Database Test 2 Computer Subject
Question 21
Which of the following are basic data distribution strategies?
The basic strategies for distributing data include partitioning, centralizing, and replicating data.
Not clear enough?
Question 22
_______ refers to a method of database distribution in which different portions of the database reside at different nodes in the network.
Partitioning distributes different parts of a database across multiple nodes to improve performance and availability.
Not clear enough?
Question 23
_______ refers to a method of database distribution in which one database contains data that are included in another database.
Replication involves copying data from one database to another to ensure redundancy and availability.
Not clear enough?
Question 24
Database __________ which is the logical design of the database, and the database _______ which is a snapshot of the data in the database at a given instant in time.
A schema defines the logical structure, while an instance is the data content at a specific time.
Not clear enough?
Question 25
Relational schemas and other metadata about relations are stored in a structure called the _____?
A data dictionary stores metadata describing the structure of tables, columns, constraints, and relationships in the database.
Not clear enough?
Question 26
Which Of the following refers to something that can be identified in the users work environment, something that the users want to track?
An entity is something in the user's environment that needs to be tracked or identified in the database.
Not clear enough?
Question 27
Properties that describe the entity's characteristics are called_______?
Attributes are properties or characteristics that describe an entity.
Not clear enough?
Question 28
Attributes that name, or identify, entity instances are called______?
Identifiers are special attributes that uniquely identify entity instances.
Not clear enough?
Question 29
Customers, cars and parts are example of____?
Entities represent real-world objects or things in the database, such as customers, cars, and parts.
Not clear enough?
Question 30
Which of the following represent the entities?
All the options listed are examples of entities because they represent identifiable objects in the environment.
Not clear enough?
You might like
The writer's posture, as conveyed in the statement ‘Electricity from living cells is no new idea’, can be described as
A bank statement shows an overdraft of GH¢190,000. Kofi, a debtor, paid GH¢400,000 into the account. The new bank balance is
The pie chart below shows the monthly distribution of a man's salary on food items. If he spent ₦8,000 on rice, how much did he spent on yam?
