ログイン

(Finals) Advanced Database Systems Mocktest BSIT 505
62問 • 1ヶ月前
  • Xai Alexandrei Delos Reyes
  • 通報

    問題一覧

  • 1

    What does CRUD mean?

    Creating, Reading, Updating, and Deleting

  • 2

    To insert a single document, what method is used?

    insertOne

  • 3

    This is used to insert multiple documents into a collection

    insertMany

  • 4

    Which syntax is correct in inserting a document with a title of "Stand by Me" in collection movies?

    db.movies.insertOne({"title" : "Stand by Me"})

  • 5

    Which syntax is correct in inserting multiple documents which are, Ghostbusters, E.T. and Blade Runner in movies collection?

    db.movies.insertMany([ {"title" : "Ghostbusters"}, {"title" : "E.T."}, {"title" : "Blade Runner"} ]);

  • 6

    Which statement is NOT TRUE about ordered insert?

    MongoDB will attempt to insert all documents, regardless of whether some insertions produce errors.

  • 7

    Which statement BEST DESCRIBES unordered insert?

    MongoDB will attempt to insert all documents, regardless of whether some insertions produce errors.

  • 8

    Which is the correct syntax to delete the document with the "_id" value of 4 in mongoDB?

    db.movies.deleteOne({"_id" : 4})

  • 9

    What is used to delete all the documents that match a filter?

    deleteMany

  • 10

    Which method is NOT USED in Updating a documents in mongoDB?

    changeOne

  • 11

    It fully replaces a matching document with a new one

    replaceOne

  • 12

    This operator sets the value of a field

    $set

  • 13

    Which statement is NOT TRUE about "$set"?

    Use this to remove the a key altogether.

  • 14

    Which statement BEST DESCRIBES "$unset"?

    Use this to remove the a key altogether.

  • 15

    method is used to perform queries in MongoDB

    find()

  • 16

    Which is the correct syntax for querying through documents that have the age of 27 in users collection?

    db.users.find({"age" : 27})

  • 17

    Which is the correct syntax for querying through documents where users are between the ages of 18 and 30 in the users collection?

    db.users.find({"age" : {"$gte" : 18, "$lte" : 30}})

  • 18

    Which is not a comparison operator for mongoDB?

    $equals

  • 19

    To query for documents where a key’s value is not equal to a certain value, you can use what conditional operator?

    $ne

  • 20

    Which is the correct syntax for querying through documents who do not have the username “joe” in the users collection?

    db.users.find({"username" : {"$ne" : "joe"}})

  • 21

    This can be used to query for a variety of values for a single key.

    $in

  • 22

    This is more general; it can be used to query for any of the given values across multiple keys.

    $or

  • 23

    It is useful to find all documents that don’t match a given pattern.

    $not

  • 24

    it provides regular expression capabilities for pattern matching strings in queries. These are useful for flexible string matching.

    $regex

  • 25

    What is the correct syntax if we want to find all users with the name “John” or “john,”?

    db.users.find( {"name" : {"$regex" : /john/i } })

  • 26

    It is designed to behave the way querying for scalars (string, numbers, date, etc.) does

    Querying Arrays

  • 27

    In Querying Arrays, If you need to match arrays by more than one element, what method should be used?

    $all

  • 28

    Which is the correct syntax to find all documents with both "apple" and "banana" elements in the array?

    db.food.find({fruit : {$all : ["apple", "banana"]}})

  • 29

    This method matches any array with the number of elements specified by the argument.

    $size

  • 30

    Which is the correct syntax to find all documents with arrays that have the size of 3 elements inside them?

    db.food.find({"fruit" : {"$size" : 3}})

  • 31

    This is an operator that can be used to return a subset of elements for an array key

    $slice

  • 32

    What is the correct syntax to query embedded keys in documents based on the given the data below? { "name" : { "first" : "John", "last" : "Escalona" }, "age" : 45 }

    db.people.find({"name.first" : "John", "name.last" : "Escalona"})

  • 33

    Which statement is NOT TRUE about Data Modelling?

    These capture relationships between data by storing related data in a single document structure.

  • 34

    Which statement is NOT TRUE about Embedded Data?

    These store the relationships between data by including links or references from one document to another.

  • 35

    This store the relationships between data by including links or references from one document to another. Applications can resolve these references to access the related data. Broadly, these are normalized data models.

    References

  • 36

    Which statement is NOT TRUE about Cloud Computing?

    It is defined according to where the infrastructure for the deployment resides and who has control over that infrastructure.

  • 37

    It is the delivery of different services through the Internet. These resources include tools and applications like data storage, servers, databases, networking, and software.

    Cloud computing

  • 38

    It is defined according to where the infrastructure for the deployment resides and who has control over that infrastructure.

    Cloud Implementation

  • 39

    This type of cloud infrastructure is built by a third-party organization to sell cloud services to the general public.

    Public cloud

  • 40

    This type of internal cloud is built by an organization for the sole purpose of servicing its own needs.

    Private cloud

  • 41

    It is the combination of a private and public cloud, providing for more flexibility to businesses while having control over critical operations and assets, coupled with improved flexibility and cost-efficiency.

    Hybrid cloud

  • 42

    Which is NOT a Cloud Implementation?

    Cloud Database

  • 43

    Which statement is NOT TRUE about Public Cloud?

    This type of internal cloud is built by an organization for the sole purpose of servicing its own needs.

  • 44

    Which statement is NOT TRUE about Private Cloud?

    It is the combination of a private and public cloud, providing for more flexibility to businesses while having control over critical operations and assets, coupled with improved flexibility and cost-efficiency.

  • 45

    Which statement is NOT TRUE about Hybrid Cloud?

    This type of cloud infrastructure is built by a third-party organization to sell cloud services to the general public.

  • 46

    These come in different shapes and forms; no single type of service works for all consumers. These often follow an à la carte model; consumers can choose multiple service options according to their individual needs. These services can build on top of each other to provide sophisticated solutions.

    Cloud services

  • 47

    The cloud service provider offers turnkey applications that run in the cloud. Consumers can run the provider’s applications internally in their organizations via the web or any mobile device.

    Software as a Service (SaaS)

  • 48

    The cloud service provider offers the capability to build and deploy consumer-created applications using the provider’s cloud infrastructure.

    Platform as a Service (PaaS)

  • 49

    In this case, the cloud service provider offers consumers the ability to provision their own resources on demand; these resources include storage, servers, databases, processing units, and even a complete virtualized desktop.

    Infrastructure as a Service (IaaS)

  • 50

    Which is NOT a Cloud Service?

    Database as a Service (BaaS)

  • 51

    Which Benefit of Cloud Computing is being described? "Cloud computing enables immediate scalability of infrastructure capacity depending on the business need. It is like having an unlimited IT resource, which can be scaled up and/ or down to meet user demands."

    Instant scalability

  • 52

    Which Benefit of Cloud Computing is being described? "Cloud empowers enterprises to deploy their applications across the globe so they can service their customers at a fraction of the cost of traditional brick-and-motor businesses. Due to lower latency, customers around the world get an identical digital experience while using the applications"

    Anywhere accessibility

  • 53

    Which Benefit of Cloud Computing is being described? "Such an ability improves organizational agility, productivity, and efficiency, making scope to experiment with new ideas and thereby offering competitive advantage and the ability for the organization of any size to disrupt the market."

    Increased speed and operational agility

  • 54

    Which Benefit of Cloud Computing is being described? "With the cloud, enterprises can focus on building their business rather than investing in hardware infrastructure and data centers that either remain idle or underutilized"

    Reduced expenditure

  • 55

    A cloud service provider or a managed service provider can take care of these automatically, saving time and manual effort on maintenance.

    Automatic updates/patches

  • 56

    The world is going digital, making robust backup and disaster recovery crucial for businesses of all sizes.

    Disaster recovery

  • 57

    Protecting sensitive, personally identifiable, and/ or financial information is a considerable challenge for CIOs. Advanced cloud security features, however, have reduced the risks of information loss and cyber stealth.

    High security

  • 58

    Cloud infrastructure significantly reduces power, IT infrastructure, and resource consumption by offering resources as per demand, thereby reducing e-waste and adverse impact on the environment

    Reduced carbon footprint

  • 59

    From closed cabins to bringing your internet-enabled devices to work, irrespective of the device type and/ or global location, the cloud offers vast flexibility and empowerment to businesses as well as to their employees

    Flexibility

  • 60

    Centralized documentation control on cloud-based, file-sharing and social communication apps (like Slack, Yammer, etc.) offers transparency and visibility into work processes, streamlining information flow and enabling better collaboration between teams, departments, and employees seated in different time zones -- all of which leads to improved productivity and bottom line

    Enterprise Collaboration

  • 61

    This is the GUI for MongoDB. It allows you to analyze and understand the contents of your data without formal knowledge of MongoDB query syntax.

    MongoDB Compass

  • 62

    This provides an easy way to host and manage your data in the cloud.

    MongoDB Atlas

  • The Contemporary World Mock test (Prelims)

    The Contemporary World Mock test (Prelims)

    Xai Alexandrei Delos Reyes · 58問 · 2年前

    The Contemporary World Mock test (Prelims)

    The Contemporary World Mock test (Prelims)

    58問 • 2年前
    Xai Alexandrei Delos Reyes

    Computing Mock test (Prelims)

    Computing Mock test (Prelims)

    Xai Alexandrei Delos Reyes · 67問 · 2年前

    Computing Mock test (Prelims)

    Computing Mock test (Prelims)

    67問 • 2年前
    Xai Alexandrei Delos Reyes

    Programming Mock Test (Prelims)

    Programming Mock Test (Prelims)

    Xai Alexandrei Delos Reyes · 64問 · 2年前

    Programming Mock Test (Prelims)

    Programming Mock Test (Prelims)

    64問 • 2年前
    Xai Alexandrei Delos Reyes

    Entrepreneurship Mock Test (Prelims)

    Entrepreneurship Mock Test (Prelims)

    Xai Alexandrei Delos Reyes · 23問 · 2年前

    Entrepreneurship Mock Test (Prelims)

    Entrepreneurship Mock Test (Prelims)

    23問 • 2年前
    Xai Alexandrei Delos Reyes

    Computing Mock Test (Midterms) BSIT 107

    Computing Mock Test (Midterms) BSIT 107

    Xai Alexandrei Delos Reyes · 76問 · 2年前

    Computing Mock Test (Midterms) BSIT 107

    Computing Mock Test (Midterms) BSIT 107

    76問 • 2年前
    Xai Alexandrei Delos Reyes

    Math Mock Test (Prelims)

    Math Mock Test (Prelims)

    Xai Alexandrei Delos Reyes · 48問 · 2年前

    Math Mock Test (Prelims)

    Math Mock Test (Prelims)

    48問 • 2年前
    Xai Alexandrei Delos Reyes

    Programming Mock Test (Midterms) BSIT 107

    Programming Mock Test (Midterms) BSIT 107

    Xai Alexandrei Delos Reyes · 52問 · 2年前

    Programming Mock Test (Midterms) BSIT 107

    Programming Mock Test (Midterms) BSIT 107

    52問 • 2年前
    Xai Alexandrei Delos Reyes

    UTS Mock Test (Midterms) BSIT107

    UTS Mock Test (Midterms) BSIT107

    Xai Alexandrei Delos Reyes · 40問 · 2年前

    UTS Mock Test (Midterms) BSIT107

    UTS Mock Test (Midterms) BSIT107

    40問 • 2年前
    Xai Alexandrei Delos Reyes

    Entrepreneurship Mock Test (Midterms) BSIT 107

    Entrepreneurship Mock Test (Midterms) BSIT 107

    Xai Alexandrei Delos Reyes · 38問 · 2年前

    Entrepreneurship Mock Test (Midterms) BSIT 107

    Entrepreneurship Mock Test (Midterms) BSIT 107

    38問 • 2年前
    Xai Alexandrei Delos Reyes

    Contemporary World Mock Test (Midterms) BSIT 107

    Contemporary World Mock Test (Midterms) BSIT 107

    Xai Alexandrei Delos Reyes · 28問 · 2年前

    Contemporary World Mock Test (Midterms) BSIT 107

    Contemporary World Mock Test (Midterms) BSIT 107

    28問 • 2年前
    Xai Alexandrei Delos Reyes

    Math Mocktest (Midterms) BSIT 107

    Math Mocktest (Midterms) BSIT 107

    Xai Alexandrei Delos Reyes · 24問 · 2年前

    Math Mocktest (Midterms) BSIT 107

    Math Mocktest (Midterms) BSIT 107

    24問 • 2年前
    Xai Alexandrei Delos Reyes

    Computer Programming Mocktest (Pre-finals)

    Computer Programming Mocktest (Pre-finals)

    Xai Alexandrei Delos Reyes · 26問 · 2年前

    Computer Programming Mocktest (Pre-finals)

    Computer Programming Mocktest (Pre-finals)

    26問 • 2年前
    Xai Alexandrei Delos Reyes

    Math Mocktest (Pre-Finals)

    Math Mocktest (Pre-Finals)

    Xai Alexandrei Delos Reyes · 19問 · 2年前

    Math Mocktest (Pre-Finals)

    Math Mocktest (Pre-Finals)

    19問 • 2年前
    Xai Alexandrei Delos Reyes

    Computing Mock Test (Pre-finals)

    Computing Mock Test (Pre-finals)

    Xai Alexandrei Delos Reyes · 36問 · 2年前

    Computing Mock Test (Pre-finals)

    Computing Mock Test (Pre-finals)

    36問 • 2年前
    Xai Alexandrei Delos Reyes

    Computing Mock Test Finals

    Computing Mock Test Finals

    Xai Alexandrei Delos Reyes · 26問 · 2年前

    Computing Mock Test Finals

    Computing Mock Test Finals

    26問 • 2年前
    Xai Alexandrei Delos Reyes

    Comprog 2nd sem (prelims) BSIT 205

    Comprog 2nd sem (prelims) BSIT 205

    Xai Alexandrei Delos Reyes · 63問 · 1年前

    Comprog 2nd sem (prelims) BSIT 205

    Comprog 2nd sem (prelims) BSIT 205

    63問 • 1年前
    Xai Alexandrei Delos Reyes

    Discrete Math 2nd sem (prelims) BSIT 205

    Discrete Math 2nd sem (prelims) BSIT 205

    Xai Alexandrei Delos Reyes · 36問 · 1年前

    Discrete Math 2nd sem (prelims) BSIT 205

    Discrete Math 2nd sem (prelims) BSIT 205

    36問 • 1年前
    Xai Alexandrei Delos Reyes

    Art Appreciation (Prelim) BSIT 205

    Art Appreciation (Prelim) BSIT 205

    Xai Alexandrei Delos Reyes · 56問 · 1年前

    Art Appreciation (Prelim) BSIT 205

    Art Appreciation (Prelim) BSIT 205

    56問 • 1年前
    Xai Alexandrei Delos Reyes

    Ethics 2nd sem (Prelims) BSIT 205

    Ethics 2nd sem (Prelims) BSIT 205

    Xai Alexandrei Delos Reyes · 45問 · 1年前

    Ethics 2nd sem (Prelims) BSIT 205

    Ethics 2nd sem (Prelims) BSIT 205

    45問 • 1年前
    Xai Alexandrei Delos Reyes

    STS 2nd Sem (Prelim) BSIT 205

    STS 2nd Sem (Prelim) BSIT 205

    Xai Alexandrei Delos Reyes · 40問 · 1年前

    STS 2nd Sem (Prelim) BSIT 205

    STS 2nd Sem (Prelim) BSIT 205

    40問 • 1年前
    Xai Alexandrei Delos Reyes

    問題一覧

  • 1

    What does CRUD mean?

    Creating, Reading, Updating, and Deleting

  • 2

    To insert a single document, what method is used?

    insertOne

  • 3

    This is used to insert multiple documents into a collection

    insertMany

  • 4

    Which syntax is correct in inserting a document with a title of "Stand by Me" in collection movies?

    db.movies.insertOne({"title" : "Stand by Me"})

  • 5

    Which syntax is correct in inserting multiple documents which are, Ghostbusters, E.T. and Blade Runner in movies collection?

    db.movies.insertMany([ {"title" : "Ghostbusters"}, {"title" : "E.T."}, {"title" : "Blade Runner"} ]);

  • 6

    Which statement is NOT TRUE about ordered insert?

    MongoDB will attempt to insert all documents, regardless of whether some insertions produce errors.

  • 7

    Which statement BEST DESCRIBES unordered insert?

    MongoDB will attempt to insert all documents, regardless of whether some insertions produce errors.

  • 8

    Which is the correct syntax to delete the document with the "_id" value of 4 in mongoDB?

    db.movies.deleteOne({"_id" : 4})

  • 9

    What is used to delete all the documents that match a filter?

    deleteMany

  • 10

    Which method is NOT USED in Updating a documents in mongoDB?

    changeOne

  • 11

    It fully replaces a matching document with a new one

    replaceOne

  • 12

    This operator sets the value of a field

    $set

  • 13

    Which statement is NOT TRUE about "$set"?

    Use this to remove the a key altogether.

  • 14

    Which statement BEST DESCRIBES "$unset"?

    Use this to remove the a key altogether.

  • 15

    method is used to perform queries in MongoDB

    find()

  • 16

    Which is the correct syntax for querying through documents that have the age of 27 in users collection?

    db.users.find({"age" : 27})

  • 17

    Which is the correct syntax for querying through documents where users are between the ages of 18 and 30 in the users collection?

    db.users.find({"age" : {"$gte" : 18, "$lte" : 30}})

  • 18

    Which is not a comparison operator for mongoDB?

    $equals

  • 19

    To query for documents where a key’s value is not equal to a certain value, you can use what conditional operator?

    $ne

  • 20

    Which is the correct syntax for querying through documents who do not have the username “joe” in the users collection?

    db.users.find({"username" : {"$ne" : "joe"}})

  • 21

    This can be used to query for a variety of values for a single key.

    $in

  • 22

    This is more general; it can be used to query for any of the given values across multiple keys.

    $or

  • 23

    It is useful to find all documents that don’t match a given pattern.

    $not

  • 24

    it provides regular expression capabilities for pattern matching strings in queries. These are useful for flexible string matching.

    $regex

  • 25

    What is the correct syntax if we want to find all users with the name “John” or “john,”?

    db.users.find( {"name" : {"$regex" : /john/i } })

  • 26

    It is designed to behave the way querying for scalars (string, numbers, date, etc.) does

    Querying Arrays

  • 27

    In Querying Arrays, If you need to match arrays by more than one element, what method should be used?

    $all

  • 28

    Which is the correct syntax to find all documents with both "apple" and "banana" elements in the array?

    db.food.find({fruit : {$all : ["apple", "banana"]}})

  • 29

    This method matches any array with the number of elements specified by the argument.

    $size

  • 30

    Which is the correct syntax to find all documents with arrays that have the size of 3 elements inside them?

    db.food.find({"fruit" : {"$size" : 3}})

  • 31

    This is an operator that can be used to return a subset of elements for an array key

    $slice

  • 32

    What is the correct syntax to query embedded keys in documents based on the given the data below? { "name" : { "first" : "John", "last" : "Escalona" }, "age" : 45 }

    db.people.find({"name.first" : "John", "name.last" : "Escalona"})

  • 33

    Which statement is NOT TRUE about Data Modelling?

    These capture relationships between data by storing related data in a single document structure.

  • 34

    Which statement is NOT TRUE about Embedded Data?

    These store the relationships between data by including links or references from one document to another.

  • 35

    This store the relationships between data by including links or references from one document to another. Applications can resolve these references to access the related data. Broadly, these are normalized data models.

    References

  • 36

    Which statement is NOT TRUE about Cloud Computing?

    It is defined according to where the infrastructure for the deployment resides and who has control over that infrastructure.

  • 37

    It is the delivery of different services through the Internet. These resources include tools and applications like data storage, servers, databases, networking, and software.

    Cloud computing

  • 38

    It is defined according to where the infrastructure for the deployment resides and who has control over that infrastructure.

    Cloud Implementation

  • 39

    This type of cloud infrastructure is built by a third-party organization to sell cloud services to the general public.

    Public cloud

  • 40

    This type of internal cloud is built by an organization for the sole purpose of servicing its own needs.

    Private cloud

  • 41

    It is the combination of a private and public cloud, providing for more flexibility to businesses while having control over critical operations and assets, coupled with improved flexibility and cost-efficiency.

    Hybrid cloud

  • 42

    Which is NOT a Cloud Implementation?

    Cloud Database

  • 43

    Which statement is NOT TRUE about Public Cloud?

    This type of internal cloud is built by an organization for the sole purpose of servicing its own needs.

  • 44

    Which statement is NOT TRUE about Private Cloud?

    It is the combination of a private and public cloud, providing for more flexibility to businesses while having control over critical operations and assets, coupled with improved flexibility and cost-efficiency.

  • 45

    Which statement is NOT TRUE about Hybrid Cloud?

    This type of cloud infrastructure is built by a third-party organization to sell cloud services to the general public.

  • 46

    These come in different shapes and forms; no single type of service works for all consumers. These often follow an à la carte model; consumers can choose multiple service options according to their individual needs. These services can build on top of each other to provide sophisticated solutions.

    Cloud services

  • 47

    The cloud service provider offers turnkey applications that run in the cloud. Consumers can run the provider’s applications internally in their organizations via the web or any mobile device.

    Software as a Service (SaaS)

  • 48

    The cloud service provider offers the capability to build and deploy consumer-created applications using the provider’s cloud infrastructure.

    Platform as a Service (PaaS)

  • 49

    In this case, the cloud service provider offers consumers the ability to provision their own resources on demand; these resources include storage, servers, databases, processing units, and even a complete virtualized desktop.

    Infrastructure as a Service (IaaS)

  • 50

    Which is NOT a Cloud Service?

    Database as a Service (BaaS)

  • 51

    Which Benefit of Cloud Computing is being described? "Cloud computing enables immediate scalability of infrastructure capacity depending on the business need. It is like having an unlimited IT resource, which can be scaled up and/ or down to meet user demands."

    Instant scalability

  • 52

    Which Benefit of Cloud Computing is being described? "Cloud empowers enterprises to deploy their applications across the globe so they can service their customers at a fraction of the cost of traditional brick-and-motor businesses. Due to lower latency, customers around the world get an identical digital experience while using the applications"

    Anywhere accessibility

  • 53

    Which Benefit of Cloud Computing is being described? "Such an ability improves organizational agility, productivity, and efficiency, making scope to experiment with new ideas and thereby offering competitive advantage and the ability for the organization of any size to disrupt the market."

    Increased speed and operational agility

  • 54

    Which Benefit of Cloud Computing is being described? "With the cloud, enterprises can focus on building their business rather than investing in hardware infrastructure and data centers that either remain idle or underutilized"

    Reduced expenditure

  • 55

    A cloud service provider or a managed service provider can take care of these automatically, saving time and manual effort on maintenance.

    Automatic updates/patches

  • 56

    The world is going digital, making robust backup and disaster recovery crucial for businesses of all sizes.

    Disaster recovery

  • 57

    Protecting sensitive, personally identifiable, and/ or financial information is a considerable challenge for CIOs. Advanced cloud security features, however, have reduced the risks of information loss and cyber stealth.

    High security

  • 58

    Cloud infrastructure significantly reduces power, IT infrastructure, and resource consumption by offering resources as per demand, thereby reducing e-waste and adverse impact on the environment

    Reduced carbon footprint

  • 59

    From closed cabins to bringing your internet-enabled devices to work, irrespective of the device type and/ or global location, the cloud offers vast flexibility and empowerment to businesses as well as to their employees

    Flexibility

  • 60

    Centralized documentation control on cloud-based, file-sharing and social communication apps (like Slack, Yammer, etc.) offers transparency and visibility into work processes, streamlining information flow and enabling better collaboration between teams, departments, and employees seated in different time zones -- all of which leads to improved productivity and bottom line

    Enterprise Collaboration

  • 61

    This is the GUI for MongoDB. It allows you to analyze and understand the contents of your data without formal knowledge of MongoDB query syntax.

    MongoDB Compass

  • 62

    This provides an easy way to host and manage your data in the cloud.

    MongoDB Atlas