Introduction To The SQLite C/C++ Interface

Introduction To The SQLite C/C++ Interface

Assessment

Assessment

Created by

Angela Gregory

others

Hard

Student preview

quiz-placeholder

43 questions

Show all answers

1.

OPEN ENDED

30 sec • 1 pt

sqlite3

Answer explanation

The database connection object. Created by sqlite3_open() and destroyed by sqlite3_close().

2.

OPEN ENDED

30 sec • 1 pt

sqlite3_stmt

Answer explanation

The prepared statement object. Created by sqlite3_prepare() and destroyed by sqlite3_finalize().

3.

OPEN ENDED

30 sec • 1 pt

sqlite3_open()

Answer explanation

Open a connection to a new or existing SQLite database. The constructor for sqlite3.

4.

OPEN ENDED

30 sec • 1 pt

sqlite3_prepare_v2()

Answer explanation

Compile SQL text into byte-code that will do the work of querying or updating the database. The constructor for sqlite3_stmt.

5.

OPEN ENDED

30 sec • 1 pt

sqlite3_bind()

Answer explanation

Store application data into parameters of the original SQL.

6.

OPEN ENDED

30 sec • 1 pt

sqlite3_step()

Answer explanation

Advance an sqlite3_stmt to the next result row or to completion.

7.

OPEN ENDED

30 sec • 1 pt

sqlite3_column()

Answer explanation

Column values in the current result row for an sqlite3_stmt.

8.

OPEN ENDED

30 sec • 1 pt

sqlite3_finalize()

Answer explanation

Destructor for sqlite3_stmt.

9.

OPEN ENDED

30 sec • 1 pt

sqlite3_close()

Answer explanation

Destructor for sqlite3.

10.

OPEN ENDED

30 sec • 1 pt

sqlite3_exec()

Answer explanation

A wrapper function that does sqlite3_prepare(), sqlite3_step(), sqlite3_column(), and sqlite3_finalize() for a string of one or more SQL statements.

Explore all questions with a free account

or continue with
Microsoft
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?