Database Lesson 3 & 4 Study/Vocab

What is the process of adding information to a set of database fields called?

• Deleting Records

• Inserting Records

• Modifying Records

• Exporting Records

Which type of query allows for one or more fields in a table to be updated?

• Delete Query

• Append Query

• Update Query

• Make Table Query

Answer explanation

An Update Query is specifically designed to modify existing records in a table, allowing one or more fields to be updated. In contrast, Delete, Append, and Make Table Queries serve different purposes.

What is a query in the context of databases?

• A question you ask a database using a set of criteria

• A type of database software

• A method to delete data from a database

• A way to back up database information

Answer explanation

A query is essentially a question posed to a database, specifying criteria to retrieve or manipulate data. The correct choice highlights this definition, distinguishing it from other database functions like software or data deletion.

Which file formats are mentioned for exporting functions?

• .doc, .pdf, .jpg

• .html, .xml, .json

• .txt, .csv, .xlsx

• .mp3, .wav, .flac

How can data in a virtual table be changed?

• All records at once

• One record at a time

• By deleting the table

• By renaming the table

Answer explanation

Data in a virtual table can be changed one record at a time, allowing for precise updates. The other options, such as deleting or renaming the table, do not directly change the data within the records.

What is a potential impact of deleting records in a database?

• It may improve performance

• It may impact other database objects

• It may create duplicates

• It may increase storage space

Answer explanation

Deleting records can impact other database objects, such as foreign key constraints or related data, leading to potential data integrity issues. This makes it crucial to consider dependencies before deletion.

What happens to information when it is deleted from a database?

• It is temporarily removed

• It is permanently deleted

• It is archived

• It is hidden

Answer explanation

When information is deleted from a database, it is typically permanently deleted, meaning it cannot be recovered. This distinguishes it from options like temporarily removed or archived, which imply the data can still be accessed.

What does a query automatically create between Primary and Foreign Key?

• A join

• A backup

• A report

• A deletion

Answer explanation

A query creates a join between Primary and Foreign Keys, allowing related data from different tables to be combined. This is essential for retrieving meaningful information from a relational database.

What can you do with fields in Datasheet View?

• Only view them

• Add or edit them

• Delete them

• Hide them

Answer explanation

In Datasheet View, you can add or edit fields, allowing you to modify the data directly. The other options, such as only viewing, deleting, or hiding fields, do not fully capture the capabilities of this view.

Which pool companies have purchased the BN-0609-TGOLD bullnose?

• Hawaiian Pools and Alure Pools

• Sahara Pools and Pete's Pools

• Clear Pools and Pete's Pools

• Alure Pools and Clear Pools

Answer explanation

Hawaiian Pools and Alure Pools are the correct choices as they are the companies that have purchased the BN-0609-TGOLD bullnose, distinguishing them from the other options listed.