3i Infotech Placement: Sample Questions 242 - 244 of 1245

Glide to success with Doorsteptutor material for competitive exams : get questions, notes, tests, video lectures and more- for all subjects of your exam.

Question 242

Edit

Describe in Detail

Essay▾

What is silly window syndrome?

Explanation

Understanding of Silly Window Syndrome
  • Silly window syndrome is problem in computer networking caused by poorly implemented TCP flow control.
  • Server with this problem is unable to process all incoming data and requests its clients to reduce the amount of data they send.
  • TCP/IP has some flaws and Silly Window Syndrome is the manifestation of these flaws.

Silly Window Syndrome is Avoided By

  • The receiver not advertising small window.
  • The sender not transmitting data unless:
    • A packet is at least as large as the maximum segment size.
    • Ensuring that a packet with at least data half of the remote host՚s window size is sent.
    • The output data is received and there is no unacknowledged data.

Question 243

Edit

Write in Short

Short Answer▾

What is 3NF?

Explanation

  • A relation schema R is in 3NF if it is in 2NF and every FD X A either of the following is true
  • X is a Super-key of R
  • A is a prime attribute of R
  • In other words, if every non prime attribute is non-transitively dependency on primary key.

Question 244

Question

MCQ▾

Does the database trigger fire when the table is TRUNCATED?

Choices

Choice (4)

a.

Yes

b.

No

c.

All of the above

d.

None of the above

Answer

b.

Explanation

Define Truncating a Table
  • No, the database trigger does not fire when the table is TRUNCATED- Because, we cannot trigger on truncate operation.
  • Database trigger apply only for INSERT/UPDATE/DELETE.

Truncate Statement

  • Use TRUNCATE TABLE statement to remove all rows from a table.
  • Removing rows with the TRUNCATE TABLE can be more efficient than dropping and re-creating a table.
  • Performs the same function as DELETE statement without a WHERE clause.

Developed by: