Database Design & Development- Testing & Security 1

What does the principle of least privilege entail in database security?

• Granting users full access by default

• Denying all access to users by default

• Granting users the minimum level of access required

• Granting users access based on their seniority

Which type of attack involves inserting malicious SQL statements into an entry field?

• Phishing

• SQL Injection

• Cross-site scripting

• Man-in-the-middle

Which principle of the CIA triad is most concerned with ensuring data is accurate and trustworthy?

• Confidentiality

• Integrity

• Availability

• Authentication

What is the meaning of 'data masking' in the context of database security?

• Encrypting data for secure transmission

• Hiding data by scrambling it

• Deleting redundant data

• Copying data to a secure location

During database testing, what is the purpose of a 'stress test'?

• To check the database for vulnerabilities

• To evaluate database performance under heavy load

• To verify data integrity

• To ensure database backup procedures are working

Which of the following is a method for ensuring data integrity in a database?

• Data Encryption

• Data Validation

• Data Masking

• Data Backups

Which of the following is a primary objective of white box testing in databases?

• To verify the database schema

• To validate database transactions

• To check the internal logic of stored procedures and functions

• To confirm data integrity constraints

During black box testing, which approach is typically utilised to validate the accuracy of data relationships and constraints?

• Data flow testing

• Functional testing

• Regression testing

• Structural testing

Which form of database validation ensures that data entered into the system conforms to a specific format, such as a postcode or email address?

• Length Check

• Format Check

• Range Check

• Consistency Check

Which type of verification technique involves comparing data input into the system with the original source document to ensure accuracy?

• Double Entry

• Data Masking

• Cross-Field Validation

• Source Document Verification