SQLite Multiple-Choice Questions (MCQs)

SQLite is a database engine written in the C language. It is not a standalone app; rather, it is a library (a self-contained, serverless, zero-configuration) that software developers embed in their apps. As such, it belongs to the family of embedded databases.

SQLite MCQs: This section contains multiple-choice questions and answers on the SQLite. It will help the students to test their skills and prepare well for their exams.

List of SQLite MCQs

1. The SQLite database management system is an ____ database.

  1. Embedded relational
  2. Non-embedded relational
  3. Non-relational
  4. Structural

Answer: A) Embedded relational

Explanation:

The SQLite database management system is an embedded relational database.


2. The SQLite database engine is ____. It is self-contained and no configuration is required.

  1. Serverless
  2. Transactional
  3. Both A and B
  4. None of the above

Answer: C) Both A and B

Explanation:

The SQLite database engine is serverless and transactional. It is self-contained and no configuration is required.


3. An ____, self-contained, stand-alone, transactional relational database engine, SQLite is designed to be embedded within an application without requiring additional configuration.

  1. Open-source
  2. Closed-source
  3. Open-end
  4. Open-wire

Answer: A) Open-source

Explanation:

An open-source, self-contained, stand-alone, transactional relational database engine, SQLite is designed to be embedded within an application without requiring additional configuration.


4. SQLite differs from most other SQL databases because it is based on a server process instead of a ____ server.

  1. Unique
  2. Mixed
  3. Configured
  4. Separate

Answer: D) Separate

Explanation:

SQLite differs from most other SQL databases because it is based on a server process instead of a separate server.


5. In SQLite, files are ____ directly to disk.

  1. Read
  2. Written
  3. Both A and B
  4. None of the above

Answer: C) Both A and B

Explanation:

In SQLite, files are read and written directly to disk.


Advertisement

6. Typically, a single disk file contains the entire SQL database, including ____ and views.

  1. Tables
  2. Indices
  3. Triggers
  4. All of the above

Answer: D) All of the above

Explanation:

Typically, a single disk file contains the entire SQL database, including tables, indices, triggers, and views.


7. SQLite is written in -

  1. C
  2. C#
  3. C++
  4. ANSI-C

Answer: D) ANSI-C

Explanation:

SQLite is written in ANSI-C.


8. SQLite is -

  1. Data-based
  2. File-based
  3. Structure-based
  4. None of the above

Answer: B) File-based

Explanation:

SQLite is File-based.


9. SQLite supports many of the features of SQL and is fast; however, ____ procedures are not supported.

  1. Stored
  2. Bypass
  3. Failed
  4. Transactional

Answer: A) Stored

Explanation:

SQLite supports many of the features of SQL and is fast; however, stored procedures are not supported.


10. SQLite is a ____ database resource.

  1. Interface
  2. Non-interface
  3. Portable
  4. Non-portable

Answer: C) Portable

Explanation:

SQLite is a non-portable database resource.


Advertisement

11. For your programming language to access that database, you'll need an SQLite ____.

  1. Powerplug
  2. Extension
  3. Structure
  4. Database

Answer: B) Extension

Explanation:

For your programming language to access that database, you'll need an SQLite extension.


12. In contrast with other database management systems like SQL Server or Oracle, SQLite is very small (less than ____ in size).

  1. 200 kb
  2. 500 kb
  3. 1000 kb
  4. 1 MB

Answer: B) 500 kb

Explanation:

In contrast with other database management systems like SQL Server or Oracle, SQLite is very small (less than 500 Kb in size).


13. What is/are the feature(s) of SQLite?

  1. Totally free
  2. Serverless
  3. Very flexible
  4. All of the above

Answer: D) All of the above

Explanation:

The features of SQLite are -

  1. Totally free
  2. Serverless
  3. Very flexible

14. What is not the feature of SQLite?

  1. Configuration Not Required
  2. Storage of data is tough
  3. Variable length of columns
  4. Cross-platform DBMS

Answer: B) Storage of data is tough

Explanation:

Storage of data is easy in SQLite.


15. ____ databases can be accessed simultaneously with SQLite in the same session.

  1. Two
  2. Three
  3. Four
  4. Multiple

Answer: D) Multiple

Explanation:

Multiple databases can be accessed simultaneously with SQLite in the same session.


Advertisement

16. Several programming languages support SQLite's API such as -

  1. PHP
  2. Java
  3. Python
  4. All of the above

Answer: D) All of the above

Explanation:

Several programming languages support SQLite's API such as PHP, Java, Python, etc.


17. SQLite is available on -

  1. Windows
  2. Linux
  3. Both A and B
  4. None of the above

Answer: C) Both A and B

Explanation:

SQLite is available on Windows and Linux.


18. In addition to version control systems, financial analysis tools, media cataloging and editing suites, CAD packages, and record keeping programs, SQLite has been used successfully in many desktop applications as well as ____ file formats.

  1. On-disk
  2. Off-disk
  3. Disk
  4. None

Answer: A) On-disk

Explanation:

In addition to version control systems, financial analysis tools, media cataloging, and editing suites, CAD packages, and record-keeping programs, SQLite has been used successfully in many desktop applications as well as on-disk file formats.


19. What is/are the advantage(s) of SQLite?

  1. Lightweight
  2. Better Performance
  3. No Installation Needed
  4. All of the above

Answer: D) All of the above

Explanation:

The advantages of SQLite are -

  1. Lightweight
  2. Better Performance
  3. No Installation Needed

20. In addition to being a very light weight database, SQLite can be easily integrated into devices such as ____, home electronic devices, and so forth.

  1. Televisions
  2. Mobile Phones
  3. Cameras
  4. All of the above

Answer: D) All of the above

Explanation:

In addition to being a very light weight database, SQLite can be easily integrated into devices such as televisions, mobile phones, cameras, home electronic devices, and so forth.


Advertisement

21. As SQLite databases are almost ____ faster than the File system, reading and writing operations are very fast.

  1. 10%
  2. 35%
  3. 65%
  4. 95%

Answer: B) 35%

Explanation:

As SQLite databases are almost 35% faster than the File system, reading and writing operations are very fast.


22. Instead of reading the whole file and storing it in memory, SQLite only ____ the data that is needed.

  1. Adds
  2. Restores
  3. Loads
  4. Deletes

Answer: C) Loads

Explanation:

Instead of reading the whole file and storing it in memory, it only loads the data that is needed.


23. When you edit small segments of the file, SQLite ____ only the portions that have been edited.

  1. Writes
  2. Rewrites
  3. Overwrites
  4. None

Answer: C) Overwrites

Explanation:

When you edit small segments of the file, it overwrites only the portions that have been edited.


24. Which of the following is TRUE about the reliability of SQLite?

  1. Your content is continuously updated, so when the power goes out or the computer crashes, little or no work is lost.
  2. I/O code written in SQLite is less likely to be bug-prone than custom-written code.
  3. In contrast to procedural code, SQLite queries are smaller, so the chances of a bug occurring are lower.
  4. All of the above

Answer: D) All of the above

Explanation:

The following is TRUE about the reliability of SQLite -

  1. Your content is continuously updated, so when the power goes out or the computer crashes, little or no work is lost.
  2. I/O code written in SQLite is less likely to be bug-prone than custom-written code.
  3. In contrast to procedural code, SQLite queries are smaller, so the chances of a bug occurring are lower.

25. This open-source database management system is compatible with both big- and little-endian architectures, including ____ operating systems.

  1. 32-bit
  2. 64-bit
  3. Both A and B
  4. None of the above

Answer: C) Both A and B

Explanation:

This open-source database management system is compatible with both big- and little-endian architectures, including 32-bit and 64-bit operating systems.


26. The same application file can be accessed and written by ____ processes without interfering with one another.

  1. Two
  2. Three
  3. Five
  4. Multiple

Answer: D) Multiple

Explanation:

The same application file can be accessed and written by multiple processes without interfering with one another.


27. Which of the following is TRUE about the portability of SQLite?

  1. There is one compatibility issues with any of the programming languages
  2. There are two compatibility issues with any of the programming languages
  3. There are no compatibility issues with any of the programming languages
  4. There are multiple compatibility issues with any of the programming languages

Answer: C) There are no compatibility issues with any of the programming languages

Explanation:

There are no compatibility issues with any of the programming languages.


28. What is TRUE about accessibility of SQLite?

  1. A number of third-party tools are available for accessing the SQLite database
  2. There is a greater likelihood of recovering content from a SQLite database if it has been lost
  3. Code is short-lived compared to data
  4. All of the above

Answer: D) All of the above

Explanation:

In case of accessibility of SQLite -

  1. A number of third-party tools are available for accessing the SQLite database.
  2. There is a greater likelihood of recovering content from a SQLite database if it has been lost.
  3. Code is short-lived compared to data.

29. Because SQLite allows access to and update content in a concise manner rather than through lengthy and error-prone procedural queries, it reduces the application's ____.

  1. Cost
  2. Size
  3. Storage
  4. Fields

Answer: A) Cost

Explanation:

Because SQLite allows access to and update content in a concise manner rather than through lengthy and error-prone procedural queries, it reduces the application's cost.


30. What is TRUE about reducing the cost and complexity in SQLite?

  1. With the addition of new tables and/or columns, SQLite can easily be extended in the future
  2. Backward compatibility is also preserved
  3. Both A and B
  4. None of the above

Answer: C) Both A and B

Explanation:

In case of reducing the cost and complexity in SQLite -

  1. With the addition of new tables and/or columns, SQLite can easily be extended in the future.
  2. Backward compatibility is also preserved.

Advertisement

31. HTTP requests with _____ traffic is/are handled by SQLite.

  1. Low
  2. Medium
  3. Both A and B
  4. None of the above

Answer: C) Both A and B

Explanation:

HTTP requests with low to medium traffic are handled by SQLite.


32. Most databases have a size limit of ____.

  1. 2 KB
  2. 2 MB
  3. 2 GB
  4. 2 TB

Answer: C) 2 GB

Explanation:

Most databases have a size limit of 2 GB.


33. With SQLite, there is no ____ required, making it an excellent choice for small businesses.

  1. Configuration
  2. Administration
  3. Both A and B
  4. None of the above

Answer: C) Both A and B

Explanation:

With SQLite, there is no configuration or administration required, making it an excellent choice for small businesses.


34. How many types of SQLite commands are there?

  1. 1
  2. 2
  3. 3
  4. 4

Answer: C) 3

Explanation:

There are 3 types of SQLite commands.


35. Which of the following is/are SQLite command(s)?

  1. DDL
  2. DML
  3. DQL
  4. All of the above

Answer: D) All of the above

Explanation:

The following are the SQLite commands -

  1. DDL
  2. DML
  3. DQL

36. What is the full form of DQL?

  1. Data Quantization Language
  2. Data Query Language
  3. Data Qualcomm Language
  4. Data Quarter Language

Answer: B) Data Query Language

Explanation:

The full form of DQL is Data Query Language.


37. How many commands are there in DDL?

  1. 1
  2. 2
  3. 3
  4. 4

Answer: C) 3

Explanation:

There are 3 commands in DDL.


38. Which of the following is/are the DDL command(s)?

  1. CREATE
  2. ALTER
  3. DROP
  4. All of the above

Answer: D) All of the above

Explanation:

The following are the DDL commands -

  1. CREATE
  2. ALTER
  3. DROP

39. The CREATE command creates ____ in the database.

  1. Tables
  2. Views of tables
  3. Other objects
  4. All of the above

Answer: D) All of the above

Explanation:

The CREATE command creates tables, views of tables, and other objects in the database.


40. A table can be ____ with the ALTER command.

  1. Created
  2. Modified
  3. Recreated
  4. Deleted

Answer: B) Modified

Explanation:

A table can be modified with the ALTER command.


41. You can delete a whole table, a view of a table, or any other object within a database by using the ____ command.

  1. DELETE
  2. DROP
  3. REMOVE
  4. None

Answer: B) DROP

Explanation:

You can delete a whole table, a view of a table, or any other object within a database by using the DROP command.


42. How many commands are there in DML?

  1. 1
  2. 2
  3. 3
  4. 4

Answer: C) 3

Explanation:

There are 3 commands in DML.


43. Which of the following is/are the command(s) in DML?

  1. INSERT
  2. UPDATE
  3. DELETE
  4. All of the above

Answer: D) All of the above

Explanation:

The following are the commands in DML -

  1. INSERT
  2. UPDATE
  3. DELETE

44. How many commands are there in DQL?

  1. 1
  2. 2
  3. 3
  4. 4

Answer: A) 1

Explanation:

There is 1 command in DQL.


45. SQLite dot commands are not terminated by -

  1. Colon (:)
  2. Semicolon (;)
  3. Both A and B
  4. None of the above

Answer: C) Both A and B

Explanation:

SQLite dot commands are not terminated by Colon(:) and Semicolon(;).


46. What does .backup ?db? File command do?

  1. It takes DB(default "main") backup to file
  2. It takes file backup to file
  3. It takes file backup to DB(default "main")
  4. It takes DB(default "main") backup to DB

Answer: A) It takes DB(default "main") backup to file

Explanation:

.backup ?db? File command takes the backup DB(default "main") to file.


47. What does .bail on|off command do?

  1. It stops after hitting an error. default off
  2. It starts after hitting an error
  3. It stops after switching off
  4. It defaults to off

Answer: A) It stops after hitting an error. default off

Explanation:

.bail on|off command stops after hitting an error. default off.


48. What does .databases command do?

  1. It removes files of attached databases
  2. It adds files of attached databases
  3. It lists names and files of attached databases
  4. It alter names and files of attached database

Answer: C) It lists names and files of attached databases

Explanation:

.databases command lists names and files of attached databases.


49. Does .dump ?table? command do?

  1. Databases are dumped in SQLite format
  2. Databases are dumped in SQL text format
  3. Databases are dumped in PL/SQL format
  4. Databases are dumped in SQL image format

Answer: B) Databases are dumped in SQL text format

Explanation:

In .dump ?table? Command, the databases are dumped in SQL text format.


50. What does .echo on|off command do?

  1. It turns the echo command on
  2. It turns the echo command off
  3. It turns the echo command on or off
  4. None of the above

Answer: C) It turns the echo command on or off

Explanation:

.echo on|off command turns the echo command on or off.


51. What does .exit command do?

  1. It exits the sql prompt
  2. It exits the sqlite prompt
  3. It exits the PL/SQL prompt
  4. None of the above

Answer: B) It exits the sqlite prompt

Explanation:

The .exit command exits the sqilte prompt.


52. What does .explain on|off command do?

  1. Switches between input modes suitable for explaining and non-explaining
  2. Switches between output modes suitable for explaining
  3. Switches between output modes suitable for non-explaining
  4. Switches between output modes suitable for explaining and non-explaining

Answer: D) Switches between output modes suitable for explaining and non-explaining

Explanation:

The .explain on|off command switches between output modes suitable for explaining and non-explaining.


53. What does .header(s) on|off command do?

  1. Display of headers are turned on
  2. Display of headers are turned off
  3. Display of headers are turned on or off
  4. None of the above

Answer: C) Display of headers are turned on or off

Explanation:

In the case of .header(s) on|off command, the display of headers are turned on or off.


54. What does .import file table command do?

  1. It imports the data from table into file
  2. It imports the data from file into table
  3. It exports the data from table into file
  4. It exports the data from file into table

Answer: B) It imports the data from file into table

Explanation:

The .import file command imports the data from file into table.


55. What does .indices ?table? command do?

  1. It shows the name of all indices
  2. It changes the name of all indices
  3. It adds the name of new indices
  4. It deletes the name of indices

Answer: A) It shows the name of all indices

Explanation:

The .indices ?table? command shows the name of all indices.


56. What does .load file ?entry? command do?

  1. It loads an extension file
  2. It loads an extension entry
  3. It loads an extension library
  4. None of the above

Answer: C) It loads an extension entry

Explanation:

The .load file ?entry? command loads an extension library.


57. What does .log file|off command do?

  1. It turns the logging on
  2. It turns the logging off
  3. It turns the logging on or off
  4. None of the above

Answer: C) It turns the logging on or off

Explanation:

The .load file ?entry? Command turns the logging on or off.


58. What does .nullvalue string command do?

  1. In place of null values, it prints not null values
  2. In place of null values, it prints string
  3. In place of not null values, it prints null values
  4. In place of not null values, it prints string

Answer: B) In place of null values, it prints string

Explanation:

The .nullvalue string command print string in place of null values.


59. What does .output filename command do?

  1. It sends output to filename
  2. It sends input to filename
  3. It sends filename to output
  4. It sends filename to input

Answer: A) It sends output to filename

Explanation:

The .output filename command send output to filename.


60. What does .output stdout command do?

  1. It sends input to the screen
  2. It sends output to the screen
  3. It sends screen to the input
  4. It sends screen to the output

Answer: B) It sends output to the screen

Explanation:

The .output stdout command send output to the screen.


61. What does .print string... command do?

  1. It prints normal string
  2. It prints literal string
  3. It prints sequential string
  4. It prints consecutive string

Answer: B) It prints literal string

Explanation:

The .print string... command prints literal string.


62. What does .prompt main continue command do?

  1. It adds main prompts
  2. It continues with main prompts
  3. It replaces standard prompts
  4. It replaces main prompts

Answer: C) It replaces standard prompts

