Mirrored databases are a fundamental component of high-availability systems because they maintain an exact, real-time copy of data on a separate physical device. This redundancy ensures that if the primary database fails due to hardware issues or disasters, the mirrored copy can immediately take over operations without data loss. Consequently, these systems are almost always provided in high-availability environments to guarantee continuous service and protect critical business data from interruption.

Question 2 Easy Mcq

✓ Correct ✗ Incorrect

A ____ is responsible for maintaining a large, multiuser system.

Software engineer

System administrator

Vice president of information systems

Explanation:

A system administrator is specifically tasked with the ongoing management and maintenance of large-scale multiuser computer systems. This role involves ensuring network stability, managing user access controls, and performing routine updates to keep the infrastructure secure and operational. Unlike software engineers who focus on creating new applications, or executives who handle strategic planning, the system administrator directly handles the daily technical operations required to support multiple users simultaneously. Their expertise in operating systems and server management makes them the essential personnel for maintaining complex IT environments. Therefore, this position is the definitive answer for who maintains such systems.

Question 3 Easy Mcq

✓ Correct ✗ Incorrect

A traditional data administrator performs which of the following roles?

Establish backup and recovery procedures

Resolve data ownership issues

Protect the security of the database.

Tune Database Performance

Explanation:

In a traditional data administration framework, the primary responsibility lies with the data administrator to define and enforce data ownership across the organization. This role involves identifying who owns specific data elements and ensuring they are accountable for data quality and standards, which directly addresses resolving data ownership issues. While backup, security, and performance tuning are critical tasks, they are typically executed by database administrators or specialized engineers rather than the data administrator. Therefore, resolving data ownership issues is the distinct function performed by this specific role.

Question 4 Easy Mcq

✓ Correct ✗ Incorrect

One of the important functions of a dbms is to provide the necessary tools for ________.

Administering the database

Storing data types such as images, audio, and videos in organizations

Application programs

Administration

Explanation:

A Database Management System (DBMS) serves as the essential software layer that enables database administrators to manage, secure, and maintain the database environment effectively. It provides critical utilities for performing routine tasks such as user access control, backup and recovery, and performance tuning, which are fundamental to administering the database. Without these built-in administrative tools, organizations would lack the necessary mechanisms to ensure data integrity and availability. Consequently, the primary function highlighted here is the provision of tools specifically designed for administering the database infrastructure. This capability distinguishes a DBMS from simple file storage systems by adding a layer of professional management and control.

Question 5 Easy Mcq

✓ Correct ✗ Incorrect

Flat, raised, sunken, etched, shadowed, and chiseled are options for the ____ control property.

Ribbon

Special Effect

Shift

Multiple

Explanation:

The Special Effect property in Microsoft Access allows users to modify the visual appearance of a control by applying specific graphical styles. Options like Flat, Raised, Sunken, and Chiseled are standard settings within this property that determine how a control is rendered on the form or report. By selecting one of these values, developers can create depth and dimension without needing complex image editing. This feature is essential for enhancing the user interface aesthetics and providing visual cues about the control's state. It directly influences the rendering engine to apply the chosen shadow or border style.

Question 6 Easy Mcq

✓ Correct ✗ Incorrect

The ____ establishes the naming conventions for tables, fields, and indexes in the data dictionary.

users

DBMS

DBA

Programmers.

Explanation:

The Database Administrator (DBA) is the primary professional responsible for defining and enforcing the structural rules of a database system. This role involves creating the data dictionary, which serves as a central repository for metadata describing all database objects. Within this dictionary, the DBA explicitly sets the naming conventions for tables, fields, and indexes to ensure consistency and avoid conflicts. By establishing these standards, the DBA maintains data integrity and simplifies the management of complex database environments for all users. This centralized governance prevents ambiguity and ensures that the database schema remains organized and efficient over time.

Question 7 Easy Mcq

✓ Correct ✗ Incorrect

We prevent a user from updating a table by:

Blocking the table

Granting a right

Revoking a right

Blocking the columns

Explanation:

To stop a user from updating a table, you must remove their permission to perform that specific action. This is achieved by revoking the UPDATE right, which immediately denies the privilege and prevents any modification attempts. Once the right is revoked, the database system will reject any update commands issued by that user, ensuring data integrity. This method relies on the principle of least privilege, where access is granted only when needed and removed when no longer required.

Question 8 Easy Mcq

✓ Correct ✗ Incorrect

Management of classified data includes its storage and _________.

Systems-specific

Risk identification

Distribution, portability, and destruction (All of the above)

Disadvantage

Explanation:

Managing classified data requires a comprehensive lifecycle approach that extends beyond simple storage to include secure distribution, ensuring portability across environments, and proper destruction when no longer needed. These steps collectively prevent unauthorized access and data breaches throughout the entire existence of the information. By addressing all these critical stages, organizations maintain strict compliance with security policies and safeguard sensitive information from loss or leakage. This holistic strategy ensures that data remains protected from creation until it is permanently and securely erased. Therefore, the complete management process inherently encompasses distribution, portability, and destruction as essential components.

Question 9 Medium Mcq

