“150”, Aptitude Test Questions and Answers for ICT Officer II (Database Administration) – e-GA.
ABSTRACT
This publication provides 150 Aptitude
Test Questions and Answers for ICT Officer Grade II (Database Administration),
designed to help candidates prepare for competitive public-service online
aptitude assessments in Tanzania, particularly within the e-Government
environment. The questions assess practical knowledge, technical reasoning,
problem-solving, and professional judgment across database design, SQL,
performance tuning, security, transactions, backup and recovery, disaster
recovery, high availability, monitoring, troubleshooting, infrastructure, and
database administration. Each question contains four plausible multiple-choice
options, the correct answer, and a concise rationale, with emphasis on
realistic scenarios that require candidates to distinguish the most appropriate
solution rather than rely on simple memorization.
Prepared by: ICT Officer II (Database
Administration)
Compiled by ICT Officer II (Database
Administration)
0628729934.
Date: September 02, 2026
Dear applicants,
This collection of questions and answers
has been prepared to help all of you to understand the key areas tested during
the interview. The goal is to provide a useful, and practical study guide so
you can all perform confidently and fairly in the selection process. I wish you
the best of luck, and may this resource support you in achieving success!
Warm regards,
ICT Officer II (Database Administration)
For Personal Use by Applicants Preparing
for ICT Officer II (Database Administration) - at Public Service Recruitment
Service.
ICT OFFICER II
(Database Administration) – e-GA
150 Aptitude
Test Questions and Answers
1. A government online service is
experiencing slow response times during peak hours. Database CPU utilization is
only 45%, memory usage is normal, but the number of active database sessions
waiting for disk reads has increased significantly. Which action is the most
appropriate first step for the Database Administrator?
A. Increase
database server memory capacity immediately
B. Examine execution plans and identify high-I/O queries
C. Increase application-server processing capacity immediately
D. Rebuild every database index before further testing
Answer: B.
Examine execution plans and identify high-I/O queries
Rationale: Low CPU utilization does not eliminate
the database as the source of the problem because queries can spend substantial
time waiting for disk I/O. The most appropriate first step is to examine
execution plans and identify queries performing excessive scans, inefficient
joins, or other I/O-intensive operations. Increasing memory or
application-server capacity without evidence may simply move the bottleneck
elsewhere, while rebuilding every index is an unnecessarily broad and
potentially disruptive action. Query execution evidence provides a targeted
basis for determining whether indexing, query rewriting, storage optimization,
or another intervention is actually required.
2. A transaction transfers funds between two
accounts in a government payment system. The amount is successfully deducted
from the first account, but a system failure occurs before the amount is
credited to the second account. Which database property is primarily
responsible for ensuring that the incomplete transaction does not remain
partially applied?
A. Consistency
B. Isolation
C. Durability
D. Atomicity
Answer: D.
Atomicity
Rationale: Atomicity requires a transaction to be
treated as an indivisible unit: either all of its operations are committed or
none of them are. In this case, deducting the amount from one account without
crediting the second would leave the transaction partially completed, so the
DBMS must roll back the incomplete transaction. Consistency concerns preserving
defined data rules and constraints, isolation concerns interaction between
concurrent transactions, and durability ensures committed changes survive
failures. The specific requirement described is therefore atomicity.
3. A government database frequently runs
queries that filter records by both RegionCode and RegistrationDate.
The DBA wants an index designed around this recurring workload. Which approach
is most appropriate?
A. Create a
composite index with column order aligned to the common filtering workload
B. Create
separate indexes on unrelated columns that are rarely used in queries
C. Create an
index only on a descriptive column that is seldom included in filtering
D. Create a
clustered index without considering the workload's query patterns
Answer: A.
Create a composite index with column order aligned to the common filtering
workload
Rationale: A composite index can efficiently support
queries that repeatedly filter on multiple columns when its column order is
chosen according to the workload's predicates, selectivity, and access
patterns. The exact order should be determined from actual query behavior
rather than assumed solely from the column names. Indexing unrelated or rarely
filtered columns provides little benefit, while creating a clustered index
without considering workload characteristics can result in an inefficient
design. The key principle is to align index structure and column order with the
database's actual query workload.
4. A database administrator notices that a
production application occasionally becomes unresponsive even though CPU and
memory utilization remain moderate. Database monitoring shows many application
sessions waiting for locks held by other sessions. What is the most
appropriate initial investigation?
A. Increase CPU
allocation to the database server
B. Increase the database connection-pool size immediately
C. Identify blocking sessions and inspect their transactions
D. Reinstall the database management system on the server
Answer: C.
Identify blocking sessions and inspect their transactions
Rationale: When many sessions are waiting for locks
while general resource utilization remains moderate, blocking and transaction
behavior should be investigated first. The administrator should identify the
blocking sessions, determine which objects are locked, inspect transaction
duration and activity, and establish why locks are being held for so long.
Increasing CPU or connection-pool capacity does not remove the underlying lock
contention and may increase pressure on the database. Reinstalling the DBMS is
unjustified and potentially destructive without evidence of software
corruption.
5. A database is backed up with a full
backup every Sunday and differential backups every weekday. If the
database fails on Friday morning, and Thursday's differential backup completed
successfully, which backup sequence is required for recovery?
A. Sunday's full
backup followed by Thursday's differential backup
B. Monday's differential followed by Tuesday's differential backup
C. Sunday's full backup followed by Wednesday's differential backup
D. Sunday's full backup followed by every weekday differential backup
Answer: A
Rationale: A differential backup contains changes
made since the most recent full backup. Therefore, recovery requires the latest
successful full backup—in this case Sunday's full backup—followed by the latest
completed differential backup before the failure, which is Thursday's
differential backup. Earlier differential backups are not required because each
differential contains the cumulative changes since Sunday's full backup.
6. A DBA needs to give an application account
permission to retrieve information from a database view but must prevent the
account from directly reading the underlying base table. Which approach
provides the best security design?
A. Grant full
table access and rely on application restrictions
B. Grant the required permission on the view only
C. Grant database-owner privileges and audit application activity
D. Grant server-level privileges and restrict selected application queries
Answer: B.
Grant the required permission on the view only
Rationale: Granting the application only the
permissions it requires follows the principle of least privilege. If the
application needs information exposed through a view, permission can be granted
on the view without unnecessarily granting direct access to the underlying
table. Granting broad table, database-owner, or server-level privileges creates
excessive access and increases the potential impact of compromised credentials
or application defects. Views can therefore serve as an important layer for
controlled data exposure when combined with appropriate database permissions.
7. A production query that normally completes
in two seconds suddenly takes several minutes. The query text has not changed,
but the amount of data in the relevant tables has grown substantially. Which
investigation would provide the strongest evidence about why the query
has degraded?
A. Compare the
current execution plan with the previous plan
B. Restart the database server and measure the query again
C. Increase the transaction timeout before examining the query
D. Disable database logging to reduce background processing
Answer: A.
Compare the current execution plan with the previous plan
Rationale: A substantial increase in data volume can
cause the optimizer to choose a different execution plan, especially when
statistics no longer accurately represent the data distribution or when a
previously efficient access method becomes expensive. Comparing the current
execution plan with a known good previous plan can reveal changes such as a
switch from an index seek to a large table scan, inefficient join selection, or
other plan changes. Restarting the server, increasing timeouts, or disabling
logging does not establish the root cause and could obscure useful diagnostic
evidence.
8. Two concurrent transactions each acquire a
lock required by the other transaction and then wait indefinitely for the
second lock to become available. What condition has occurred?
A. Dirty read
B. Lost update
C. Deadlock
D. Phantom read
Answer: C.
Deadlock
Rationale: A deadlock occurs when two or more
transactions hold resources while waiting for resources held by one another,
creating a circular dependency that prevents progress. Database systems
commonly detect such conditions and terminate or roll back one transaction so
that the others can continue. A dirty read occurs when uncommitted data is
read, a lost update involves conflicting modifications being overwritten, and a
phantom read concerns newly appearing or disappearing rows within repeated
queries. The described circular lock dependency specifically represents a
deadlock.
9. An e-Government database must remain
available if its primary database server fails. The organization has configured
a secondary database that continuously receives changes from the primary and
can be promoted when required. Which capability is being primarily provided?
A. Data
normalization
B. High availability through replication
C. Query optimization through partitioning
D. Data confidentiality through encryption
Answer: B.
High availability through replication
Rationale: Continuously transferring database
changes to a secondary server and making that server capable of taking over
after primary failure is a common high-availability design using replication or
a related standby mechanism. Its purpose is to reduce service interruption
caused by infrastructure failure. Normalization addresses data structure,
partitioning can improve manageability or query performance, and encryption
protects data confidentiality. Replication can also support disaster recovery,
but the stated objective of maintaining service when the primary server fails
is specifically a high-availability requirement.
10. A database administrator is preparing to
apply a major DBMS upgrade to a production environment supporting critical
government services. Which approach provides the strongest operational
control before performing the production upgrade?
A. Apply the
upgrade directly because backups already exist
B. Upgrade production first and resolve compatibility issues afterward
C. Test the upgrade against a representative environment and recovery plan
D. Disable monitoring temporarily so upgrade alerts do not interrupt operations
Answer: C.
Test the upgrade against a representative environment and recovery plan
Rationale: A major DBMS upgrade can introduce
compatibility problems involving applications, drivers, stored procedures,
functions, extensions, configuration settings, or database features. Testing
against a representative environment allows administrators to identify such
problems before affecting production. The process should also include validated
backups and a tested rollback or recovery strategy. Having backups alone does
not prove that recovery will meet operational requirements, while upgrading
production first unnecessarily exposes critical services to avoidable risk.
11. A database contains a table recording
transactions for several years. Most operational queries access only the
current financial year, while historical data is rarely accessed. The table has
become very large and maintenance operations increasingly affect production
performance. Which design approach could most directly improve
manageability for this workload?
A. Partition the
table using an appropriate date-based strategy
B. Replace the table with a single unindexed archive table
C. Increase transaction isolation for historical queries
D. Store every historical row in the application server memory
Answer: A.
Partition the table using an appropriate date-based strategy
Rationale: Date-based partitioning can divide a
large logical table into manageable physical portions, allowing operations and
queries that target specific date ranges to work with relevant partitions
rather than the entire dataset. For workloads dominated by recent records,
partitioning can also simplify archival and maintenance operations. It does not
automatically guarantee better performance, because the partitioning strategy
must align with actual query patterns and DBMS capabilities. The other options
either remove useful database structures or address unrelated concerns.
12. A database administrator discovers that an
application account has permissions to create users, modify database security
settings, and read sensitive citizen information. The application itself only
requires permission to read and update specific business tables. What is the most
appropriate corrective action?
A. Keep the
privileges because application accounts require broad access
B. Move the account to another database without changing permissions
C. Disable database auditing to reduce exposure of security information
D. Reduce the account privileges to only those required by the application
Answer: D.
Reduce the account privileges to only those required by the application
Rationale: The application account has excessive
privileges relative to its legitimate functions, violating the principle of
least privilege and increasing the potential impact of credential compromise or
application exploitation. The correct response is to reduce the account to the
minimum permissions required for its operations. Moving the account without
changing its privileges does not solve the security weakness, while disabling
auditing removes an important control. Application accounts should generally be
separated from highly privileged administrative accounts.
13. A database server suddenly reports that a
transaction log is almost full. The database itself still has sufficient free
disk space, and the application is continuing to generate transactions. Which
investigation is most appropriate first?
A. Determine why
log truncation or reuse is being prevented
B. Delete old database tables to create additional data space
C. Increase the application's database connection timeout
D. Rebuild all indexes to reduce transaction processing time
Answer: A.
Determine why log truncation or reuse is being prevented
Rationale: A transaction log can become full even
when the underlying database data files have substantial free space. The
administrator should first determine why log space cannot be reused, such as an
uncompleted transaction, replication-related dependency, backup requirement, or
another DBMS-specific condition. Deleting tables does not necessarily free
transaction-log space, connection timeouts are unrelated, and index rebuilding
can generate additional logging and potentially worsen the situation.
Understanding the reason for log growth is therefore the appropriate first
diagnostic step.
14. A government application submits a query
containing user-supplied text directly into an SQL statement. An attacker
discovers that specially crafted input can alter the meaning of the query and
retrieve unauthorized records. Which control is the most appropriate primary
defense?
A. Increase
database server memory to handle abnormal queries
B. Use parameterized queries and restrict database privileges
C. Increase network bandwidth between the application and database
D. Create additional indexes on columns accessed by the application
Answer: B. Use
parameterized queries and restrict database privileges
Rationale: The described vulnerability is
characteristic of SQL injection, where untrusted input changes the structure or
meaning of a database statement. Parameterized queries separate SQL
instructions from user-supplied values and are a primary defense against this
class of attack. Restricting database privileges limits the damage if an
application vulnerability is exploited. Memory, network bandwidth, and indexing
can affect performance but do not address the underlying injection
vulnerability. Secure application design must therefore be combined with
appropriate database authorization.
15. During a database performance
investigation, a query performs a full scan of a very large table even though a
potentially useful index exists. The DBA confirms that the query returns a
large proportion of the table's rows. Which explanation is most plausible?
A. The database
must always use an available index
B. The optimizer may determine that the table scan is cheaper
C. The index automatically becomes invalid whenever scans occur
D. Full scans indicate that the database server has insufficient memory
Answer: B. The
optimizer may determine that the table scan is cheaper
Rationale: The presence of an index does not mean
that the optimizer must use it. If a query is expected to return a large
proportion of a table, following an index can require many random data accesses
and may cost more than sequentially scanning the table. The optimizer evaluates
available access paths using statistics, estimated costs, and other
information. Therefore, a full scan can be an appropriate plan rather than
evidence of a defective database. The DBA should evaluate the execution plan
and workload before forcing index usage.
16. A database backup job reports
"successful" every night, but the DBA has never attempted to restore
any of the backups. The database supports a critical public service. Which
statement best describes the situation?
A. The backups
are proven reliable because the job completes successfully
B. The backups are sufficient because successful files cannot be corrupted
C. The backups provide no value until the database reaches capacity
D. The backups remain unverified until restoration testing confirms
recoverability
Answer: D. The
backups remain unverified until restoration testing confirms recoverability
Rationale: A successful backup job only indicates
that the backup operation completed according to the DBMS or backup system; it
does not prove that the backup can successfully restore the required database
or meet recovery objectives. Restoration testing verifies the integrity and
practical usability of backup media, procedures, credentials, dependencies, and
recovery processes. For critical government systems, recovery testing is
therefore an essential part of backup management rather than an optional
exercise. A backup strategy should be evaluated against defined recovery
objectives.
17. A production database experiences repeated
deadlocks involving the same two application transactions. Investigation shows
that Transaction A updates Table X and then Table Y, while Transaction B
updates Table Y and then Table X. Which change would most directly
reduce this recurring deadlock pattern?
A. Increase the
database server's CPU allocation
B. Increase the maximum number of concurrent sessions
C. Make transactions acquire shared resources in a consistent order
D. Disable all database locking mechanisms during business hours
Answer: C.
Make transactions acquire shared resources in a consistent order
Rationale: The transactions acquire the same
resources in opposite orders, creating a classic circular-wait condition.
Establishing a consistent resource-acquisition order—for example, always
modifying Table X before Table Y—reduces the possibility that two transactions
will hold conflicting resources while waiting for each other. Increasing CPU or
session capacity does not remove the lock-order conflict, and disabling locking
is not a safe solution for maintaining transactional consistency. Application
transaction design is therefore the most direct corrective measure in this
scenario.
18. A DBA is asked to provide a report showing
which users accessed sensitive citizen records, when they accessed them, and
what database operations were performed. Which database capability is most
directly relevant?
A. Database
auditing
B. Database partitioning
C. Query result caching
D. Connection pooling
Answer: A.
Database auditing
Rationale: Database auditing records
security-relevant activities such as user access, executed operations,
timestamps, and, depending on the DBMS and configuration, affected objects or
records. It provides evidence for accountability, compliance investigations, security
monitoring, and incident analysis. Partitioning is concerned with organizing
data, caching improves repeated query performance, and connection pooling
manages database connections. For determining who accessed sensitive data and
what they did, an appropriately configured auditing mechanism is the most
directly relevant control.
19. A database application uses a connection
pool. Monitoring shows that the database itself is healthy, but application
requests are increasingly waiting because all available pooled connections are
occupied for long periods. Which action should the DBA and application team
investigate first?
A. Replace the
database server with a larger physical machine
B. Investigate long-running transactions and connection release behavior
C. Increase database storage capacity regardless of disk utilization
D. Disable transaction logging to shorten connection processing time
Answer: B.
Investigate long-running transactions and connection release behavior
Rationale: When all pooled connections remain
occupied for unusually long periods while the database itself is healthy, the
problem may be caused by long-running queries or transactions, connections that
are not being returned promptly, or application code holding connections longer
than necessary. Increasing server capacity without understanding connection
behavior may not solve the bottleneck. Storage capacity is unrelated unless
storage exhaustion is actually occurring, and disabling transaction logging
would compromise database durability and recovery. The first investigation
should therefore follow the lifecycle and duration of the connections and
transactions.
20. A database administrator must ensure that
a committed transaction remains preserved even if the database server loses
power immediately afterward. Which ACID property addresses this requirement?
A. Atomicity
B. Consistency
C. Durability
D. Isolation
Answer: C.
Durability
Rationale: Durability means that once a transaction
has been successfully committed, its effects must survive subsequent failures
such as a power outage or database-server restart. Database systems commonly
achieve durability through mechanisms such as transaction logging and reliable
storage. Atomicity concerns all-or-nothing transaction completion, consistency
concerns valid database states, and isolation concerns concurrent transaction interaction.
The requirement specifically concerns preservation of committed data after
failure, making durability the correct property.
21. An organization operates a primary
database in its main data center and maintains a standby database at a
geographically separate disaster recovery site. The standby receives replicated
changes but is not normally used to serve production transactions. What is the primary
purpose of this arrangement?
A. Reduce the
number of database tables required by applications
B. Improve normalization of replicated database structures
C. Eliminate the need for database backups at the primary site
D. Provide a recovery capability following a major site failure
Answer: D.
Provide a recovery capability following a major site failure
Rationale: A geographically separate standby
provides an additional recovery capability if the primary data center becomes
unavailable because of a major incident such as fire, prolonged power failure,
network disruption, or other disaster. This is primarily a disaster-recovery
measure, although replication can also contribute to high availability
depending on architecture and failover design. It does not eliminate the need
for backups because replication can reproduce accidental deletions or corrupt
changes. The separation between sites is particularly important because a
disaster affecting the primary site may also affect locally stored copies.
22. A DBA notices that a query filtering on a
column returns only a very small percentage of rows, yet the optimizer
consistently chooses a full table scan. Statistics on the table are several
months old and the underlying data distribution has changed significantly.
Which action is most appropriate to investigate first?
A. Update or
refresh the relevant database statistics
B. Increase the application's connection timeout value
C. Remove all indexes from the affected database table
D. Increase transaction isolation to force index usage
Answer: A.
Update or refresh the relevant database statistics
Rationale: Query optimizers depend heavily on
statistics to estimate row counts and select appropriate execution plans. If
statistics are significantly outdated, the optimizer may incorrectly estimate
the selectivity of a predicate and choose a full scan even when an index would
likely be more efficient. Refreshing statistics can provide the optimizer with
more accurate information and may lead to a better plan. Connection timeouts
and transaction isolation do not correct inaccurate cardinality estimates,
while removing indexes would eliminate potentially useful access paths rather
than addressing the cause.
23. A database administrator needs to apply a
security patch to a production DBMS. The vendor recommends installing the patch
as soon as possible, but the system supports a critical government service
operating continuously. Which approach represents the best balance between
security and availability?
A. Ignore the
patch until the next major database upgrade
B. Install the patch immediately without testing to reduce exposure
C. Test the patch, schedule controlled deployment, and prepare rollback
D. Disable the security controls affected by the patch until deployment
Answer: C.
Test the patch, schedule controlled deployment, and prepare rollback
Rationale: Security patches should be applied within
an appropriate risk-managed timeframe, but critical production systems should
not be changed blindly. Testing the patch in a representative environment helps
identify application, configuration, compatibility, or performance issues
before deployment. A controlled maintenance window, validated backup or
rollback strategy, monitoring, and communication with stakeholders help
minimize service disruption. Ignoring security updates leaves known
vulnerabilities exposed, while untested immediate deployment can introduce
avoidable operational failures. Effective database administration balances
security urgency with controlled change management.
24. A database has a unique identifier for
every citizen record. The identifier must never be duplicated and must always
identify exactly one record. Which database constraint most directly enforces
this requirement when the identifier is used as the table's principal
identifier?
A. Foreign key
constraint
B. Primary key constraint
C. Check constraint
D. Default value constraint
Answer: B.
Primary key constraint
Rationale: A primary key uniquely identifies each
row in a relational table and does not permit duplicate values; it also
requires the key value to be non-null in standard relational implementations.
This makes it appropriate for a principal identifier that must uniquely
distinguish every citizen record. A foreign key establishes a relationship with
a key in another table, a check constraint enforces a specified logical
condition, and a default supplies a value when one is not explicitly provided.
The primary key is therefore the most direct mechanism for the stated
requirement.
25. A critical government database must meet a
recovery objective requiring the organization to lose no more than a few
minutes of committed transactions after a catastrophic failure. Which design
consideration is most important when selecting the backup and recovery
architecture?
A. The number of
database views created by application developers
B. The number of indexes maintained on historical tables
C. The color scheme used by the database monitoring dashboard
D. The required Recovery Point Objective and transaction protection method
Answer: D. The
required Recovery Point Objective and transaction protection method
Rationale: A Recovery Point Objective (RPO) defines
the maximum acceptable amount of data loss measured in time. If the
organization can tolerate only a few minutes of committed transactions being
lost, relying solely on infrequent full or differential backups may be
insufficient. The recovery architecture must provide transaction protection and
backup or replication mechanisms capable of meeting that RPO, with the exact
implementation depending on the DBMS and infrastructure. Database views,
historical indexes, and dashboard appearance do not determine whether the
recovery design can meet the required data-loss tolerance.
26. A government database contains millions
of records, and users frequently search for citizens by their National
Identification Number. The column is already defined as unique, but searches
are becoming slower as the table grows. Which action would most directly
improve the efficiency of these lookups?
A. Increase the
transaction log size
B. Create an appropriate index on the identification number
C. Increase the maximum number of database connections
D. Move historical records to a backup device
Answer: B.
Create an appropriate index on the identification number
Rationale: An
index on a frequently searched unique column allows the database engine to
locate matching records efficiently without scanning the entire table.
Increasing connections or transaction-log capacity does not directly improve
lookup performance, while moving records to backup storage would not address
normal query execution.
27. A database administrator discovers that
several developers use the same highly privileged database account when
deploying applications. There is no reliable way to determine which individual
performed a particular database change. Which control would most directly
improve accountability?
A. Increase the
number of database replicas
B. Create individual accounts with appropriate privileges and auditing
C. Increase the database connection timeout for developer sessions
D. Move the deployment database to a separate physical server
Answer: B.
Create individual accounts with appropriate privileges and auditing
Rationale: Shared privileged accounts undermine
accountability because database activity cannot reliably be attributed to a
particular individual. Individual accounts combined with appropriate role-based
permissions and auditing provide a much stronger control by identifying who
performed an operation and ensuring each user receives only the access required
for their duties. Replication, connection timeouts, and physical server
separation do not address the attribution problem. Privileged access should
therefore be individually identifiable and auditable wherever practical.
28. An application occasionally reports that
two users successfully modified the same record, but one user's changes appear
to have disappeared after the second update. Database logs show that both
transactions read the original value before either transaction committed. Which
concurrency problem does this most closely represent?
A. Phantom read
B. Dirty read
C. Lost update
D. Cascading rollback
Answer: C.
Lost update
Rationale: A lost update occurs when two concurrent
transactions modify the same data based on an earlier value, causing one
transaction's modification to overwrite the other's result. The critical clue
is that both transactions read the original state and subsequently performed
updates without adequately coordinating their changes. A dirty read involves
reading uncommitted data, while a phantom read concerns changes in the set of
rows returned by repeated queries. The described behavior is therefore
characteristic of a lost update and should prompt investigation of transaction
isolation, locking, or optimistic concurrency controls.
29. A DBA is designing a database for a
government system where a citizen may have multiple telephone numbers, and each
telephone number may be associated with multiple citizens because of shared
household or organizational contacts. Which relational design is most
appropriate?
A. Store all
telephone numbers in one comma-separated column
B. Store one telephone number directly in the citizen table
C. Create a separate telephone table with repeated citizen columns
D. Use separate citizen and telephone tables connected through a junction table
Answer: D. Use
separate citizen and telephone tables connected through a junction table
Rationale: The relationship described is
many-to-many: one citizen can have several telephone numbers, while one
telephone number can be associated with multiple citizens. In a normalized
relational design, the entities should be represented separately and their relationship
captured through a junction or associative table containing the relevant
foreign keys. Storing multiple values in one column violates atomicity and
makes querying and integrity management difficult. A direct one-to-many
structure would also fail to represent the possibility of a telephone number
belonging to multiple citizens.
30. A production database server has adequate
CPU and memory, but storage latency has increased sharply after a new reporting
application was introduced. The reporting application executes large analytical
queries against the same production database used by transactional services.
Which architectural change would most directly reduce the competition
between the workloads?
A. Move
analytical workloads to a separate reporting environment
B. Increase transaction isolation for all reporting transactions
C. Add more foreign keys to the production transaction tables
D. Disable transaction logging while reports are being generated
Answer: A.
Move analytical workloads to a separate reporting environment
Rationale: Large analytical queries can consume substantial I/O and other resources and interfere with latency-sensitive transactional workloads. Separating reporting workloads through a reporting database, replica, data warehouse, or other appropriate architecture can isolate resource-intensive analytical activity from the production transaction system. Increasing isolation can actually increase locking or resource overhead, foreign keys do not solve resource contention, and disabling transaction logging would undermine recovery and durability. Workload separation is therefore the most direct architectural response when reporting activity is competing with production transactions.
📘 Get the Full Aptitude Test Questions PDF through your Gmail (Questions 1–150)
You’ve just accessed the first 30 questions. The full set of 150 expertly prepared aptitude test questions for ICT Officer II (Data Administrations) – e-GA., Is available, pay, and get access.
To get access to the full PDF, please make a payment of Tsh 10,000 to the LIPA numbers below:
After payment, please send a text message to notify us of your payment:
⚠️ Important Notice
- The PDF will be watermarked with your name and phone number and protected for personal use only.
- Redistribution, sharing, screenshotting, or copying the contents is strictly prohibited. When you share unlawfully, your name and phone number are visible and easy to trace as you leaked a document to other third parties.
- Legal action may be taken against the misuse of this material.
Thank you for supporting quality content. Best of luck in your interview preparation!
 – e-GA.){kind=link}
0 Comments
PLACE YOUR COMMENT HERE
WARNING: DO NOT USE ABUSIVE LANGUAGE BECAUSE IT IS AGAINST THE LAW.
THE COMMENTS OF OUR READERS IS NOT OUR RESPONSIBILITY.