SQLite - 1 - Introduction to SQLite MCQ

SQLite – Introduction to SQLite

1 / 26

1. What is SQLite?

A programming language

A markup language

A relational database management system

A web development framework

2 / 26

2. Which of the following is true about SQLite’s data storage?

It stores data in a centralized server

It stores data in a file on the local device

It stores data in the cloud

It stores data in a distributed manner

3 / 26

3. In SQLite, what is the maximum size of a single database file?

2 terabytes

16 megabytes

1 petabyte

4 gigabytes

4 / 26

4. Which programming languages have SQLite libraries or bindings available?

Ruby and Java

All of the above

C and C++

Only Python

5 / 26

5. What type of database management system is SQLite classified as?

Key-Value

NoSQL

Relational

GraphDB

6 / 26

6. What file extension is commonly used for SQLite database files?

.data

.db

.sql

.sqlite3

7 / 26

7. Which of the following data types does SQLite support?

ARRAY and OBJECT

INTEGER and FLOAT

ENUM and DECIMAL

BOOLEAN and DATE

8 / 26

8. In SQLite, how do you comment a single line of SQL code?

<!– Comment –>

— Comment

/* Comment */

// Comment

9 / 26

9. What command is used to create a new SQLite database?

CREATE TABLE

CREATE DATABASE ONLY

CREATE DATABASE IF NOT EXISTS

CREATE DATABASE

10 / 26

10. In SQLite, how do you define a primary key constraint when creating a table?

CONSTRAINT PRIMARY KEY

PRIMARY KEY

UNIQUE

11 / 26

11. Which SQL command is used to retrieve data from a SQLite database?

FETCH

SELECT

GET

QUERY

12 / 26

12. What is the purpose of the SQLite command “ATTACH DATABASE”?

To attach an additional database file

To delete a database

To create a new table

To rename a table

13 / 26

13. What happens if you try to insert a row with a duplicate primary key in SQLite?

The new row is added with a new primary key

The existing row is deleted

An error is raised and the insert fails

The new row replaces the existing one

14 / 26

14. Which SQL command is used to delete records from a SQLite table?

DROP

ERASE

DELETE

REMOVE

15 / 26

15. What is the purpose of the SQLite command “VACUUM”?

To optimize and defragment the database

To encrypt the database

To create a backup of the database

To add a new column to a table

16 / 26

16. What is the default isolation level in SQLite?

READ UNCOMMITTED

READ COMMITTED

SERIALIZABLE

NONE

17 / 26

17. In SQLite, what is the purpose of the “UNIQUE” constraint on a column?

It enforces that the column is the only one in the table

It enforces that the column has a unique name

It enforces that the column values are unique

It enforces that the column cannot be NULL

18 / 26

18. What is the purpose of the SQLite command “BEGIN TRANSACTION”?

To begin a new database

To start a new transaction

To delete a table

To start a new query

19 / 26

19. How do you terminate a transaction in SQLite without making any changes?

TERMINATE TRANSACTION

END TRANSACTION

ROLLBACK

COMMIT

20 / 26

20. Which of the following statements is true about indexing in SQLite?

Indexes can only be created on text columns

Indexes are automatically created for all columns

Indexes can only be created on primary keys

Indexes can improve query performance

21 / 26

21. What is the purpose of the SQLite command “ALTER TABLE”?

To delete a table

To rename a table

To add, modify, or delete columns

To change the table's primary key

22 / 26

22. Which of the following is NOT a way to interact with SQLite?

Graphical user interface

Command-line shell

Web browser

Programming language API

23 / 26

23. What does the acronym “ACID” stand for in the context of databases?

All Columns In Database

Atomicity, Consistency, Isolation, Durability

Asynchronous, Concurrent, In-memory, Disk-based

Aggregate, Compute, Insert, Delete

24 / 26

24. In SQLite, what command is used to drop a table from a database?

DELETE TABLE

ERASE TABLE

REMOVE TABLE

DROP TABLE

25 / 26

25. Which of the following is NOT a valid data type in SQLite?

BOOLEAN

INTEGER

TEXT

DATE

26 / 26

26. What does “CRUD” stand for in the context of database operations?

Create, Read, Update, Delete

Compile, Run, Use, Delete

Connect, Retrieve, Update, Disconnect

Copy, Replace, Unlink, Delete

Your score is

SQLite – 1 – Introduction to SQLite MCQ