What is SQLite?

• A web browser
• A server-based RDBMS
• A self-contained, serverless SQL database engine
• A JavaScript framework

What file extension is commonly used for SQLite databases?

• .db
• .sqlite
• .sqlitedb
• All of the above

Which command is used to create a new table in SQLite?

• CREATE NEW
• TABLE MAKE
• CREATE TABLE
• MAKE TABLE

Which function is used to get the current date in SQLite?

• NOW()
• CURDATE()
• CURRENT_DATE()
• GETDATE()

What is the default datatype for numeric values in SQLite?

• INTEGER
• FLOAT
• NUMERIC
• REAL

How can you check the SQLite version?

• SELECT version()
• PRAGMA version
• SELECT sqlite_version()
• .version

Which of the following best describes a pragma in SQLite?

• A stored procedure
• A schema object
• A command to modify database operation
• An error handler

What does the "AUTOINCREMENT" keyword do in SQLite?

• Forces unique values
• Creates a foreign key
• Automatically generates a value
• Adds index to column

Which keyword is used to ensure column uniqueness?

• PRIMARY
• KEY
• UNIQUE
• NOT NULL

How are Boolean values stored in SQLite?

• As BOOLEAN type
• As TRUE/FALSE
• As integers 1 and 0
• As text values

What does the WITHOUT ROWID optimization in SQLite do?

• Disables indexes
• Uses B-Trees directly
• Removes all rows
• Makes foreign keys faster

What is a virtual table in SQLite?

• A table stored in memory
• A table that exists temporarily
• A table backed by an external module
• A table that cannot be queried

What is the purpose of the FTS5 extension in SQLite?

• To enforce foreign keys
• To improve indexing
• To enable full-text search
• To run triggers

Which SQLite feature is used for implementing upsert?

• REPLACE clause
• ON CONFLICT DO UPDATE
• TRIGGER BEFORE INSERT
• UPSERT function

What is the default journaling mode in SQLite?

• OFF
• MEMORY
• WAL
• DELETE