Froggy Jumps Database Management Systems QuizVersion en ligne Test your knowledge on database management systems with this fun quiz! par Angayarkanni V 1 The DBMS acts as an interface between ________________ and ________________ of an enterprise-class system. a Data and the DBMS b Application and SQL c Database application and the database 2 What is the primary purpose of a database management system (DBMS)? a To create web applications. b To manage and organize data. c To perform calculations. 3 Which of the following is a type of DBMS? a Spreadsheet DBMS. b Relational DBMS. c Document DBMS. 4 What does SQL stand for? a Structured Query Language. b Standard Query Language. c Simple Query Language. 5 Which of these is NOT a DBMS? a Microsoft Excel. b Oracle Database. c MySQL. 6 What is a primary key in a database? a A password for access. b A type of data entry. c A unique identifier for a record. 7 Which of the following is not an example of DBMS? a MySQL b Google c Microsoft Acessv 8 Which SQL command is used to retrieve data? a SELECT. b GET. c FETCH. 9 What is a foreign key? a A field that links to a primary key in another table. b A key for database access. c A type of encryption key. 10 Which of the following is a NoSQL database? a MySQL. b MongoDB. c PostgreSQL. 11 What is a database schema? a The structure that defines the organization of data. b A type of database query. c A user interface design. 12 ______________ is a set of one or more attributes taken collectively to uniquely identify a record. a Super key b Foreign key c Candidate key 13 Which of the following is a feature of the database? a Lack of Authentication b No-backup for the data stored c User interface provided 14 In which of the following formats data is stored in the database management system? a Text b Table c Image 15 Which of the following is a primary function of a DBMS? a Data storage and retrieval b Data encryption c Data visualization 16 What is one advantage of using a DBMS? a Increased data redundancy b Slower data access c Data integrity and consistency 17 Which model is commonly used in DBMS? a Hierarchical model b Relational model c Network model 18 Which language is primarily used to interact with a DBMS? a HTML b Python c SQL (Structured Query Language) 19 What does ACID stand for in DBMS? a Atomicity, Consistency, Integration, Durability b Atomicity, Consistency, Isolation, Durability c Accuracy, Consistency, Isolation, Durability 20 What is a primary key in a database? a A foreign key reference b A type of data field c A unique identifier for a record