DBMS-DBMS CONCEPT Questions and Answers
DBMS Concepts questions with answers are crucial for students preparing for database-related aptitude and placement exams. Topics such as normalization, keys, constraints, and data models are frequently tested by companies like TCS, Accenture, and Infosys. Understanding how databases are structured and managed helps candidates solve conceptual and query-based problems confidently. This article provides DBMS interview and aptitude questions with clear explanations, focusing on real-world applications. Practice these database management system MCQs to improve your conceptual grasp and get ready for technical interviews and campus placement drives.
DBMS-DBMS CONCEPT
Showing 10 of
45 questions
31. Which of the following is characterstic of the data in a database?
- independent
- Secure
- shared
- all of these.
32. The name of the system database that contains descriptions of data in the database is
- data dictionary
- metadata
- table
- none of these
34. System catalog is a system-created database that describes:
- database objects
- data dictionary information
- user access information
- all of these
35. A file is a collection of related sequence of records:
- related records
- related fields
- related data items
- none of these
36. Relationships could be of the fillowing type:
- one-to-one relationship
- one-to-many relationships
- many-to-many relationships
- all of these.
37. In a file-oriented system there is:
- data inconsistency
- duplication of data
- data dependence
- all of these.
38. In a database system there is:
- increased productivity
- improved security
- economy of scale
- all of these
39. In a database system there is:
- Large size of DBMS
- increased overall costs
- increased complexity
- all of these .
40. IDS formed the basis for the:
- network model
- hierachical model
- relational model
- all of these