×

Multiple-Choice Questions

Web Technologies MCQs

Computer Science Subjects MCQs

Databases MCQs

Programming MCQs

Testing Software MCQs

Digital Marketing Subjects MCQs

Cloud Computing Softwares MCQs

AI/ML Subjects MCQs

Engineering Subjects MCQs

Office Related Programs MCQs

Management MCQs

More

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

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 ↻





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