Explanation:

The .prompt main continue command replaces the standard prompts.


63. What does .quit command do?

  1. It enters sqlite prompt
  2. It exits sqlite prompt
  3. It quits sqlite
  4. None of the above

Answer: B) It exits sqlite prompt

Explanation:

The .quit command exits sqlite prompt.


64. What does .read filename command do?

  1. It executes read in filename
  2. It executes write in filename
  3. It executes sql in filename
  4. It stops sql in filename

Answer: C) It executes sql in filename

Explanation:

The .read filename command executes sql in filename.


65. What does .schema ?table? Command do?

  1. It shows the CREATE statements
  2. It shows the UPDATE statements
  3. It shows the INSERT statements
  4. It shows the DELETE statements

Answer: B) It shows the UPDATE statements

Explanation:

The .schema ?table? Command shows the CREATE statement.


66. What happens when the table is specified in the .schema ?table? Command?

  1. Tables not matching the specified pattern will only be displayed if the table is specified
  2. Tables matching the specified pattern will only be displayed if the table is specified
  3. Tables matching the different pattern will only be displayed if the table is specified
  4. Tables matching the specialized pattern will only be displayed if the table is specified

Answer: B) Tables matching the specified pattern will only be displayed if the table is specified

Explanation:

Tables matching the specified pattern will only be displayed if the table is specified.


67. What does .separate string command do?

  1. In output mode and .import, it displays the separator used
  2. In output mode and .import, it changes the separator used
  3. In output mode and .import, it adds the separator used
  4. In output mode and .import, it removes the separator used

Answer: B) In output mode and .import, it changes the separator used

Explanation:

The .separate string command changes the separator used in output mode and .import.


68. What does .show command do?

  1. Current values are shown for various settings
  2. Current values are revoked for various settings
  3. Current values are changed for various settings
  4. Current values are deleted for various settings

Answer: A) Current values are shown for various settings

Explanation:

Current values are shown for various settings in case of .show command.


69. What does .stats on|off command do?

  1. It turns the stats on
  2. It turns the stats off
  3. It turns the stats on or off
  4. It turns the stats deadlocked

Answer: C) It turns the stats on or off

Explanation:

The .stats on|off command turns the stats on or off.


70. What does .tables ?pattern? Command do?

  1. Tables matching a pattern are listed
  2. Tables not matching a pattern are listed
  3. Tables matching a pattern are revoked
  4. Tables not matching a pattern are revoked

Answer: A) Tables matching a pattern are listed

Explanation:

Tables matching a pattern are listed in case of .tables ?pattern? Command.


71. What does .timeout ms command do?

  1. For ms seconds, it tries to open locked tables
  2. For ms milliseconds, it tries to open locked tables
  3. For ms microseconds, it tries to open locked tables
  4. For ms average seconds, it tries to open locked tables

Answer: B) For ms milliseconds, it tries to open locked tables

Explanation:

For ms milliseconds, .timeout ms command tries to open locked tables.


72. What does .width num num command do?

  1. For "column" mode, it sets column widths
  2. For "row" mode, it sets column widths
  3. For "column" mode, it sets row widths
  4. For "row" mode, it sets row widths

Answer: A) For "column" mode, it sets column widths

Explanation:

For "column" mode, .widht num num command sets column widths.


73. What does .timer on|off command do?

  1. Activates CPU timer measurement
  2. Deactivates CPU timer measurement
  3. Activates or deactivates CPU timer measurement
  4. None of the above

Answer: C) Deactivates CPU timer measurement

Explanation:

The .timer on|off command activates or deactivates CPU timer measurement.


74. What dot command(s) is/are used to format the output?

  1. .header on
  2. .mode column
  3. .timer on
  4. All of the above

Answer: D) All of the above

Explanation:

Dot commands that are used to format the output are -

  1. .header on
  2. .mode column
  3. .timer on

75. Based on case-sensitivity, SQLite is -

  1. Case sensitive
  2. Not case sensitive
  3. Not case sensitive with few commands being case sensitive
  4. None of the above

Answer: C) Not case sensitive with few commands being case sensitive

Explanation:

SQLite is not case sensitive with few commands being case sensitive.


76. Which of the following command(s) is/are case sensitive in SQLite?

  1. GLOB
  2. Glob
  3. Both A and B
  4. None of the above

Answer: C) Both A and B

Explanation:

The following commands are case sensitive in SQLite - GLOB and glob as they have different meanings.


77. Which of the following is/are TRUE about Comments in SQLite?

  1. You can add comments to your SQLite code to make it more readable.
  2. Nesting is not possible
  3. Two consecutive "-" characters begin a comment.
  4. All of the above

Answer: D) All of the above

Explanation:

The following are TRUE about Comments in SQLite -

  1. You can add comments to your SQLite code to make it more readable.
  2. Nesting is not possible
  3. Two consecutive "-" characters begin a comment.

78. Comment can also appear with -

  1. /*
  2. */
  3. Both A and B
  4. None of the above

Answer: C) Both A and B

Explanation:

Comment can also appear with /* and */ as they form a character pair.


79. All the SQLite statements end with a -

  1. ;
  2. :
  3. !
  4. )

Answer: A) ;

Explanation:

All the SQLite statements ends with a Semicolon (;).


80. Which of the following is/are the syntax of ANALYZE statement?

  1. ANALYZE;
  2. ANALYZE database_name;
  3. ANALYZE database_name.table_name;
  4. All of the above

Answer: D) All of the above

Explanation:

The following are the syntax of ANALYZE statement -

  1. ANALYZE;
  2. ANALYZE database_name;
  3. ANALYZE database_name.table_name;

81. What is the syntax of ALTER TABLE statement (Rename)?

  1. ALTER TABLE table_name RENAME FOR new_table_name;
  2. ALTER TABLE table_name RENAME OF new_table_name;
  3. ALTER TABLE table_name RENAME TO new_table_name;
  4. ALTER TABLE table_name RENAME FROM new_table_name;

