Computer awareness questions ibps so it officer practice question set 2

COMPUTER AWARENESS QUESTIONS FOR IBPS SO | IT OFFICER PRACTICE QUESTION SET-2

1. In Oracle, who owns the data dictionary?

    (A)  Oracle

    (B)  SYS

    (C)  The DBA

    (D)  SYSTEM

    (E) None of these

2. The effect of the ROLLBACK command in a transaction is the following :             

    (A) Undo all changes to the database resulting from the execution of the transaction.

    (B)  Undo the effects of the last UPDATE command.

    (C)  Restore the content of the database to its state at the end of the previous day.

    (D) Make sure that all changes to the database are in effect.

    (E) None of these

 3. Which of the following switching methods provides the greatest frame throughput?               

    (A) Store-and-forward switching

    (B)  Frame-tag switching

    (C)  Cut-through switching

    (D)  ISL switching

    (E)   Store-and-backward switching'

4.  A gateway is :

     (A)  a deviec that enables users to send information simultaneously over a network without slowing down teansmission

     (B)  An electronic device that connects severakl computing devices to a network.

     (C)  A point in one network that is an enteance point to another network.

     (D)  A device that links two or more segments of a network and helps direct traffic.

     (E) None of these

 5.  Network routing information distributed among outers is stored in which of the following.

      (A) Flash memory            

      (B)   Route table

      (C)  Metric tableU             

      (D)   NVRAM

      (E)   Router memory

6.  Which is not a part of the Oracle database block?

       (A)  Header

       (B)  Row directory

       (C)  Data

       (D)  Freelists

       (E)   None of these

7.  Which layers of the OSI, model are included in the lower layers?

       (A)  Application, Session, Presentation

       (B)  Physical, Transport, data Link, Network

       (C)  Data like, Physical, Network

       (D)  Session, Data Link, Physical

       (E) None of these

 8.   Where are cookies Stored ?

       (A) On the server

       (B)  In web. xml

       (C)  On the client

       (D)  In HTML

       (E) None of these

 9.   You are planning on using a single network that supports 208 users. Which IP address class would you choose to be most efficient ?

       (A)  Class A

       (B) Class B                         

       (C) Class C

       (D)  Class D

       (E)   Class E

10.   Which of the following is not perfomed by TCP?

       (A)  Flow control               

       (B)   Sequencing

       (C) Error checking             

       (D)   Subnetting

       (E) None of these

 

Answers:

 

1. (b)

2. (a)

3. (c)

4. (c)

5. (e)

6. (d)

7. (b)

8. (c)

9. (c)

10. (e)

 

arrow