41.When can you get an SQLITE_SCHEMA error?

The SQLITE_SCHEMA error is returned when a prepared SQL statement is not valid and cannot be executed. Such type occurs only when using the sqlite3 prepare() and sqlite3 step() interfaces to run SQL.

42.Mention what is the Export Control Classification Number (EECN) for SQLite?

The core public domain SQLite source code is not described by any ECCN. Hence, the ECCN should be reported as EAR99. But if you are adding new code or linking SQL Lite with the application, then it might change the EECN number.

43.Explain what is view in SQL Lite?

In SQL Lite, a view is actually a composition of a table in the form of pre-defined SQL Lite Query. A view can consist of all rows of a table or selected rows from one or more tables.

44.Explain what are SQL Lite Indexes?

SQL Lite indexes are special lookup tables that the database search engine use to speed up data retrieval. In simple words, it is a pointer to data in a table.

45.When Indexes should be avoided?

Indexes should be avoided when

• Tables are small
• Tables that changes frequently
• Columns that are frequently manipulated or having a high number of NULL values

46.?

47.?

48.?

49.?

50.?

51.?

52.?

53.?

54.?

55.?

56.?

57.?

58.?

59.?

60.?