Answered step by step
Verified Expert Solution
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 })
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started