Answer: C) ALTER TABLE table_name RENAME TO new_table_name;

Explanation:

The syntax of ALTER TABLE statement (Rename) is ALTER TABLE table_name RENAME TO new_table_name;


82. What is the syntax of SQLite ATTACH DATABASE statement?

  1. ATTACH DATABASE 'DatabaseName' As 'Alias-Name';
  2. ATTACH DATABASE 'DatabaseName' For 'Alias-Name';
  3. ATTACH DATABASE 'DatabaseName' Of 'Alias-Name';
  4. ATTACH DATABASE 'DatabaseName' To 'Alias-Name';

Answer: A) ATTACH DATABASE 'DatabaseName' As 'Alias-Name';

Explanation:

The syntax of SQLite ATTACH DATABASE statement is ATTACH DATABASE 'DatabaseName' As 'Alias-Name';


83. What is/are the syntax of BEGIN TRANSACTION statement?

  1. BEGIN;
  2. BEGIN EXCLUSIVE TRANSACTION;
  3. Both A and B
  4. None of the above

Answer: C) Both A and B

Explanation:

The syntax of BEGIN TRANSACTION statement are -

  1. BEGIN;
  2. BEGIN EXCLUSIVE TRANSACTION;

84. What is the syntax of CREATE INDEX statement?

  1. CREATE INDEX index_name OF table_name ( column_name COLLATE NOCASE );
  2. CREATE INDEX index_name ON table_name ( column_name COLLATE NOCASE );
  3. CREATE INDEX index_name AT table_name ( column_name COLLATE NOCASE );
  4. CREATE INDEX index_name AS table_name ( column_name COLLATE NOCASE );

Answer: B) CREATE INDEX index_name ON table_name ( column_name COLLATE NOCASE );

Explanation:

The syntax of CREATE INDEX statement is CREATE INDEX index_name ON table_name ( column_name COLLATE NOCASE );.


85. What is the syntax of CREATE UNIQUE INDEX statement?

  1. CREATE INDEX index_name ON table_name ( column1, column2,...columnN);
  2. CREATE UNIQUE INDEX index_name AS table_name ( column1, column2,...columnN);
  3. CREATE UNIQUE INDEX index_name ON table_name ( column_name COLLATE NOCASE );
  4. CREATE UNIQUE INDEX index_name ON table_name ( column1, column2,...columnN);

Answer: D) CREATE UNIQUE INDEX index_name ON table_name ( column1, column2,...columnN);

Explanation:

The syntax of CREATE UNIQUE INDEX statement is:

CREATE UNIQUE INDEX index_name ON table_name ( column1, column2,...columnN);

86. What is the syntax of CREATE VIEW statement?

  1. CREATE VIEW database_name.view_name AT SELECT statement...;
  2. CREATE VIEW database_name.view_name ON SELECT statement...;
  3. CREATE VIEW database_name.view_name AS SELECT statement...;
  4. CREATE VIEW database_name.view_name FOR SELECT statement...;

Answer: C) CREATE VIEW database_name.view_name AS SELECT statement...;

Explanation:

The syntax of CREATE VIEW statement is:

CREATE VIEW database_name.view_name  AS SELECT 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( );

88. What is the syntax of SQLite COUNT Clause?

  1. SELECT COUNT(column_name)
    WHERE CONDITION;
  2. SELECT COUNT(column_name)
    FROM database_name
    WHERE CONDITION;
  3. SELECT COUNT(column_name)
    FROM table_name
    NULL CONDITION;
  4. SELECT COUNT(column_name)
    FROM table_name
    WHERE CONDITION;

Answer: D)

SELECT COUNT(column_name)
FROM table_name  
WHERE CONDITION;

Explanation:

The syntax of SQLite COUNT clause is -

SELECT COUNT(column_name)
FROM table_name  
WHERE CONDITION;

89. What is the syntax of SQLite DELETE statement?

  1. DROP FROM table_name WHERE {CONDITION};
  2. DELETE OF table_name WHERE {CONDITION};
  3. DELETE TO table_name WHERE {CONDITION};
  4. DELETE FROM table_name WHERE {CONDITION};

Answer: D) DELETE FROM table_name WHERE {CONDITION};

Explanation:

The syntax of SQLite DELETE statement is:

DELETE FROM table_name WHERE {CONDITION};

90. What is the syntax of SQLite DETACH DATABASE statement?

  1. ATTACH DATABASE 'Alias-Name';
  2. DETACH TABLE 'Alias-Name';
  3. DETACH DATABASE 'Alias-Name';
  4. DETACH DATABASE;

Answer: C) DETACH DATABASE 'Alias-Name';

Explanation:

The syntax of SQLite DETACH DATABASE statement is:

DETACH DATABASE 'Alias-Name';

91. What is the syntax of SQLite DISTINCT Clause?

  1. SELECT DISTINCT column1, column2....columnN
    OF table_name;
  2. SELECT DISTINCT column1, column2....columnN
    FROM table_name;
  3. SELECT column1, column2....columnN
    FROM table_name;
  4. SELECT column1, column2....columnN
    OF table_name;

Answer: B)

SELECT DISTINCT column1, column2....columnN  
FROM   table_name;

Explanation:

The syntax of SQLite DISTINCT Clause is -

SELECT DISTINCT column1, column2....columnN  
FROM   table_name; 

92. What is the syntax of SQLite DROP INDEX statement?

  1. DELETE INDEX database_name.index_name;
  2. DROP INDEX database_name.index_name;
  3. DROP INDEX index_name.index_name;
  4. DROP INDEX index_name.database_name;

Answer: B) DROP INDEX database_name.index_name;

Explanation:

The syntax of SQLite DROP INDEX statement is:

DROP INDEX database_name.index_name;

