làm chủ database trong 1 quiz?

A relational database consists of a collection of

• Table

• Record

• Field

• Key

What term is used to refer a row?

• Field

• Foreign key

• Primary key

• Record

Answer explanation

Also called an entry in a table

A ... in a table represents a relationship among a set of values:

• Record

• Field

• Primary key

• Foreign key

A attribute in a relation is a foreign key if the ... from one relation is used as an attribute in that relation.

• Candidate key

• Foreign key

• Primary key

• Field

• Record

Some advantages of the database approach include all, but:

• Program-data dependency

• Improved data consistency

• Improved data sharing

• Minimal data redundancy

A database management system (DBMS) is a

• Software system used to create, maintain, and provide controlled access to a database

• Software system used to create, maintain, and provide uncontrolled access to a database

• Hardware system used to create, maintain, and provide controlled access to a database

• Hardware system used to create, maintain, and provide uncontrolled access to a database

The following are functions of a DBMS except

• Creating database

• Processing database

• Creating and processing forms

• Administrating database

A database application can perform which of the following activities?

• Add records

• Display / read records

• Update records

• Delete records

The term attribute refers to a ... of a table

• Field

• Record

• Primary key

• Foreign key

What does a data designers do?

• Define the content, the structure, the constraints, and functions or transactions against the database

• communicate with the end-users and understand their needs

• use the data for queries, reports and some of them actually update the database content

• Overall management of data resources in an organization