Data types and database setup in No-Code - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to define a text data type in a database.

No-Code

CREATE TABLE users (name [1](50));

Drag options to blanks, or click blank then click option'

ADATE

BNUMBER

CVARCHAR

DBOOLEAN

Attempts:

3 left

💡 Hint

Common Mistakes

Using NUMBER instead of VARCHAR for text fields.

Using DATE for storing names.

The VARCHAR data type is used to store text strings of variable length in a database.

2fill in blank

medium

Complete the code to set up a primary key in a database table.

No-Code

CREATE TABLE products (id [1] PRIMARY KEY, name VARCHAR(100));

Drag options to blanks, or click blank then click option'

ATEXT

BINT

CFLOAT

DBOOLEAN

Attempts:

3 left

💡 Hint

Common Mistakes

Using TEXT for primary keys which should be numeric.

Using BOOLEAN which only stores true or false.

The INT data type is commonly used for primary keys because it stores whole numbers uniquely identifying each record.

3fill in blank

hard

Fix the error in the data type declaration for a date field.

No-Code

CREATE TABLE events (event_date [1]);

Drag options to blanks, or click blank then click option'

ADATETIME

BVARCHAR

CNUMBER

DDATE

Attempts:

3 left

💡 Hint

Common Mistakes

Using VARCHAR to store dates as text.

Using NUMBER which is for numeric values.

The correct data type for storing dates without time is DATE. DATETIME includes time, VARCHAR stores text, and NUMBER stores numbers.

4fill in blank

hard

Fill both blanks to create a table with an auto-incrementing integer ID and a boolean active status.

No-Code

CREATE TABLE accounts (id [1] PRIMARY KEY [2], active BOOLEAN);

Drag options to blanks, or click blank then click option'

AINT

BAUTO_INCREMENT

CNOT NULL

DDEFAULT TRUE

Attempts:

3 left

💡 Hint

Common Mistakes

Using BOOLEAN for the ID field.

Forgetting to set the ID as auto-incrementing.

The INT data type is used for the ID, and AUTO_INCREMENT makes the ID increase automatically for each new record.

5fill in blank

hard

Fill all three blanks to create a dictionary comprehension that maps uppercase keys to values greater than zero.

No-Code

result = [1]: [2] for k, v in data.items() if v [3] 0}

Drag options to blanks, or click blank then click option'

Ak.upper()

Bv

C>

Dk.lower()

Attempts:

3 left

💡 Hint

Common Mistakes

Using k.lower() instead of k.upper().

Using < instead of > in the condition.

This comprehension creates a new dictionary where keys are uppercase versions of the original keys (k.upper()), values are the same (v), and only includes items where the value is greater than zero (> 0).