Database Management System (DBMS) Questions and Answers | DBMS MCQs

1. What is DBMS?
  1. DBMS is a collection of queries
  2. DBMS is a high-level language
  3. DBMS is a programming language
  4. DBMS stores, modifies and retrieves data

Answer: DBMS stores, modifies and retrieves data

2. Which of the following is not a feature of DBMS?
  1. Minimum Duplication and Redundancy of Data
  2. High Level of Security
  3. Single-user Access only
  4. Support ACID Property

Answer: Single-user Access only

⭐ Make GKSeries Your Preferred Source on Google

Add GKSeries as Preferred Source
3. Which of the following command is a type of Data Definition language command?
  1. Create
  2. Update
  3. Delete
  4. Merge

Answer: Create

4. In a relation database, every tuples divided into the fields are known as the______.
  1. Queries
  2. Domains
  3. Relations
  4. All of the above

Answer: Domains

5. Which one of the following command is used to delete the existing row in a table?
  1. Delete
  2. Update
  3. Insert
  4. None of the above

Answer: Delete

6. The database management system can be considered as the collection of ______ that enables us to create and maintain the database.
  1. Translators
  2. Programs
  3. Keys
  4. Language activity

Answer: Programs

7. ____________ offers the ability to query the data and insert, alter, and delete tuples.
  1. Transaction Control Language (TCL)
  2. Data Control Language (DCL)
  3. Data Definition Language (DDL)
  4. Data Manipulation Language (DML)

Answer: Data Manipulation Language (DML)

8.Which of the following is known as a set of entities of the same type that share same properties, or attributes?
  1. Relation set
  2. Tuples
  3. Entity set
  4. Entity Relation model

Answer: Entity set

9._____________ is a hardware component that is most important for the operation of a database management system.
  1. Microphone
  2. High speed, large capacity disk to store data
  3. High-resolution video display
  4. Printer

Answer: High speed, large capacity disk to store data

10.Which of the following provides the ability to query information from the database and insert tuples into, delete tuples from, and modify tuples in the database?
  1. DML(Data Manipulation Language)
  2. DDL(Data Definition Language)
  3. Query
  4. Relational Schema

Answer: DML(Data Manipulation Language)

11. In the following Query, which of the following can be placed in the Query's blank portion to display the salary from highest to lowest amount, and sorting the employs name alphabetically? 
SELECT *  
FROM instructor  
ORDER BY salary ____, name ___;
  1. Ascending, Descending
  2. Asc, Desc
  3. Desc, Asc
  4. All of the above

Answer: Desc, Asc

12. Which of the following can be considered as the maximum size that is supported by FAT?
  1. 8GB
  2. 4GB
  3. 4TB
  4. None of the above

Answer: 4GB

13. A huge collection of the information or data accumulated form several different sources is known as ________:
  1. Data Management
  2. Data Mining
  3. Data Warehouse
  4. Both B and C

Answer: Data Warehouse

14. Which one of the following refers to the "data about data"?
  1. Directory
  2. Sub Data
  3. Warehouse
  4. Meta Data

Answer: Meta Data

15. In general, a file is basically a collection of all related______.
  1. Rows & Columns
  2. Fields
  3. Database
  4. Records

Answer: Records

16. Rows of a relation are known as the _______.
  1. Degree
  2. Tuples
  3. Entity
  4. All of the above

Answer: All of the above

17. Which one of the following is a type of Data Manipulation Command?
  1. Create
  2. Alter
  3. Delete
  4. All of the above

Answer: Delete

18. In which one of the following, the multiple lower entities are grouped (or combined) together to form a single higher-level entity?
  1. Specialization
  2. Generalization
  3. Aggregation
  4. None of the above

Answer: Generalization

19. In the relational table, which of the following can also be represented by the term "attribute"?
  1. Entity
  2. Row
  3. Column
  4. Both B & C

Answer: Column

