Database connections (DBI, RSQLite) in R Programming - Interactive Code Practice

Practice - 5 Tasks

1fill in blank

easy

Complete the code to load the DBI package.

R Programming

library([1])

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

ADBI

BRSQLite

Cdplyr

Dggplot2

Attempts:

3 left

💡 Hint

Common Mistakes

Trying to load RSQLite instead of DBI first.

The library() function loads the DBI package, which is needed to work with databases in R.

2fill in blank

medium

Complete the code to connect to an in-memory SQLite database.

R Programming

con <- DBI::dbConnect([1], ":memory:")

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

ARSQLite::SQLite()

BSQLite

CRSQLite

DDBI

Attempts:

3 left

💡 Hint

Common Mistakes

Passing just 'RSQLite' or 'SQLite' without calling the function.

The dbConnect() function needs the driver object from RSQLite, which is RSQLite::SQLite() for an SQLite database.

3fill in blank

hard

Fix the error in the code to disconnect from the database.

R Programming

DBI::dbDisconnect([1])

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

Aconnection

Bconn

Cdb

Dcon

Attempts:

3 left

💡 Hint

Common Mistakes

Using a variable name that was not defined for the connection.

The connection object was stored in the variable con. You must pass it to dbDisconnect() to close the connection.

4fill in blank

hard

Fill both blanks to create a table named 'people' with columns 'name' and 'age'.

R Programming

DBI::dbExecute(con, "CREATE TABLE [1] ([2] TEXT, age INTEGER)")

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

Apeople

Bperson

Cname

Dfullname

Attempts:

3 left

💡 Hint

Common Mistakes

Using singular table name or wrong column name.

The table name is 'people' and the first column is 'name' of type TEXT.

5fill in blank

hard

Fill all three blanks to insert a person named 'Alice' aged 30 into the 'people' table.

R Programming

DBI::dbExecute(con, "INSERT INTO people ([1], age) VALUES ('[2]', [3])")

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

Aname

BAlice

C30

Dage

Attempts:

3 left

💡 Hint

Common Mistakes

Mixing column names or values, or forgetting quotes around the name.

The column to insert is 'name', the value is 'Alice', and the age is 30.