SQLite - 4 - Creating Tables MCQ

SQLite – Creating Tables

1 / 25

1. What is the primary purpose of creating tables in an SQLite database?

To query data from the database

To define the database schema

To create a database file

To insert data into the database

2 / 25

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

UPDATE TABLE

INSERT INTO

CREATE TABLE

ADD TABLE

3 / 25

3. In SQLite, how do you specify the name of the table when creating it?

After the column definitions

In the VALUES clause

Before the column definitions

By using the ALTER TABLE statement

4 / 25

4. What is the purpose of the “PRIMARY KEY” constraint when creating a table?

It ensures that all columns are unique

It specifies the default value for a column

It defines the first column in the table

It identifies the primary data type

5 / 25

5. Which of the following is a valid SQLite data type for storing date and time values?

TIME

TIMESTAMP

DATE

DATETIME

6 / 25

6. How do you specify the data type of a column when creating a table in SQLite?

By following the column name with the data type

By using the TYPE OF keyword

By using the DATA TYPE keyword

By enclosing the data type in square brackets

7 / 25

7. In SQLite, how do you add a new column to an existing table?

Use the ADD COLUMN statement

Use the ALTER TABLE statement

Use the INSERT COLUMN statement

Use the CREATE COLUMN statement

8 / 25

8. Which keyword is used to specify that a column should allow NULL values when creating a table?

NOT NULL

NONNULL

NULLABLE

ALLOW NULL

9 / 25

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

64KB

255 characters

Unlimited

512 characters

10 / 25

10. Which SQL statement is used to remove a column from an existing table in SQLite?

DELETE COLUMN

REMOVE COLUMN

DROP COLUMN

ERASE COLUMN

11 / 25

11. How do you specify a default value for a column when creating a table in SQLite?

DEFAULT

DEFAULT VALUE

SET DEFAULT

SET VALUE DEFAULT

12 / 25

12. In SQLite, what is the purpose of the “AUTOINCREMENT” keyword when creating a table?

To automatically insert data into a table

To automatically increment the primary key

To automatically update records in a table

To automatically delete rows from a table

13 / 25

13. What is the purpose of the “CHECK” constraint when creating a table in SQLite?

To check for NULL values in columns

To verify the data types of columns

To validate the data against a specific condition

To enforce foreign key relationships

14 / 25

14. Which keyword is used to specify a unique constraint on a column when creating a table?

UNIQUE

DISTINCT

PRIMARY

CONSTRAINT

15 / 25

15. What does the “DEFAULT CURRENT_TIMESTAMP” constraint do in SQLite?

Sets the column to the current date and time

Sets the column to the current date

Sets the column to a default value of "CURRENT_DATE"

Sets the column to a default value of "CURRENT_TIMESTAMP"

16 / 25

16. What is the primary purpose of the “FOREIGN KEY” constraint when creating a table in SQLite?

To enforce uniqueness of values in a column

To specify the primary key of the table

To create an index on the column

To link the table to another table

17 / 25

17. How do you specify a foreign key constraint on a column when creating a table in SQLite?

By using the FOREIGN KEY keyword

By using the FOREIGN REFERENCE keyword

By using the REFERENCES keyword

By using the FOREIGN CONSTRAINT keyword

18 / 25

18. Which SQL command is used to create a unique index on a column when creating a table in SQLite?

CREATE UNIQUE INDEX

INDEX UNIQUE

UNIQUE INDEX

CREATE INDEX

19 / 25

19. What is the purpose of the “IF NOT EXISTS” clause when creating a table in SQLite?

It renames the table if it exists

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

It checks if the table exists and prevents creation

It deletes the table if it exists

20 / 25

20. Which of the following is a valid SQLite data type for storing binary data, such as images?

BLOB

VARBINARY

RAW

BINARY

21 / 25

21. In SQLite, how do you specify that a column should have a unique constraint when creating a table?

By using the PRIMARY keyword

By using the CONSTRAINT keyword

By using the INDEX keyword

By using the UNIQUE keyword

22 / 25

22. What is the primary difference between VARCHAR and CHAR data types in SQLite?

VARCHAR is case-sensitive, CHAR is case-insensitive

VARCHAR is used for numbers, CHAR is used for text

VARCHAR allows for variable-length strings, CHAR is fixed-length

VARCHAR is for small data, CHAR is for large data

23 / 25

23. Which keyword is used to specify a column as the primary key when creating a table in SQLite?

KEY

INDEX

CONSTRAINT

PRIMARY KEY

24 / 25

24. What is the purpose of the “DEFAULT” keyword when creating a table in SQLite?

To specify the default value for a column

To create an index on a column

To check for NULL values in columns

To enforce a primary key constraint

25 / 25

25. In SQLite, what is the maximum number of columns that a table can have?

Unlimited

128

256

Your score is

SQLite – 4 – Creating Tables MCQ