Search your Topic HERE....

February 04, 2015

Professional Knowledge Quiz for IBPS IT Officers - Set 6

32 comments

sponsored links

  1. Which of the following is a database administrator's function ?
    1. database design 
    2. backing up the database 
    3. performance monitoring 
    4. user coordination 
    5. all of the above 
  2. Primitive operations common to all record management systems include 
    1. print
    2. sort 
    3. look-up
    4. all of the above 
    5. none of these
  3. Each of data files has a __________ that describe the way the data is stored in the file 
    1. file structure 
    2. records
    3. fields 
    4. database 
    5. none of these
  4. What is the language used by most of the DBMSs for helping their users to access data ?
    1. high level language 
    2. query language 
    3. SQL 
    4. 4GL
    5. none of these
  5. Data item characteristics that are important in data management include 
    1. punctuation 
    2. language 
    3. spelling
    4. width 
    5. none of these
  6. A locked file can be 
    1. accessed by only one user 
    2. modified by users with the correct password 
    3. is used to hide sensitive information 
    4. both 1 and 2
    5. none of these
  7. If the record management system allows you to edit values before they are recorded on disk, you can 
    1. correct spelling changes before they are recorded 
    2. change the name of a field 
    3. change the width of a field 
    4. all of the above 
    5. none of these
  8. Which command is used to remove an index from the database in SQL ?
    1. DELETE INDEX 
    2. DROP INDEX
    3. REMOVE INDEX 
    4. ROLL BACK INDEX
    5. none of these
  9. What is the name given to the database management system which is able to handle full text data, image data, audio and video ?
    1. Full media 
    2. Graphics media 
    3. Multimedia 
    4. Hypertext 
    5. none of these
  10. When using a database management system, the first thing that you must do is to 
    1. create a database file 
    2. activate file editor 
    3. load the software into your microcomputer 
    4. keep a floppy disk in readiness 
    5. none of these
  11. If the record management system allows you to edit values before they are recorded on disk, you can 
    1. correct spelling changes before they are recorded 
    2. change the name of a field 
    3. change the width of a field 
    4. all of the above 
    5. none of these
  12. The relational model uses some unfamiliar terminology. A tuple is equivalent to a 
    1. record
    2. field 
    3. file
    4. data base 
    5. data item 
  13. Which command is used to remove an index from the database in SQL ?
    1. DELETE INDEX 
    2. DROP INDEX 
    3. REMOVE INDEX 
    4. ROLL BACK INDEX
    5. none of these
  14. What is the name given to the database management system which is able to handle full text data, image data, audio and video ?
    1. Full media 
    2. Graphics media 
    3. Multimedia 
    4. Hypertext 
    5. none of these
  15. Which password management feature ensures a user cannot reuse a password for a specified time interval ?
    1. Account Locking 
    2. Password History 
    3. Password Verification 
    4. Password Expiration and Aging 
    5. none of these
  16. Which privilege is required to create a database ?
    1. SYSDBA 
    2. DBA
    3. SYSOPER
    4. RESOURCE 
    5. none of these
  17. What is the type of Oracle backup in which all uncommitted changes have been removed from the datafiles ?
    1. Full backup 
    2. Consistent backup 
    3. Inconsistent backup 
    4. Differential backup 
    5. none of these
  18. Which type of file is part of the Oracle database ?
    1. Control file 
    2. Password file 
    3. Parameter files 
    4. Archived log files 
    5. none of these
  19. What type of failure occurs when Oracle fails due to an operating system or computer hardware failure ?
    1. Application failure 
    2. Instance failure 
    3. Media failure 
    4. Rollback failure 
    5. none of these
  20. What Oracle backup and recovery file contains user and system data ?
    1. Control file 
    2. Datafile 
    3. OnLine ReDo file 
    4. Offline ReDo file 
    5. none of these


32 comments:

  1. what is diff btw public sector bank and nationalised bank???

    ReplyDelete
  2. Hai BA readers i am from tamil nadu most of in our state dont know HINDI so kindly uplode this kind of usefull tips in english

    ReplyDelete
  3. TRACKS-A ring on a disk where data can be
    written( concentric circles)

    SECTOR-Each track is divided
    into sections called sectors. A sector is the smallest
    physical storage unit on the disk. The data size of a sector is always a
    power of two

    CYLINDER-consists of the set
    of tracks that are at the same head position on the disk

    SEEK TIME- the amount of
    time required for the read/write heads to the cylinder containing desired
    sector.

    ACCESS TIME-(seek
    time+latency) total time it takes the computer to read data from a
    storage device such as computer memory....

    ROTATIONAL DELAY/LATENCY-is
    the time to move the required sector to the disk head

    ReplyDelete
  4. Please tell what is the subject-wise cutoff for IBPS IT Officer Scale 1

    ReplyDelete
  5. Hi Mr.soumen well done .. Its pretty Kool but you really think that we have that much time to recollect the whole story in the exam???? Think realistic...

    ReplyDelete
  6. Don't think about cutoff now concentrate on your preparation bro.while preparing also don't think about cutoff

    ReplyDelete
  7. madam plz send the NABARD exam details and preparation plan

    ReplyDelete
  8. And I don't understand one thing y u all run after shortcuts?? It makes it even more difficult... :-\

    ReplyDelete
  9. Hi... Your work is appreciable but do you really think that we have enough time to recall the whole story in exam.... Think realistic bro....

    ReplyDelete
  10. M solving by efficiency method. But it's not coming 22.5 . give hint. .

    ReplyDelete
  11. Lets B=1 A=2
    C=half of A&B=1+2/2=3/2 means 1.5 ok
    Now
    (1+2+1.5)x15=3x?
    4.5x15/3=?
    =22.5

    ReplyDelete
  12. last time paper was easy but this time we all are expecting good questions ,So friends what should be the safe cut off for ibps SO.

    ReplyDelete
  13. friends i ahve a question kindly clear my doubt,....binding can occur while a)writing a program b)compiling a program c)invoking a sub program d)during loading e)when separately compiled modeules are being linked together f)

    ReplyDelete
  14. Thank you very much!

    ReplyDelete
  15. 3 questions are repeated ...!!! Q. 7,8 & 9 ... kindly update with new ones ...

    ReplyDelete
  16. please provide last years agriculture questions

    ReplyDelete
  17. hai pls tell some tips to clear the exam i am also from tamilnadu

    ReplyDelete
  18. You Can Join This Facebook Nabard Group At https://www.facebook.com/groups/nabard.gradea.b.prelims.mains.exam For Nabard Prelims & Mains Preparation

    ReplyDelete

Related Posts Plugin for WordPress, Blogger...