Home » MCQs » SQLite MCQs

What is/are the syntax of CREATE VIRTUAL TABLE statement?

87. What is/are the syntax of CREATE VIRTUAL TABLE statement?

1. CREATE VIRTUAL TABLE database_name.table_name USING weblog( access.log );
2. CREATE VIRTUAL TABLE database_name.table_name USING fts3( );
3. Both A and B
4. None of the above

Answer: C) Both A and B

Explanation:

The syntax of CREATE VIRTUAL TABLE statement are -

1. CREATE VIRTUAL TABLE database_name.table_name USING weblog( access.log );
2. CREATE VIRTUAL TABLE database_name.table_name USING fts3( );