Database management systems (DBMS) Questions with Correct Answers

1




Database management systems (DBMS)
Questions with Correct Answers for Specific
Exam Mail
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

-improved data integrity

-more program independence

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


Pretest - Stuvia US

, 2


Ans: an action, database table name, set of parameters



What are SQL keywords?

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?

Ans: creating relationship



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?




Pretest - Stuvia US