MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 10 Mcqs, each offering curated multiple-choice questions to sharpen your Technical MCQs knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Which operator is used to search for values that are within a set of values, given the minimum value and the maximum value? |
| A. | And |
| B. | EXISTS |
| C. | In |
| D. | Between |
| E. | |
| Answer» E. | |
| 2. |
Any column can still store any type of data but the preferred storage class for a column is called its ? |
| A. | affinity |
| B. | type affinity |
| C. | column store |
| D. | type storage |
| Answer» B. type affinity | |
| 3. |
Which of the following command is true regarding ROLLBACK Statement? |
| A. | ROLLBACK; |
| B. | ROLLBACK TO SAVEPOINT savepoint_name; |
| C. | Both A and B |
| D. | ROLLBACK TO savepoint_name; |
| Answer» D. ROLLBACK TO savepoint_name; | |
| 4. |
Does SQLite is case insensitive? |
| A. | TRUE |
| B. | FALSE |
| C. | Can be true or false |
| D. | Can not say |
| Answer» B. FALSE | |
| 5. |
Which command print STRING in place of NULL values? |
| A. | .null STRING |
| B. | .value STRING |
| C. | .nullSTRING |
| D. | .nullvalue STRING |
| Answer» E. | |
| 6. |
SQLite dot commands and exception should not be terminated by? |
| A. | : |
| B. | / |
| C. | ; |
| D. | ' |
| Answer» D. ' | |
| 7. |
Which command is used to modifies an existing database object, such as a table? |
| A. | Create |
| B. | Alter |
| C. | Drop |
| D. | Modify |
| Answer» C. Drop | |
| 8. |
SQLite is an in-process library that implements a? |
| A. | self-contained |
| B. | serverless |
| C. | zero-configuration |
| D. | All of the above |
| Answer» E. | |
| 9. |
SQLite written in? |
| A. | C++ |
| B. | C |
| C. | Java |
| D. | Python |
| Answer» C. Java | |
| 10. |
SQLite is a ? |
| A. | NoSQL database |
| B. | Distributed database |
| C. | Relational database |
| D. | Operational database |
| Answer» D. Operational database | |