IncludeHelp_logo
Skip Navigation Links

Home » MCQs

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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).

Discuss this Question

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

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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

Discuss this Question

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.

Discuss this Question

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(;).

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

79. All the SQLite statements end with a -

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

Answer: A) ;

Explanation:

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

Discuss this Question

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;

Discuss this Question

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;

Discuss this Question

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';

Discuss this Question

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;

Discuss this Question

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 );.

Discuss this Question

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);

Discuss this Question

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 ...;

Discuss this Question

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( );

Discuss this Question

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;

Discuss this Question

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};

Discuss this Question

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';

Discuss this Question

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;

Discuss this Question

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;

Discuss this Question

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;

Discuss this Question

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;

Discuss this Question

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;

Discuss this Question

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...;

Discuss this Question

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;"

Discuss this Question

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;

Discuss this Question

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;

Discuss this Question

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;

Discuss this Question

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;

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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).

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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

Discuss this Question

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.

Discuss this Question

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()

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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).

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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

  1. > 
  2. < 
  3. -
  4. <=

Answer: C) -

Explanation:

'-' is not the SQLite Comparison operator.

Discuss this Question

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.

Discuss this Question

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. ||

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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. > >

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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:

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

Discuss this Question

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.

Discuss this Question

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

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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.

Discuss this Question

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;

Discuss this Question




Comments and Discussions!

Load comments ↻




Top MCQs
Top Programs/Examples
Top Tutorials
About
Student's Section
Subscribe

Copyright © 2024 www.includehelp.com. All rights reserved.