20. A transaction enters into its _______ state when it finishes the final statement.
  1. Abort state
  2. Partially committed state
  3. Committed state
  4. Active state

Answer: Partially committed state

21. Which one of the following commands is used to restore the database to the last committed state?
  1. Savepoint
  2. Rollback
  3. Commit
  4. Both A & B

Answer: Rollback

22. The term "SQL" stands for
  1. Standard query language
  2. Sequential query language
  3. Structured query language
  4. Server-side query language

Answer: Structured query language

23. Which one of the following commands is used for removing (or deleting) a relation forms the SQL database?
  1. Delete
  2. Drop
  3. Remove
  4. All of the above

Answer: Drop

24. Fifth Normal form is concerned with:
  1. Join dependency
  2. Domain-key
  3. Multivalued dependency
  4. Functional dependency

Answer: Join dependency

25. When recovering from a failure:
  1. examination of each pair of physical blocks occurs
  2. examination of a specified pair of physical blocks occurs
  3. examination of the first pair of physical blocks occurs
  4. none of the above

Answer: examination of each pair of physical blocks occurs

26. The node pointing towards another node in a B+ tree is known as:
  1. External node
  2. Leaf node
  3. Internal node
  4. Final node

Answer: Internal node

27. In crabbing, the protocol locking goes:
  1. down the tree, back up
  2. up the tree, back down
  3. down the tree, releases
  4. up the tree, releases

Answer: down the tree, back up

28. The easiest way in which we can transfer control is when the old backup site sends __________ to the old primary.
  1. Redo logs
  2. Primary Logs
  3. Undo Logs
  4. All of the above

Answer: Primary Logs

29. What is an alternative name for a weak entity?
  1. Dominant
  2. Owner
  3. Child
  4. All of the above

Answer: Child

30. Which of the following is generally used for performing tasks like creating the structure of the relations, deleting relation?
  1. DML(Data Manipulation Language)
  2. Query
  3. Relational Schema
  4. DDL(Data Definition Language)

Answer: DDL(Data Definition Language)

31. The DBMS acts as an interface between ________________ and ________________ of an enterprise-class system.
  1. Data and the DBMS
  2. Application and SQL
  3. Database application and the database
  4. The user and the software

Answer: Database application and the database

32. What does an RDBMS consist of?
  1. Collection of Records
  2. Collection of Keys
  3. Collection of Tables
  4. Collection of Fields

Answer: Collection of Tables

33. Which of the following is a component of the DBMS?
  1. Data
  2. Data Languages
  3. Data Manager
  4. All of the above

Answer: All of the above

34. Which of the following is not a function of the database?
  1. Managing stored data
  2. Manipulating data
  3. Security for stored data
  4. Analysing code

Answer: Analysing code

35. Which of the following is a feature of the database?
  1. No-backup for the data stored
  2. User interface provided
  3. Lack of Authentication
  4. Store data in multiple locations

Answer: User interface provided

36. Which of the following is not a type of database?
  1. Hierarchical
  2. Network
  3. Distributed
  4. Decentralized

Answer: Decentralized

37. What is a database?
  1. Organized collection of information that cannot be accessed, updated, and managed
  2. Collection of data or information without organizing
  3. Organized collection of data or information that can be accessed, updated, and managed
  4. Organized collection of data that cannot be updated

Answer: Organized collection of data or information that can be accessed, updated, and managed

38. Who created the first DBMS?
  1. Edgar Frank Codd
  2. Charles Bachman
  3. Charles Babbage
  4. Sharon B. Codd

Answer: Charles Bachman

39. Which of the following is not an example of DBMS?
  1. MySQL
  2. Microsoft Acess
  3. IBM DB2
  4. Google

Answer: Google

40. Which of the following is a function of the DBMS?
  1. Storing data
  2. Providing multi-users access control
  3. Data Integrity
  4. All of the above

Answer: All of the above

41. The ability to query data, as well as insert, delete, and alter tuples, is offered by ____________
  1. TCL (Transaction Control Language)
  2. DCL (Data Control Language)
  3. DDL (Data Definition Langauge)
  4. DML (Data Manipulation Langauge)

Answer: DML (Data Manipulation Langauge)

42. A Database Management System is a type of _________software.
  1. It is a type of system software
  2. It is a kind of application software
  3. It is a kind of general software
  4. Both A and C

Answer: It is a type of system software

43. The term "NTFS" refers to which one of the following?
  1. New Technology File System
  2. New Tree File System
  3. New Table type File System
  4. Both A and C

Answer: New Technology File System

44. Which of the following can be used to extract or filter the data & information from the data warehouse?
  1. Data redundancy
  2. Data recovery tool
  3. Data mining
  4. Both B and C

Answer: Data mining

45. Which of the following refers to the level of data abstraction that describes exactly how the data actually stored?
  1. Conceptual Level
  2. Physical Level
  3. File Level
  4. Logical Level

Answer: Physical Level

46. Which of the following refers to the number of tuples in a relation?
  1. Entity
  2. Column
  3. Cardinality
  4. None of the above

Answer: Cardinality

47. The term "TCL" stands for_____.
  1. Ternary Control Language
  2. Transmission Control Language
  3. Transaction Central Language
  4. Transaction Control Language

Answer: Transaction Control Language

48. The term "DFD" stands for?
  1. Data file diagram
  2. Data flow document
  3. Data flow diagram
  4. None of the above

Answer: Data flow diagram

49. We can add or remove the user IDs using which of these fixed roles?
  1. db_setupadmin
  2. db_securityadmin
  3. db_accessadmin
  4. db_sysadmin

Answer: db_accessadmin

50. The _____ system does not require a password to travel across the internet.
  1. Response
  2. Challenge-response
  3. Manipulation
  4. Readable

Answer: Challenge-response

51. The name of the very first microprocessor chip available commercially was:
  1. Intel 4004
  2. Intel 639
  3. Intel 308
  4. Motorola 33

Answer: Intel 4004

52. Which of the following refers collection of the information stored in a database at a specific time?
  1. Independence
  2. Instance of the database
  3. Schema
  4. Data domain

Answer: Instance of the database

53. We can force a log switch by using:
  1. ALTER SYS LOGFILES
  2. ALTER SYSTEM SWITCH LOGS
  3. ALTER SYSTEM LOG
  4. ALTER SYSTEM SWITCH LOGFILE

Answer: ALTER SYSTEM SWITCH LOGFILE

54. A linear search algorithm’s complexity would be:
  1. O(n2)
  2. O(n log n)
  3. O(n)
  4. O(log n)

Answer: O(n)

55. In which of the following formats data is stored in the database management system?
  1. Image
  2. Text
  3. Table
  4. Graph

Answer: Table

56. What is information about data called?
  1. Hyper data
  2. Tera data
  3. Meta data
  4. Relations

Answer: Meta data

57. What is the full form of DBMS?
  1. Data of Binary Management System
  2. Database Management System
  3. Database Management Service
  4. Data Backup Management System

Answer: Database Management System

58. The values appearing in given attributes of any tuple in the referencing relation must likewise occur in specified attributes of at least one tuple in the referenced relation, according to _____________________ integrity constraint.
  1. Referential
  2. Primary
  3. Referencing
  4. Specific

Answer: Referential

59. The term "FAT" is stands for_____
  1. File Allocation Tree
  2. File Allocation Table
  3. File Allocation Graph
  4. All of the above

Answer: File Allocation Table

60. Which one of the following refers to the copies of the same data (or information) occupying the memory space at multiple places.
  1. Data Repository
  2. Data Inconsistency
  3. Data Mining
  4. Data Redundancy

Answer: Data Redundancy

ADRE 3.0 Complete Study Material