93. What is the syntax of SQLite DROP TABLE statement?

  1. DROP TABLE database_name.table_name;
  2. DROP TABLE database_name;
  3. DROP TABLE table_name;
  4. DELETE TABLE database_name.table_name;

Answer: A) DROP TABLE database_name.table_name;

Explanation:

The syntax of SQLite DROP TABLE statement is:

DROP TABLE database_name.table_name;

94. What is the syntax of DROP VIEW statement?

  1. DROP VIEW database_name.view_name;
  2. DROP VIEW view_name;
  3. DROP INDEX database_name;
  4. DROP INDEX database_name.view_name;

Answer: D) DROP INDEX database_name.view_name;

Explanation:

The syntax of DROP VIEW statement is:

DROP INDEX database_name.view_name;

95. What is the syntax of DROP TRIGGER statement?

  1. DROP TRIGGER database_name.trigger_name;
  2. DROP TRIGGER trigger_name;
  3. DROP TRIGGER database_name;
  4. DROP INDEX database_name.trigger_name;

Answer: D) DROP INDEX database_name.trigger_name;

Explanation:

The syntax of DROP TRIGGER statement is:

DROP INDEX database_name.trigger_name;  

96. What is/are the syntax of SQLite EXPLAIN statement?

  1. EXPLAIN INSERT statement...;
  2. EXPLAIN QUERY PLAN SELECT statement...;
  3. Both A and B
  4. None of the above

Answer: C) Both A and B

Explanation:

The syntax of SQLite EXPLAIN statement are -

  1. EXPLAIN INSERT statement...;
  2. EXPLAIN QUERY PLAN SELECT statement...;

97. What is the syntax of SQLite PRAGMA statement?

  1. PRAGMA pragma_name;
  2. CREATE PRAGMA pragma_name;
  3. INSERT PRAGMA pragma_name;
  4. UPDATE PRAGMA pragma_name;

Answer: A) PRAGMA pragma_name;

Explanation:

The syntax of SQLite PRAGMA statement is "PRAGMA pragma_name;"


98. What is the syntax of SQLite RELEASVE SAVEPOINT statement?

  1. RELEASE SAVEPOINT savepoint_name;
  2. RELEASE savepoint_name;
  3. RELEASE name;
  4. RELEASE SAVEPOINT name;

Answer: B) RELEASE savepoint_name;

Explanation:

The syntax of SQLite RELEASE SAVEPOINT statement is:

RELEASE savepoint_name;

99. What is/are the syntax of REINDEX statement?

  1. REINDEX collation_name;
  2. REINDEX database_name.index_name;
  3. REINDEX database_name.table_name;
  4. All of the above

Answer: D) All of the above

Explanation:

The syntax of REINDEX statement are -

  1. REINDEX collation_name;
  2. REINDEX database_name.index_name;
  3. REINDEX database_name.table_name;

100. What is/are the syntax of ROLLBACK statement?

  1. ROLLBACK;
  2. ROLLBACK TO SAVEPOINT savepoint_name;
  3. Both A and B
  4. None of the above

Answer: C) Both A and B

Explanation:

The syntax of ROLLBACK statements are -

  1. ROLLBACK;
  2. ROLLBACK TO SAVEPOINT savepoint_name;

101. What is the syntax of SQLite SAVEPOINT statement?

  1. SAVEPOINT savepoint_name;
  2. SAVEPOINT name;
  3. SAVEPOINT;
  4. None of the above

Answer: A) SAVEPOINT savepoint_name;

Explanation:

The syntax of SQLite SAVEPOINT statement is:

SAVEPOINT savepoint_name;

102. Any object's ____ can be specified using SQLite data types.

  1. Type
  2. Data type
  3. Datasets
  4. Data variables

Answer: B) Data type

Explanation:

Any object's data type can be specified using SQLite data types.


103. Data types for ____ are defined in SQLite.

  1. Columns
  2. Variables
  3. Expressions
  4. All of the above

Answer: D) All of the above

Explanation:

Data types for columns, variables, and expressions are defined in SQLite.


104. Datatypes in SQLite are associated with ____ themselves rather than their containers.

  1. Values
  2. Arrays
  3. Stacks
  4. Pointers

Answer: A) Values

Explanation:

Datatypes in SQLite are associated with values themselves rather than their containers.


105. What does the NULL storage class do?

  1. In this case, it specifies a not null value
  2. In this case, it specifies a current value
  3. In this case, it specifies a null value
  4. In this case, it specifies a real value

Answer: C) In this case, it specifies a null value

Explanation:

The NULL storage class specifies a current value.


106. Depending on the magnitude of the value, the value is stored as a signed integer in _, 4, 6, or 8 bytes in INTEGER storage class.

  1. 1
  2. 2
  3. 3
  4. All of the above

Answer: D) All of the above

Explanation:

Depending on the magnitude of the value, the value is stored as a signed integer in 1, 2, 3, 4, 6, or 8 bytes in INTEGER storage class.


107. As an IEEE floating point number, REAL specifies the value as a ____.

  1. Real value
  2. Real point value
  3. Floating value
  4. Floating point value

Answer: D) Floating point value

Explanation:

As an IEEE floating point number, REAL specifies the value as a floating-point value.


108. If text is specified, the value will be a ____, encoded using the database encoding (utf-8, utf-16be, utf-16le).

  1. Number
  2. Text
  3. Text string
  4. None of the above

Answer: C) Text string

Explanation:

If text is specified, the value will be a text string, encoded using the database encoding (utf-8, utf-16be, utf-16le).


109. Values with the BLOB type are ___ of data that are stored in their original format.

  1. Blogs
  2. Blobs
  3. Binary
  4. Boolean

Answer: B) Blobs

Explanation:

Values with the BLOB type are blobs of data that are stored in their original format.


110. There is no limit to what data types a column can store, but its ____ determines how it is stored.

  1. Storage
  2. Memory
  3. Pages
  4. Affinity

Answer: D) Affinity

Explanation:

