Information Technology Mixed Test - 2

Information Technology Mix Test - 2

25 Questions Published

Questions

Question 1 Multiple Choice (Single Answer)

In which of the following networks are reassembly buffers required?

  1. Message-switched networks
  2. Packet-switched networks
  3. Both (1) and (2)
  4. None of above
Question 2 Multiple Choice (Single Answer)

Which of the following is/are NOT the characteristic(s) of a physical layer?

  1. Functional
  2. Mechanical
  3. Electrical
  4. None of these
Question 3 Multiple Choice (Single Answer)

What is the meaning of 'A ' in ACID Model in SQL ?

  1. Attributes
  2. Atomicity
  3. Both (1) and (2)
  4. None of above
Question 4 Multiple Choice (Single Answer)

How can we increase the efficiency of the doubly linked list ?

  1. By accessing the last element of the list.
  2. By accessing any element from the list.
  3. By traversing the list in left or right direction from node.
  4. None of these
Question 5 Multiple Choice (Single Answer)

Which of the following is/are example(s) of virtual terminal?

  1. Presentation layer
  2. Transport Layer
  3. Application Layer
  4. Both (2) and (3)
Question 6 Multiple Choice (Single Answer)

The number of subtrees of a node in a Tree/Graph is called as

  1. level
  2. depth
  3. degree
  4. none of these
Question 7 Multiple Choice (Single Answer)

Let the depth of a root = 1, what would be the maximum number of nodes in a binary tree of depth 5 ?

  1. 32
  2. 36
  3. 30
  4. 31
Question 8 Multiple Choice (Single Answer)

DOD's transmission control protocol is/are example(s) of _______________ layer.

  1. data link
  2. transport
  3. both (1) and (2)
  4. physical
Question 9 Multiple Choice (Single Answer)

Which of the following is not a Guided Transmission Line ?

  1. Laser beam
  2. A pair of wires
  3. Optical fibre
  4. Both (1) and (2)
Question 10 Multiple Choice (Single Answer)

How many number of nodes are used in a FULL BINARY TREE of depth 5 with no children (from right to left) ?

  1. 17
  2. 15
  3. 16
  4. 18
Question 11 Multiple Choice (Single Answer)

___________________ is used to provide cure or remedy when there are variations amongst clocks of various data sources.

  1. Shared bit
  2. Clock cycle
  3. Pulse stuffing
  4. None of above
Question 12 Multiple Choice (Single Answer)

Which of the following layers of the OSI reference model resolves the problems of the damage or loss of duplicate frames?

  1. Session layer
  2. Application layer
  3. Network layer
  4. Data link layer
Question 13 Multiple Choice (Single Answer)

You cannot use duplicate values in a _______________ key.

  1. duplicate
  2. public
  3. private
  4. primary
Question 14 Multiple Choice (Single Answer)

Which of the following is NOT an example of standard at the data link layer?

  1. HDLC
  2. ADCCP
  3. TCP
  4. None of these
Question 15 Multiple Choice (Single Answer)

Which topology of the LAN uses circuit switching?

  1. Tree
  2. Bus
  3. Ring
  4. Star
Question 16 Multiple Choice (Single Answer)

Which of the following is/are the main objective(s) of SQL SELECT statement?

  1. Projection, selection and joining
  2. Updating the data
  3. Inserting new data in the tables
  4. Deleting data from tables
Question 17 Multiple Choice (Single Answer)

A ___________ key value must match an existing primary key value or unique key value.

  1. foreign
  2. refer
  3. relation
  4. duplicate
Question 18 Multiple Choice (Single Answer)

Which of the following statements is used for eliminating duplicating data in the row 'name' of 'class' table in a SELECT clause?

  1. SELECT UNIQUE name from class.
  2. SELECT name UNIQUE from class;
  3. SELECT DISTINCT name from class.
  4. SELECT name DISTINCT from name.
Question 19 Multiple Choice (Single Answer)

If 0(nlogn) time is used in average case, which of the following sorting techniques is used?

  1. Quick sort
  2. Selection sort
  3. Insertion sort
  4. None of these
Question 20 Multiple Choice (Single Answer)

Which of the following operator precedences is used in SQL Oracle?

  1. [ { ( / * + -
  2. / + * -
  3. * + / -
  4. * / + -
Question 21 Multiple Choice (Single Answer)

Which of the following operating systems does not truly support multithreading?

  1. Solaris Operating system
  2. Windows XP
  3. OS/2
  4. MS DOS
Question 22 Multiple Choice (Single Answer)

Which of the following operating systems does not have GUI Environment (Graphical User Interface)?

  1. Windows 98
  2. Windows Vista
  3. MS DOS
  4. Window XP
Question 23 Multiple Choice (Single Answer)

Which is the path where the user data is stored in windows operating system, i.e windows is installed in C drive ?

  1. C:windowssystem32
  2. c:system
  3. c:Documents and Settings
  4. C:windows
Question 24 Multiple Choice (Single Answer)

Which of the following cabling techniques is assumed as the best technique for building and establishing LANS?

  1. 10BaseF
  2. 10Base2
  3. 10Base5
  4. None of these
Question 25 Multiple Choice (Single Answer)

Which of the following contains the information about file permission, ownership and location?

  1. File block
  2. File system
  3. FCB - File Control Block
  4. Nested Block