Nagaland PSC: Computer Science MCQs (Practice-Test 3 of 6)

Download PDF of This Page (Size: 111K)

  1. The relational model whose guiding ideas were published in 1970 has dominated the area of

    1. software system

    2. hardware system

    3. database research and development

    4. none of the above

  2. A link is represented by a diagram, called a

    1. Bachman diagram

    2. Pascal diagram

    3. Theory diagram

    4. none of die above

  3. A great advantage of Modula-2 over Ada is that it is a

    1. greater language

    2. small language

    3. Pascal language

    4. none of die above

  4. Integrity constraints are predicates which must be true for data stored in the

    1. system

    2. hardware system

    3. database

    4. none of the above

  5. In a distributed DBMS one may add a third factor which is the transmission time in the

    1. relation

    2. system

    3. network

    4. none of die above

  6. A transaction is the unit of concurrency

    1. system

    2. recovery control

    3. software system

    4. none of the above

  7. A DBMS allows data manipulation through primitive operations which can be grouped to form

    1. data transactions

    2. software system

    3. hardware system

    4. none of the above

  8. The INSERTION clause specifies the storage method as either AUTOMATIC or

    1. DBMS

    2. MANUAL

    3. CODASYL

    4. None of the above

  9. The RETENTION clause specifies the degree of freedom available to the members of a

    1. database

    2. system

    3. link

    4. none of the above

  10. When items stored in primary storage need to be kept permanently, they can be transferred to secondary storage. Example of secondary storage media are

    1. magnetic disks and tape

    2. air

    3. water

    4. none of the above

  11. Programs are list of instructions that a computer can use to solve a problem. A program or series of programs is called

    1. hardware

    2. software

    3. language program

    4. none of the above

  12. Pascal provides standard fifes, named

    1. input and output

    2. input only

    3. output only

    4. none of the above

  13. An operating system contains

    1. one type of program

    2. several types of programs

    3. only two types of programs

    4. none of the above

  14. Computers can only perform

    1. two basic operations

    2. three basic operations

    3. several basic operations

    4. none of the above

  15. A data model may be defined as a pattern according to which data are

    1. organized

    2. weakly organized

  16. The term ‘software engineering’ implies the application of scientific knowledge and discipline to the construction of

    1. systems

    2. hardware systems

    3. software systems

    4. none of the above

  17. In software system, the data must be shared among

    1. a very few users

    2. many different users

    3. two users

    4. none of the above

  18. One of the most important techniques for dealing with complexity in software systems is the

    1. principle of abstraction

    2. principle of stepwise refinement

    3. maintainability of the system

    4. none of the above

  19. Concurrency control in database management systems, including

    1. database procedure

    2. transaction

    3. alternatives to locking

    4. none of the above

  20. The developments in software engineering have led to the emergence of a

    1. programming language

    2. new class of programming language

    3. new class of system

    4. none of the above

  21. Program correctness has been a strong motivation for much of the work in software engineering

    1. hardware system

    2. assembly language

    3. programming language design

    4. none of the above

  22. Modula-2 is a language which is suitable both for the implementation of

    1. database system only

    2. application programs

    3. database management systems and application programs

    4. none of the above

  23. The logical database design is a

    1. three stage process

    2. two-stage process.

    3. four stage process

    4. none of the above

Discussions & Questions