SQL Server/MySQL [Examination] Bài Thi Thực Hành SQL Server BÀI TRẮC NGHIỆM ĐÁNH GIÁ Ôn tập môn học MongoDB Bộ đề kiểm tra: Ôn tập môn học MongoDB (100 câu). ⏱️ 20 phút 🎯 Điểm đạt: 80% 📝 100 câu Làm bài toàn màn hình Câu 1: What is the primary format used by MongoDB to store data? JSON XML BSON CSV Câu 2: Which of the following is NOT a valid database type mentioned? Hierarchical Relational Object Oriented Sequential Câu 3: Which scaling method is natively supported by NoSQL databases like MongoDB? Vertical scaling Horizontal scaling Diagonal scaling Circular scaling Câu 4: Which of the following properties are mostly NOT supported by NoSQL databases compared to RDBMS? Dynamic schema High performance ACID properties Horizontal scaling Câu 5: In MongoDB Architecture, which layer receives queries and forwards them to the storage engine? Storage Layer Network Layer Data Layer Application Layer Câu 6: Which component is used as the command-line interface to interact with the MongoDB server? MongoDB Compass MongoDB Shell MongoDB Atlas MongoDB Driver Câu 7: What makes up a database in MongoDB? Multiple tables Multiple collections Multiple rows Multiple graphs Câu 8: Which MongoDB edition is available as a service on the cloud? Community Server Enterprise Server MongoDB Atlas MongoDB Desktop Câu 9: Which flag is used with mongod.exe to set the data directory path? --path --dbpath --datadir --dir Câu 10: What is the default port for running a MongoDB deployment on localhost? 27017 3306 8080 2000 Câu 11: Which command is used to check the existing databases in MongoDB Shell? show collections show dbs list databases display dbs Câu 12: Which MongoDB Database Tool is used to export data to JSON or CSV? mongodump mongorestore mongoexport mongoimport Câu 13: Which datatype is used to store 128-bit floating point decimal values? Double Decimal Integer String Câu 14: Which datatype in MongoDB is used to store embedded documents? Array Object ID Object Binary Data Câu 15: Which datatype is used for high-dimensional numeric data like AI embeddings? Array Vector Data Binary Data Double Câu 16: Which of the following maintains operation order and replication in MongoDB? Object ID Date Timestamp Câu 17: How do you switch to or create a database named 'Student_detail' in MongoDB Shell? create Student_detail db Student_detail use Student_detail switch Student_detail Câu 18: Which method is used to insert a single document into a collection? db.collection.insert() db.collection.insertOne() db.collection.addOne() db.collection.add() Câu 19: Which method is used to insert multiple documents into a collection? db.collection.insertMany() db.collection.addMany() db.collection.insertAll() db.collection.addAll() Câu 20: Which method is used to retrieve documents from a collection? db.collection.query() db.collection.fetch() db.collection.find() db.collection.get() Câu 21: Which operator is used with updateOne to set a new value for a field? $change $put $set $update Câu 22: Which command removes a collection from the database? db.collection.remove() db.collection.drop() db.collection.delete() db.collection.destroy() Câu 23: Which command drops the currently active database? db.drop() db.dropDatabase() db.removeDatabase() db.deleteDatabase() Câu 24: Which command deletes multiple documents based on a filter? db.collection.removeMany() db.collection.deleteMany() db.collection.dropMany() db.collection.deleteAll() Câu 25: Which of the following is a Comparison operator? $and $gt $type $size Câu 26: What does the $eq operator do? Matches documents where field value is greater than a specified value Matches documents where field value is less than a specified value Matches documents where field value is equal to a specified value Matches documents where field value is not equal to a specified value Câu 27: Which operator returns documents if any one of the specified expressions evaluates to true? $and $or $not $nor Câu 28: Which Element operator checks if a specified field is present in a document? $exists $type $present $has Câu 29: Which Array operator returns documents that have an array field containing all elements specified? $elemMatch $all $size $in Câu 30: Which operator returns the first element in an array that matches the condition? $slice $meta $ $elemMatch Câu 31: Which of the following is a Field update operator? $pop $push $pull $currentDate Câu 32: Which operator removes the first or last item from an array? $pull $pop $slice $shift Câu 33: Which operator adds comments to a query predicate? $log $comment $note $desc Câu 34: Which of these is NOT an array update operator? $push $addToSet $pullAll $inc Câu 35: What does the $inc operator do? Includes a field in projection Increments the value of a field by a specified amount Includes an element in an array Initializes a field Câu 36: Which operator is used to rename a field in a document? $rename $setname $changename $mod Câu 37: Which aggregation stage takes in documents and does manipulations such as including/excluding fields? $match $project $group $sort Câu 38: Which stage helps in limiting the number of documents passed to the next stage? $skip $limit $count $match Câu 39: Which stage groups documents according to a specified key? $project $match $group $addFields Câu 40: Which stage filters documents based on conditions before sending them to the next stage? $match $limit $sort $group Câu 41: Which stage removes a specified number of documents before passing the rest to the next stage? $limit $skip $match $drop Câu 42: Which stage adds new fields to the documents passed on to the next stage? $project $addFields $set $merge Câu 43: Which stage copies the query results to a new collection? $out $merge $copy $save Câu 44: Which stage returns the total number of documents in the aggregation pipeline? $sum $limit $count $size Câu 45: Which stage randomly selects a specified number of documents from the input? $rand $sample $any $fetch Câu 46: Which of the following is an Arithmetic operator used in aggregation? $concat $avg $add $size Câu 47: Which string operator combines multiple strings into a single string? $merge $concat $join $append Câu 48: Which array operator returns the first element of an array? $first $slice $shift $elemMatch Câu 49: Which boolean operator returns true if any of the specified expressions evaluates to true? $and $or $not $nor Câu 50: Which operator converts a string to lowercase? $toLower $lower $lowercase $strcasecmp Câu 51: What does the $sortByCount stage do? Groups documents by an expression and sorts by count in descending order Groups documents by an expression and sorts by count in ascending order Sorts the collection and returns the count Counts sorted documents Câu 52: Which aggregation operator calculates the square root of a value? $pow $exp $sqrt $log Câu 53: What is the syntax to run a command against the current database? db.executeCommand({ <command> }) db.runCommand({ <command> }) db.command({ <command> }) db.run({ <command> }) Câu 54: Which category of commands deals with inserting, updating, and deleting data? User Management Aggregation Write Operation Authentication Câu 55: Which command is used to create a new user? addUser createUser insertUser newUser Câu 56: Which command grants additional roles to a user? addRolesToUser grantRolesToUser assignRoles updateUserRoles Câu 57: Which command removes a user from the current database? deleteUser removeUser dropUser killUser Câu 58: Which authentication mechanism is default for MongoDB? SCRAM LDAP Kerberos x.509 Câu 59: Which write operation command is used to search for a document and modify it? update findAndModify findAndUpdate modify Câu 60: Which aggregation command is used to group data and perform operations? group aggregate distinct count Câu 61: Which command identifies unique values for a specified field? unique distinct group filter Câu 62: Which of the following is NOT a Collection Method? Count Distinct Find and Update Check Connection Câu 63: Which method fetches distinct values for a field? db.collection.distinct() db.collection.unique() db.collection.findDistinct() db.collection.getDistinct() Câu 64: Which method locates a document and replaces it entirely based on criteria? db.collection.findOneAndUpdate() db.collection.findOneAndReplace() db.collection.replaceOne() db.collection.updateAndReplace() Câu 65: Which Database method gets the names of all collections and views? db.getCollectionNames() db.listCollections() db.collections() db.showCollections() Câu 66: Which method tests the connection between mongosh and the database instance? db.testConnection() db.getMongo() db.ping() db.status() Câu 67: Which role management method deletes a user-defined role? db.deleteRole() db.removeRole() db.dropRole() db.destroyRole() Câu 68: Which bulk operation executes multiple writes sequentially in order? Ordered Bulk Operations Unordered Bulk Operations Sequential Bulk Operations Synchronous Bulk Operations Câu 69: Which method is used for single-collection bulk operations? bulkWrite() adminCommand() executeBulk() bulk() Câu 70: Which method is used for multi-collection bulk operations? bulkWrite() adminCommand() multiBulk() executeMulti() Câu 71: What is the default index created for every collection? _name id _id index Câu 72: Which index is created on multiple fields of the documents in a collection? Single Field Index Compound Field Index Multikey Index Hashed Index Câu 73: Which index is created on each element of an array? Array Index Multikey Index Compound Index Wildcard Index Câu 74: Which index supports queries against unknown or arbitrary fields? Wildcard Index Text Index Hashed Index Unknown Index Câu 75: Which method is used to create an index? db.collection.makeIndex() db.collection.addIndex() db.collection.createIndex() db.collection.setIndex() Câu 76: Which method drops all indexes (except _id) from a collection? db.collection.dropIndexes() db.collection.removeIndexes() db.collection.deleteIndexes() db.collection.clearIndexes() Câu 77: What is the term for building duplicates of existing data on different servers? Sharding Partitioning Replication Clustering Câu 78: In a P-S-S configuration, which server can perform write operations? Primary server Secondary server Both Primary and Secondary Arbiters Câu 79: What happens when the primary server fails in a replica set? The database shuts down An election is held between secondary servers A new server is automatically created Data becomes corrupted Câu 80: Which buffer manages oplog entry ingestion in replication? Write Buffer Apply Buffer Read Buffer Log Buffer Câu 81: Which command initializes a replica set? rs.start() rs.init() rs.initiate() rs.create() Câu 82: Which solution solves the depletion of resources by horizontally scaling data across multiple servers? Replication Sharding Virtualization Caching Câu 83: Which component in a sharded cluster serves as a query router? Shard Servers Configuration Servers mongos mongod Câu 84: What type of sharding divides data into chunks based on computed hash values? Range-based sharding Hash-based sharding Zone-based sharding Geo-based sharding Câu 85: What is the default size of a chunk in sharding? 16 MB 32 MB 64 MB 128 MB Câu 86: Which method enables sharding for a database? sh.enableSharding() sh.addShard() sh.shardCollection() sh.start() Câu 87: What properties do MongoDB transactions follow? BASE ACID CAP SOLID Câu 88: Which of the following is NOT an ACID property? Atomicity Consistency Isolation Dynamic Câu 89: Which Transaction API does not require an explicit call to start a transaction? Core API Callback API Session API Auto API Câu 90: Which error label indicates that a temporary error has occurred and the transaction can be retried? TransientTransactionError UnknownTransactionCommitResult RetryableWriteError NetworkError Câu 91: What is the logical grouping of related read and write operations called? Transaction Session Cluster Pipeline Câu 92: Which method commits a transaction? session.saveTransaction() session.commitTransaction() session.endTransaction() session.finish() Câu 93: What is the cloud product offered by MongoDB? MongoDB Compass MongoDB Shell MongoDB Atlas MongoDB Enterprise Câu 94: Which GUI tool is used for interacting with the MongoDB Server? MongoDB Shell MongoDB Compass MongoDB Atlas mongos Câu 95: Which component allows integrating MongoDB with BI tools like Tableau using SQL? MongoDB Compass MongoDB Atlas MongoDB BI Connector MongoDB Shell Câu 96: What command launches the BI Connector program? mongod mongosh mongos mongosqld Câu 97: Which is the official Python driver for MongoDB? MongoPy PyMongo MongoDB-Python pymongo-driver Câu 98: What method is used to sort query results in PyMongo? order_by() sort() arrange() group() Câu 99: Which AI approach is enabled using MongoDB Atlas and Gen AI? Supervised Learning Retrieval-Augmented Generation (RAG) Reinforcement Learning Transfer Learning Câu 100: What is the first stage in implementing Predictive Maintenance using MongoDB Atlas? Failure Prediction Repair Plan Generators Machine Prioritization Maintenance Guidance Generation 🚀 Nộp Bài & Xem Điểm 🔄 Làm Lại