Skip to content

Generic filters

Exact matches only

Cybersecurity
AI & Privacy
Cloud
OS
Databases
Networks
Web Apps
Mobile Apps
Servers
Virtualization
Containers

Home
Audit Collections
Trainings
Blog
Glossary
Contact

Generic filters

Exact matches only

Database Server Security Audit Quiz

Database Server Security Audit Quiz

Refresh page if Quiz does not AUTOSTART in 5 seconds

Time limit: 0

Quiz Summary

0 of 20 Questions completed

Questions:

Information

You have already completed the quiz before. Hence you can not start it again.

Quiz is loading…

You must sign in or sign up to start the quiz.

You must first complete the following:

Results

Quiz complete. Results are being recorded.

Results

0 of 20 Questions answered correctly

Your time:

Time has elapsed

You have reached 0 of 0 point(s), (0)

Earned Point(s): 0 of 0, (0)
0 Essay(s) Pending (Possible Point(s): 0)

Categories

Not categorized 0%

maximum of 20 points
Pos.	Name	Entered on	Points	Result
Table is loading
No data available

Would you like to submit your quiz result to the leaderboard?

Loading

Name: E-Mail:

Captcha:

captcha

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

Question 1 of 20

1. Question

Select the SQL command(s) in the DDL category

Create
Correct Incorrect Correct answer

Alter
Correct Incorrect Correct answer

Drop
Correct Incorrect Correct answer

Select
Correct Incorrect Correct answer

Insert
Correct Incorrect Correct answer

Update
Correct Incorrect Correct answer

Delete
Correct Incorrect Correct answer

Grant
Correct Incorrect Correct answer

Revoke
Correct Incorrect Correct answer

Deny
Correct Incorrect Correct answer
Question 2 of 20

2. Question

Select the SQL command(s) in the DML category

Select
Correct Incorrect Correct answer

Insert
Correct Incorrect Correct answer

Update
Correct Incorrect Correct answer

Delete
Correct Incorrect Correct answer

Create
Correct Incorrect Correct answer

Alter
Correct Incorrect Correct answer

Drop
Correct Incorrect Correct answer

Grant
Correct Incorrect Correct answer

Revoke
Correct Incorrect Correct answer

Deny
Correct Incorrect Correct answer
Question 3 of 20

3. Question

Select the SQL command(s) in the DCL category

Grant
Correct Incorrect Correct answer

Revoke
Correct Incorrect Correct answer

Deny
Correct Incorrect Correct answer

Create
Correct Incorrect Correct answer

Alter
Correct Incorrect Correct answer

Drop
Correct Incorrect Correct answer

Select
Correct Incorrect Correct answer

Insert
Correct Incorrect Correct answer

Update
Correct Incorrect Correct answer

Delete
Correct Incorrect Correct answer

Question 4 of 20

4. Question

Drag the SQL statement category to the appropriate definition

Sort elements

DDL
DML
DCL

Statements for database objects lifecycle.

Correct Incorrect Correct answer

Statements for querying and modifying data.

Correct Incorrect Correct answer

Statements for database objects security permissions.

Correct Incorrect Correct answer

Question 5 of 20

5. Question

Write the default port used by Microsoft SQL Server for remote client connections to a database?

BLANK 1 of 1

Fill in the blank 1 of 1
Question 6 of 20

6. Question

Write the default port used by Oracle Database Listener for remote client connections to a database?

BLANK 1 of 1

Fill in the blank 1 of 1
Question 7 of 20

7. Question

Write the default port used by MySQL Server for remote client connections to a database?

BLANK 1 of 1

Fill in the blank 1 of 1

Question 8 of 20

8. Question

Drag the BEST data protection method for each scenario

Sort elements

Encryption
Hashing
Masking
HTTPS

Data at rest

Correct Incorrect Correct answer

Data Integrity

Correct Incorrect Correct answer

Data sharing with third-parties

Correct Incorrect Correct answer

Data in transit

Correct Incorrect Correct answer

Question 9 of 20

9. Question

What is the BEST method to store protected Payment Card Information (PCI) in a database that will prevent it from being easily reversed to plain text?

Hashing
Correct Incorrect Correct answer

Masking
Correct Incorrect Correct answer

Encryption
Correct Incorrect Correct answer

None of the above
Correct Incorrect Correct answer
Question 10 of 20

10. Question

db_owner, db_datareader & db_datawriter built-in database roles are applicable to which database server?

Microsoft SQL
Correct Incorrect Correct answer

Oracle
Correct Incorrect Correct answer

