Summary Database management systems (DBMS) Questions and Answers 2024 with complete solution(Graded A+)

Database management systems (DBMS)
Questions and Answers 2024 with complete
solution(Graded A+)
What is a database management system? - CORRECT ANSWERS 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? - CORRECT ANSWERS -reduced
data redundancy
-improved data integrity
-more program independence
-increased user productivity
-increased security


What is DBMS used for? - CORRECT ANSWERS to create tables and
relationships in databases


What do applications use DBMS for? - CORRECT ANSWERS to read, insert,
modify, and delete data


What is a structured query language (SQL)? - CORRECT ANSWERS SQL is
an international standard language for manipulating relational databases


What do SQL queries consist of? - CORRECT ANSWERS an action, database
table name, set of parameters


What are SQL keywords? - CORRECT ANSWERS they issue instructions
-create, delete, insert, etc.


What are boo lean operators? - CORRECT ANSWERS AND, OR, NOT for
searching


What are global updates? - CORRECT ANSWERS based on some criteria

, Database management systems (DBMS)
Questions and Answers 2024 with complete
solution(Graded A+)
What are joining tables? - CORRECT ANSWERS creating relationship


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


What is a database structure? - CORRECT ANSWERS an arrangement of the
fields, tables, and relationships


. - CORRECT ANSWERS .


What are some techniques for creating a data model? - CORRECT ANSWERS
entity relationship
data model
unified modeling language


Database content? - CORRECT ANSWERS entities stored in database and
relationship among those things


What is an entity? - CORRECT ANSWERS item for which we want to store
information
-tables