Database Test Prep B

What are the components of a database?

• Tables, fields, records

• Graphs, charts, tables

• Pages, paragraphs, sentences

• Nodes, links, paths

What is the difference between fields and records in a database?

• Fields are columns, records are rows

• Fields are rows, records are columns

• Fields are tables, records are databases

• Fields are databases, records are tables

Which of the following is a basic data type used in databases?

• Integer

• Graph

• Paragraph

• Node

What is the difference between a table and a query in a database?

• A table stores data, a query retrieves data

• A table retrieves data, a query stores data

• A table is a report, a query is a chart

• A table is a chart, a query is a report

What are primary and foreign keys in a database?

• Types of database keys

• Types of data formats

• Types of queries

• Types of reports

What type of relationship is described as one-to-many in a database?

• One record in a table is related to many records in another table

• One record in a table is related to one record in another table

• Many records in a table are related to one record in another table

• Many records in a table are related to many records in another table

What is the difference between a query and a report in a database?

• A query retrieves data, a report presents data

• A query presents data, a report retrieves data

• A query is a type of key, a report is a type of relationship

• A query is a type of relationship, a report is a type of key

What are various report types in a database?

• Summary, detailed, graphical

• Integer, string, boolean

• Primary, foreign, composite

• One-to-one, one-to-many, many-to-many

Which of the following is a step in designing a database?

• Determine the software version

• Identify data types

• Install antivirus software

• Create a backup schedule

What is the first step in designing a database according to the image?

• Identify Queries, Forms and Reports

• Organize data tables and fields

• Who needs what information

• Relate the information