Scribd
Upload
27 views22 pages

DBMS MCQS

The document contains over 100 multiple choice questions (MCQs) related to Database Management Systems (DBMS) aimed at preparing candidates for a computer operator exam. Each question is accompanied by four answer options, with the correct answer indicated. Topics covered include definitions, SQL commands, database models, and relationships within databases.

Uploaded by

Sunlight School
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
27 views22 pages

DBMS MCQS

The document contains over 100 multiple choice questions (MCQs) related to Database Management Systems (DBMS) aimed at preparing candidates for a computer operator exam. Each question is accompanied by four answer options, with the correct answer indicated. Topics covered include definitions, SQL commands, database models, and relationships within databases.

Uploaded by

Sunlight School
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 22

100+ DBMS Multiple Choice Questions

(MCQs)
For Computer Operator Exam Preparation

1. 1. What is the full form of DBMS?

 A. Data Basic Management System


 B. Database Management System
 C. Data Banking Management System
 D. Database Machine System

✅Correct Answer: B

2. 2. What is a database?

 A. Irregular data
 B. Unorganized file
 C. Organized collection of data
 D. Data deletion process

✅Correct Answer: C

3. 3. What is a row in a table called?

 A. Field
 B. Record
 C. Data
 D. Row

✅Correct Answer: B

4. 4. What is a column in a table called?

 A. File
 B. Record
 C. Field
 D. Entry
✅Correct Answer: C

5. 5. What is a unique field in a table called?

 A. Foreign Key
 B. Candidate Key
 C. Primary Key
 D. Super Key

✅Correct Answer: C

6. 6. Why is SQL used?

 A. To run operating systems


 B. To connect hardware
 C. To manage databases
 D. To program microchips

✅Correct Answer: C

7. 7. Which of the following is a DBMS?

 A. MS Word
 B. MySQL
 C. Photoshop
 D. Windows

✅Correct Answer: B

8. 8. What is the purpose of a Query in MS Access?

 A. To create a report
 B. To create a form
 C. To search/filter data
 D. To delete a table

✅Correct Answer: C

9. 9. Which is an example of a 'One to Many' relationship?

 A. One student teaches many teachers


 B. One teacher teaches many students
 C. Two students have the same name
 D. One ID belongs to two persons

✅Correct Answer: B

10. 10. What is a Form used for in DBMS?

 A. To input data
 B. To delete data
 C. To transfer data
 D. To download data

✅Correct Answer: A

11. 11. Which language is used for querying databases?

 A. HTML
 B. SQL
 C. XML
 D. CSS

✅Correct Answer: B

12. 12. Which one is not a type of database model?

 A. Hierarchical
 B. Relational
 C. Network
 D. Linear

✅Correct Answer: D

13. 13. Which of the following is a relational database?

 A. MS Excel
 B. Oracle
 C. Notepad
 D. MS Paint

✅Correct Answer: B

14. 14. What is the function of the SELECT command?


 A. Insert data
 B. Delete data
 C. Retrieve data
 D. Update data

✅Correct Answer: C

15. 15. Which command is used to remove all records from a table?

 A. DELETE
 B. REMOVE
 C. DROP
 D. CLEAR

✅Correct Answer: A

16. 16. In SQL, which keyword is used to sort the result-set?

 A. ORDER
 B. SORT
 C. ORDER BY
 D. GROUP BY

✅Correct Answer: C

17. 17. Which of the following is not a SQL Data Manipulation Language (DML) command?

 A. SELECT
 B. INSERT
 C. UPDATE
 D. CREATE

✅Correct Answer: D

18. 18. Which command is used to create a new table in SQL?

 A. MAKE TABLE
 B. NEW TABLE
 C. CREATE TABLE
 D. INIT TABLE

✅Correct Answer: C
19. 19. Which normal form deals with removal of transitive dependency?

 A. 1NF
 B. 2NF
 C. 3NF
 D. BCNF

✅Correct Answer: C

20. 20. What is the result of a Cartesian product in SQL?

 A. No rows
 B. All matching rows
 C. All combinations of rows
 D. Duplicate rows only

✅Correct Answer: C

21. 21. Which language is used for querying databases?

 A. HTML
 B. SQL
 C. XML
 D. CSS

✅Correct Answer: B

22. 22. Which one is not a type of database model?

 A. Hierarchical
 B. Relational
 C. Network
 D. Linear