MySQL
Correct Incorrect Correct answer

PostgreSQL
Correct Incorrect Correct answer
Question 11 of 20

11. Question

sysdba & sysoper are built-in privileges applicable to which database server?

Oracle
Correct Incorrect Correct answer

Microsoft SQL
Correct Incorrect Correct answer

MySQL
Correct Incorrect Correct answer

PostgreSQL
Correct Incorrect Correct answer
Question 12 of 20

12. Question

Which authentication mode in MSSQL Server provides the highest level of security in a domain environment?

Windows Authentication
Correct Incorrect Correct answer

SQL Server Authentication
Correct Incorrect Correct answer
Question 13 of 20

13. Question

The SQL statement CREATE DATABASE example_db CHARACTER SET utf8mb4; is specific to:

MySQL
Correct Incorrect Correct answer

MSSQL
Correct Incorrect Correct answer

Oracle
Correct Incorrect Correct answer

PostgreSQL
Correct Incorrect Correct answer
Question 14 of 20

14. Question

The SQL statement CREATE DATABASE example_db CHARACTER SET AL32UTF8; is specific to:

Oracle
Correct Incorrect Correct answer

MSSQL
Correct Incorrect Correct answer

MySQL
Correct Incorrect Correct answer

PostgreSQL
Correct Incorrect Correct answer
Question 15 of 20

15. Question

Select all database object(s)

Tables
Correct Incorrect Correct answer

Views
Correct Incorrect Correct answer

Stored Procedures
Correct Incorrect Correct answer

Users
Correct Incorrect Correct answer

Roles
Correct Incorrect Correct answer

Schemas
Correct Incorrect Correct answer

Queries
Correct Incorrect Correct answer

Hint

Database objects are components within a database management system (DBMS) that allows for storing, retrieving and controlling data.
Question 16 of 20

16. Question

Splunk, Nagios and Sentinel are examples of ________ solutions

SIEM
Correct Incorrect Correct answer

NAC
Correct Incorrect Correct answer

IAM
Correct Incorrect Correct answer

WAF
Correct Incorrect Correct answer

Question 17 of 20

17. Question

Drag the IDE solutions to the applicable database server

Sort elements

Management Studio
SQL Developer
Workbench

Microsoft SQL

Correct Incorrect Correct answer

Oracle Database

Correct Incorrect Correct answer

MySQL

Correct Incorrect Correct answer

Question 18 of 20

18. Question

One of the core features of a Database Activity Monitoring (DAM) solution is to help detect and prevent

SQL Injection
Correct Incorrect Correct answer

Cross Site Scripting (XSS)
Correct Incorrect Correct answer

Insecure Direct Object Reference (IDOR)
Correct Incorrect Correct answer

Cross Site Request Forgery (CSRF)
Correct Incorrect Correct answer

Question 19 of 20

19. Question

Drag the property to the applicable description

Sort elements

Atomicity
Consistency
Isolation
Durability

Ensures that each transaction is treated as a single unit, which either completely succeeds or completely fails.

Correct Incorrect Correct answer

Ensures that a transaction brings the database from one valid state to another valid state, maintaining all predefined rules.

Correct Incorrect Correct answer

Ensures that the operations of one transaction are separated from those of other transactions.

Correct Incorrect Correct answer

Ensures that once a transaction is committed, its changes are permanent and will survive any subsequent system failures.

Correct Incorrect Correct answer

Hint

ACID is an acronym for Atomicity, Consistency, Isolation & Durability, representing the four key properties of a transaction in a database management system to ensure reliability and consistency.

Question 20 of 20

20. Question

Select only the Relational Database Management Systems (RDBMS) from the list

Oracle
Correct Incorrect Correct answer

Microsoft SQL
Correct Incorrect Correct answer

MySQL
Correct Incorrect Correct answer

PostgreSQL
Correct Incorrect Correct answer

Db2
Correct Incorrect Correct answer

CockroachDB
Correct Incorrect Correct answer

YugabyteDB
Correct Incorrect Correct answer

MongoDB
Correct Incorrect Correct answer

DynamoDB
Correct Incorrect Correct answer

Copyright © 2026 | Euriun Technologies | All Rights Reserved.

The guidance, recommendations and procedures on this site is for information purposes only.

Not all recommendations is applicable to all technology environments. Before acting on any recommendation from this site, independently evaluate the security, legal, technical, compliance and reputational implications, considering the unique technology configurations in each scenario.

In your workplace, consult the neccessary Information Technology and/or Security Unit before implementing any recommendation from this site.

Pin It on Pinterest