Database Management Systems (DBMS) – Questions
With Correct Solutions
What is a database management system? Right 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? Right Ans - -reduced data
redundancy
-improved data integrity
-more program independence
-increased user productivity
-increased security
What is DBMS used for? Right Ans - to create tables and relationships in
databases
What do applications use DBMS for? Right Ans - to read, insert, modify, and
delete data
What is a structured query language (SQL)? Right Ans - SQL is an
international standard language for manipulating relational databases
What do SQL queries consist of? Right Ans - an action, database table name,
set of parameters
What are SQL keywords? Right Ans - they issue instructions
-create, delete, insert, etc.
What are boo lean operators? Right Ans - AND, OR, NOT for searching
What are global updates? Right Ans - based on some criteria
What are joining tables? Right Ans - creating relationship
What are some things that go into selecting a DBMS? Right Ans - database
size
number of concurrent users
With Correct Solutions
What is a database management system? Right 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? Right Ans - -reduced data
redundancy
-improved data integrity
-more program independence
-increased user productivity
-increased security
What is DBMS used for? Right Ans - to create tables and relationships in
databases
What do applications use DBMS for? Right Ans - to read, insert, modify, and
delete data
What is a structured query language (SQL)? Right Ans - SQL is an
international standard language for manipulating relational databases
What do SQL queries consist of? Right Ans - an action, database table name,
set of parameters
What are SQL keywords? Right Ans - they issue instructions
-create, delete, insert, etc.
What are boo lean operators? Right Ans - AND, OR, NOT for searching
What are global updates? Right Ans - based on some criteria
What are joining tables? Right Ans - creating relationship
What are some things that go into selecting a DBMS? Right Ans - database
size
number of concurrent users