✅Correct Answer: D

23. 23. Which of the following is a relational database?

 A. MS Excel
 B. Oracle
 C. Notepad
 D. MS Paint
✅Correct Answer: B

24. 24. What is the function of the SELECT command?

 A. Insert data
 B. Delete data
 C. Retrieve data
 D. Update data

✅Correct Answer: C

25. 25. Which command is used to remove all records from a table?

 A. DELETE
 B. REMOVE
 C. DROP
 D. CLEAR

✅Correct Answer: A

26. 26. In SQL, which keyword is used to sort the result-set?

 A. ORDER
 B. SORT
 C. ORDER BY
 D. GROUP BY

✅Correct Answer: C

27. 27. Which of the following is not a SQL Data Manipulation Language (DML) command?

 A. SELECT
 B. INSERT
 C. UPDATE
 D. CREATE

✅Correct Answer: D

28. 28. Which command is used to create a new table in SQL?

 A. MAKE TABLE
 B. NEW TABLE
 C. CREATE TABLE
 D. INIT TABLE

✅Correct Answer: C

29. 29. Which normal form deals with removal of transitive dependency?

 A. 1NF
 B. 2NF
 C. 3NF
 D. BCNF

✅Correct Answer: C

30. 30. What is the result of a Cartesian product in SQL?

 A. No rows
 B. All matching rows
 C. All combinations of rows
 D. Duplicate rows only

✅Correct Answer: C

31. 31. Which language is used for querying databases?

 A. HTML
 B. SQL
 C. XML
 D. CSS

✅Correct Answer: B

32. 32. Which one is not a type of database model?

 A. Hierarchical
 B. Relational
 C. Network
 D. Linear

✅Correct Answer: D

33. 33. Which of the following is a relational database?


 A. MS Excel
 B. Oracle
 C. Notepad
 D. MS Paint

✅Correct Answer: B

34. 34. What is the function of the SELECT command?

 A. Insert data
 B. Delete data
 C. Retrieve data
 D. Update data

✅Correct Answer: C

35. 35. Which command is used to remove all records from a table?

 A. DELETE
 B. REMOVE
 C. DROP
 D. CLEAR

✅Correct Answer: A

36. 36. In SQL, which keyword is used to sort the result-set?

 A. ORDER
 B. SORT
 C. ORDER BY
 D. GROUP BY

✅Correct Answer: C

37. 37. Which of the following is not a SQL Data Manipulation Language (DML) command?

 A. SELECT
 B. INSERT
 C. UPDATE
 D. CREATE

✅Correct Answer: D
38. 38. Which command is used to create a new table in SQL?

 A. MAKE TABLE
 B. NEW TABLE
 C. CREATE TABLE
 D. INIT TABLE

✅Correct Answer: C

39. 39. Which normal form deals with removal of transitive dependency?

 A. 1NF
 B. 2NF
 C. 3NF
 D. BCNF

✅Correct Answer: C

40. 40. What is the result of a Cartesian product in SQL?

 A. No rows
 B. All matching rows
 C. All combinations of rows
 D. Duplicate rows only

✅Correct Answer: C

41. 41. Which language is used for querying databases?

 A. HTML
 B. SQL
 C. XML
 D. CSS

✅Correct Answer: B

42. 42. Which one is not a type of database model?

 A. Hierarchical
 B. Relational
 C. Network
 D. Linear
✅Correct Answer: D

43. 43. Which of the following is a relational database?

 A. MS Excel
 B. Oracle
 C. Notepad
 D. MS Paint

✅Correct Answer: B

44. 44. What is the function of the SELECT command?

 A. Insert data
 B. Delete data
 C. Retrieve data
 D. Update data

✅Correct Answer: C

45. 45. Which command is used to remove all records from a table?

 A. DELETE
 B. REMOVE
 C. DROP
 D. CLEAR

✅Correct Answer: A

46. 46. In SQL, which keyword is used to sort the result-set?

 A. ORDER
 B. SORT
 C. ORDER BY
 D. GROUP BY

✅Correct Answer: C

47. 47. Which of the following is not a SQL Data Manipulation Language (DML) command?

 A. SELECT
 B. INSERT
 C. UPDATE
 D. CREATE

✅Correct Answer: D

48. 48. Which command is used to create a new table in SQL?

 A. MAKE TABLE
 B. NEW TABLE
 C. CREATE TABLE
 D. INIT TABLE

