SQLite Quiz

Which of the following is not a valid SQLite datatype?

• INTEGER

• STRING

• REAL

• BLOB

Which feature describes SQLite's flexible type system?

• Static typing

• Strict typing

• Manifest typing

• None of these

Which SQLite datatype is used to store large binary data?

• TEXT

• INTEGER

• BLOB

• REAL

What does a NULL datatype represent in SQLite?

• Zero

• No value

• Blank text

• Default integer

Which of these is not a fundamental SQL transaction command?

• COMMIT

• ROLLBACK

• SAVEPOINT

• TRUNCATE

What is the purpose of ROLLBACK in SQLite?

• To save changes

• To reverse changes

• To lock a table

• To create triggers

What is COMMIT used for?

• To reverse a transaction

• To start a transaction

• To save a transaction permanently

• To delete a table

Which keyword removes duplicate rows in a SELECT query?

• UNIQUE

• DISTINCT

• FILTER

• EXCEPT

Which clause is used to filter records?

• ORDER BY

• HAVING

• WHERE

• GROUP BY

Which operator checks if a value is within a range?

• IN

• BETWEEN

• LIKE

• UNION