Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

32. Which of the following is not a valid mongodb statement? a) db.employee find( { dno: 8},{ lname: 1, , salary: 1}).sort( { salary:asc })

image text in transcribed

32. Which of the following is not a valid mongodb statement? a) db.employee find( { "dno": 8},{ "lname": 1, , salary": 1}).sort( { "salary":asc }) b) db.employee find(\{ \$or:[\{"dno": 8},{ "gender": "m" }]},{" id":0, "fname":1, "dno"-1\}).limit(3) c) db.employee.find(\{"_id"::\{lte:14\}\},\{"_id":0, "ssn":1 })limit(4) d) None of the above 33. Does the following Mongodb code is correct? db.employee.aggregate [ [ averageSalary: \{ Savg: "Ssalary" \}, maxSalary: \{ \$max: "\$salary" \}, minSalary: \{ Smin: "Ssalary" \} ) ]) a) Correct b) Not correct 34. Does the following Mongodb code is correct? db.employee.aggregate([ Ssort: "id:1 \} Sgroup : : idd :"Sdno", totalSalary: ;Ssum: "Ssalary" : ]) a) Correct b) Not correct 35. Does the following Mongodb code is correct? db.employee.aggregate [ [ f \$group : \{ _id : "\$dno", count: \{\$sum: 1} ) 3. \$match: \{count:\{\$gt:4\} \}, \$sort:\{"_id":1\} 3 ]) a) Correct b) Not correct

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Advances In Databases And Information Systems Uropean Conference Adbis 2020 Lyon France August 25 27 2020 Proceedings Lncs 12245

Authors: Jerome Darmont ,Boris Novikov ,Robert Wrembel

1st Edition

3030548317, 978-3030548315

More Books

Students also viewed these Databases questions

Question

d. How were you expected to contribute to family life?

Answered: 1 week ago