Sign Up

Have an account? Sign In Now

Sign In

Forgot Password?

Don't have account, Sign Up Here

Forgot Password

Lost your password? Please enter your email address. You will receive a link and will create a new password via email.

Have an account? Sign In Now

Sorry, you do not have permission to ask a question, You must login to ask a question.

Forgot Password?

Need An Account, Sign Up Here

You must login to ask a question.

Forgot Password?

Need An Account, Sign Up Here
Sign InSign Up

SIKSHAPATH

SIKSHAPATH Logo SIKSHAPATH Logo

SIKSHAPATH Navigation

  • Home
  • Questions
  • Blog
    • Computer Science(CSE)
    • NPTEL
    • Startup
  • Shop
    • Internshala Answers
Search
Ask A Question

Mobile menu

Close
Ask A Question
  • Home
  • Questions
  • Blog
    • Computer Science(CSE)
    • NPTEL
    • Startup
  • Shop
    • Internshala Answers
  • About
    1. Asked: November 16, 2021In: DBMS

      Two transactions T1 and T2 are given as: T1: r1(X) w1(X)r1(Y)w1(Y) T2 : r2(Y)w2(Y)r2(Z)w2(Z) where ri(V) denotes a read operation by transaction Ti on a variable V and wi(V) denotes a write operation by transaction Ti on a variable V. Calculate The total number of conflict serializable schedules that can be formed by T1 and T2

      I'M ADMIN
      I'M ADMIN
      Added an answer on November 16, 2021 at 2:59 pm

      Two transactions T1 and T2 are given as: T1: r1(X) w1(X)r1(Y)w1(Y) T2 : r2(Y)w2(Y)r2(Z)w2(Z)   . . . . . . .. ANSWER :

      Two transactions T1 and T2 are given as:

      T1: r1(X) w1(X)r1(Y)w1(Y)

      T2 : r2(Y)w2(Y)r2(Z)w2(Z)

       

      . . . . . . ..

      ANSWER :

      See less
      Attachment

        • 0
      • Share
        Share
        • Share on WhatsApp
        • Share on Facebook
        • Share on Twitter
        • Share on LinkedIn
    2. Asked: November 16, 2021In: DBMS

      State the purpose of the checkpoint mechanism. How often should checkpoints be performed? How does the frequency of checkpoints affect. a. System performance when no failure occurs

      I'M ADMIN
      I'M ADMIN
      Added an answer on November 16, 2021 at 2:29 pm

      A checkpoint log record indicates that a log record and its modified data has been written to stable storage and that the transaction need not to be redone in case of a system crash. Obviously, the more often checkpoints are performed, the less likely it is that redundant updates will have to be perRead more

      
      A checkpoint log record indicates that a log record and its modified data has been written to stable storage and that the transaction need not to be redone in case of a system crash. Obviously, the more often checkpoints are performed, the less likely it is that redundant updates will have to be performed during the recovery process.
      
      
      • System performance when no failure occurs-If no failures occur, the system must incur the cost of performing checkpoints that are essentially unnecessary. In this situation, performing checkpoints less often will lead to better system performance.
      
      • The time it takes to recover from a system crash-The existence of a checkpoint record means that an operation will not have to be redone during system recovery. In this situation, the more often checkpoints were performed, the faster the recovery time is from a system crash.
      
      
      •The time it takes to recover from a disk crash-The existence of a checkpoint record means that an operation will not have to be redone during system recovery. In this situation, the more often checkpoints were performed, the faster the recovery time is from a disk crash.
      
      See less
        • 2
      • Share
        Share
        • Share on WhatsApp
        • Share on Facebook
        • Share on Twitter
        • Share on LinkedIn
    3. Asked: November 16, 2021In: DBMS

      The following table has two attributes A and C where A is the primary key and C is the foreign key referencing A with on-delete cascade. A C —– 2 4 3 4 4 3 5 2 7 2 9 5 6 4 The set of all tuples that must be additionally deleted to preserve referential integrity when the tuple (2,4) is deleted

      I'M ADMIN
      I'M ADMIN
      Added an answer on November 16, 2021 at 2:26 pm

      When (2,4) is deleted. Since C is a foreign key referring A with delete on cascade, all entries with value 2 in C must be deleted. So (5, 2) and (7, 2) are deleted. As a result of this 5 and 7 are deleted from A which causes (9, 5) to be deleted.

      
      When (2,4) is deleted. Since C is a foreign key referring A with delete on cascade, all entries with value 2 in C must be deleted. So (5, 2) and (7, 2) are deleted. As a result of this 5 and 7 are deleted from A which causes (9, 5) to be deleted.
      
      
      See less
        • 3
      • Share
        Share
        • Share on WhatsApp
        • Share on Facebook
        • Share on Twitter
        • Share on LinkedIn
    4. Asked: October 31, 2021In: DBMS

      calculate electricity bill- dbms

      I'M ADMIN
      I'M ADMIN
      Added an answer on November 11, 2021 at 10:11 pm

      CREATE OR REPLACE PROCEDURE E_bill(unit in number,net out number) is BEGIN --drop procedure E_bill --for first 100 unit :RS 5 per unit if (unit between 0 and 100) then . . . . . . . .   TAP ON ATTACHMENT BUTTON FOR ANSWER:

      CREATE OR REPLACE PROCEDURE E_bill(unit in number,net out number) is

      BEGIN

      –drop procedure E_bill

      –for first 100 unit :RS 5 per unit

      if (unit between 0 and 100) then . . . . . . . .

       

      TAP ON ATTACHMENT BUTTON FOR ANSWER:

      See less
      Attachment

        • 0
      • Share
        Share
        • Share on WhatsApp
        • Share on Facebook
        • Share on Twitter
        • Share on LinkedIn
    5. Asked: November 9, 2021In: Other

      Combination circuit using nor gate

      I'M ADMIN
      I'M ADMIN
      Added an answer on November 10, 2021 at 10:47 pm
      This answer was edited.

      QUESTION: Design a combinational circuit using NOR gates with three inputs, x, y, and z, and three outputs, A, B, and C. When the binary input is 0, 1, 2, or 3, the binary output is one greater than the input. When the binary input is 4, 5, 6, or 7, the binary output is two less than the input. ANSWRead more

      QUESTION:

      Design a combinational circuit using NOR gates with three inputs, x, y, and z, and three outputs, A, B, and C. When the binary input is 0, 1, 2, or 3, the binary output is one greater than the input. When the binary input is 4, 5, 6, or 7, the binary output is two less than the input.

      ANSWER IN ATTACHMENT JUST TAP ON ATTACHMENT BUTTON:

      See less
      Attachment

        • 0
      • Share
        Share
        • Share on WhatsApp
        • Share on Facebook
        • Share on Twitter
        • Share on LinkedIn
    6. Asked: November 10, 2021In: DBMS

      Create a package which includes a function to return a square of a number if it is positive else return an error message to the user.

      I'M ADMIN
      I'M ADMIN
      Added an answer on November 10, 2021 at 10:13 pm

      create or replace package Square as   function cal(n in number) return number; . . . . . . . FULL ANSWER IS IN THE ATTACHMENT:

      create or replace package Square as

       

      function cal(n in number) return number;

      . . . . . . .

      FULL ANSWER IS IN THE ATTACHMENT:

      See less
      Attachment

        • 0
      • Share
        Share
        • Share on WhatsApp
        • Share on Facebook
        • Share on Twitter
        • Share on LinkedIn
    1 … 116 117 118 119 120 … 122

    Sidebar

    store ads

    Stats

    • Questions 1k
    • Answers 1k
    • Posts 149
    • Best Answers 89
    • This Free AI Tool Translates Entire Books in Minute !
    • AI News: 🎬 Hollywood’s AI Studios, 🎓 OpenAI’s Latest Gift to Educators, 🚚 Class8 Bags $22M, 🧠 Google Gemini’s Memory Upgrade
    • AI NEWS: Legal Action Against OpenAI, $16M Paid, & Elon Musk’s Praise from Investor 🤖💰📑 | AI Boosts Cloud Seeding for Water Security 🌱💧
    • AI News: 🎬AI Video Tool Scam Exposed🤯, 🛰️ AI-Powered Drones to Ukraine 😱, Google’s $20M AI Push, Sam Altman Joins SF’s Leadership Team
    • AI News: 🤝 Biden Meets Xi on AI Talks, 💡 Xavier Niel’s Advice for Europe, ♻️ Hong Kong’s Smart Bin Revolution, 🚀 AI x Huawei

    Explore

    • Recent Questions
    • Questions For You
    • Answers With Time
    • Most Visited
    • New Questions
    • Recent Questions With Time

    Footer

    SIKSHAPATH

    Helpful Links

    • Contact
    • Disclaimer
    • Privacy Policy Notice
    • TERMS OF USE
    • FAQs
    • Refund/Cancellation Policy
    • Delivery Policy for Sikshapath

    Follow Us

    © 2021-24 Sikshapath. All Rights Reserved