Nothing Special   »   [go: up one dir, main page]
Scribd Logo
Upload

Welcome to Scribd!

  • 32 views

    CAt-2 (D Slot)

    Uploaded by

    rupa sree
    This document contains a sample question paper for the exam "CAT 2" for the course "NoSQL Databases". It has 4 questions worth a total of 50 marks. Question 1 (15 marks) asks about performing various operations like insertion, updating, and deletion on a MongoDB database containing car details. Question 2 (10 marks) asks about performing queries on a MongoDB database containing hospital reports. Question 3 (15 marks) and 4 (10 marks) ask about performing various operations like creation, insertion, counting, and union on Redis datastores containing subject names and exam details.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    CAt-2 (D Slot)

    Uploaded by

    rupa sree
    32 views2 pages
    This document contains a sample question paper for the exam "CAT 2" for the course "NoSQL Databases". It has 4 questions worth a total of 50 marks. Question 1 (15 marks) asks about performing various operations like insertion, updating, and deletion on a MongoDB database containing car details. Question 2 (10 marks) asks about performing queries on a MongoDB database containing hospital reports. Question 3 (15 marks) and 4 (10 marks) ask about performing various operations like creation, insertion, counting, and union on Redis datastores containing subject names and exam details.

    Original Title

    CAt-2(d slot)

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document contains a sample question paper for the exam "CAT 2" for the course "NoSQL Databases". It has 4 questions worth a total of 50 marks. Question 1 (15 marks) asks about performing various operations like insertion, updating, and deletion on a MongoDB database containing car details. Question 2 (10 marks) asks about performing queries on a MongoDB database containing hospital reports. Question 3 (15 marks) and 4 (10 marks) ask about performing various operations like creation, insertion, counting, and union on Redis datastores containing subject names and exam details.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    32 views2 pages

    CAt-2 (D Slot)

    Uploaded by

    rupa sree
    This document contains a sample question paper for the exam "CAT 2" for the course "NoSQL Databases". It has 4 questions worth a total of 50 marks. Question 1 (15 marks) asks about performing various operations like insertion, updating, and deletion on a MongoDB database containing car details. Question 2 (10 marks) asks about performing queries on a MongoDB database containing hospital reports. Question 3 (15 marks) and 4 (10 marks) ask about performing various operations like creation, insertion, counting, and union on Redis datastores containing subject names and exam details.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 2

    QUESTION PAPER

    Name of the Examination: CAT 2

    School SCOPE
    Course Code cs3009 Course Title NoSQL Databases
    Semester Date of exam
    Faculty Name
    Slot Dr. Karthika Natarajan & 70279
    & ID
    Duration 110 mins Total Marks 50

    Type your questions here

    Q1. Mr. Sanjeev wants to development a database using MongoDB for his sales especially car
    which has details such as Sale_id, Brand_name, Supplier_id, Payment-method, Number_of_
    car_ordered and Date & Year of Purchase. (15)
    For the following occurrences, write an answer.
    1. Very first he planned to insert every brand of car details individually.
    2. Later he decided to add all the car details at a time upon the database.
    3. While adding the details, he found out that there is an error, so he has decided to update
    the Payment_method from COD to Card payment for all the cars purchased.
    4. Now he decided to update the database with Customer_id.
    5. He wants to delete a car detail which matches with Brand_name “ TOYOTA”.
    Q2. Mr. Baskar intends to develop an app using MongoDB which deals with hospital report. The
    details are Hoapital_id, Hospital_name , Patient_id , Doctor_id, Consultation_payment,
    Visiting_hour, in_patient, Out_patient (10)
    1. He wants to find the patients who is visiting the Doctor_3.
    2. He wishes to note down the number of patients admitted in hospital.
    3. He wants to know total visiting hours by the doctor_id 2 for the patient-id 3.
    4. He wants to know the number of in-patient waiting for the Doctor id 2 at today.
    5. He wants to calculate the average payment done by the patients in the year 2021.
    Q3. Write commands using REDIS datastore (15)

    1. Write a command for creating a key “CAT-2”


    2. Using List data structure for the same key CAT-2, add the following 5 subjects of yours
    in the front end of the list. i.e. NoSql, DBMS, COA, Python, DA.
    3. Insert a document called ”CN” before Python.
    4. Once inserted list out all the values of the CAT-2.
    5. Pop the document DBMS from CAT-2 and insert the same in another list called
    “Subjects”
    Q4. Write commands using REDIS datastore (10)

    1. Create a key as “Exam”


    2. Insert the members like NoSql, DBMS, COA, Python, DA in sorted order.
    3. Count the member of values between range 1 to 3.
    4. Create another set in an ordered manner with members like Java, SQL, OS, CN. Union
    both the sets together and store it in another set.
    5. Check the new set whether it has OS as its member.

    QP Mapping

    Module CO PO PEO PSO


    Q. No. Marks
    Number Mapped Mapped Mapped Mapped
    Q1 3 CO1, CO2, PO1, PO2, PEO1, PSO1, PSO2 15
    CO3 PO3, PO5, PEO2,
    PO9 PEO3, PEO4
    Q2 3 CO1, CO2, PO1, PO2, PEO1, PSO1, PSO2 10
    CO3 PO3, PO5, PEO2,
    PO9 PEO3, PEO4
    Q3 4 CO1, CO2, PO1, PO2, PEO1, PSO1, PSO2 15
    CO3 PO3, PO5, PEO2,
    PO9 PEO3, PEO4
    Q4 4 CO1, CO2, PO1, PO2, PEO1, PSO1, PSO2 10
    CO3 PO3, PO5, PEO2,
    PO9 PEO3, PEO4

    You might also like