Information Technology Mixed Test - 2
Information Technology Mix Test - 2
Questions
In which of the following networks are reassembly buffers required?
- Message-switched networks
- Packet-switched networks
- Both (1) and (2)
- None of above
Which of the following is/are NOT the characteristic(s) of a physical layer?
- Functional
- Mechanical
- Electrical
- None of these
What is the meaning of 'A ' in ACID Model in SQL ?
- Attributes
- Atomicity
- Both (1) and (2)
- None of above
How can we increase the efficiency of the doubly linked list ?
- By accessing the last element of the list.
- By accessing any element from the list.
- By traversing the list in left or right direction from node.
- None of these
Which of the following is/are example(s) of virtual terminal?
- Presentation layer
- Transport Layer
- Application Layer
- Both (2) and (3)
The number of subtrees of a node in a Tree/Graph is called as
- level
- depth
- degree
- none of these
Let the depth of a root = 1, what would be the maximum number of nodes in a binary tree of depth 5 ?
- 32
- 36
- 30
- 31
DOD's transmission control protocol is/are example(s) of _______________ layer.
- data link
- transport
- both (1) and (2)
- physical
Which of the following is not a Guided Transmission Line ?
- Laser beam
- A pair of wires
- Optical fibre
- Both (1) and (2)
How many number of nodes are used in a FULL BINARY TREE of depth 5 with no children (from right to left) ?
- 17
- 15
- 16
- 18
___________________ is used to provide cure or remedy when there are variations amongst clocks of various data sources.
- Shared bit
- Clock cycle
- Pulse stuffing
- None of above
Which of the following layers of the OSI reference model resolves the problems of the damage or loss of duplicate frames?
- Session layer
- Application layer
- Network layer
- Data link layer
You cannot use duplicate values in a _______________ key.
- duplicate
- public
- private
- primary
Which of the following is NOT an example of standard at the data link layer?
- HDLC
- ADCCP
- TCP
- None of these
Which topology of the LAN uses circuit switching?
- Tree
- Bus
- Ring
- Star
Which of the following is/are the main objective(s) of SQL SELECT statement?
- Projection, selection and joining
- Updating the data
- Inserting new data in the tables
- Deleting data from tables
A ___________ key value must match an existing primary key value or unique key value.
- foreign
- refer
- relation
- duplicate
Which of the following statements is used for eliminating duplicating data in the row 'name' of 'class' table in a SELECT clause?
- SELECT UNIQUE name from class.
- SELECT name UNIQUE from class;
- SELECT DISTINCT name from class.
- SELECT name DISTINCT from name.
If 0(nlogn) time is used in average case, which of the following sorting techniques is used?
- Quick sort
- Selection sort
- Insertion sort
- None of these
Which of the following operator precedences is used in SQL Oracle?
- [ { ( / * + -
- / + * -
- * + / -
- * / + -
Which of the following operating systems does not truly support multithreading?
- Solaris Operating system
- Windows XP
- OS/2
- MS DOS
Which of the following operating systems does not have GUI Environment (Graphical User Interface)?
- Windows 98
- Windows Vista
- MS DOS
- Window XP
Which is the path where the user data is stored in windows operating system, i.e windows is installed in C drive ?
- C:windowssystem32
- c:system
- c:Documents and Settings
- C:windows
Which of the following cabling techniques is assumed as the best technique for building and establishing LANS?
- 10BaseF
- 10Base2
- 10Base5
- None of these
Which of the following contains the information about file permission, ownership and location?
- File block
- File system
- FCB - File Control Block
- Nested Block