FiltersDone

Question type

Essay

Multiple Choice

Short Answer

True False

Matching

Exam 4: Database Processing

Show Answer

Share

---

All types

Filters

Study FlashcardsPractice ExamLearn

Question 1

True/False

Review LaterAdd Note

Review Later

Attributes describe the characteristics of an entity.

A) True
B) False

Correct Answer

verified

Show Answer

Question 2

Multiple Choice

Review LaterAdd Note

Review Later

In which of the following cases would the user(s) use a personal rather than an enterprise DBMS?

A) A startup company needs a database that can accommodate its 150 employees and be expanded to include more users.
B) A professor needs to maintain a database of his students' attendance and marks for the term.
C) Gensys needs a DBMS that is accessible across its locations around the world.
D) A university needs a database that can be accessed by students from all its departments.

E) B) and D)
F) C) and D)

Correct Answer

verified

Show Answer

Question 3

Multiple Choice

Review LaterAdd Note

Qtopia Inc. needs a database system which can support approximately 20 trillion bytes of data and 5000 users within the organization. Which of the following DBMS products would be appropriate?

Which of the following is a license-free, open-source database management system?

The database is a self-describing collection of integrated records.

A ________ is a collection of forms, reports, queries, and application programs that use the DBMS to process a database.

________ refers to the number of entities that can be involved in a relationship.

An identifier is an attribute (or group of attributes)whose value is associated with one and only one entity instance.

In a relational database, every table must have a key.

A single database can have only one application and user.

In a data model, entities always represent physical objects.

One of the development tasks of the database administrator is to develop a system to record and manage resolution of problems.

Normalization is the only criterion for evaluating database designs.

When there are same number of entities on each side of the relationship, an N:M relationship can be referred to as an N:N relationship.

One of the functions of a DBMS is to provide tools to assist in the administration of the database.

The data integrity problem occurs only if data are duplicated.

A group of similar rows or records is called a field.

Bytes are grouped into columns, which are also called ________.

All entity relationships are represented using crow's foot diagrams.

Joanna wants to find a particular report containing the sales analyses of the company for the second and third quarters of the year. After accessing the DBMS, she should type in the keyword into a ________ to locate what she is looking for.