Database Query Flashcard

Front

What is letter "A" showing? Options: Where to configure the Join properties, Where to Run the query, Where to configure which fields and criteria are used for the Query

Back

Where to Run the query

Front

What is letter "B" showing? Options: Where to click to Run the Query, Where to Configure the Fields returned and criteria to be used, Where to click to configure the Join properties, Where to click to Save this Query

Back

Where to click to configure the Join properties

Front

A query can get its data from: one or more tables, existing queries, a combination of a and b, or all of the above?

Back

one or more tables.

Front

Which Boolean operator will narrow your results? Options: AND, OR, NOT, BUT

Back

AND

Front

Which Boolean operator will expand your results? Options: AND, OR, NOT, BUT

Back

OR

Front

A football team keeps a database about its players. Which query would allow them to produce a query showing players who are strikers and who have scored 20 goals or more?

Back

Position = "Striker" AND Goals >= 20

Front

Wildcard that represents any collection of characters

Back

Asterisk

Front

A customer is looking for a particular author but cannot remember their full name. The customer remembers that the surname of the author starts with the letters "Co". What kind of query could the bookshop owner use to find this information?

Back

Wildcard

Front

Which of the following would be used to uniquely identify a record? Validation, Data type, Primary key, Field size

Back

Primary key

Front

What is a foreign key?

Back

A FOREIGN KEY is a field in one table that matches the PRIMARY KEY in another table.