3i Infotech Placement: Sample Questions 1054 - 1056 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 1054

Edit

Write in Short

Short Answer▾

What is a VIEW? How to get script for a view?

Explanation

VIEW: View is a logical partition of one or more table in horizontally (by putting condition) or vertically (by including selected columns) .

  • View can be used to update table, provides security mechanism.
  • View definition (query) stored as plan text or Encrypted text
  • We can see view definition by using following stored procedure exec sp_helptext viewname

Question 1055

Edit

Describe in Detail

Essay▾

In Unix “. profile” files contains

Explanation

“. profile” contains commands meant to be executed only once in a session.

Bellow is the information that it includes:

  • The type of terminal user is using
  • A list of directories in which to locate the commands
  • A list of variable affecting the look and feel of our terminal
The Information

Question 1056

Edit

Write in Short

Short Answer▾

Which line will be activated when an output device requires attention from CPU?

Explanation

  • Interrupt line is activated when an output device requires attention from CPU.
  • This is why adding a new device to a PC requires IRQ number by setting a DIP switch. This specifies the interrupt line the device will use.
  • IRQ conflicts were a common problem when adding expansion boards, but the plug and play specification removed this problem.

Developed by: