This set of MongoDB Multiple Choice Questions & Answers (MCQs) focuses on “Model Monetary and Time Data”.
1. __________ precision multiplies the monetary value by a power of 10.
a) Exact
b) Accurate
c) Ambiguity
d) None of the mentioned
View Answer
Explanation: MongoDB stores numeric data as either IEEE 754 standard 64-bit floating point numbers or as 32-bit or 64-bit signed integers.
2. Point out the correct statement.
a) Applications that handle monetary data often require capturing fractional units of currency
b) Applications that handle time data often require capturing fractional units of currency
c) Applications that handle temporal and spatial data often require capturing fractional units of currency
d) All of the mentioned
View Answer
Explanation: Some fractional numeric quantities, such as one third and one tenth, have no exact representation in binary floating point numbers.
3. Which of the following precision uses two values for the field?
a) Exact
b) Accurate
c) Ambiguity
d) None of the mentioned
View Answer
Explanation: Arbitrary Precision which uses two fields for the value: one field to store the exact monetary value as a non-numeric and another field to store a floating point approximation of the value.
4. MongoDB stores times in _____ by default, and will convert any local time representations into this form.
a) UTC
b) GMT
c) IST
d) None of the mentioned
View Answer
Explanation: Applications that must operate or report on some unmodified local time value may store the time zone alongside the UTC timestamp, and compute the original local time in their application logic.
5. Point out the wrong statement.
a) If you need to query the database for exact, mathematically valid matches, use Exact Precision
b) If you regularly need to perform server-side arithmetic on monetary data, the exact precision model may be appropriate
c) If you need to query the database for exact, mathematically valid matches, use Ambiguity Precision
d) None of the mentioned
View Answer
Explanation: If you need to be able to do server-side arithmetic, e.g., $inc, $mul, and aggregation framework arithmetic, use Exact Precision.
6. Which of the following is used to handle arbitrary or unforeseen number of precision?
a) Exact
b) Accurate
c) Ambiguity
d) None of the mentioned
View Answer
Explanation: If there is no need to perform server-side arithmetic on monetary data, modeling monetary data using the arbitrary precision model may be suitable.
7. Use of the approximation field for the query and sort operations requires that applications perform _______ side post-processing.
a) client
b) server
c) application
d) none of the mentioned
View Answer
Explanation: Client side processing is used to decode the non-numeric representation of the exact value and then filter out the returned documents based on the exact monetary value.
8. The ______ factor is a constant and known property of the currency.
a) rank
b) scale
c) high
d) none of the mentioned
View Answer
Explanation: Applications can determine the scale factor from the currency.
9. In one field, exact monetary value is encoded as a _________ data type.
a) numeric
b) character
c) non numeric
d) none of the mentioned
View Answer
Explanation: In one field, exact monetary value is encoded as a non-numeric data type; e.g., BinData or a string.
Sanfoundry Global Education & Learning Series – MongoDB.
Here’s the list of Best Books in MongoDB.
- Check Information Technology Books
- Check MongoDB Books
- Practice Programming MCQs
- Apply for Programming Internship