Latest DBMS Multiple Choice Questions and Answers PDF free Download

70 top dbms multiple choice questions and answers for freshers and experienced 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.