Introduction to SQLite and Its Key Features Quiz

1. What type of database is SQLite commonly classified as?

   What type of database is SQLite commonly classified as for its storage and use on devices like phones and laptops?

   1. Relational Database
   2. Distributed Database
   3. NoSQL Database
   4. Cloud Database
   5. Object-Oriented Database

2. Which of the following best describes how SQLite stores its data?

   Which of the following best describes how SQLite stores its data?

   1. In a single ordinary disk file
   2. Across multiple remote servers
   3. Only in memory with no disk storage
   4. Using a proprietary hardware device
   5. Within an email attachment

3. Which programming language can directly interact with SQLite without any external server process?

   Which programming language can directly interact with SQLite without any external server process?

   1. Python
   2. Cobol
   3. Assembly
   4. Oracle
   5. Fortran

4. What makes SQLite a 'serverless' database?

   What makes SQLite a 'serverless' database?

   1. It does not require a separate server process to operate
   2. It only works on cloud services
   3. It needs a large database server
   4. It requires server activation for queries
   5. It connects to remote databases by default

5. Which SQL command can you use in SQLite to create a new table named 'Students'?

   Which SQL command can you use in SQLite to create a new table named 'Students'?

   1. CREATE TABLE Students;
   2. BUILD Students;
   3. MAKE Students;
   4. GENERATE Students;
   5. INSERT Students;

6. Which of the following is NOT a key benefit of using SQLite?

   Which of the following is NOT a key benefit of using SQLite?

   1. Requires minimal setup and administration
   2. High compatibility with many languages
   3. Built-in support for distributed transactions
   4. Lightweight and fast performance
   5. Suitable for small to medium-sized applications

7. In which situation is SQLite generally NOT recommended?

   In which situation is SQLite generally NOT recommended?

   1. High-concurrency multi-user server applications
   2. Embedded systems with limited resources
   3. Prototyping simple database applications
   4. Standalone desktop programs
   5. Mobile apps needing local storage

8. Which file extension is commonly used for SQLite database files?

   Which file extension is commonly used for SQLite database files?

   1. .db
   2. .sqlt
   3. .data
   4. .sqlite3d
   5. .sdbm

9. What command would you use to view all tables in an SQLite database from the command-line interface?

   What command would you use to view all tables in an SQLite database from the command-line interface?

   1. .tables
   2. SHOW TABLES;
   3. LIST TABLES;
   4. PRINT TABLES;
   5. .showtables

10. Which of the following is true about data types in SQLite?

    Which of the following is true about data types in SQLite?

    1. Data types are dynamically typed and flexible
    2. Only integer data types are allowed
    3. It has no data type system
    4. You must declare strict types for every field
    5. It uses only binary data types