There is no limit to what data types a column can store, but its affinity determines how it is stored.


111. ____ storage class(es) is/are all stored in the TEXT column.

  1. NULL
  2. TEXT
  3. BLOB
  4. All of the above

Answer: D) All of the above

Explanation:

NULL, TEXT, and BLOB storage classes are all stored in the TEXT column.


112. Each of the ____ storage classes may be used in the NUMERIC column.

  1. Two
  2. Three
  3. Four
  4. Five

Answer: D) Five

Explanation:

Each of the five storage classes may be used in the NUMERIC column.


113. With an exception in a cast expression, INTEGER behaves like a column with ____ affinity.

  1. Variable affinity
  2. Text affinity
  3. Numeric affinity
  4. Null affinity

Answer: C) Numeric affinity

Explanation:

With an exception in a cast expression, INTEGER behaves like a column with numeric affinity.


114. Integer values are converted into _____ by REAL, just like a column with numeric affinity.

  1. Point values
  2. Floating values
  3. Floating point values
  4. None of the above

Answer: C) Floating point values

Explanation:

Integer values are converted into floating point values by REAL, just like a column with numeric affinity.


115. Columns with affinity NONE maintain ____ between storage classes and don't persuade data between them.

  1. Preference
  2. No preference
  3. Partial preference
  4. Average preference

Answer: B) No preference

Explanation:

Columns with affinity NONE maintain no preference between storage classes and don't persuade data between them.


116. Which of the following is/are the data type(s) for the INTEGER affinity?

  1. INT
  2. INTEGER
  3. BIGINT
  4. All of the above

Answer: D) All of the above

Explanation:

The following are the data types for the INTEGER affinity -

  1. INT
  2. INTEGER
  3. BIGINT

117. Which of the following is NOT the data type for the INTEGER affinity?

  1. TINYINT
  2. SMALLINT
  3. NUMERIC
  4. MEDIUMINT

Answer: C) NUMERIC

Explanation:

NUMERIC is NOT the data type for the INTEGER affinity.


118. Which of the following is/are the data type(s) for the TEXT affinity?

  1. CHARACTER()
  2. VARCHAR()
  3. NCHAR()
  4. All of the above

Answer: D) All of the above

Explanation:

The following are the data types for the TEXT affinity -

  1. CHARACTER()
  2. VARCHAR()
  3. NCHAR()

119. Which of the following is the data type for the NONE affinity?

  1. BLOB datatype specified
  2. BLOB no datatype specified
  3. CLOB datatype specified
  4. CLOB no datatype specified

Answer: B) BLOB no datatype specified

Explanation:

BLOB no datatype specified is the data type for the NONE affinity.


120. Which of the following is/are the data type(s) for the REAL affinity?

  1. NUMERIC
  2. DATETIME
  3. FLOAT
  4. All of the above

Answer: C) FLOAT

Explanation:

FLOAT is the data type for the REAL affinity.


121. Which of the following is NOT the data type for REAL affinity?

  1. REAL
  2. DOUBLE
  3. DOUBLE PRECISION
  4. INTEGER

Answer: D) INTEGER

Explanation:

INTEGER is NOT the data type for REAL affinity.


122. Which of the following is/are the data type(s) for NUMERIC affinity?

  1. NUMERIC
  2. DECIMAL(,)
  3. DATETIME
  4. All of the above

Answer: D) All of the above

Explanation:

The following are the data types for NUMERIC affinity -

  1. NUMERIC
  2. DECIMAL(,)
  3. DATETIME

123. There is no separate class for storing ____ in SQLite.

  1. Dates
  2. Times
  3. Both A and B
  4. None of the above

Answer: C) Both A and B

Explanation:

There is no separate class for storing dates and times in SQLite.


124. ____ values can be used to store date and time values.

  1. TEXT
  2. REAL
  3. INTEGER
  4. All of the above

Answer: D) All of the above

Explanation:

TEXT, REAL, or INTEGER values can be used to store date and time values.


125. A Boolean value is stored as an ____ 0 (false) or 1 (true).

  1. Real
  2. Integer
  3. Text
  4. Float

Answer: B) Integer

Explanation:

A Boolean value is stored as an integer 0 (false) or 1 (true).


126. Whenever we use the WHERE clause in SQLite to perform arithmetic or comparison operations, SQLite operators are reserved ____.

  1. Words
  2. Characters
  3. Both A and B
  4. None of the above

Answer: C) Both A and B

Explanation:

Whenever we use the WHERE clause in SQLite to perform arithmetic or comparison operations, SQLite operators are reserved words or characters.


127. An SQLite statement may contain operators to specify conditions or as a _____ for multiple conditions.

  1. Command
  2. Control
  3. Conjuction
  4. Cartesian

Answer: C) Conjuction

Explanation:

An SQLite statement may contain operators to specify conditions or as a conjunction for multiple conditions.


128. How many types of operators are there in SQLite?

  1. 2
  2. 3
  3. 4
  4. 5

Answer: C) 4

Explanation:

There are 4 types of operators in SQLite.


129. Which of the following is/are the type(s) of operator in SQLite?

  1. Arithmetic
  2. Comparison
  3. Logical
  4. All of the above

Answer: D) All of the above

Explanation:

The following are the types of operators in SQLite -

  1. Arithmetic
  2. Comparison
  3. Logical

130. Which of the following is an SQLite Arithmetic Operator?

  1. *
  2. /
  3. %
  4. All of the above

Answer: D) All of the above

Explanation:

*, /, % are all the SQLite Arithmetic Operators.


131. Which of the following is/are a/the SQLite Comparison Operator(s)?

  1. ==
  2. =
  3. Both A and B
  4. None of the above

Answer: C) Both A and B

Explanation:

The operators ==, = both are the SQLite Comparison Operators.


132. Which of the following is not the SQLite Comparison Operator?

  1. -
  2. <=

Answer: C) -

Explanation:

