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
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
