FREE ADC Security Protocols & Access Control Questions and Answers

Question 1

What is the main purpose of access control in a database?

Accepted Answer

To restrict unauthorized data access.

Answer

To organize files alphabetically.

Answer

To encrypt all tables.

Answer

To automatically back up data.

Question 2

What does authentication verify?

Accepted Answer

User identity.

Answer

System settings.

Answer

IP location.

Answer

Browser history.

Question 3

Which of the following is an example of multi-factor authentication?

Accepted Answer

Password and fingerprint.

Answer

Username only.

Answer

Password only.

Answer

Security question.

Question 4

What is the principle of least privilege?

Accepted Answer

Users get minimum access rights.

Answer

All users are administrators.

Answer

Guests get more access.

Answer

Everyone has full access.

Question 5

Which SQL command controls user access to database objects?

Accepted Answer

GRANT

Answer

SELECT

Answer

INSERT

Answer

UPDATE

Question 6

What does role-based access control (RBAC) rely on?

Accepted Answer

User roles.

Answer

Time of access.

Answer

User email domain.

Answer

Table size.

Question 7

What is the function of database auditing?

Accepted Answer

Monitors and logs database activity.

Answer

Deletes unused tables.

Answer

Increases backup speed.

Answer

Optimizes queries.

Question 8

What risk does SQL injection pose?

Accepted Answer

Allows unauthorized access or manipulation of data.

Answer

Slows down the database.

Answer

Increases storage needs.

Answer

Deletes all indexes.

Question 9

How can you prevent SQL injection attacks?

Accepted Answer

Use parameterized queries.

Answer

Encrypt table names.

Answer

Disable the internet.

Answer

Add more indexes.