✓ Correct ✗ Incorrect

If both data and database administration exist in an organization, the database administrator is responsible for which of the following?

All of these

Database design

Metadata

Data Modeling

Explanation:

The database administrator holds primary responsibility for the technical architecture and structural integrity of the database system, which encompasses database design and data modeling. While data administration often focuses on business requirements and metadata governance, the DBA executes the technical implementation of these designs. This role ensures that the database schema is optimized for performance, security, and scalability to meet organizational needs. Consequently, the creation and refinement of the database structure fall squarely within the DBA's core duties.

Question 10 Easy Mcq

✓ Correct ✗ Incorrect

What does RDBMS stand for?

Relational Database Micro System

Relational Database, Microsoft

Rational Database Management System

Relational Database Management System

Explanation:

RDBMS stands for Relational Database Management System, which is the standard industry term for software that organizes data into structured tables with defined relationships. This system uses SQL to manage data integrity, enforce constraints, and handle complex queries efficiently across various applications. The "Relational" aspect refers to the mathematical model of storing data in rows and columns, while "Management System" highlights its role in administering storage, security, and concurrency. Therefore, option D is the only choice that accurately reflects the full technical definition of this essential database architecture.

Question 11 Easy Mcq

✓ Correct ✗ Incorrect

Poor data administration can lead to which of the following?

Missing data elements

A single definition of the same data entity

Familiarity with existing data

All of these

Explanation:

Poor data administration often results in missing data elements because inadequate governance fails to enforce mandatory entry rules or track data lineage effectively. Without proper oversight, critical fields remain empty or are lost during system migrations, directly causing gaps in the information repository. This lack of discipline prevents organizations from maintaining complete and accurate records necessary for reliable decision-making. Consequently, the absence of structured management leads directly to incomplete datasets rather than ensuring consistency or familiarity. Ultimately, weak administrative practices create vulnerabilities that allow data to disappear or become unusable over time.

Question 12 Easy Mcq

✓ Correct ✗ Incorrect

Which of the following is part of an administrative policy to secure a database?

All of these

Ensure appropriate responses rates are in external maintenance agreements

Authentication policies

Limiting particular areas within a building to only authorized people

Explanation:

Administrative policies for database security encompass a broad range of organizational rules designed to protect data integrity and confidentiality. This includes defining strict authentication protocols to verify user identities and establishing external maintenance agreements that mandate specific response times for security incidents. Additionally, physical access controls, such as restricting building areas to authorized personnel, are integral components of a comprehensive security strategy. By integrating these diverse measures, an organization creates a layered defense that addresses both logical and physical threats effectively.

Question 13 Easy Mcq

✓ Correct ✗ Incorrect

A default object is?

A stored procedure that activates when data is added, edited or deleted from a table

A set of T-SQL statements designed to perform a set task similar to a macro

An object assigned to a column which defines a value to be used if nothing is entered

An object assigned to a column which defines how data can be added

Explanation:

A default object is a database constraint assigned directly to a specific column to automatically supply a value when an INSERT statement omits that field. This mechanism ensures data integrity by preventing null entries for critical fields without requiring the user to manually provide a value every time. It functions as a pre-defined placeholder that activates specifically during data insertion operations, streamlining the data entry process. By defining a fallback value, the database guarantees that the column always contains valid data according to the schema requirements. This behavior distinguishes it from triggers or stored procedures which handle more complex logic or multiple table events.

Question 14 Easy Mcq

✓ Correct ✗ Incorrect

Failure to control confidentiality may lead to loss of competitiveness.

False

True

Explanation:

Maintaining strict confidentiality is essential for protecting sensitive business strategies, proprietary data, and trade secrets. When an organization fails to control who accesses this information, competitors can exploit these leaks to replicate products or undercut market positioning. Consequently, the erosion of unique advantages directly results in a significant loss of competitive edge and market share. Therefore, the statement accurately reflects the critical link between data security and business competitiveness.

Question 15 Easy Mcq

✓ Correct ✗ Incorrect

Constraints are

A way of organising data in a table

Precompiled queries that are stored in the database

A way of providing a different perspective on data stored in the database

A way of checking that inserted values are within an acceptable range

Explanation:

Constraints act as essential rules that enforce data integrity by validating every value before it is stored in a database. They ensure that inserted data falls within a specific acceptable range or meets defined conditions, preventing invalid or inconsistent information from corrupting the dataset. By strictly checking these parameters during the insertion process, the database maintains high accuracy and reliability for all subsequent operations. This mechanism protects the system from user errors and guarantees that the stored information remains logically consistent and trustworthy.

Question 16 Easy Mcq

✓ Correct ✗ Incorrect

Which of the following could cause data to be unavailable?

Data becoming lost or inaccurate

Planned database maintenance activities

All of these

The database server

Explanation:

Data unavailability often stems from a combination of factors including accidental data loss, inaccuracies during updates, or intentional downtime for scheduled maintenance. When a database server encounters hardware failures or requires critical updates, it may temporarily stop responding to requests, rendering data inaccessible. Since all these scenarios represent valid reasons for service interruption, the comprehensive option that encompasses these various causes is the correct choice. Understanding these diverse triggers helps in designing robust systems with better redundancy and recovery strategies.

