The SQL ____________ statement is used to validate the uniqueness of values in a column.

  • CHECK
  • CONSTRAINT
  • PRIMARY KEY
  • UNIQUE
The SQL UNIQUE constraint ensures that all values in a column are unique, meaning no two rows in the table have the same value in that column. It's used to enforce data integrity and maintain uniqueness.

What is the significance of referential integrity constraints in data consistency testing?

  • Ensures data is not duplicated
  • Maintains data relationships
  • Optimizes database performance
  • Validates input data against criteria
Referential integrity constraints play a crucial role in data consistency testing by maintaining the relationships between related data in different tables. They ensure that any changes to data maintain the integrity of the relationships defined in the database schema, preventing inconsistencies and errors.

In role-based access control (RBAC), permissions are assigned to ____________ rather than individual users.

  • Roles
  • Groups
  • Users
  • Profiles
In RBAC systems, permissions are associated with roles rather than individual users. This approach simplifies access management by assigning permissions to predefined roles, and users are then assigned to those roles. Hence, the correct option is "Roles."

Which of the following is NOT a common access control method used in database systems?

  • Attribute-based access control
  • Discretionary access control
  • Role-based access control
  • Single sign-on
Single sign-on (SSO) is not typically considered a common access control method used in database systems. Instead, SSO is more commonly associated with authentication systems that allow users to access multiple applications or systems with a single set of credentials, rather than directly controlling access to database resources.

Which testing technique ensures that ETL processes can handle large volumes of data efficiently?

  • Performance Testing
  • Regression Testing
  • Stress Testing
  • Volume Testing
Volume Testing ensures that ETL processes can handle large volumes of data efficiently by testing the system's ability to manage and process a significant amount of data. This helps in identifying bottlenecks and scalability issues before deployment.

In performance testing, what is the purpose of stress testing?

  • To assess database scalability
  • To evaluate system behavior under heavy loads
  • To identify memory leaks
  • To measure response time for typical transactions
Stress testing is used in performance testing to evaluate system behavior under heavy loads. It involves subjecting the system to extreme conditions beyond its normal operational capacity to determine its robustness and ability to handle stress. By simulating high user concurrency, stress testing helps identify performance bottlenecks, weaknesses, and potential failure points in the system.

Which database system feature can help improve query performance by storing precomputed results?

  • Cursors
  • Materialized Views
  • Stored Procedures
  • Triggers
Materialized Views are database objects that store the results of a query as a physical table. They contain precomputed results based on the underlying query, which can help improve query performance by reducing the need to recompute the results every time the query is executed. Materialized Views are especially useful for queries that involve complex calculations or aggregations, as they allow the system to retrieve the results directly from the stored data without having to recompute them from scratch.

Which type of data consistency issue involves duplicate records with slight variations in data values?

  • Data corruption
  • Data duplication
  • Data fragmentation
  • Data normalization
The type of data consistency issue involving duplicate records with slight variations in data values is known as data duplication. This can occur due to various reasons such as human error, system bugs, or improper data entry processes.

Which type of testing tools is commonly used for automating database testing processes?

  • Database testing tools
  • Functional testing tools
  • Performance testing tools
  • Security testing tools
Database testing tools are specifically designed for automating the testing processes related to databases. These tools provide features such as executing SQL queries, comparing expected and actual results, validating data integrity, and managing test data, making them well-suited for database testing automation.

What is the primary objective of data migration testing?

  • Confirming data completeness
  • Ensuring data consistency
  • Validating data accuracy
  • Verifying data integrity
Data migration testing aims primarily at validating data accuracy to ensure that data is transferred correctly and without corruption.