dbms test

A row of fields in a database is known as:

• A column
• A cell reference
• A record
• A table

A ________ in a database is used to hold a single item of data, such as "pupilName".

• Table
• Record
• Cell
• Field

Which query could be used to find all pupils who are at least 13 years old in a pupil database?

• age >13
• age<13
• age>=13
• age<=13

A unique identifying field.

• Primary Key
• Integer
• Verification
• Boolean

When you normalize a relation by breaking it into two smaller relations, what must you do to maintain data integrity?

• Remove any functional dependencies from both relations

• Assign both relations the same primary key field(s)

• Create a primary key(s) for the new relation

A medical office needs to create a solution to manage patient records. They have about 10,000 patients and eight staff, they want to include notes from medical professionals, emails to and from patients, and images such as X-ray. What should they create?

• Spreadsheet

• Relational database

• Non-relational database

• Primary key

You have created a relational database. Which of the following elements uniquely identifies a record in the database?

• Primary key

• Foreign key

• Schema

• Field

What are the advantages of database approach?

Which of the following is NOT the advantages of using database?

• minimizes data redundancy

• ensure data security

• can control data inconsistency

• tools for financial documents

What is a database?

• A type of software used for graphic design

• A type of spreadsheet used for data analysis

• An organized collection of data, typically stored and accessed electronically from a computer system.

• A type of computer hardware