Top 50 DBMS (Database Management Questions with Answers)
Q. 1. What is the full form of DBMS?
a) Data of Binary Management System
b) Database Management System
c) Database Management Service
d) Data Backup Management System
Ans: b
Q. 2. What is a database?
a) Organized collection of information that cannot be accessed, updated, and managed
b) Collection of data or information without organizing
c) Organized collection of data or information that can be accessed, updated, and managed
d) Organized collection of data that cannot be updated
Ans: c
Q. 3. What is DBMS?
a) DBMS is a collection of queries
b) DBMS is a high-level language
c) DBMS is a programming language
d) DBMS stores, modifies and retrieves data
Ans: d
Q. 4. Who created the first DBMS?
a) Edgar Frank Codd
b) Charles Bachman
c) Charles Babbage
d) Sharon
Ans: b
Q. 5. Which type of data can be stored in the database?
a) Image oriented data
b) Text, files containing data
c) Data in the form of audio or video
d) All of the above
Ans: d
Q. 6. In which of the following formats data is stored in the database management system?
a) Image
b) Text
c) Table
d) Graph
Ans: c
Q. 7. Which of the following is a component of the DBMS?
a) Data
b) Data Languages
c) Data Manager
d) All of the above
Ans: d
Q. 8. Which of the following is known as a set of entities of the same type that share same properties, or attributes?
a) Relation set
b) Tuples
c) Entity set
d) Entity Relation model
Ans: c
Q. 9. What is information about data called?
a) Hyper data
b) Tera data
c) Meta data
d) Relations
Ans: c
Q. 10. What does an RDBMS consist of?
a) Collection of Records
b) Collection of Keys
c) Collection of Tables
d) Collection of Fields
Ans: c
Q. 11. Which command is used to remove a relation from an SQL?
a) Drop table
b) Delete
c) Purge
d) Remove
Ans: a
Q. 12. Which of the following command is used to change data in table?
a) Insert
b) Delete
c) Purge
d) Update
Ans: d
Q. 13. What is rows of a relation known as?
a) Degree
b) Entity
c) Tuple
d) None
Ans: c
Q. 14. What is the name of the query that is placed within a WHERE or HAVING clause of another query?
a) Multi query
b) Sub query
c) Super Query
d) Master Query
Ans: b
Q. 15. What is the number of tuples of a relation known as?
a) Column
b) Cardinality
c) Entity
d) None
Ans: b
Q. 16. What is the use of COUNT in SQL?
a) Return total values
b) Return total values
c) Return number of groups
d) Return Numbers of column
Ans: b
Q. 17. Which of the following can be considered as the maximum size that is supported by FAT?
a) 8 GB
b) 4 GB
c) 4 TB
d) None
Ans: b
Q. 18. The term "NTFS" refers to which one of the following?
a) New Technology File System
b) New Tree File System
c) New Table type File System
d) Both A and C
Ans: a
Q. 19. A huge collection of the information or data accumulated form several different sources is known as ________:
a) Data Management
b) Data Mining
c) Data Warehouse
d) Both B and C
Ans: c
Q. 20. Which of the following can be used to extract or filter the data & information from the data warehouse?
a) Data redundancy
b) Data Recovery tool
c) Data mining
d) Both B and C
Ans: c
Q. 21. Which one of the following refers to the copies of the same data (or information) occupying the memory space at multiple places.
a) Data Repository
b) Data Inconsistency
c) Data mining
d) Data Redundancy
Ans: d
Q. 22. Which one of the following refers to the "data about data"?
a) Directory
b) Sub Data
c) Ware house
d) Meta Data
Ans: d
Q. 23. Which of the following refers to the level of data abstraction that describes exactly how the data actually stored?
a) Conceptual Level
b) Physical Level
c) File Level
d) Logical Level
Ans: b
Q. 24. "DBA" referred?
a) Data Bank Administrator
b) Database Administrator
c) Data Administrator
d) None of the above
Ans: b
Q. 25. Which of the following refers to the number of tuples in a relation?
a) Entity
b) Column
c) Cardinality
d) None of the above
Ans: c
Q. 26. Which one of the following is a type of Data Manipulation Command?
a) Create
b) Alter
c) Delete
d) All
Ans: c
Q. 27. Which of the following refers to the level of data abstraction that describes exactly how the data actually stored?
a) Create
b) Update
c) Delete
d) Merge
Ans: a
Q. 28. Which of the following is a top-down approach in which the entity's higher level can be divided into two lower sub-entities?
a) Aggregation
b) Generalization
c) Specialization
d) All of the above
Ans: d
Q. 29. In which one of the following, the multiple lower entities are grouped (or combined) together to form a single higher-level entity?
a) Aggregation
b) Generalization
c) Specialization
d) All of the above
Ans: b
Q. 30. In a relation database, every tuples divided into the fields are known as the______.
a) Queries
b) Domains
c) Relations
d) All
Ans: b
Q. 31. The oldest DB model is _______________
a) Network
b) Physical
c) Hierarchical
d) Relational
Ans: c
Q. 32. Which of the following establishes a top-to-bottom relationship among the items?
a) Relational schema
b) Network schema
c) Hierarchical schema
d) All of the mentioned
Ans: c
Q. 33. Which of the following is known as minimal super key?
a) Primary Key
b) Candidate key
c) Foreign Key
d) None
Ans: b
Q. 34. Which of the following is not a SQL command?
a) Delete
b) Order by
c) Select
d) Where
Ans: a
Q. 35. Which of the following is preserved in execution of transaction in isolation?
a) Atomicity
b) Isolation
c) Durability
d) Consistency
Ans: d
Q. 36. Which of the following normal forms contains information about a single entity?
a) 1NF
b) 2NF
c) 3NF
d) 4NF
Ans: d
Q. 37. How many levels are there in architecture of database?
a) 2
b) 3
c) 4
d) None
Ans: b
Q. 38. Primary key can be?
a) Null
b) Not Null
c) Both Null and Not Null
d) Depends on Situation
Ans: b
Q. 39. Rectangles in ER diagram represents?
a) Tables
b) Attributes
c) Tuples
d) Entity Sets
Ans: d
Q. 40. Select the correct advantages of view.
a) Derived Columns
b) Data Security
c) Hiding of complex queries
d) All of the Above
Ans: d
Q. 41. Which operation is used to extract specified columns from a table?
a) Project
b) Join
c) Extract
d) Index Table
Ans: a
Q. 42. In RDBMS, different classes of relations are created using __________ technique to prevent modification anomalies.
a) Functional Dependencies
b) Data integrity
c) Referential integrity
d) Normal Forms
Ans: d
Q. 43. Relations produced from E - R Model will always be in ________.
a) 1 NF
b) 2 NF
c) 3 NF
d) 4 NF
Ans: a
Q. 44. Which of the following RAID level provides the highest Data Transfer Rate (Read/Write)
a) RAID 1
b) RAID 2
c) RAID 4
d) RAID 5
Ans: a
Q. 45. The unit of storage that can store one are more records in a hash file organization are
a) Buckets
b) Disk pages
c) Blocks
d) Nodes
Ans: a
Q. 46. A ______ file system is software that enables multiple computers to share file storage while maintaining consistent space allocation and file content.
a) Storage
b) Tertiary
c) Secondary
d) Cluster
Ans: d
Q. 47. Which of the following is a physical storage media?
a) Tape Storage
b) Optical Storage
c) Flash memory
d) All of the mentioned
Ans: d
Q. 48. The _________ is the fastest and most costly form of storage, which is relatively small; its use is managed by the computer system hardware.
a) Cache
b) Disk
c) Main memory
d) Flash memory
Ans: a
Q. 49. Which of the following stores several gigabytes of data but usually lost when power failure?
a) Flash memory
b) Disk
c) Main memory
d) Secondary memory
Ans: c
Q. 50. The flash memory storage used are
a) NOR Flash
b) OR Flash
c) AND Flash
d) All of the mentioned
Ans: c
