SQLite - 3 - Creating a Database MCQ

SQLite – Creating a Database

1 / 26

1. What is the primary step in creating a new SQLite database?

Defining tables

Inserting data

Specifying data types

Creating the database

2 / 26

2. Which command is used to create a new SQLite database file?

CREATE DATABASE

CREATE TABLE

OPEN DATABASE

CREATE FILE

3 / 26

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

.data

.db

.sql

.sqlite3

4 / 26

4. Which SQLite command is used to connect to an existing database?

LINK DATABASE

ATTACH DATABASE

CONNECT DATABASE

OPEN DATABASE

5 / 26

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

To create a new table

To attach an additional database file

To delete a database

To rename a table

6 / 26

6. Which SQL command is used to create a new table in an SQLite database?

CREATE DATABASE

CREATE TABLE

CREATE SCHEMA

CREATE RECORD

7 / 26

7. In SQLite, how do you specify the columns of a table during creation?

By using the INSERT INTO statement

By using the UPDATE TABLE statement

By using the ALTER TABLE statement

By using the CREATE TABLE statement

8 / 26

8. Which clause is used to define a primary key in an SQLite table?

PRIMARY

PRIMARY KEY

KEY

PRIMARY_ID

9 / 26

9. What happens if you try to create a table with the same name as an existing one in an SQLite database?

An error is raised and the creation fails

The new table replaces the existing one

The existing table is deleted

The new table is created with a new name

10 / 26

10. Which data type is commonly used to store integer values in SQLite?

INT

NUMBER

INTEGER

INT32

11 / 26

11. What is the maximum length of a VARCHAR column in SQLite?

512 characters

Unlimited

255 characters

64KB

12 / 26

12. Which SQLite command is used to delete a table from a database?

DELETE TABLE

REMOVE TABLE

ERASE TABLE

DROP TABLE

13 / 26

13. How do you specify a default value for a column when creating a table?

DEFAULT VALUE

DEFAULT

DEFAULT ATTRIBUTE

DEFAULT COLUMN

14 / 26

14. In SQLite, what is the purpose of the “AUTOINCREMENT” keyword?

To automatically delete rows from a table

To automatically insert data into a table

To automatically update records in a table

To automatically increment the primary key value

15 / 26

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

To begin a new database

To start a new transaction

To start a new query

To delete a table

16 / 26

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

ROLLBACK

COMMIT

END TRANSACTION

TERMINATE TRANSACTION

17 / 26

17. What is the purpose of the SQLite command “COMMIT”?

To end a transaction and save changes

To roll back a transaction

To delete a table

To start a new transaction

18 / 26

18. Which SQL statement is used to add a new column to an existing table in SQLite?

ADD COLUMN

MODIFY COLUMN

INSERT COLUMN

ALTER TABLE

19 / 26

19. Which keyword is used to remove a column from an existing table in SQLite?

REMOVE COLUMN

DROP COLUMN

DELETE COLUMN

ERASE COLUMN

20 / 26

20. In SQLite, what is the purpose of the “IF NOT EXISTS” clause when creating a table?

It ensures that the table is created even if it already exists

It renames the table if it exists

It deletes the table if it exists

It checks if the table exists and prevents creation

21 / 26

21. Which SQL command is used to rename an existing table in SQLite?

MODIFY TABLE

ALTER TABLE

RENAME TABLE

CHANGE TABLE

22 / 26

22. What is the purpose of the “DROP TABLE” command in SQLite?

To delete a table

To delete a row

To delete a database

To delete a column

23 / 26

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

Command-line shell

Graphical user interface

Web browser

Programming language API

24 / 26

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

Connect, Retrieve, Update, Disconnect

Copy, Replace, Unlink, Delete

Compile, Run, Use, Delete

Create, Read, Update, Delete

25 / 26

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

GET

FETCH

QUERY

SELECT

26 / 26

26. In SQLite, how do you specify the columns you want to retrieve in a SELECT statement?

By using the FROM clause

By using the WHERE clause

By listing the column names after SELECT

By using the SELECT ALL keyword

Your score is

SQLite – 3 – Creating a Database MCQ