Encryption Ciphers Overview | Dataford Interview Questions

Describe different encryption ciphers.

Write a SQL query that returns each approved cipher, its family classification, key length, and number of recorded deployments. Include approved ciphers with no deployments and exclude unapproved ciphers.

Output

One row per approved cipher.
Columns: cipher_name, cipher_family, cipher_type, key_length_bits, and deployment_count.
Sort by cipher_family, then cipher_name alphabetically.

Schema

cipher_catalog

Column	Type	Description
cipher_idPK	INT	Unique cipher identifier
cipher_name	VARCHAR(80)	Cipher algorithm name
cipher_family	VARCHAR(20)	Cipher family, such as symmetric or asymmetric
mode	VARCHAR(40)	Cipher mode or construction
key_length_bits	INT	Nominal key length in bits
is_approved	BOOLEAN	Whether the cipher is approved for use

cipher_deployments

Column	Type	Description
deployment_idPK	INT	Unique deployment record identifier
cipher_id	INT	Referenced cipher identifier
deployment_environment	VARCHAR(30)	Environment where the cipher is deployed

Your question is Encryption Ciphers Overview. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem