Top 80 TinyDB Multiple Choice Questions (MCQs) with Answers

1 .

TinyDB is written in which programming languages?

A)

C

B)

C++

C)

Java

D)

Python

Correct Answer : Python

Explanation : TinyDB is a document-oriented database, which is purely written in Python

2 .

What is TinyDB?

A)

A programming language for mobile devices

B)

A small database system for mobile devices

C)

A database system for desktop computers

D)

A programming language for desktop computers

Correct Answer : A small database system for mobile devices

Explanation : TinyDB is a small database system designed for mobile devices such as smartphones and tablets. It allows developers to store and retrieve data in a simple and efficient manner.

3 .

What is the maximum number of records that can be stored in a TinyDB database?

A)

100

B)

1,000

C)

10,000

D)

There is no limit

Correct Answer : There is no limit

Explanation : TinyDB does not impose any limit on the number of records that can be stored in a database. However, the performance of the database may degrade as the number of records increases.

4 .

Is TinyDB open-source?

A)

Yes

B)

No

C)

Can Not Say

D)

None of the above

Correct Answer : Yes

Explanation : Yes, TinyDB is an open-source database.

5 .

TinyDB is designed for ____.

A)

Small-scale Projects

B)

Large-scale Projects

C)

Both (A) and (B)

D)

None of the above

Correct Answer : Small-scale Projects

Explanation : TinyDB is designed for small-scale projects.

6 .

Using which of the following method the first document that matches a specific criterion is updated?

A)

Update_all()

B)

Update()

C)

Can Not Say

D)

None of the above

Correct Answer : Update()

Explanation : The first document that matches a specific criterion is updated using the update() method.

7 .

All documents that match a specific criterion are updated, using which of the following method?

A)

Update_all()

B)

Update()

C)

Can Not Say

D)

None of the above

Correct Answer : Update_all()

Explanation : All documents that match a specific criterion are updated, using the update_all() method.

8 .

What is a document in TinyDB?

A)

A file format used for data storage

B)

A programming language construct

C)

A data type used to store text

D)

A collection of data fields and values

Correct Answer : A data type used to store text

Explanation : In TinyDB, a document is a collection of data fields and values that are stored together as a single entity. Documents can be added, retrieved, and deleted from the database.

9 .

Which of the following operations can be performed on a TinyDB database?

A)

Add a document

B)

Delete a document

C)

Retrieve a document

D)

All of the above

Correct Answer : All of the above

Explanation : TinyDB allows developers to perform various operations on a database such as adding, retrieving, and deleting documents. Developers can also perform queries to search for specific documents based on their data fields and values.

10 .

TinyDB is a _____.

A)

SQL

B)

Graph Database

C)

NoSQL

D)

None of the above

Correct Answer : NoSQL

Explanation : TinyDB is a NoSQL database.

11 .

TinyDB stores data in which format?

A)

CSV

B)

JSON

C)

Vertex and Edges

D)

None of the above

Correct Answer : JSON

Explanation : TinyDB stores data in JSON format.

12 .

Which of the following is an example of a TinyDB query for retrieving documents sorted in ascending order by a specific data field?

A)

{“sort field1 ASC”}

B)

{“sort field1 DESC”}

C)

{“sort field1 ascending”}

D)

{“sort field1 descending”}

Correct Answer : {“sort field1 ASC”}

Explaination : To retrieve documents sorted in ascending order by a specific data field, developers can use the {“sort field1 ASC”} syntax in a TinyDB query.

13 .

Which of the following is an example of a TinyDB query for retrieving documents sorted in descending order by a specific data field?

A)

{“sort field1 ASC”}

B)

{“sort field1 DESC”}

C)

{“sort field1 ascending”}

D)

{“sort field1 descending”}

Correct Answer : {“sort field1 DESC”}

Explaination : To retrieve documents sorted in descending order by a specific data field, developers can use the {“sort field1 DESC”} syntax in a TinyDB query.

14 .

Does TinyDB support join operations?

A)

Yes

B)

No

C)

Can Not Say

D)

None of the above

Correct Answer : No

Explanation : TinyDB does not support join operations.

15 .

Does TinyDB allows you to use logical operators?

A)

Yes

B)

No

C)

Can Not Say

D)

None of the above

Correct Answer : Yes

Explanation : Yes, TinyDB allows logical operator usage.

16 .

What is a query in TinyDB?

A)

A data type used for text

B)

A programming language construct

C)

A search operation on a database

D)

A file format used for data storage

Correct Answer : A search operation on a database

Explanation : In TinyDB, a query is a search operation that developers can use to retrieve documents from a database based on specific criteria. Queries can be performed using various operators such as equality, inequality, and comparison.

17 .

What is an index in TinyDB?

A)

A data field used for sorting

B)

A file format used for data storage

C)

A programming language construct

D)

A data structure used for faster searches

Correct Answer : A data structure used for faster searches

Explanation : In TinyDB, an index is a data structure that is used to optimize searches for specific data fields. Indexes can significantly improve the performance of a database by reducing the time it takes to search for documents.

18 .

Which of the following data types are supported by TinyDB?

A)

Text

B)

Number

C)

Boolean

D)

All of the above

Correct Answer : All of the above

Explanation : TinyDB supports various data types such as text, numbers, and boolean values. Developers can use these data types to store and retrieve different types of data in a database.

19 .

Is TinyDB designed for distributed systems?

A)

Yes

B)

No

C)

Can Not Say

D)

None of the above

Correct Answer : No

Explanation : TinyDB is not designed for the distributed system.

20 .

Does TinyDB has external dependencies?

A)

Yes

B)

No

C)

Can Not Say

D)

None of the above

Correct Answer : No

Explanation : TinyDB has no external dependencies.

21 .

TinyDB follows which kind of NoSQL database?

A)

Graph database

B)

Key-value pair database

C)

Document-oriented

D)

None of the above

Correct Answer : Document-oriented

Explanation : TinyDB is a document-oriented database.

22 .

Which of the following method is used to insert an item in TinyDB?

A)

Db.put()

B)

Db.add()

C)

Db.input()

D)

Db.insert()

Correct Answer : Db.insert()

Explanation : Db.insert() method is used to insert an item in TinyDB.

23 .

Which of the following is an example of a TinyDB query for retrieving a specific number of documents from a certain point in the database?

A)

{“limit start, count”}

B)

{“limit count, start”}

C)

{“range start, count”}

D)

{“range count, start”}

Correct Answer : {“limit start, count”}

Explaination : To retrieve a specific number of documents from a certain point in the database, developers can use the {“limit start, count”} syntax in a TinyDB query.

24 .

Which of the following is an example of a TinyDB query for retrieving documents where a specific data field contains a certain substring?

A)

{“field1 like ‘%substring%'”}

B)

{“field1 contains ‘substring'”}

C)

{“field1 not like ‘%substring%'”}

D)

{“field1 not contains ‘substring'”}

Correct Answer : {“field1 like ‘%substring%'”}

Explaination : To retrieve documents where a specific data field contains a certain substring, developers can use the {“field1 like ‘%substring%'”} syntax in a TinyDB query.

25 .

Which of the following is an example of a TinyDB query for retrieving documents where a specific data field does not contain a certain substring?

A)

{“field1 like ‘%substring%'”}

B)

{“field1 contains ‘substring'”}

C)

{“field1 not contains ‘substring'”}

D)

{“field1 not like ‘%substring%'”}

Correct Answer : {“field1 not like ‘%substring%'”}

Explaination : To retrieve documents where a specific data field does not contain a certain substring, developers can use the {“field1 not like ‘%substring%'”} syntax in a TinyDB query.

26 .

What will happen if you will Insert a Document with an already existing ID in TinyDB?

A)

It will show you the value error

B)

It will insert the same record again

C)

Both (A) and (B)

D)

None of the above

Correct Answer : It will show you the value error

Explanation : Inserting a Document with an already existing ID will result in a ValueError.

27 .

To create a table which of the following method is used?

A)

Db.table()

B)

Db.create()

C)

Db.new_table()

D)

None of the above

Correct Answer : Db.table()

Explanation : To create a table, db.table() is used

28 .

Which of the following method is used to remove a table from DB?

A)

Db.drop()

B)

Db.drop_table()

C)

Db.remove()

D)

Db.remove_table()

Correct Answer : Db.drop_table()

Explanation : Db.drop_table() is used to remove a table from DB.

29 .

TinyDB comes with how many storage types?

A)

2

B)

3

C)

4

D)

5

Correct Answer : 2

Explanation : TinyDB comes with two storage types: JSON and in-memory.

30 .

The "____" operator combines two conditions and returns True if any of them is fulfilled.

A)

LOGICAL AND

B)

LOGICAL OR

C)

Can Not Say

D)

None of the above

Correct Answer : LOGICAL OR

Explanation : The "Logical OR" operator combines two conditions and returns True if any of them is fulfilled.

31 .

Which query enables us to enter and update data at the same time based on the criteria?

A)

Indate()

B)

Insert_update()

C)

Upsert()

D)

Enter_update()

Correct Answer : Upsert()

Explanation : upsert() query enables us to enter and update data at the same time based on the criteria.

32 .

What is the syntax for adding a document to a TinyDB database?

A)

addDocument([field1=value1, field2=value2])

B)

addDocument(â€œfield1=value1, field2=value2â€)

C)

addDocument({value1: field1, value2: field2})

D)

addDocument({field1: value1, field2: value2})

Correct Answer : addDocument({field1: value1, field2: value2})

Explanation : The syntax for adding a document to a TinyDB database is to use the addDocument() function and pass in a dictionary object containing the data fields and their values.

33 .

What is the syntax for retrieving all documents from a TinyDB database?

A)

retrieveAll()

B)

getAllDocuments()

C)

getDocuments({})

D)

findDocuments({})

Correct Answer : getAllDocuments()

Explanation : The syntax for retrieving all documents from a TinyDB database is to use the getAllDocuments() function. This function returns a list of all the documents in the database.

34 .

What is the syntax for retrieving a document from a TinyDB database based on a specific criteria?

A)

getDocuments({field1: value1})

B)

retrieveDocument({field1: value1})

C)

findDocuments({field1: value1})

D)

searchDocuments({field1: value1})

Correct Answer : findDocuments({field1: value1})

Explanation : To retrieve a document from a TinyDB database based on specific criteria, developers can use the findDocuments() function and pass in a dictionary object containing the search criteria.

35 .

What is the syntax for deleting a document from a TinyDB database based on specific criteria?

A)

deleteDocument({field1: value1})

B)

deleteDocuments({field1: value1})

C)

removeDocument({field1: value1})

D)

removeDocuments({field1: value1})

Correct Answer : removeDocuments({field1: value1})

Explanation : To delete a document from a TinyDB database based on a specific criteria, developers can use the removeDocuments() function and pass in a dictionary object containing the search criteria.

36 .

What is the syntax for updating a document in a TinyDB database based on a specific criteria?

A)

updateDocument({field1: value1}, {field2: value2})

B)

modifyDocument({field1: value1}, {field2: value2})

C)

changeDocument({field1: value1}, {field2: value2})

D)

updateDocuments({field1: value1}, {field2: value2})

Correct Answer : updateDocument({field1: value1}, {field2: value2})

Explanation : To update a document in a TinyDB database based on a specific criteria, developers can use the updateDocument() function and pass in two dictionary objects – one containing the search criteria and the other containing the updated data fields and their values.

37 .

To insert an item, the data should be in the form of a ____?

A)

LIST

B)

DICT

C)

MAP

D)

None of the above

Correct Answer : DICT

Explanation : The data should be in the form of a Python dictionary.

38 .

Use the ____ function to verify the stored objects in the database?

A)

Full ()

B)

List()

C)

Complete ()

D)

All()

Correct Answer : All()

Explanation : Use the all() function to verify the stored objects in the database.

39 .

To insert many objects at once, which of the following method is used?

A)

Insert_several

B)

Insert_various

C)

Insert_multiple

D)

None of the above

Correct Answer : Insert_multiple

Explanation : To insert many objects at once, the Insert_multiple method is used.

40 .

The ____ function delivers just one document that matches.

A)

One()

B)

Get()

C)

Search()

D)

None of the above

Correct Answer : Get()

Explanation : The get() function delivers just one document that matches.

41 .

You may use the ____ command to delete all data from a database.

A)

truncate

B)

Delete

C)

Remove

D)

Delete_all

Correct Answer : truncate

Explanation : You may use the truncate command to delete all data from a database.

42 .

The ____ query checks the availability of a JSON file's subfield data.

A)

Is()

B)

exists()

C)

Present()

D)

None of the above

Correct Answer : exists()

Explanation : The exists() query checks the availability of a JSON file's subfield data.

43 .

Which of the following is an example of a TinyDB query for retrieving documents where a specific data field matches a certain regular expression?

A)

{“field1 regex ‘regex_pattern'”}

B)

{“field1 match ‘regex_pattern'”}

C)

{“field1 not regex ‘regex_pattern'”}

D)

{“field1 not match ‘regex_pattern'”}

Correct Answer : {“field1 regex ‘regex_pattern'”}

Explaination : To retrieve documents where a specific data field matches a certain regular expression, developers can use the {“field1 regex ‘regex_pattern'”} syntax in a TinyDB query.

44 .

Which of the following is an example of a TinyDB query for retrieving documents where a specific data field does not match a certain regular expression?

A)

{“field1 regex ‘regex_pattern'”}

B)

{“field1 match ‘regex_pattern'”}

C)

{“field1 not match ‘regex_pattern'”}

D)

{“field1 not regex ‘regex_pattern'”}

Correct Answer : {“field1 not regex ‘regex_pattern'”}

Explaination : To retrieve documents where a specific data field does not match a certain regular expression, developers can use the {“field1 not regex ‘regex_pattern'”} syntax in a TinyDB query.

45 .

Which of the following is an example of a TinyDB query for retrieving documents where a specific data field matches one of the multiple values?

A)

{“field1 in (value1, value2)”}

B)

{“field1 not in (value1, value2)”}

C)

{“field1 = value1 OR field1 = value2”}

D)

{“field1 = value1 AND field1 = value2”}

Correct Answer : {“field1 in (value1, value2)”}

Explaination : To retrieve documents where a specific data field matches one of the multiple values, developers can use the {“field1 in (value1, value2)”} syntax in a TinyDB query.

46 .

The number of documents in a database can be obtained, using which of the following query?

A)

All()

B)

List()

C)

Number()

D)

Len()

Correct Answer : Len()

Explanation : The number of documents in a database can be obtained, using the len() query.

47 .

The ____ query determines whether or not the database contains a matching value.

A)

In

B)

Is

C)

Include

D)

contains

Correct Answer : contains

Explanation : The contains query determines whether or not the database contains a matching value.

48 .

The ____ query returns the number of matched documents in a database.

A)

Len

B)

total

C)

Count

D)

All of the above

Correct Answer : Count

Explanation : The count query returns the number of matched documents in a database.

49 .

Which of the following is an example of a TinyDB query for retrieving documents where a specific data field matches none of multiple values?

A)

{“field1 in (value1, value2)”}

B)

{“field1 = value1 OR field1 = value2”}

C)

{“field1 not in (value1, value2)”}

D)

{“field1 = value1 AND field1 = value2”}

Correct Answer : {“field1 not in (value1, value2)”}

Explaination : To retrieve documents where a specific data field matches none

50 .

Which of the following is an example of a TinyDB query for retrieving documents where a specific data field is less than a certain value?

A)

{“field1 > value”}

B)

{“field1 >= value”}

C)

{“field1 <= value”}

D)

{“field1 < value”}

Correct Answer : {“field1 < value”}

Explaination : To retrieve documents where a specific data field is less than a certain value, developers can use the {“field1 < value”} syntax in a TinyDB query.

51 .

Which of the following is an example of a TinyDB query for retrieving documents where a specific data field matches a certain value or is null?

A)

{“field1 = value OR field1 = null”}

B)

{“field1 = value OR field1 is null”}

C)

{“field1 != value AND field1 != null”}

D)

{“field1 != value AND field1 is not null”}

Correct Answer : {“field1 = value OR field1 is null”}

Explaination : To retrieve documents where a specific data field matches a certain value or is null, developers can use the {“field1 = value OR field1 is null”} syntax in a TinyDB query.

52 .

Which of the following is an example of a TinyDB query for retrieving documents where a specific data field does not match a certain value and is not null?

A)

{“field1 = value OR field1 = null”}

B)

{“field1 = value OR field1 is null”}

C)

{“field1 != value AND field1 != null”}

D)

{“field1 != value AND field1 is not null”}

Correct Answer : {“field1 != value AND field1 is not null”}

Explaination : To retrieve documents where a specific data field does not match a certain value and is not null, developers can use the {“field1 != value AND field1 is not null”} syntax in a TinyDB query.

53 .

Which of the following is an example of a TinyDB query for retrieving documents where a specific data field matches one of the multiple values or is null?

A)

{“field1 in (value1, value2) OR field1 = null”}

B)

{“field1 not in (value1, value2) AND field1 is not null”}

C)

{“field1 = value1 OR field1 = value2 OR field1 is null”}

D)

{“field1 != value1 AND field1 != value2 AND field1 is not null”}

Correct Answer : {“field1 = value1 OR field1 = value2 OR field1 is null”}

Explaination : To retrieve documents where a specific data field matches one of multiple values or is null, developers can use the {“field1 = value1 OR field1 = value2 OR field1 is null”} syntax in a TinyDB query.

54 .

Which of the following is an example of a TinyDB query for retrieving documents where a specific data field does not match any of multiple values and is not null?

A)

{“field1 in (value1, value2) OR field1 = null”}

B)

{“field1 = value1 OR field1 = value2 OR field1 is null”}

C)

{“field1 not in (value1, value2) AND field1 is not null”}

D)

{“field1 != value1 AND field1 != value2 AND field1 is not null”}

Correct Answer : {“field1 not in (value1, value2) AND field1 is not null”}

Explaination : To retrieve documents where a specific data field does not match any of multiple values and is not null, developers can use the {“field1 not in (value1, value2) AND field1 is not null”} syntax in a TinyDB query.

55 .

Which of the following middleware, speeds up a database by decreasing disc I/O?

A)

Caching middleware

B)

Sharing middleware

C)

Application middleware

D)

None of the above

Correct Answer : Caching middleware

Explanation : Caching middleware, speeds up a database by decreasing disc I/O.

56 .

Removes all documents that meet a specific requirement?

A)

Purge()

B)

Remove()

C)

Can Not Say

D)

None of the above

Correct Answer : Purge()

Explanation : Purge() Removes all documents that meet a specific requirement.

57 .

which of the following operations returns documents matching both queries?

A)

~(query1)

B)

(query1) | (query2)

C)

(query1) & (query2)

D)

All of the above

Correct Answer : (query1) & (query2)

Explanation : (query1) & (query2) operations, return documents matching both queries.

58 .

TinyDB internally attaches an ID with each document you input.

A)

True

B)

False

C)

Can Not Say

D)

None of the above

Correct Answer : True

Explanation : TinyDB internally attaches an ID with each document you input.

59 .

Is it possible to open the same table with different settings several times?

A)

Yes

B)

No

C)

Can Not Say

D)

None of the above

Correct Answer : No

Explanation : It is not possible to open the same table with different settings several times.

60 .

Which of the following is an example of a TinyDB query for retrieving documents where a specific data field is greater than a certain value?

A)

{“field1 > value1”}

B)

{“field1 < value1”}

C)

{“field1 <= value1”}

D)

{“field1 >= value1”}

Correct Answer : {“field1 >= value1”}

Explaination : To retrieve documents where a specific data field is greater than or equal to a certain value, developers can use the {“field1 >= value1”} syntax in a TinyDB query.

61 .

Which of the following is an example of a TinyDB query for retrieving documents where a specific data field matches a certain value exactly?

A)

{“field1 = value1”}

B)

{“field1 > value1”}

C)

{“field1 < value1”}

D)

{“field1 != value1”}

Correct Answer : {“field1 = value1”}

Explaination : To retrieve documents where a specific data field matches a certain value exactly, developers can use the {“field1 = value1”} syntax in a TinyDB query.

62 .

Which of the following is an example of a TinyDB query for retrieving documents where a specific data field contains a certain value as a substring?

A)

{“field1 similar value1”}

B)

{“field1 like %value1%”}

C)

{“field1 contains value1”}

D)

{“field1 matches value1”}

Correct Answer : {“field1 like %value1%”}

Explaination : To retrieve documents where a specific data field contains a certain value as a substring, developers can use the {“field1 like %value1%”} syntax in a TinyDB query. The % symbol is a wildcard character that matches any number of characters.

63 .

Which of the following is an example of a TinyDB query for retrieving documents where a specific data field is in a list of values?

A)

{“field1 in (value1, value2)”}

B)

{“field1 not in (value1, value2)”}

C)

{“field1 between (value1, value2)”}

D)

{“field1 not between (value1, value2)”}

Correct Answer : {“field1 in (value1, value2)”}

Explaination : To retrieve documents where a specific data field is in a list of values, developers can use the {“field1 in (value1, value2)”} syntax in a TinyDB query.

64 .

Which of the following method finds at least one value in the database?

A)

One()

B)

Any()

C)

Some()

D)

None of the above

Correct Answer : Any()

Explanation : any() method finds at least one value in the database.

65 .

TinyDB's ____ assures data consistency and avoids data redundancy by separating data into distinct tables.

A)

data sharding

B)

data modeling

C)

data integration

D)

data normalisation

Correct Answer : data normalisation

Explanation : TinyDB's data normalization assures data consistency and avoids data redundancy by separating data into distinct tables.

66 .

Which of the following is an example of a TinyDB query for retrieving documents where a specific data field matches a certain regular expression pattern?

A)

{“field1 equals ‘substring'”}

B)

{“field1 like ‘%substring%'”}

C)

{“field1 contains ‘substring'”}

D)

{“field1 matches ‘.substring.'”}

Correct Answer : {“field1 matches ‘.substring.'”}

Explaination : To retrieve documents where a specific data field matches a certain regular expression pattern, developers can use the {“field1 matches ‘.substring.'”} syntax in a TinyDB query.

67 .

Which of the following is an example of a TinyDB query for retrieving documents where a specific data field does not match a certain regular expression

A)

{“field1 not equals ‘substring'”}

B)

{“field1 not like ‘%substring%'”}

C)

{“field1 not contains ‘substring'”}

D)

{“field1 not matches ‘.substring.'”}

Correct Answer : {“field1 not matches ‘.substring.'”}

Explaination : To retrieve documents where a specific data field does not match a certain regular expression pattern, developers can use the {“field1 not matches ‘.substring.'”} syntax in a TinyDB query.

68 .

Which of the following is an example of a TinyDB query for retrieving documents where a specific data field is within a certain range of values?

A)

{“value1 < field1 <= value2”}

B)

{“value1 <= field1 < value2”}

C)

{“value1 < field1 < value2”}

D)

{“value1 <= field1 <= value2”}

Correct Answer : {“value1 < field1 < value2”}

Explaination : To retrieve documents where a specific data field is within a certain range of values, developers can use the {“value1 < field1 < value2”} syntax in a TinyDB query.

69 .

Which of the following is an example of a TinyDB query for retrieving documents where a specific data field is not within a certain range of values?

A)

{“value1 not < field1 < value2”}

B)

{“value1 not < field1 <= value2”}

C)

{“value1 not <= field1 < value2”}

D)

{“value1 not <= field1 <= value2”}

Correct Answer : {“value1 not < field1 < value2”}

Explaination : To retrieve documents where a specific data field is not within a certain range of values, developers can use the {“value1 not < field1 < value2”} syntax in a TinyDB query.

70 .

Which of the following is an example of a TinyDB query for retrieving documents where multiple criteria must be met?

A)

{“field1 = value1, field2 = value2”}

B)

{“field1 = value1 & field2 = value2”}

C)

{“field1 = value1 OR field2 = value2”}

D)

{“field1 = value1 AND field2 = value2”}

Correct Answer : {“field1 = value1 AND field2 = value2”}

Explaination : To retrieve documents where multiple criteria must be met, developers can use the {“field1 = value1 AND field2 = value2”} syntax in a TinyDB query.

71 .

Which of the following is an example of a TinyDB query for retrieving documents where multiple criteria must be met, but only one of the criteria is required to be true?

A)

{“field1 = value1, field2 = value2”}

B)

{“field1 = value1 & field2 = value2”}

C)

{“field1 = value1 XOR field2 = value2”}

D)

{“field1 = value1 NOT field2 = value2”}

Correct Answer : {“field1 = value1 XOR field2 = value2”}

Explaination : To retrieve documents where multiple criteria must be met, but only one of the criteria is required to be true, developers can use the {“field1 = value1 XOR field2 = value2”} syntax in a TinyDB query.

72 .

The search method in TinyDB ____.

A)

Returns single document

B)

Returns multiple documents

C)

Can Not Say

D)

None of the above

Correct Answer : Returns multiple documents

Explanation : The search method in TinyDB, returns multiple documents.

73 .

The get method in TinyDB ____.

A)

Returns single document

B)

Returns multiple documents

C)

Can Not Say

D)

None of the above

Correct Answer : Returns single document

Explanation : The get method in TinyDB, returns a single document.

74 .

To erase data from a TinyDB database, use the ____ function.

A)

Del()

B)

Erase()

C)

Delete()

D)

Remove()

Correct Answer : Remove()

Explanation : To erase data from a TinyDB database, use the remove() function.

75 .

Which of the following is an example of a TinyDB query for retrieving documents where a specific data field is in a list of possible values?

A)

{“field1 in (‘value1’, ‘value2’, ‘value3’)”}

B)

{“field1 in [‘value1’, ‘value2’, ‘value3’]”}

C)

{“field1 in {‘value1’, ‘value2’, ‘value3’}”}

D)

{“field1 in {‘value1’: 1, ‘value2’: 2, ‘value3’: 3}”}

Correct Answer : {“field1 in [‘value1’, ‘value2’, ‘value3’]”}

Explaination : To retrieve documents where a specific data field is in a list of possible values, developers can use the {“field1 in [‘value1’, ‘value2’, ‘value3’]”} syntax in a TinyDB query.

76 .

Which of the following is an example of a TinyDB query for retrieving documents where a specific data field exists in the document?

A)

{“field1 exists”}

B)

{“field1 not none”}

C)

{“field1 is not null”}

D)

{“field1 is not none”}

Correct Answer : {“field1 exists”}

Explaination : To retrieve documents where a specific data field exists in the document, developers can use the {“field1 exists”} syntax in a TinyDB query.

77 .

Which of the following is an example of a TinyDB query for retrieving documents where multiple data fields meet all of several possible criteria?

A)

{“field1 = value1 and field2 = value2”}

B)

{“field1 = value1 or field2 = value2 or field3 = value3”}

C)

{“field1 = value1 and field2 = value2 and field3 = value3”}

D)

{“field1 = value1 and (field2 = value2 or field3 = value3)”}

Correct Answer : {“field1 = value1 and (field2 = value2 or field3 = value3)”}

Explaination : To retrieve documents where multiple data fields meet all of several possible criteria, developers can use the {“field1 = value1 and (field2 = value2 or field3 = value3)”} syntax in a TinyDB query.

78 .

Which of the following is an example of a TinyDB query for retrieving documents where a specific data field is not null?

A)

{“field1 = null”}

B)

{“field1 is null”}

C)

{“field1 != null”}

D)

{“field1 is not null”}

Correct Answer : {“field1 is not null”}

Explaination : To retrieve documents where a specific data field is not null, developers can use the {“field1 is not null”} syntax in a TinyDB query.

79 .

Which of the following is an example of a TinyDB query for retrieving documents where multiple data fields meet at least one of several possible criteria?

A)

{“field1 = value1 or field2 = value2”}

B)

{“field1 = value1 and field2 = value2”}

C)

{“field1 = value1 and field2 = value2 or field3 = value3”}

D)

{“field1 = value1 or field2 = value2 and field3 = value3”}

Correct Answer : {“field1 = value1 or field2 = value2”}

Explaination : To retrieve documents where multiple data fields meet at least one of several possible criteria, developers can use the {“field1 = value1 or field2 = value2”} syntax in a TinyDB query.

80 .

Which of the following is an example of a TinyDB query for retrieving documents where multiple data fields meet certain criteria?

A)

{“field1 = value1 or field2 = value2”}

B)

{“field1 = value1 and field2 = value2”}

C)

{“field1 = value1 and field2 = value2 or field3 = value3”}

D)

{“field1 = value1 or field2 = value2 and field3 = value3”}

Correct Answer : {“field1 = value1 and field2 = value2”}

Explaination : To retrieve documents where multiple data fields meet certain criteria, developers can use the {“field1 = value1 and field2 = value2”} syntax in a TinyDB query.