Competitive Exams: Computers MCQs (Practice-Test 19 of 21)

  1. We can combine dBASE power with other software systems by transferring

    1. files to an fro dBASE

    2. program to another program

    3. files to an fro Database

    4. none of the above

  2. It is not possible to declare all the functions on an entity, or all of the subtypes, at the

    1. existing data

    2. entire database

    3. module creation

    4. none of the above

  3. Integrity constraints are predicates which must be free for data stored in

    1. an entity

    2. the database

    3. the system

    4. none of the above

  4. One of the aspects of data integrity is related to data access

    1. on the database

    2. the language programming

    3. privacy problems

    4. none of the above

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

    1. database transactions

    2. database modification

    3. software modules

    4. none of the above

  6. The INGRES system is composed with

    1. one module

    2. two modules

    3. four modules

    4. none of the above

  7. QUEL is interpreted by the

    1. DBMS system

    2. INGRES system

    3. SQL system

    4. none of the above

  8. It is also possible to access the relational DBMS through application program written in

    1. high-level programming language

    2. Pascal language programming

    3. procedural language

    4. none of the above

  9. We can send dBASE reports to word processing systems for further editing or inclusion

    1. in other programs

    2. in other documents

    3. in other systems

    4. none of the above

  10. The top three lines in a LOTUS 1 − 2 − 3 is termed as

    1. PANEL

    2. CONTROL PANEL

    3. EXTENSION

    4. none of the above

  11. The module scheme does not provide one of the common features of modules in programming, namely

    1. the accessing a number of shared modules

    2. the hiding of names

    3. and the partitioning of the same space

    4. both B and C

  12. Modules of the kind used in ADA and Module-2 allow one to declare a collection of procedures and functions that

    1. hiding the names

    2. reference each other

    3. partitioning of the same space

    4. none of the above

  13. The advantage of using storage system like binary relations or triples which does not keep all the function values on

    1. an entity together

    2. entire database

    3. existing data

    4. none of the above

  14. SQL is a relational language which has also been implemented in several

    1. DBMSs

    2. QUEL

    3. INGRES

    4. none of the above

  15. Several relational languages have been defined for different

    1. relational DBMS

    2. relational DBMSs

    3. QUEL languages

    4. none of the above

  16. Relational algebra is one of the basic concepts for defining

    1. programming languages

    2. relational languages

    3. high-level programming language

    4. none of the above

  17. Using the operators of relational algebra one may manipulate and query the database in a

    1. non-homogeneous manner

    2. homogeneous manner

    3. both A and B

    4. none of the above

  18. Modula-2 is an ideal language for interacting with an existing DBMS, where a suitable module

    1. has not been provided

    2. has been provided

    3. both A and B

    4. none of the above

  19. Locking mechanism guarantees exclusive access to an item of data while a lock

    1. has not been used

    2. is in force

    3. both A and B

    4. none of the above

  20. The ability to define such abstract objects, together with appropriate operations, is invaluable for

    1. programming language

    2. high-level programming language

    3. database applications

    4. none of the above

  21. One of the most important technique for dealing with complexity in software system is the principle of

    1. programming language

    2. abstraction

    3. database technology

    4. hone of the above

  22. The term ‘software engineering’ implies the application of scientific knowledge to the construction of

    1. computer software systems

    2. computer hardware systems

    3. high-level programming language

    4. none of the above

  23. By error we mean any deviation from the behavior stipulated by the

    1. database system

    2. requirements analysis

    3. incorrect data modeling

    4. none of the above

  24. By implementation we mean the transformation of our design into a database system which operates on a particular machine, usually under the control of

    1. software system

    2. hardware system

    3. Both

    4. none of the above

  25. Boolean variables are sometimes referred to as

    1. variables

    2. real variables

    3. logical variables

    4. none of the above

  26. In Pascal, decimal notation, requires that a real number contains at least one digit before and after the

    1. exponential notation

    2. decimal point

    3. zero

    4. none of the above