Register
Login
Home
Categories
Technology
Health
Education
Business
Lifestyle
News
Food & Reicipe
Notes
Mock Test
About
Contact
Unit 1: Database Management System (DBMS) (12 Hours)
1. What does DBMS stand for?
Data Base Management System
Data Bank Management System
Data Buffer Management System
Data Block Management System
2. Which of the following is NOT a type of database?
Hierarchical
Network
Distributed
Connected
3. Which language is used to query databases?
HTML
SQL
CSS
JavaScript
4. A primary key in a database is used to:
Delete data
Access files
Uniquely identify records
Create indexes
5. The term 'CRUD' in DBMS refers to:
Create, Read, Update, Delete
Copy, Replace, Undo, Delete
Create, Replace, Update, Download
Create, Read, Upgrade, Delete
6. In relational databases, tables are also known as:
Attributes
Tuples
Relations
Records
7. What is a tuple in a relational database?
A column
A row
A table
A query
8. Which of the following is an example of a DBMS software?
MS Word
Excel
Oracle
PowerPoint
9. Which SQL statement is used to extract data from a database?
GET
SELECT
OPEN
EXTRACT
10. In an ER diagram, what does a diamond shape represent?
Attribute
Relationship
Entity
Primary Key
11. Normalization in DBMS is used to:
Remove redundancy
Add redundancy
Remove constraints
Add tables
12. A foreign key is a key used to:
Uniquely identify records within a table
Relate two tables
Sort data
Perform calculations
13. Which command is used to remove a table from a database?
DELETE
REMOVE
DROP
CLEAR
14. What is the function of the ‘JOIN’ operation in SQL?
Connects rows in the same table
Connects rows in different tables
Connects databases
Connects data types
15. In SQL, what does 'NULL' represent?
A zero value
An empty string
An unknown value
A negative value
16. What is a view in SQL?
A table copy
A stored procedure
A virtual table
A backup
17. Which type of database model uses parent-child relationships?
Hierarchical
Network
Relational
Object-oriented
18. The command to add data into a database table is:
ADD
INSERT
PUT
UPDATE
19. What does DML stand for?
Data Manipulation Language
Database Manipulation Language
Data Management Language
Database Management Language
20. Which of the following statements is used to modify existing records in a database?
UPDATE
MODIFY
CHANGE
ALTER
21. What does DBMS stand for?
Data Base Management System
Data Bank Management System
Data Buffer Management System
Data Block Management System
22. Which of the following is NOT a type of database?
Hierarchical
Network
Distributed
Connected
23. Which language is used to query databases?
HTML
SQL
CSS
JavaScript
24. A primary key in a database is used to:
Delete data
Access files
Uniquely identify records
Create indexes
25. The term 'CRUD' in DBMS refers to:
Create, Read, Update, Delete
Copy, Replace, Undo, Delete
Create, Replace, Update, Download
Create, Read, Upgrade, Delete
26. In relational databases, tables are also known as:
Attributes
Tuples
Relations
Records
27. What is a tuple in a relational database?
A column
A row
A table
A query
28. Which of the following is an example of a DBMS software?
MS Word
Excel
Oracle
PowerPoint
29. Which SQL statement is used to extract data from a database?
GET
SELECT
OPEN
EXTRACT
30. In an ER diagram, what does a diamond shape represent?
Attribute
Relationship
Entity
Primary Key
31. Normalization in DBMS is used to:
Remove redundancy
Add redundancy
Remove constraints
Add tables
32. A foreign key is a key used to:
Uniquely identify records within a table
Relate two tables
Sort data
Perform calculations
33. Which command is used to remove a table from a database?
DELETE
REMOVE
DROP
CLEAR
34. What is the function of the ‘JOIN’ operation in SQL?
Connects rows in the same table
Connects rows in different tables
Connects databases
Connects data types
35. In SQL, what does 'NULL' represent?
A zero value
An empty string
An unknown value
A negative value
36. What is a view in SQL?
A table copy
A stored procedure
A virtual table
A backup
37. Which type of database model uses parent-child relationships?
Hierarchical
Network
Relational
Object-oriented
38. The command to add data into a database table is:
ADD
INSERT
PUT
UPDATE
39. What does DML stand for?
Data Manipulation Language
Database Manipulation Language
Data Management Language
Database Management Language
40. Which of the following statements is used to modify existing records in a database?
UPDATE
MODIFY
CHANGE
ALTER
41. What does DBMS stand for?
Data Base Management System
Data Bank Management System
Data Buffer Management System
Data Block Management System
42. Which of the following is NOT a type of database?
Hierarchical
Network
Distributed
Connected
43. Which language is used to query databases?
HTML
SQL
CSS
JavaScript
44. A primary key in a database is used to:
Delete data
Access files
Uniquely identify records
Create indexes
45. The term 'CRUD' in DBMS refers to:
Create, Read, Update, Delete
Copy, Replace, Undo, Delete
Create, Replace, Update, Download
Create, Read, Upgrade, Delete
46. In relational databases, tables are also known as:
Attributes
Tuples
Relations
Records
47. What is a tuple in a relational database?
A column
A row
A table
A query
48. Which of the following is an example of a DBMS software?
MS Word
Excel
Oracle
PowerPoint
49. Which SQL statement is used to extract data from a database?
GET
SELECT
OPEN
EXTRACT
50. In an ER diagram, what does a diamond shape represent?
Attribute
Relationship
Entity
Primary Key
51. Normalization in DBMS is used to:
Remove redundancy
Add redundancy
Remove constraints
Add tables
52. A foreign key is a key used to:
Uniquely identify records within a table
Relate two tables
Sort data
Perform calculations
53. Which command is used to remove a table from a database?
DELETE
REMOVE
DROP
CLEAR
54. What is the function of the ‘JOIN’ operation in SQL?
Connects rows in the same table
Connects rows in different tables
Connects databases
Connects data types
55. In SQL, what does 'NULL' represent?
A zero value
An empty string
An unknown value
A negative value
56. What is a view in SQL?
A table copy
A stored procedure
A virtual table
A backup
57. Which type of database model uses parent-child relationships?
Hierarchical
Network
Relational
Object-oriented
58. The command to add data into a database table is:
ADD
INSERT
PUT
UPDATE
59. What does DML stand for?
Data Manipulation Language
Database Manipulation Language
Data Management Language
Database Management Language
60. Which of the following statements is used to modify existing records in a database?
UPDATE
MODIFY
CHANGE
ALTER
61. What does DBMS stand for?
Data Base Management System
Data Bank Management System
Data Buffer Management System
Data Block Management System
62. Which of the following is NOT a type of database?
Hierarchical
Network
Distributed
Connected
63. Which language is used to query databases?
HTML
SQL
CSS
JavaScript
64. A primary key in a database is used to:
Delete data
Access files
Uniquely identify records
Create indexes
65. The term 'CRUD' in DBMS refers to:
Create, Read, Update, Delete
Copy, Replace, Undo, Delete
Create, Replace, Update, Download
Create, Read, Upgrade, Delete
66. In relational databases, tables are also known as:
Attributes
Tuples
Relations
Records
67. What is a tuple in a relational database?
A column
A row
A table
A query
68. Which of the following is an example of a DBMS software?
MS Word
Excel
Oracle
PowerPoint
69. Which SQL statement is used to extract data from a database?
GET
SELECT
OPEN
EXTRACT
70. In an ER diagram, what does a diamond shape represent?
Attribute
Relationship
Entity
Primary Key
71. Normalization in DBMS is used to:
Remove redundancy
Add redundancy
Remove constraints
Add tables
72. A foreign key is a key used to:
Uniquely identify records within a table
Relate two tables
Sort data
Perform calculations
73. Which command is used to remove a table from a database?
DELETE
REMOVE
DROP
CLEAR
74. What is the function of the ‘JOIN’ operation in SQL?
Connects rows in the same table
Connects rows in different tables
Connects databases
Connects data types
75. In SQL, what does 'NULL' represent?
A zero value
An empty string
An unknown value
A negative value
76. What is a view in SQL?
A table copy
A stored procedure
A virtual table
A backup
77. Which type of database model uses parent-child relationships?
Hierarchical
Network
Relational
Object-oriented
78. The command to add data into a database table is:
ADD
INSERT
PUT
UPDATE
79. What does DML stand for?
Data Manipulation Language
Database Manipulation Language
Data Management Language
Database Management Language
80. Which of the following statements is used to modify existing records in a database?
UPDATE
MODIFY
CHANGE
ALTER
81. What does DBMS stand for?
Data Base Management System
Data Bank Management System
Data Buffer Management System
Data Block Management System
82. Which of the following is NOT a type of database?
Hierarchical
Network
Distributed
Connected
83. Which language is used to query databases?
HTML
SQL
CSS
JavaScript
84. A primary key in a database is used to:
Delete data
Access files
Uniquely identify records
Create indexes
85. The term 'CRUD' in DBMS refers to:
Create, Read, Update, Delete
Copy, Replace, Undo, Delete
Create, Replace, Update, Download
Create, Read, Upgrade, Delete
86. In relational databases, tables are also known as:
Attributes
Tuples
Relations
Records
87. What is a tuple in a relational database?
A column
A row
A table
A query
88. Which of the following is an example of a DBMS software?
MS Word
Excel
Oracle
PowerPoint
89. Which SQL statement is used to extract data from a database?
GET
SELECT
OPEN
EXTRACT
90. In an ER diagram, what does a diamond shape represent?
Attribute
Relationship
Entity
Primary Key
91. Normalization in DBMS is used to:
Remove redundancy
Add redundancy
Remove constraints
Add tables
92. A foreign key is a key used to:
Uniquely identify records within a table
Relate two tables
Sort data
Perform calculations
93. Which command is used to remove a table from a database?
DELETE
REMOVE
DROP
CLEAR
94. What is the function of the ‘JOIN’ operation in SQL?
Connects rows in the same table
Connects rows in different tables
Connects databases
Connects data types
95. In SQL, what does 'NULL' represent?
A zero value
An empty string
An unknown value
A negative value
96. What is a view in SQL?
A table copy
A stored procedure
A virtual table
A backup
97. Which type of database model uses parent-child relationships?
Hierarchical
Network
Relational
Object-oriented
98. The command to add data into a database table is:
ADD
INSERT
PUT
UPDATE
99. What does DML stand for?
Data Manipulation Language
Database Manipulation Language
Data Management Language
Database Management Language
100. Which of the following statements is used to modify existing records in a database?
UPDATE
MODIFY
CHANGE
ALTER
Check Score
Results
