Database management systems (DBMS) Questions with Detailed Verified Answers (100% Correct Answers) Already Graded A+

1 Exampromax - Stuvia US 2025/2026


Database management systems (DBMS)
Questions with Detailed Verified Answers
(100% Correct Answers) Already Graded A+
What is a database management system?
Ans: a program controlling the structure of a database and access to the
data; creates, processes, and administers database

What are some advantages of a DBMS?
Ans: -reduced data redundancy
©, 2025 All rights reserved®




-improved data integrity
-more program independence
Exampromax - Stuvia US




-increased user productivity
-increased security

What is DBMS used for?
Ans: to create tables and relationships in databases

What do applications use DBMS for?
Ans: to read, insert, modify, and delete data

What is a structured query language (SQL)?
Ans: SQL is an international standard language for manipulating relational
databases

What do SQL queries consist of?
Ans: an action, database table name, set of parameters

What are SQL keywords?

, 2 Exampromax - Stuvia US 2025/2026

Ans: they issue instructions
-create, delete, insert, etc.

What are boo lean operators?
Ans: AND, OR, NOT for searching

What are global updates?
Ans: based on some criteria

What are joining tables?
©, 2025 All rights reserved®




Ans: creating relationship
Exampromax - Stuvia US




What are some things that go into selecting a DBMS?
Ans: database size
number of concurrent users
performance
integration
features
vendor
cost

What is a database structure?
Ans: an arrangement of the fields, tables, and relationships

.
Ans: .

What are some techniques for creating a data model?