SQLite - 25 - SQLite Command-Line Interface (CLI) MCQ

SQLite – SQLite Command-Line Interface (CLI)

1 / 26

1. What is the primary purpose of the SQLite Command-Line Interface (CLI)?

To design database schemas

To write SQL queries

To manage SQLite databases

To execute Python code

2 / 26

2. What command is used to start the SQLite CLI tool in the terminal?

sqlite-start

startsqlite

opensqlite

sqlite3

3 / 26

3. In SQLite CLI, how do you list all the available SQLite databases?

LIST DATABASES

SHOW DATABASES

.databases

LIST DBS

4 / 26

4. What command is used to open an existing SQLite database in the SQLite CLI?

.open

USE DATABASE

OPEN DATABASE

CONNECT DATABASE

5 / 26

5. In SQLite CLI, how do you display the current date and time?

PRINT DATETIME

GET DATE

.date

SHOW TIME

6 / 26

6. What command is used to execute a SQL script file in the SQLite CLI?

EXECUTE SCRIPT

RUN SCRIPT

EXECUTE FILE

.read

7 / 26

7. In SQLite CLI, how do you exit the CLI tool and close the current database?

CLOSE DATABASE

QUIT

.quit

EXIT

8 / 26

8. What command is used to display the structure of a table in SQLite CLI?

DESCRIBE TABLE

DISPLAY TABLE

.schema TABLE

SHOW STRUCTURE

9 / 26

9. In SQLite CLI, what command is used to set the output mode to CSV format for query results?

SET CSV

FORMAT CSV

OUTPUT CSV

.mode csv

10 / 26

10. What command is used to execute a single SQL statement in SQLite CLI?

RUN SQL

EXECUTE SQL

EXECUTE STATEMENT

.sql

11 / 26

11. In SQLite CLI, what command is used to display the help documentation for available commands?

HELP

.help

DISPLAY HELP

SHOW COMMANDS

12 / 26

12. What command is used to create a new SQLite database file in SQLite CLI?

NEW DATABASE

.open DATABASE

INIT DATABASE

CREATE DATABASE

13 / 26

13. In SQLite CLI, what command is used to change the output format for query results to display in column mode?

MODE COLUMN

SET COLUMN

.mode column

FORMAT COLUMN

14 / 26

14. What command is used to list all the available tables in the current SQLite database in SQLite CLI?

LIST TABLES

.tables

DISPLAY TABLES

SHOW TABLES

15 / 26

15. In SQLite CLI, how do you display the version of the SQLite database software?

VERSION

SHOW VERSION

.version

DISPLAY VERSION

16 / 26

16. What command is used to delete a table from the current SQLite database in SQLite CLI?

DROP TABLE

.drop TABLE

REMOVE TABLE

DELETE TABLE

17 / 26

17. In SQLite CLI, what command is used to enter the interactive mode for running queries?

INTERACTIVE

QUERY MODE

SQL MODE

.interactive

18 / 26

18. What command is used to create a new table in the current SQLite database in SQLite CLI?

NEW TABLE

CREATE TABLE

.table TABLE

INIT TABLE

19 / 26

19. In SQLite CLI, how do you list the indexes associated with a table in the current database?

.indexes TABLE

DISPLAY INDEXES

SHOW INDEXES

LIST INDEXES

20 / 26

20. What command is used to rename a table in the current SQLite database in SQLite CLI?

ALTER TABLE

RENAME TABLE

.rename TABLE

CHANGE TABLE

21 / 26

21. In SQLite CLI, what command is used to display the last inserted row ID after an INSERT operation?

SHOW ROW ID

INSERTED ROW ID

LAST ROWID

.last_insert_rowid

22 / 26

22. What command is used to create an index on a table in the current SQLite database in SQLite CLI?

CREATE INDEX

INIT INDEX

.index TABLE

NEW INDEX

23 / 26

23. In SQLite CLI, how do you enable the display of row headers in query results?

SHOW HEADERS

ENABLE HEADERS

.header ON

DISPLAY HEADERS

24 / 26

24. What command is used to remove an index from a table in the current SQLite database in SQLite CLI?

.drop INDEX

DROP INDEX

REMOVE INDEX

DELETE INDEX

25 / 26

25. In SQLite CLI, what command is used to import data from a CSV file into a table?

IMPORT CSV

INSERT CSV

.import FILE TABLE

LOAD CSV

26 / 26

26. What command is used to export the contents of a table to a CSV file in SQLite CLI?

.output FILE

EXPORT CSV

OUTPUT CSV

SAVE CSV

Your score is

SQLite – 25 – SQLite Command-Line Interface (CLI) MCQ