SQLite differs from commercial relational database systems in terms of features as it does not support a number of features supported by commercial relational database systems. Which of the following statement(s) is/are true about SQLite?

Answer options:

A.SQLite also assigns a type to the columns like most relational database systems.
B.SQLite supports all – LEFT OUTERJOIN, RIGHT OUTERJOIN and FULL OUTERJOIN.
C.SQLite supports no type of OUTERJOIN.
D.SQLite supports only LEFT OUTERJOIN, not RIGHT OUTERJOIN or FULL OUTERJOIN.
E.You can’t create views in SQLite

Correct Answer: D 
SQLite puts some restrictions while creating the SQL statements. SQLite utilizes dynamic typing for values. It supports only LEFT OUTERJOIN, not RIGHT or FULL OUTERJOIN. SQLite allows creating views but here views are read only.
Option A is incorrect. SQLite utilizes dynamic typing for values rather than allotting a type to the columns.
Option B is incorrect. SQLite supports only LEFT OUTERJOIN.
Option C is incorrect. SQLite supports LEFT OUTERJOIN.
Option D is correct. SQLite supports only LEFT OUTERJOIN, not RIGHT OUTERJOIN or FULL OUTERJOIN.
Option E is incorrect. SQLite allows creating views but here views are read-only. It does not allow executing INSERT, DELETE, or UPDATE statements on a view.
Reference:
To know more about SQL Transformation, please visit the below-given link: 

https://docs.microsoft.com/en-us/azure/machine-learning/algorithm-module-reference/apply-sql-transformation