Show:
Advanced SQL
Database optimization
Database Security
Distributed Databases
Miscellaneous
100

SQL Command for creating a database

CREATE database [database_name];

100

What is the basic unit of measurement to measure database optimization?

Time (e.g., seconds)

100

Your database is no longer accessible from outside your organization. This is an example of an attack on the database ... 

Availability

100
How do distributed databases reduce the risk of failure?

They eliminate the problem of single-point of failure

100

The two main actors that participate in any database transaction

Client and server

200

SQL command to remove the permission/privileges of a user

REVOKE

200

The two commands that allow transaction control in an RDBMS

COMMIT and ROLLBACK

200

You willingly gave hackers your credentials for accessing a database because you thought it was your manager. This is an example of ...

Phishing or social engineering

200

Distributed database technology is commonly confused with cryptocurrency

Blockchain

200
Formal name for virtual tables on SQL

VIEW

300

SQL command to change the structure of a table (e.g., add/remove column)

ALTER TABLE

300

Database mechanism that allows DBMS to process concurrent requests while maintaining transaction isolation

Locks

300
Database attack that exploits the lack or poor user parameter sanitization 

SQL Injection

300

What are the two storage processes distributed databases rely on?

Replication and fragmentation
300

From the query processing flow, which phase takes most of the processing time

Parsing

400

SQL Command for removing all the data stored inside a table.

TRUNCATE

400

Database mechanism that can improve the speed of a SQL transaction

INDEX

400

This attack is known for affecting the availability of a database by encrypting all the files of a system and charging money for the private key

Ransomware

400

Round-robing data partition is a method for ...

Data fragmentation
400

What does ACID stands for?

Atomicity, consistency, isolation, and durability

500

SQL Command that is used for collapsing data into one column to compute information

GROUP BY

500

List all the phases of the query processing flow

Parsing, execution, and fetching

500

Underestimated method to improve database security that does not require the implementation of technical controls

Training

500

New nodes can be added to the database network without causing a disruption. This is an example of a benefit called ...

Growth facilitation

500

Default port for MySQL

3306