✅Correct Answer: C

49. 49. Which normal form deals with removal of transitive dependency?

 A. 1NF
 B. 2NF
 C. 3NF
 D. BCNF

✅Correct Answer: C

50. 50. What is the result of a Cartesian product in SQL?

 A. No rows
 B. All matching rows
 C. All combinations of rows
 D. Duplicate rows only

✅Correct Answer: C

51. 51. Which language is used for querying databases?

 A. HTML
 B. SQL
 C. XML
 D. CSS

✅Correct Answer: B

52. 52. Which one is not a type of database model?


 A. Hierarchical
 B. Relational
 C. Network
 D. Linear

✅Correct Answer: D

53. 53. Which of the following is a relational database?

 A. MS Excel
 B. Oracle
 C. Notepad
 D. MS Paint

✅Correct Answer: B

54. 54. What is the function of the SELECT command?

 A. Insert data
 B. Delete data
 C. Retrieve data
 D. Update data

✅Correct Answer: C

55. 55. Which command is used to remove all records from a table?

 A. DELETE
 B. REMOVE
 C. DROP
 D. CLEAR

✅Correct Answer: A

56. 56. In SQL, which keyword is used to sort the result-set?

 A. ORDER
 B. SORT
 C. ORDER BY
 D. GROUP BY

✅Correct Answer: C
57. 57. Which of the following is not a SQL Data Manipulation Language (DML) command?

 A. SELECT
 B. INSERT
 C. UPDATE
 D. CREATE

✅Correct Answer: D

58. 58. Which command is used to create a new table in SQL?

 A. MAKE TABLE
 B. NEW TABLE
 C. CREATE TABLE
 D. INIT TABLE

✅Correct Answer: C

59. 59. Which normal form deals with removal of transitive dependency?

 A. 1NF
 B. 2NF
 C. 3NF
 D. BCNF

✅Correct Answer: C

60. 60. What is the result of a Cartesian product in SQL?

 A. No rows
 B. All matching rows
 C. All combinations of rows
 D. Duplicate rows only

✅Correct Answer: C

61. 61. Which language is used for querying databases?

 A. HTML
 B. SQL
 C. XML
 D. CSS
✅Correct Answer: B

62. 62. Which one is not a type of database model?

 A. Hierarchical
 B. Relational
 C. Network
 D. Linear

✅Correct Answer: D

63. 63. Which of the following is a relational database?

 A. MS Excel
 B. Oracle
 C. Notepad
 D. MS Paint

✅Correct Answer: B

64. 64. What is the function of the SELECT command?

 A. Insert data
 B. Delete data
 C. Retrieve data
 D. Update data

✅Correct Answer: C

65. 65. Which command is used to remove all records from a table?

 A. DELETE
 B. REMOVE
 C. DROP
 D. CLEAR

✅Correct Answer: A

66. 66. In SQL, which keyword is used to sort the result-set?

 A. ORDER
 B. SORT
 C. ORDER BY
 D. GROUP BY

✅Correct Answer: C

67. 67. Which of the following is not a SQL Data Manipulation Language (DML) command?

 A. SELECT
 B. INSERT
 C. UPDATE
 D. CREATE

✅Correct Answer: D

68. 68. Which command is used to create a new table in SQL?

 A. MAKE TABLE
 B. NEW TABLE
 C. CREATE TABLE
 D. INIT TABLE

✅Correct Answer: C

69. 69. Which normal form deals with removal of transitive dependency?

 A. 1NF
 B. 2NF
 C. 3NF
 D. BCNF

✅Correct Answer: C

70. 70. What is the result of a Cartesian product in SQL?

 A. No rows
 B. All matching rows
 C. All combinations of rows
 D. Duplicate rows only

✅Correct Answer: C

71. 71. Which language is used for querying databases?


 A. HTML
 B. SQL
 C. XML
 D. CSS

✅Correct Answer: B

72. 72. Which one is not a type of database model?

 A. Hierarchical
 B. Relational
 C. Network
 D. Linear

✅Correct Answer: D

73. 73. Which of the following is a relational database?

 A. MS Excel
 B. Oracle
 C. Notepad
 D. MS Paint

✅Correct Answer: B

74. 74. What is the function of the SELECT command?

 A. Insert data
 B. Delete data
 C. Retrieve data
 D. Update data

✅Correct Answer: C

