AnswersVA-Information Technology Fundamentals BQuery Data

Query Data — Unit test Answers

2 verified answers1 views
21
Free Preview

Which is an advantage of using a flat file instead of a relational database?

A
A flat file is easier to set up.
B
It is easier to assign foreign keys to a flat file.
C
A flat file reduces storage of redundant data.
D
A flat file reduces storage of irrelevant data.
22
Free Preview

Which describes a query?

A
A query organizes, summarizes, and presents data in an easy-to-view format.
B
A query allows for retrieval of information from multiple tables.
C
A query is a way to modify data in tables.
D
A query is a sorted report.
23

What is a primary key?

A
a field that uniquely identifies a record in a table
B
a field that uniquely identifies a table
C
the first security key entered by a database user
D
the first security key entered by a database administrator
24

Which statement is correct?

A
Flat files use foreign keys to uniquely identify tables.
B
Flat files use foreign keys to secure data.
C
A foreign key is a primary key in another table.
D
A foreign key uniquely identifies a record in a table.
25

Jorge is creating a directory of student phone numbers and addresses. He performed a query to obtain the data he will include. He now needs to arrange the data alphabetically by last name, from A to Z. Which sort function should he use?

A
Sort Ascending
B
Sort Descending
C
Filter
D
Reapply Sort

Did you find these answers helpful?

More from this Course

Quiz
7 verified answers

Unit Test

Quiz
5 verified answers

Unit Test

Quiz
5 verified answers

Unit Test