Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Pro Blog
  • Users
  • Groups
  • Unsolved
  • Solved
Collapse
Secnto AI
  1. Secnto AI
  2. Categories
  3. Virtual University
  4. CS409 - Introduction to Database Administration
  5. CS409 Quiz 2 Solution and Discussion
CS409 Quiz 2 Solution and Discussion
zareenZ
Quiz # 2 Total Questions : 10 Please read the following instructions carefully! Quiz will be based upon Multiple Choice Questions (MCQs). You have to attempt the quiz online. You can start attempting the quiz any time within given date(s) of a particular subject by clicking the link for Quiz in VULMS. Each question has a fixed time of 90 seconds. So you have to save your answer before 90 seconds. But due to unstable internet speeds, it is recommended that you should save your answer within 60 seconds. While attempting a question, keep an eye on the remaining time. Attempting quiz is unidirectional. Once you move forward to the next question, you can not go back to the previous one. Therefore before moving to the next question, make sure that you have selected the best option. DO NOT press Back Button / Backspace Button while attempting a question, otherwise you will lose that question. DO NOT refresh the page unnecessarily, specially when following messages appear Saving… Question Timeout: Now loading next question… Javascript MUST be enabled in your browser; otherwise you will not be able to attempt the quiz. If for any reason, you lose access to internet (like power failure or disconnection of internet), you will be able to attempt the quiz again from the question next to the last shown question. But remember that you have to complete the quiz before expiry of the deadline. If any student failed to attempt the quiz in given time then no re-take or offline quiz will be held. Start Quiz
CS409 - Introduction to Database Administration
CS409 Assignment 2 Solution and Discussion
zaasmiZ
Re: CS409 Assignment 2 Solution and Discussion Assignment No. 02 SEMESTER SPRING 2020 CS409- Introduction to Database Administration Total Marks: 20 Due Date: 23/06/2020 The objectives of this assignment are, • To give students the idea of the most commonly used RDBMS for designing logical data model. • To learn how to convert entities and attributes into tables and columns. • To make relationship between them. Lectures Covered: This assignment covers topics discussed in Week # 04-05 Task Description: Scenario: CarMatch is a franchising company that is being set up to promote car sharing. CarMatch seeks to promote car sharing and to provide a service to potential car sharers by matching up people who both live and work near one another. . People who join up will pay a small membership fee, which will be refunded if the local CarMatch franchise is unable to match them up with one or more other people who require or are offering transport. The CarMatch franchise will draw up model agreements between the participants, to prevent the money that changes hands to cover fuel costs being treated as taxable income, and advice on the insurance implications of car sharing. It will act as an agent for companies that sell insurance policies that specifically cover car sharing. Consider the given below the ERD of a scenario given here. You are required to convert it into its logical model. [image: kxWIiOy.png] For any query about the assignment, contact at CS409@vu.edu.pk GOOD LUCK
CS409 - Introduction to Database Administration
CS409 Assignment 1 Solution and Discussion
zaasmiZ
Re: CS409 Assignment 1 Solution and Discussion Assignment No. 01 SEMESTER Spring 2020 CS409- Database Administration Total Marks: 20 Due Date: 01/06/2020 Instructions Please read the following instructions carefully before solving & submitting assignment: It should be clear that your assignment will not get any credit if: o The assignment is submitted after due date. o The submitted assignment does not open or file corrupt. o The assignment is fully or partially copied from (other student or ditto copy from handouts or internet). o Student ID is not mentioned in the assignment File or name of file is other than student ID. o The assignment is not submitted in .doc/docx format. Uploading instructions Your submission must include: • Assignment should be in .doc/docx format. • Save your assignment with your ID (e.g bx020200786.doc/docx). Assignment submission through email is NOT acceptable Objective The objective of this assignment is o To give some important knowledge about the database environment of organization Lectures Covered: This assignment covers Lecture # 01 – 03 Deadline Your assignment must be uploaded/submitted on or before 01/06/2020. Question# 01: Scenario In today’s era of intelligence and mobility where every thing is shifted on mobile like mobile commerce, and mobile computing. Suppose you are working as DBA in a multinational company which works on mobile system and your company decided to change the database structure to embedded database, and as a DBA you suggest your company to used SQLite. State the reasons by which you will convince your company seniors to use SQL Lite? Question # 02: Write any ten situations in which using SQLite will give best results? For any query about the assignment, contact at CS409@vu.edu.pk Good Luck
CS409 - Introduction to Database Administration
CS409 Assignment 2 Solution and Discussion
zareenZ
Assignment No. 02 SEMESTER FALL 2019 CS409- Introduction to Database Administration Total Marks: 20 Due Date: 29/11/2019 Instructions Please read the following instructions carefully before solving & submitting assignment: It should be clear that your assignment will not get any credit if: o The assignment is submitted after the due date. o The submitted assignment does not open or the file is corrupt. o The assignment is fully or partially copied from (other student or ditto copy from handouts or internet). o The student ID is not mentioned in the assignment File or name of file is other than student ID. o The assignment is not submitted in .doc/docx format. Uploading instructions Your submission must include: • Assignment should be in .doc/docx format. • Save your assignment with your ID (e.g bx020200786.doc/docx). • Assignment submission through email is NOT acceptable Objective The objectives of this assignment are, • To give students the idea of the most commonly used RDBMS for designing physical database systems i.e. SQL Server. • To build and manage tables in SQL Server. • To apply constraints e.g. Primary Key and Foreign Key on attributes. Lectures Covered: This assignment covers topics discussed in Week # 04-05 Deadline Your assignment must be uploaded/submitted on or before 29/11/2019. Task Description: This Assignment is related to Development phase and in this assignment you will focus only on the tasks given below: Consider the following ER Diagram and perform the given tasks; [image: U1DZCPN.png] Tasks: Follow the procedure explained in audio lectures to open the SQL Server and create a database with the name “Events”. You are required to transform all entities into tables by using design view method. You have to transform all entity attributes into columns. Define appropriate data types of each attribute. Apply necessary constraints on attributes. Take screenshots of every step and paste them in your solution file (.doc/docx file). For any query about the assignment, contact at CS409@vu.edu.pk GOOD LUCK
CS409 - Introduction to Database Administration
CS409 Assignment 1 Solution and Discussion
zareenZ
Assignment No. 01 SEMESTER Fall 2019 CS409- Database Administration Total Marks: 20 Due Date: 15/11/2019 Instructions Please read the following instructions carefully before solving & submitting assignment: It should be clear that your assignment will not get any credit if: o The assignment is submitted after due date. o The submitted assignment does not open or file corrupt. o The assignment is fully or partially copied from (other student or ditto copy from handouts or internet). o Student ID is not mentioned in the assignment File or name of file is other than student ID. o The assignment is not submitted in .doc/docx format. Uploading instructions Your submission must include: • Assignment should be in .doc/docx format. • Save your assignment with your ID (e.g bx020200786.doc/docx). Assignment submission through email is NOT acceptable Objective The objective of this assignment is o To give some important knowledge about the database environment of organization Lectures Covered: This assignment covers Lecture # 01 – 03 Deadline Your assignment must be uploaded/submitted at or before 15/11/2019. Question# 01: Scenario In today’s era of intelligence and mobility where every thing is shifted on mobile like mobile commerce, and mobile computing. Suppose you are working as DBA in a multinational company which works on mobile system and your company decided to change the database structure to embedded database, and as a DBA you suggest your company to used SQLite. State the reasons by which you will convince your company seniors to use SQL Lite? Question # 02: Write any ten situations in which using SQLite will give best results? For any query about the assignment, contact at CS409@vu.edu.pk Good Luck
CS409 - Introduction to Database Administration
CS409 Assignment 3 Solution and Discussion
zareenZ
Assignment No. 03 SEMESTER Fall 2019 CS409- Database Administration Total Marks: 20 Due Date: 21/01/2020 Instructions Please read the following instructions carefully before solving & submitting assignment: It should be clear that your assignment will not get any credit if: The assignment is submitted after the due date. The submitted assignment does not open or the file is corrupt. The assignment is fully or partially copied from (other student or ditto copy from the handouts or internet). Student ID is not mentioned in the assignment File or name of file is other than the student ID. The assignment is not submitted in .doc/docx format. Uploading instructions Your submission must include: Assignment should be in .doc/docx format. Save your assignment with your ID (e.g bx020200786.doc/docx). Assignment submission through email is NOT acceptable Objective The objective of this assignment is To give some important knowledge about the database environment of organization Lectures Covered: This assignment covers Lecture # 08 – 11 Deadline Your assignment must be uploaded/submitted on or before 21/1/2020. Question # 01: Suppose you have the database titles as “SchoolManagement” and you are asked to create its backup. Write down all steps of creating full backup using Microsoft Management Studio and write T-SQL query of creating backup code also. For any query about the assignment, contact at CS409@vu.edu.pk Good Luck
CS409 - Introduction to Database Administration

