Homechevron_rightEngineeringchevron_rightRPSC Programmerchevron_rightProgrammer DBMSchevron_right<p>Consider the following statements:</p> <p>S1:&...

Consider the following statements: S1: In distance v...

  • Q.

    Consider the following statements:

    S1: In distance vector routing, each router maintains a routing table indexed by, and containing one entry for each router in the network.

    S2: Link state routing requires more memory and computation as compared to distance vector routing.

    Which of the given statements is/are true?

  • filter_dramaExplanation
    Answer is : C

    Answer: Option 3

    Explanation

    Both S1 and S2 are true.

    In distance vector routing, each router maintains a routing table indexed by and containing one entry for each router in the network. This entry has two parts: the preferred outgoing line to use for that destination and an estimate of the distance to that destination. The distance might be measured as the number of hops.

    Compared to distance vector routing, link state routing requires more memory and computation. For a network with n routers, each of which has k neighbours, the memory required to store the input data is proportional to kn, which is at least as large as a routing table listing all the destinations.

Discussion

    No one started the discussion yet. Break the ice and start the conversation.
    Please Login to be part of the discussion.

Similar Questions

  • 1. Big Data is generally characterised by three Vs that stand for ______, _____ and ______.
  • filter_dramaExplanation
    Answer is : D

    Concept:

    Big data is a field that treats ways to analyse, systematically extract information from, or otherwise deal with data sets that are too large or complex to be dealt with by traditional data-processing application software.

    Explanation:

    Big Data can be defined using the famous 3 Vs - Volume, Velocity and Variety.

    VOLUME:

    Volume refers to the amount of data generated through websites, portals and online applications.

    VELOCITY:

    With Velocity we refer to the speed with which data are being generated.

    VARIETY

    Variety in Big Data refers to all the structured and unstructured data that has the possibility of getting generated either by humans or by machines.

    The most added data are unstructured -texts, tweets, pictures & videos.

  • 2.

    Given the following two statements about SQL

    (a) An SQL query can contain HAVING clause only if it has GROUP BY clause.

    (b) In an SQL query “SELECT_FROM_WHERE_GROUP BY_HAVING”, HAVING is executed before WHERE.

    Which of the following is correct?

  • filter_dramaExplanation
    Answer is : B

    Concept:

    Statement b:

    • The order of execution of Clauses:  FROM > WHERE > GROUP BY > HAVING > DISTINCT > SELECT > ORDER BY


    Statement b is saying that HAVING is executed before WHERE but according to above order WHERE is executed before HAVING so statement b is false.

    Statement a:

    • An SQL query can contain HAVING clause only if it has GROUP By clause this is true statement


    So option 2 is the correct answer.

  • 3. Which is the most reliable topology
  • filter_dramaExplanation
    Answer is : C

    the correct answer is option 3

    CONCEPT:

    Mesh topology:

    A mesh topology provides a connection from each node to every other node on the network. This provides a fully redundant network and it is the most reliable of all networks. If any link or node in the network fails, then there will be another path that will allow network traffic to continue.

    What is Mesh Topology?

    Additional Information

    Ring topology:

    A ring topology is a in which each node connects to exactly two other nodes, forming a single continuous pathway for signals through each node that makes a ring. Data travels from node to node, with each node along the way handling every packet.

    Star topology:

    A star topology is a topology for a Local Area Network(LAN) in which all nodes are individually connected to a central connection point, like a hub or a switch. A star takes more cable than bus topology, but the benefit is that if a cable fails, only one node will be brought down.

    Bus topology:

    A bus topology is a topology for a LAN in which all the nodes are connected to a single cable. The cable to which the nodes connected is called a backbone. if the backbone is broken, the entire segment fails. Bus topology is easy to install and doesn't require much cabling compared to the alternatives.

  • 4. ______ clause allows sorting of query results by one or more columns.
  • filter_dramaExplanation
    Answer is : D
    DISTINCT

    DISTINCT statement is used to return only distinct (different) values.For Ex:

    SELECT DISTINCT column1, column2, ...
    FROM table_name;

    ALL

    ALL operator returns true if all of the subquery values meet the condition. For Ex:

    SELECT column_name(s)
    FROM table_name
    WHERE column_name operator ALL
    (SELECT column_name FROM table_name WHERE condition);

    WHERE

    The WHERE clause is used to extract only those records that fulfill a specified condition.

    For ex: SELECT column_name FROM table_name WHERE condition

    ORDER BY

    he ORDER BY keyword is used to sort the result-set in ascending or descending order.For Ex:

    SELECT column1, column2, ...
    FROM table_name
    ORDER BY column1, column2, ... ASC|DESC;
     

     

  • 5.

    Consider the following statements:

    Statement 1: The two-phase locking protocol ensures conflict serializability and ensures freedom from deadlock.

    Statement 2: With rigorous two-phase locking, transactions cannot be serialized in the order in which they commit.

    Statement 3: Strict two-phase locking requires not only that locking is two-phase, but also that all exclusive-mode locks taken by a transaction be held until that transaction commits.

    Which of the given statements is/are false?

  • filter_dramaExplanation
    Answer is : A

    Answer: Option 1

    Explanation:

    The correct answer is option 1 i.e. both S1 and S2 are false.

    Statement 1: The two-phase locking protocol ensures conflict serializability and ensures freedom from deadlock.

    This Statement is not true. because The two-phase locking protocol ensures conflict serializability but does not ensure freedom from deadlock.

    Statement 2: With rigorous two-phase locking, transactions cannot be serialized in the order in which they commit.

    This Statement is not true. With rigorous two-phase locking, transactions can be serialized in the order in which they commit.

    Statement 3: Strict two-phase locking requires not only that locking is two-phase, but also that all exclusive-mode locks taken by a transaction be held until that transaction commits.

    This Statement is true. this is the definition of the Strict 2-Phase protocol.

Programmer DBMSTopics

leaderboardLeaderboard
  • Rahul Kumar

    191 Points

  • VIKRAM JEET

    54 Points

  • GEETHIKA CHOWDARY

    53 Points

  • sunita saini

    52 Points

  • Zain

    49 Points