DBMS EXAM QUESTIONS AND ANSWERS
What is a database management system? - 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? - Answers - -reduced data redundancy
-improved data integrity
-more program independence
-increased user productivity
-increased security
What is DBMS used for? - Answers - to create tables and relationships in databases
What are boo lean operators? - Answers - AND, OR, NOT for searching
What are global updates? - Answers - based on some criteria
What are joining tables? - Answers - creating relationship
What do applications use DBMS for? - Answers - to read, insert, modify, and delete
data
What is a structured query language (SQL)? - Answers - SQL is an international
standard language for manipulating relational databases
What do SQL queries consist of? - Answers - an action, database table name, set of
parameters
What are SQL keywords? - Answers - they issue instructions
-create, delete, insert, etc.
What are some things that go into selecting a DBMS? - Answers - database size
number of concurrent users
performance
integration
features
vendor
cost
What is a database structure? - Answers - an arrangement of the fields, tables, and
relationships
. - Answers - .
What are some techniques for creating a data model? - Answers - entity relationship
What is a database management system? - 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? - Answers - -reduced data redundancy
-improved data integrity
-more program independence
-increased user productivity
-increased security
What is DBMS used for? - Answers - to create tables and relationships in databases
What are boo lean operators? - Answers - AND, OR, NOT for searching
What are global updates? - Answers - based on some criteria
What are joining tables? - Answers - creating relationship
What do applications use DBMS for? - Answers - to read, insert, modify, and delete
data
What is a structured query language (SQL)? - Answers - SQL is an international
standard language for manipulating relational databases
What do SQL queries consist of? - Answers - an action, database table name, set of
parameters
What are SQL keywords? - Answers - they issue instructions
-create, delete, insert, etc.
What are some things that go into selecting a DBMS? - Answers - database size
number of concurrent users
performance
integration
features
vendor
cost
What is a database structure? - Answers - an arrangement of the fields, tables, and
relationships
. - Answers - .
What are some techniques for creating a data model? - Answers - entity relationship