'-' is not the SQLite Comparison operator.


133. What is TRUE about !< operator in SQLite?

  1. In this case, the condition becomes true if the value of left operand is lesser than that of right operand
  2. In this case, the condition becomes true if the value of left operand is higher than that of right operand
  3. In this case, the condition becomes true if the value of right operand is higher than that of right operand
  4. None of the above

Answer: B) In this case, the condition becomes true if the value of left operand is higher than that of right operand

Explanation:

In !< operator case, the condition becomes true if the value of left operand is higher than that of right operand.


134. Which of the following is/are the SQLite Logical Operator(s)?

  1. AND
  2. IN
  3. ||
  4. All of the above

Answer: D) All of the above

Explanation:

The following are the SQLite Logical Operators -

  1. AND
  2. IN
  3. ||

135. By using wildcard operators, the ____ operator compares a value to similar values.

  1. LIKE
  2. GLOB
  3. glob
  4. Both A and B

Answer: D) Both A and B

Explanation:

By using wildcard operators, the LIKE and GLOB operator compares a value to similar values.


136. Adding two strings and making a new one is done with the ____ operator.

  1. |
  2. ||
  3. |||
  4. !!

Answer: B) ||

Explanation:

Adding two strings and making a new one is done with the || operator.


137. Using SQLite Bitwise operators, you can perform operations ____ on bits.

  1. Bit by Bit
  2. Byte by Byte
  3. MB by MB
  4. KB by KB

Answer: A) Bit by Bit

Explanation:

Using SQLite Bitwise operators, you can perform operations bit by bit on bits.


138. Which of the following is/are an/the SQLite Bitwise Operator(s)?

  1. ~
  2. < <
  3. > >
  4. All of the above

Answer: D) All of the above

Explanation:

The following are the SQLite Bitwise Operators -

  1. ~
  2. < <
  3. > >

139. Bits are flipped in Binary Ones Complement Operators (~), which are ___ operators.

  1. Unary
  2. Binary
  3. Ternary
  4. None

Answer: A) Unary

Explanation:

Bits are flipped in Binary Ones Complement Operators (~), which are unary operators.


140. An operation that shifts the left operand value left by the right operand's number of bits is known as the ____ (<<).

  1. Binary Left Shift Operator
  2. Binary Left Operator
  3. Binary Shift Operator
  4. Binary Right Shift Operator

Answer: A) Binary Left Shift Operator

Explanation:

An operation that shifts the left operand value left by the right operand's number of bits is known as the Binary Left Shift Operator.


141. ____ can be combined into SQLite Expressions.

  1. Values
  2. Operates
  3. SQL Functions
  4. All of the above

Answer: D) All of the above

Explanation:

Values, operators, and SQL functions can be combined into SQLite Expressions.


142. An SQLite expression uses ____ statements and is written in the query language.

  1. CREATE
  2. SELECT
  3. INSERT
  4. ALTER

Answer: B) SELECT

Explanation:

n SQLite expression uses SELECT statements and is written in the query language.


143. How many types of SQLite expressions are there?

  1. 1
  2. 2
  3. 3
  4. 4

Answer: C) 3

Explanation:

There are 3 types of SQLite expressions.


144. Which of the following is/are the type(s) of SQLite expression?

  1. Boolean
  2. Numeric
  3. Date
  4. All of the above

Answer: D) All of the above

Explanation:

The following are the types of SQLite expressions -

  1. Boolean
  2. Numeric
  3. Date

145. The data is fetched using SQLite Boolean expressions based on matching ____ value.

  1. Single
  2. Double
  3. Triple
  4. Multiple

Answer: A) Single

Explanation:

The data is fetched using SQLite Boolean expressions based on matching a single value.


146. ____ operations are performed in queries using SQLite Numeric expressions.

  1. Algebraic
  2. Mathematical
  3. Robotics
  4. Textual

Answer: B) Mathematical

Explanation:

Mathematical operations are performed in queries using SQLite Numeric expressions.


147. There are several built-in functions in numerical expressions, such as ____.

  1. avg()
  2. sum()
  3. count()
  4. All of the above

Answer: D) All of the above

Explanation:

There are several built-in functions in numerical expressions, such as avg(), sum(), count(), etc.


148. ____ include avg(), sum(), count(), etc.

  1. Data calculation functions
  2. Aggregate calculation functions
  3. Aggregate data calculation functions
  4. None of the above

Answer: C) Aggregate data calculation functions

Explanation:

Aggregate data calculation functions include avg(), sum(), count(), etc.


149. The current system ____ is/are retrieved using SQLite Date expressions.

  1. Date
  2. Time
  3. Both A and B
  4. None of the above

Answer: C) Both A and B

Explanation:

The current system date and time are retrieved using SQLite Date expressions.


150. What is the syntax of SQLite Date Expressions?

  1. SELECT TIMESTAMP;
  2. SELECT CURRENT;
  3. SELECT DATETIME;
  4. SELECT CURRENT_TIMESTAMP;

Answer: D) SELECT CURRENT_TIMESTAMP;

Explanation:

The syntax of SQLite Date Expressions is:

SELECT CURRENT_TIMESTAMP;

ADVERTISEMENT
ADVERTISEMENT




Comments and Discussions!




Languages: » C » C++ » C++ STL » Java » Data Structure » C#.Net » Android » Kotlin » SQL
Web Technologies: » PHP » Python » JavaScript » CSS » Ajax » Node.js » Web programming/HTML
Solved programs: » C » C++ » DS » Java » C#
Aptitude que. & ans.: » C » C++ » Java » DBMS
Interview que. & ans.: » C » Embedded C » Java » SEO » HR
CS Subjects: » CS Basics » O.S. » Networks » DBMS » Embedded Systems » Cloud Computing
» Machine learning » CS Organizations » Linux » DOS
More: » Articles » Puzzles » News/Updates

© https://www.includehelp.com some rights reserved.