7. Employees need to demonstrate digital skills (hard), general (soft) skills & attitude. General skills are:

Communication, teamwork, problem-solving and time management.

3. In a database, what is the purpose of a form?

To provide a user-friendly interface for entering and editing data.

2. Which of the following is the best way to organize data in a relational database?

Using tables to structure data.

6. What is a foreign key in a relational database?

A key that links records between two tables

1. What is the primary purpose of a database?

To store and manage data for easy retrieval and analysis.

studbud

Database Review 2

8 termsStudBud Administration11 plays

A review of database topics including tables, forms and queries.

Flashcards8 cardsFPractice quizPHost liveL

Questions 8

Answers

1
7. Employees need to demonstrate digital skills (hard), general (soft) skills & attitude. General skills are:
Empathy, integrity, accountability and optimism.
Communication, teamwork, problem-solving and time management.
Programming, data analysis, software engineering and cyber security.
Coding, database management, web development and software engineering.
2
8. A key programming language for database management is SQL. What does SQL stand for?
Structured Query Language.
Search & Query Language.
Secure Query Language.
Server Query Language.
3
3. In a database, what is the purpose of a form?
To create queries that filter data.
To provide a user-friendly interface for entering and editing data.
To automatically back up the data.
To organize data in tables.
4
2. Which of the following is the best way to organize data in a relational database?
Using multiple forms for data entry.
Storing all data in one large text file.
Using tables to structure data.
Creating a graphical interface for each data set.
5
6. What is a foreign key in a relational database?
A key used for encrypting data.
A column that uniquely identifies each row in a table.
A key that links records between two tables
A tool for creating complex reports.
6
5. What type of database object is used to extract specific data from multiple tables based on a set of conditions?
Form.
Table.
Report.
Query.
7
4. Which SQL query is used to retrieve all records from a table named "Customers"?
SELECT * FROM Customers;
DELETE FROM Customers;
INSERT INTO Customers;
UPDATE Customers SET *;
8
1. What is the primary purpose of a database?
To store and manage data for easy retrieval and analysis.
To create user interfaces for data entry.
To make software applications more secure.
To display data in a graphical format.

Database Review 2 Flashcards | StudBud