User profile management in No-Code - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to create a new user profile with a unique username.

No-Code

Create user profile with username: [1]

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

Aunique_username

Bpassword123

Cemail_address

Ddate_of_birth

Attempts:

3 left

💡 Hint

Common Mistakes

Using password or email as username, which are not unique identifiers in this context.

The username must be unique to identify the user profile correctly.

2fill in blank

medium

Complete the code to update the user's email address in their profile.

No-Code

Update user profile set email = [1] where username = 'john_doe'

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

A'password123'

B'123456'

C'John Doe'

D'[e-mail]'

Attempts:

3 left

💡 Hint

Common Mistakes

Using password or name instead of email address.

Not enclosing the email in quotes.

The email field should be updated with a valid email address enclosed in quotes.

3fill in blank

hard

Fix the error in the code to delete a user profile by username.

No-Code

Delete from users where username = [1]

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

Ausername

Bjohn_doe

C'john_doe'

D"john_doe"

Attempts:

3 left

💡 Hint

Common Mistakes

Not using quotes around the username string.

Using double quotes which may not be valid in some SQL dialects.

The username value must be enclosed in single quotes to be recognized as a string.

4fill in blank

hard

Fill both blanks to filter user profiles created after 2020 and sort by username.

No-Code

Select * from users where created_date [1] '2020-12-31' order by [2]

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

A>

Busername

C<

Dcreated_date

Attempts:

3 left

💡 Hint

Common Mistakes

Using '<' instead of '>' for filtering dates.

Ordering by date instead of username.

The filter uses '>' to get users created after the date, and sorting is done by username.

5fill in blank

hard

Fill all three blanks to create a dictionary of usernames and emails for active users.

No-Code

user_emails = { [1]: [2] for user in users if [3] == True }

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

Auser.username

Buser.email

Cis_active

Duser.is_active

Attempts:

3 left

💡 Hint

Common Mistakes

Using 'is_active' without 'user.' prefix.

Swapping keys and values.

Checking 'is_active' without referencing the user object.

The dictionary keys are usernames, values are emails, and the filter checks if the user is active using 'user.is_active'.