Question 17 Easy Mcq

✓ Correct ✗ Incorrect

Unix allows permissions to be assigned to ________.

The account that owns the file or directory

A group associated with the directory

Everyone else

All of the above

Explanation:

Unix file permissions are structured into three distinct categories to manage access control effectively. The first category applies specifically to the user account that owns the file, while the second covers the group associated with that file or directory. The third category grants permissions to everyone else who does not fall into the first two groups. This comprehensive three-tier system ensures that ownership, group collaboration, and public access can all be managed independently and securely within the operating system.

Question 18 Easy Mcq

✓ Correct ✗ Incorrect

A torn page is where

A database object is split between 2 pages

Part of the page has become corrupt

Part of the page is not contiguously written to disk

Part of the page is not written to disk

Explanation:

A torn page occurs when a database page is modified in memory but the changes are not successfully flushed to the disk before a crash or failure. This results in the page being partially written, leaving some data missing from the physical storage. Consequently, the page is considered torn because it is not fully written to disk, requiring recovery mechanisms to restore consistency. This state differs from corruption or logical splits, as it specifically refers to the incomplete writing process to the storage medium.

Question 19 Easy Mcq

✓ Correct ✗ Incorrect

A data administrator is also known as a(n) _____.

Data security officer

Systems administrator

Information resource manager

Information engineering officer

Explanation:

An Information Resource Manager is the professional title often used interchangeably with a data administrator because they oversee the organization's data assets as a strategic resource. This role involves defining data standards, managing data quality, and ensuring that data policies align with business goals to maximize value. By treating data as a critical asset rather than just a byproduct of operations, this position ensures efficient utilization and governance across the enterprise. The terminology reflects the shift from viewing data as a technical utility to recognizing it as a core business resource that requires dedicated management. Consequently, the terms data administrator and information resource manager describe the same essential function within an organization. This alignment makes option C the accurate choice for this specific definition.

Question 20 Easy Mcq

✓ Correct ✗ Incorrect

Performance analysis and tuning is which of the following?

Undertaken as an ongoing part of managing a database

Undertaken one time at the time of a DBMS installation

Undertaken as an ongoing part of the backup of a database

Undertaken one time at the time of the implementation of a new application

Explanation:

Performance analysis and tuning is an iterative process essential for maintaining optimal database efficiency over time. As data volumes grow and usage patterns evolve, query execution plans and resource consumption change, requiring continuous monitoring and adjustment. This ongoing effort ensures the database system adapts to increasing workloads without degradation in speed or reliability. Treating it as a one-time task would ignore dynamic changes that inevitably occur during the database lifecycle. Therefore, it must be integrated into regular management routines rather than performed only during installation or backups.

Question 21 Easy Mcq

✓ Correct ✗ Incorrect

An extent is a block of .... pages

Explanation:

In standard Linux file systems like ext2, ext3, and ext4, an extent is a contiguous block of disk space represented by a single entry in the extent tree. This structure allows the filesystem to manage large, continuous regions of free or allocated space efficiently. Each extent specifically consists of 8 pages, which simplifies the mapping of logical blocks to physical disk sectors. By grouping pages into these fixed-size extents, the system reduces metadata overhead and improves performance for large file operations.

Question 22 Easy Mcq

✓ Correct ✗ Incorrect

_____ are used to control the behavior or interactivity of the field in database objects.

Field size

Field properties

Remove the filter

Primary key field

Explanation:

Field properties are the specific settings that dictate how a field behaves within a database object, defining its interactivity and data constraints. These properties include attributes like data type, validation rules, and default values, which collectively control how users can input or manipulate data. By configuring these settings, developers ensure data integrity and enforce specific logic without altering the underlying structure. Consequently, they serve as the primary mechanism for managing the functional behavior of fields in any relational database system.

Question 23 Easy Mcq

✓ Correct ✗ Incorrect

The ability to do an action on a table is called

A token

A password

A right

An action

Explanation:

In the context of database management systems, a right is a specific permission that grants a user the ability to perform particular actions on a table, such as selecting or inserting data. This concept is fundamental to access control, ensuring that only authorized individuals can execute specific operations on sensitive information. By assigning distinct rights, administrators can precisely define what actions are allowed for each user, thereby maintaining data security and integrity. Without these defined rights, the system would not be able to enforce restrictions on who can modify or view the stored records. Therefore, the capability to act upon a table is technically and legally defined as a right within the security framework.

Filter by Difficulty

easy medium hard

Track Progress

Difficulty Filter

easy Easy

medium Medium

hard Hard

Other Subjects

Business Finance & Management

Industrial Engineering & Manufacturing

IT & Programming

Design & Multimedia

Content Writing & Translation

Administrative Support

Quick Navigation

Other Data Management & Databases Subjects

Database Administration - Data Management & Databases

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Explanation:

Filter by Difficulty

Track Progress

Difficulty Filter

Other Subjects

Other Data Management & Databases Subjects

Quick Navigation

Similar Practices