Which of the following statements related to :memory: are true?

The correct answers are C and D. In Python’s sqlite3 module, the string ':memory:' is passed to sqlite3.connect() to create an in-memory SQLite database. This establishes a valid database connection, but the database exists only in RAM and normally disappears when the connection is closed. It is useful for testing, temporary storage, fast operations, and examples where no persistent database file is required. Option A is wrong because :memory: does not load an existing file-based database into memory. Option B is also incorrect because it is not a deletion command or database management operation. It is simply a special database name recognized by SQLite to create a temporary in-memory database.