ITF Databases

You have a contact list for an online marketing company. It contains names and email addresses for approximately three million people. A team of twenty marketers works with information on the list. Which solution should you use to store the data?

• SPREADSHEET

• RELATIONAL DATABASE

• WORD PROCESSING SOFTWARE

• NON-RELATIONAL DATABASE

Which of the following outlines the structure of the database, such as what tables and fields are included?

• Physical schema

• Logical schema

• Forms

• Primary key

Which of the following commands best describes the function of the DELETE command in a relational database?

• Deletes a record from a table

• Deletes a field from a table

• Deletes a schema from a table

• Deletes a database or a table

You are creating a table in a relational database. Which of the following is required?

• Foreign Key

• Constraints

• Logical schema

• Primary key

Which of the following is considered non-structured data?

• Text

• Numbers

• Pictures

• Pictures with metadata

Mary, a user, has created a SQL query to access data in her database. Which of the following terms best describes the type of access she is using?

• user interface/utility access

• Programmatic access

• Database dump

• Direct/ manual access

A database developer is working on generating queries. If the developer needs to ensure that the output of the query has data persistence, to where should the data be written? (Choose two.)

• HDD

• RAM

• SSD

• CPU

Which command is used to create queries in a relational database?

• FIND

• SEEK

• SEARCH

• SELECT

You need to delete a database. Which command is used to do this?

• DROP

• ALTER

• DELETE

• REMOVE

Michael, an administrator, needs to add a column to an existing table. Which command should he use?

• insert

• create

• update

• alter