Database Management Systems Quiz (1) Test your knowledge of database management systems with these 12 insightful questions. alina90 published on March 250 responses 0 « Previous Next » Questions in vertical order 1/12 What does SQL stand for? Structured Programming Language Structured Query Language Sequential Query Language System Query Language 2/12 Which database management system uses a relational model? MySQL MongoDB Redis SQLite 3/12 What is normalization in the context of databases? Adding redundancy to improve performance Simplifying data storage by using fewer tables Organizing data in a way to reduce redundancy and dependency Allowing data manipulation without restrictions 4/12 Which of the following is not a type of database management system? Relational Database Management System Document-oriented Database Management System Object-oriented Database Management System Graph Database Management System 5/12 What is the primary function of a database management system? Developing websites Storing, managing, and retrieving data Creating software applications Designing user interfaces 6/12 Which of the following is not a popular DBMS? Oracle PostgreSQL Java Microsoft SQL Server 7/12 What is ACID in the context of database transactions? A set of properties that guarantee reliability of transactions A programming language used for databases A data encryption algorithm A technique for data compression 8/12 Which of the following is an example of a NoSQL database? MySQL MongoDB PostgreSQL Oracle 9/12 What is a primary key in a database table? A key used for encryption A unique identifier for each record A password required to access the table A key used for sorting data 10/12 Which language is commonly used to interact with databases? SQL Python HTML JavaScript 11/12 What is the purpose of indexing in a database? Ensuring data is stored in alphabetical order Creating unique identifiers for records Improving query performance by speeding up data retrieval Encrypting sensitive information 12/12 Which of the following is a popular open-source DBMS? MySQL Oracle SQL Server PostgreSQL
