DBMS Multiple Choice Questions and Answers PDF free Download

  1. The ascending order of a data hirerchy is
  2. Which of the following is true of a network structure?
  3. Which of the following is a problem of file management system?
  4. One data dictionary software package is called
  5. The function of a database is ...
  6. What is the language used by most of the DBMSs for helping their users to access data?
  7. The model for a record management system might be
  8. Primitive operations common to all record management system include
  9. In a large DBMS
  10. Information can be transferred between the DBMS and a
  11. Which of the following fields in a student file can be used as a primary key?
  12. Which of the following is not an advantage of the database approach
  13. Which of the following contains a complete record of all activity that affected the contents of a database during a certain period of time?
  14. In the DBMS approach, application programs perform the
  15. A set of programs that handle a firm's database responsibilities is called
  16. Which is the make given to the database management system which is able to handle full text data, image data, audio and video?
  17. A record management system
  18. A command that lets you change one or more fields in a record is
  19. A transparent DBMS
  20. A file produced by a spreadsheet
  21. Which of the following is not true of the traditional approach to information processing
  22. Which of the following hardware component is the most important to the operation of database management system?
  23. Generalized database management system do not retrieve data to meet routine request
  24. Batch processing is appropriate if
  25. Large collection of files are called
  26. Which of the following is not a relational database?
  27. In order to use a record management system
  28. Sort/Report generators
  29. If a piece of data is stored in two places in the database, then
  30. An audit trail
  31. The relational database environment has all of the following components except
  32. Database management systems are intended to
  33. One approach to standardization storing of data?
  34. The language used application programs to request data from the DBMS is referred to as the
  35. The highest level in the hierarchy of data organization is called
  36. Choose the RDBMS which supports full fledged client server application development
  37. Report generators are used to
  38. A form defined
  39. A top-to-bottom relationship among the items in a database is established by a
  40. The management information system (MIS) structure with one main computer system is called a
  41. ------ responsible for authorizing access to the database, for co-ordinating and monitoring its use, acquiring software, and hardware resources, controlling its use and monitoring efficiency of operations.
  42. ------ is a property that describes various characteristics of an entity
  43. ------ level describes what data is stored in the database and the relationships among the data
  44. ------ denote derived attributes.
  45. A ------ is an association between entities
  46. ------ stores metadata about the structure of the data base
  47. ------ is a collection of operations that perform s single logical function in a database application
  48. The problem that is compounded when constraints involve several data items from different files are Called ------
  49. Ensuring atomicity is the responsibility of the ------ component
  50. ------ manages the allocation of the space on the disk storage and the data base structure used to represent information stored on disk
  51. ------ is the minimal super key
  52. ------ engine executes low level instructions generated by the DML compilier
  53. ------ responsible to define the content, the structure, the constraints, and functions or transactions against the database
  54. In ER model ------ denote derived attributes
  55. Foreign Key can be null
  56. All primary keys should be super keys.
  57. In Relational database Data is stored as record types and the relationship is represented by set types
  58. In Hierarchical database to get to a low-level table, you start at the root and work your way down the tree until you reach your target data.
  59. Using relational model we design conceptual database design
  60. Conceptual data model is the source of information for logical design phase
  61. Logical database design describes describes base relations, file organizations, and indexes that are used to achieve efficient access to data.
  62. Conceptual data modeling uses a high level data modeling concept of E-R Models
  63. Tables are required to have at least one column
  64. Logical data independence: Refers to the separation of the external views from the conceptual view
  65. Duplication of data is the disadvantage of DBMS
  66. Candidate key can have a null value
  67. Each program maintains its own set of data. So users of one program may be unaware of potentially useful data held by other programs this leads toDuplication of data
  68. A traditional database stores just data – with no procedures
  69. Simple Attribute composed of multiple components, each with an independent existence.
  70. Cardinality specifies how many instances of an entity relate to one instance of another entity.


1 comments:

doy said...

Thanks for this page. This assisted me in preparing questions about DBMS and networking topics