0 of 20 Questions completed
Questions:
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:
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)
Pos. | Name | Entered on | Points | Result |
---|---|---|---|---|
Table is loading | ||||
No data available | ||||
Select the SQL command(s) in the DDL category
Select the SQL command(s) in the DML category
Select the SQL command(s) in the DCL category
Drag the SQL statement category to the appropriate definition
Statements for database objects lifecycle.
|
|
Statements for querying and modifying data.
|
|
Statements for database objects security permissions.
|
|
Write the default port used by Microsoft SQL Server for remote client connections to a database?
Write the default port used by Oracle Database Listener for remote client connections to a database?
Write the default port used by MySQL Server for remote client connections to a database?
Drag the BEST data protection method for each scenario
Data at rest
|
|
Data Integrity
|
|
Data sharing with third-parties
|
|
Data in transit
|
|
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?
db_owner, db_datareader & db_datawriter built-in database roles are applicable to which database server?
sysdba & sysoper are built-in privileges applicable to which database server?
Which authentication mode in MSSQL Server provides the highest level of security in a domain environment?
The SQL statement CREATE DATABASE example_db CHARACTER SET utf8mb4; is specific to:
The SQL statement CREATE DATABASE example_db CHARACTER SET AL32UTF8; is specific to:
Select all database object(s)
Database objects are components within a database management system (DBMS) that allows for storing, retrieving and controlling data.
Splunk, Nagios and Sentinel are examples of ________ solutions
Drag the IDE solutions to the applicable database server
Microsoft SQL
|
|
Oracle Database
|
|
MySQL
|
|
One of the core features of a Database Activity Monitoring (DAM) solution is to help detect and prevent
Drag the property to the applicable description
Ensures that each transaction is treated as a single unit, which either completely succeeds or completely fails.
|
|
Ensures that a transaction brings the database from one valid state to another valid state, maintaining all predefined rules.
|
|
Ensures that the operations of one transaction are separated from those of other transactions.
|
|
Ensures that once a transaction is committed, its changes are permanent and will survive any subsequent system failures.
|
|
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.
Select only the Relational Database Management Systems (RDBMS) from the list