CS409 Quiz 2 Solution and Discussion

Scheduled Pinned Locked Moved Solved CS409 - Introduction to Database Administration
introduction to database administracs409quiz 2solutiondiscussion
13 Posts 2 Posters 2.9k Views 2 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • zareenZ Offline
    zareenZ Offline
    zareen
    Cyberian's Gold
    wrote on last edited by
    #5

    Availability comprises __________distinct components.
    c9616a97-82e8-45fc-bb44-e437fd8c05e3-image.png

    Discussion is right way to get Solution of the every assignment, Quiz and GDB.
    We are always here to discuss and Guideline, Please Don't visit Cyberian only for Solution.
    Cyberian Team always happy to facilitate to provide the idea solution. Please don't hesitate to contact us!
    %(red)[NOTE: Don't copy or replicating idea solutions.]
    Quiz Copy Solution
    Mid and Final Past Papers
    Live Chat

    1 Reply Last reply
    0
    • zareenZ Offline
      zareenZ Offline
      zareen
      Cyberian's Gold
      wrote on last edited by
      #6

      Database backup policy should consider following factor(s) before backup.

      d176a9fd-ca4e-4fc8-bb5a-0ca4e027ecb0-image.png

      Discussion is right way to get Solution of the every assignment, Quiz and GDB.
      We are always here to discuss and Guideline, Please Don't visit Cyberian only for Solution.
      Cyberian Team always happy to facilitate to provide the idea solution. Please don't hesitate to contact us!
      %(red)[NOTE: Don't copy or replicating idea solutions.]
      Quiz Copy Solution
      Mid and Final Past Papers
      Live Chat

      1 Reply Last reply
      0
      • zareenZ Offline
        zareenZ Offline
        zareen
        Cyberian's Gold
        wrote on last edited by
        #7

        Media recovery deals with ____________.

        2ce32051-d579-4b1b-a401-3573cb4acd5b-image.png

        Discussion is right way to get Solution of the every assignment, Quiz and GDB.
        We are always here to discuss and Guideline, Please Don't visit Cyberian only for Solution.
        Cyberian Team always happy to facilitate to provide the idea solution. Please don't hesitate to contact us!
        %(red)[NOTE: Don't copy or replicating idea solutions.]
        Quiz Copy Solution
        Mid and Final Past Papers
        Live Chat

        1 Reply Last reply
        0
        • zareenZ Offline
          zareenZ Offline
          zareen
          Cyberian's Gold
          wrote on last edited by
          #8

          Data is not altered in _____________.
          896724e1-b0af-486c-942e-01d74b520e66-image.png

          Discussion is right way to get Solution of the every assignment, Quiz and GDB.
          We are always here to discuss and Guideline, Please Don't visit Cyberian only for Solution.
          Cyberian Team always happy to facilitate to provide the idea solution. Please don't hesitate to contact us!
          %(red)[NOTE: Don't copy or replicating idea solutions.]
          Quiz Copy Solution
          Mid and Final Past Papers
          Live Chat

          1 Reply Last reply
          0
          • zareenZ Offline
            zareenZ Offline
            zareen
            Cyberian's Gold
            wrote on last edited by
            #9

            ______________ is an exact copy of a single data file, archived redo log file, or control file.

            76750a7a-f271-4a68-968b-8e1d87bf63c4-image.png

            Discussion is right way to get Solution of the every assignment, Quiz and GDB.
            We are always here to discuss and Guideline, Please Don't visit Cyberian only for Solution.
            Cyberian Team always happy to facilitate to provide the idea solution. Please don't hesitate to contact us!
            %(red)[NOTE: Don't copy or replicating idea solutions.]
            Quiz Copy Solution
            Mid and Final Past Papers
            Live Chat

            1 Reply Last reply
            0
            • zareenZ Offline
              zareenZ Offline
              zareen
              Cyberian's Gold
              wrote on last edited by
              #10

              Rollback of transactions is normally used to :
              f3721b47-a50f-49c3-acfc-14a982f16217-image.png

              Discussion is right way to get Solution of the every assignment, Quiz and GDB.
              We are always here to discuss and Guideline, Please Don't visit Cyberian only for Solution.
              Cyberian Team always happy to facilitate to provide the idea solution. Please don't hesitate to contact us!
              %(red)[NOTE: Don't copy or replicating idea solutions.]
              Quiz Copy Solution
              Mid and Final Past Papers
              Live Chat

              1 Reply Last reply
              0
              • zareenZ Offline
                zareenZ Offline
                zareen
                Cyberian's Gold
                wrote on last edited by
                #11

                __________________ is typically fast compared to other migration technology.

                fd0bf4d6-de74-4104-b642-24d8284e7d7e-image.png

                Discussion is right way to get Solution of the every assignment, Quiz and GDB.
                We are always here to discuss and Guideline, Please Don't visit Cyberian only for Solution.
                Cyberian Team always happy to facilitate to provide the idea solution. Please don't hesitate to contact us!
                %(red)[NOTE: Don't copy or replicating idea solutions.]
                Quiz Copy Solution
                Mid and Final Past Papers
                Live Chat

                zaasmiZ 1 Reply Last reply
                0
                • zareenZ zareen

                  __________________ is typically fast compared to other migration technology.

                  fd0bf4d6-de74-4104-b642-24d8284e7d7e-image.png

                  zaasmiZ Offline
                  zaasmiZ Offline
                  zaasmi
                  Cyberian's Gold
                  wrote on last edited by
                  #12

                  @zareen said in CS409 Quiz 2 Solution and Discussion:

                  __________________ is typically fast compared to other migration technology.

                  Array-based Migration

                  (Specifically, the third option: Array-based Migration.)

                  Why it is the fastest:

                  Array-based Migration occurs at the storage hardware level. It uses specialized controllers and high-speed links to move data directly from one storage array to another without involving the host servers (the computers using the data).

                  • Speed: It offloads the work from the servers and the local area network (LAN), using dedicated storage area network (SAN) bandwidth.
                  • Efficiency: It handles massive volumes of data at the block level, making it significantly faster than host-based methods that have to process files through the operating system.

                  Discussion is right way to get Solution of the every assignment, Quiz and GDB.
                  We are always here to discuss and Guideline, Please Don't visit Community only for Solution.
                  Community Team always happy to facilitate to provide the idea solution. Please don't hesitate to contact us!
                  [NOTE: Don't copy or replicating idea solutions.]
                  VU Handouts
                  Quiz Copy Solution
                  Mid and Final Past Papers
                  Live Chat

                  zaasmiZ 1 Reply Last reply
                  0
                  • zaasmiZ zaasmi

                    @zareen said in CS409 Quiz 2 Solution and Discussion:

                    __________________ is typically fast compared to other migration technology.

                    Array-based Migration

                    (Specifically, the third option: Array-based Migration.)

                    Why it is the fastest:

                    Array-based Migration occurs at the storage hardware level. It uses specialized controllers and high-speed links to move data directly from one storage array to another without involving the host servers (the computers using the data).

                    • Speed: It offloads the work from the servers and the local area network (LAN), using dedicated storage area network (SAN) bandwidth.
                    • Efficiency: It handles massive volumes of data at the block level, making it significantly faster than host-based methods that have to process files through the operating system.

                    zaasmiZ Offline
                    zaasmiZ Offline
                    zaasmi
                    Cyberian's Gold
                    wrote on last edited by
                    #13

                    Actually, there might be a bit of confusion in that interpretation. In the context of computer science and storage management exams (specifically regarding Data Center Management or Storage Area Networks), the question is usually asking which technology provides the highest performance and speed.

                    The correct answer remains Array-based Migration.

                    Why “None of the above” is incorrect in this context:

                    While you are right that a prompt needs a clear question, in standardized testing for IT certifications (like EMC, NetApp, or VMware), this specific sentence structure is used to test your knowledge of migration overhead.

                    Here is the technical comparison of why Array-based is the fastest:

                    • Host-based: Slowest because it consumes the host’s CPU/memory and moves data across the standard network.
                    • Appliance/Fabric-based: Fast, but requires an extra layer of hardware in the middle which can create a bottleneck.
                    • Array-based: Fastest because it moves data directly from one storage controller to another at the block level, usually over high-speed Fibre Channel links, with zero impact on the host or the application.

                    If you are filling this out for a quiz, the system expects you to identify the most efficient technology from the list provided.

                    Discussion is right way to get Solution of the every assignment, Quiz and GDB.
                    We are always here to discuss and Guideline, Please Don't visit Community only for Solution.
                    Community Team always happy to facilitate to provide the idea solution. Please don't hesitate to contact us!
                    [NOTE: Don't copy or replicating idea solutions.]
                    VU Handouts
                    Quiz Copy Solution
                    Mid and Final Past Papers
                    Live Chat

                    1 Reply Last reply
                    0
                    • zaasmiZ zaasmi has marked this topic as solved on

                    Reply
                    • Reply as topic
                    Log in to reply
                    • Oldest to Newest
                    • Newest to Oldest
                    • Most Votes


                    Reputation Earning
                    How to Build a $1,000/Month World CUP LIVE Matches Live Cricket Streaming
                    Ads
                    File Sharing
                    Earn with File Sharing
                    Stats

                    0

                    Online

                    3.0k

                    Users

                    2.8k

                    Topics

                    8.5k

                    Posts
                    Popular Tags
                    solution
                    1235
                    discussion
                    1195
                    fall 2019
                    813
                    assignment 1
                    428
                    assignment 2
                    294
                    spring 2020
                    265
                    gdb 1
                    238
                    assignment 3
                    79
                    Trending
                    • PM. IMRAN KHAN
                      Zaeem ChZ
                      Zaeem Ch
                      4
                      3
                      4.4k

                    • Are the vaccines halal or not?
                      undefined
                      4
                      1
                      4.0k

                    • All Subjects MidTerm and Final Term Solved Paper Links Attached Please check moaaz past papers
                      zaasmiZ
                      zaasmi
                      3
                      26
                      76.7k

                    • CS614 GDB Solution and Discussion
                      M
                      moaaz
                      3
                      3
                      8.3k

                    • How can I receive Reputation earning from Cyberian? 100% Discount on Fee
                      Y
                      ygytyh
                      3
                      28
                      24.9k
                    Online User
                    | |
                    Copyright © 2010-26 RUP Technologies LLC. USA | Contributors | Privacy | Terms
                    • Login

                    • Don't have an account? Register

                    • Login or register to search.
                    • First post
                      Last post
                    0
                    • Categories
                    • Recent
                    • Tags
                    • Popular
                    • Pro Blog
                    • Users
                    • Groups
                    • Unsolved
                    • Solved