2 quizzes found.

Unlike a database such as MySQL, SQLite columns are not explicitly typed. Instead, SQLite catagorizes data into which of the following catagories?

  1. textual
  2. unicode
  3. numeric
  4. binary
  5. constant

Choose 2 answers

Which of the following SQL statements will improve SQLite write performance?

  1. PRAGMA locking_mode = "Row";
  2. PRAGMA count_changes = Off;
  3. PRAGMA default_synchronous = Off;
  4. PRAGMA default_synchronous = On;
  5. PRAGMA locking_mode = "Table";

Choose 2 answers