75. 75. Which command is used to remove all records from a table?

 A. DELETE
 B. REMOVE
 C. DROP
 D. CLEAR

✅Correct Answer: A
76. 76. In SQL, which keyword is used to sort the result-set?

 A. ORDER
 B. SORT
 C. ORDER BY
 D. GROUP BY

✅Correct Answer: C

77. 77. Which of the following is not a SQL Data Manipulation Language (DML) command?

 A. SELECT
 B. INSERT
 C. UPDATE
 D. CREATE

✅Correct Answer: D

78. 78. Which command is used to create a new table in SQL?

 A. MAKE TABLE
 B. NEW TABLE
 C. CREATE TABLE
 D. INIT TABLE

✅Correct Answer: C

79. 79. Which normal form deals with removal of transitive dependency?

 A. 1NF
 B. 2NF
 C. 3NF
 D. BCNF

✅Correct Answer: C

80. 80. What is the result of a Cartesian product in SQL?

 A. No rows
 B. All matching rows
 C. All combinations of rows
 D. Duplicate rows only
✅Correct Answer: C

81. 81. Which language is used for querying databases?

 A. HTML
 B. SQL
 C. XML
 D. CSS

✅Correct Answer: B

82. 82. Which one is not a type of database model?

 A. Hierarchical
 B. Relational
 C. Network
 D. Linear

✅Correct Answer: D

83. 83. Which of the following is a relational database?

 A. MS Excel
 B. Oracle
 C. Notepad
 D. MS Paint

✅Correct Answer: B

84. 84. What is the function of the SELECT command?

 A. Insert data
 B. Delete data
 C. Retrieve data
 D. Update data

✅Correct Answer: C

85. 85. Which command is used to remove all records from a table?

 A. DELETE
 B. REMOVE
 C. DROP
 D. CLEAR

✅Correct Answer: A

86. 86. In SQL, which keyword is used to sort the result-set?

 A. ORDER
 B. SORT
 C. ORDER BY
 D. GROUP BY

✅Correct Answer: C

87. 87. Which of the following is not a SQL Data Manipulation Language (DML) command?

 A. SELECT
 B. INSERT
 C. UPDATE
 D. CREATE

✅Correct Answer: D

88. 88. Which command is used to create a new table in SQL?

 A. MAKE TABLE
 B. NEW TABLE
 C. CREATE TABLE
 D. INIT TABLE

✅Correct Answer: C

89. 89. Which normal form deals with removal of transitive dependency?

 A. 1NF
 B. 2NF
 C. 3NF
 D. BCNF

✅Correct Answer: C

90. 90. What is the result of a Cartesian product in SQL?


 A. No rows
 B. All matching rows
 C. All combinations of rows
 D. Duplicate rows only

✅Correct Answer: C

91. 91. Which language is used for querying databases?

 A. HTML
 B. SQL
 C. XML
 D. CSS

✅Correct Answer: B

92. 92. Which one is not a type of database model?

 A. Hierarchical
 B. Relational
 C. Network
 D. Linear

✅Correct Answer: D

93. 93. Which of the following is a relational database?

 A. MS Excel
 B. Oracle
 C. Notepad
 D. MS Paint

✅Correct Answer: B

94. 94. What is the function of the SELECT command?

 A. Insert data
 B. Delete data
 C. Retrieve data
 D. Update data

✅Correct Answer: C
95. 95. Which command is used to remove all records from a table?

 A. DELETE
 B. REMOVE
 C. DROP
 D. CLEAR

✅Correct Answer: A

96. 96. In SQL, which keyword is used to sort the result-set?

 A. ORDER
 B. SORT
 C. ORDER BY
 D. GROUP BY

✅Correct Answer: C

97. 97. Which of the following is not a SQL Data Manipulation Language (DML) command?

 A. SELECT
 B. INSERT
 C. UPDATE
 D. CREATE

✅Correct Answer: D

98. 98. Which command is used to create a new table in SQL?

 A. MAKE TABLE
 B. NEW TABLE
 C. CREATE TABLE
 D. INIT TABLE

✅Correct Answer: C

99. 99. Which normal form deals with removal of transitive dependency?

 A. 1NF
 B. 2NF
 C. 3NF
 D. BCNF
✅Correct Answer: C

100. 100. What is the result of a Cartesian product in SQL?

 A. No rows
 B. All matching rows
 C. All combinations of rows
 D. Duplicate rows only

✅Correct Answer: C

You might also like