Database

What is a database?

• A physical storage device.

• A collection of unorganized data.

• An organized collection of data.

• A programming language.

Which of the following is responsible for managing an organization's database?

• Data analyst

• Database administrator (DBA)

• Network engineer

• Software developer

What is the smallest unit of data in the hierarchy of data?

• Byte

• Bit

• Field

• Record

Which of the following is NOT part of the hierarchy of data?

• Bit

• Field

• Program

• Database

What does a DBMS (Database Management System) do?

• Physically stores data.

• Provides an interface for users and applications to interact with a database.

• Translates programming languages.

• Prevents unauthorized access to the Internet.

Which of the following describes a primary key?

• A field used to identify a record uniquely.

• A field that stores encrypted data.

• A backup copy of a database.

• A method of querying a database.

In a relational database, what is a table row called?

• Attribute

• Schema

• Field

• Record

Which of the following is an example of a popular DBMS for multiple users?

• Microsoft Access

• FileMaker Pro

• Oracle

• Excel

What is the main function of data centers?

• Housing database servers and delivering mission-critical information.

• Storing physical documents.

• Creating software applications.

• Managing social media accounts.

What is an entity in a database?

• A backup file.

• A program used to manage data.

• A general class of people, places, or things for which data is collected.

• A type of database software.