Database Knowledge Check 2

What is meant by sorting a database?

• selecting records that meet a certain criteria

• ensuring the database is in the correct folder in your file directory

• arranging the records into a particular order

• setting the design structure of a database table

What is meant by a simple sort?

• searching the table using one criterion or condition

• searching the table using more than one criteria or condition

• sorting records using more than one field

• sorting records using one field

What is meant by a complex sort?

• searching the table using one criterion or condition

• searching the table using more than one criteria or condition

• sorting records using more than one field

• sorting records using one field

What is meant by searching a database?

• selecting records that meet a certain criteria

• ensuring the database is in the correct folder in your file directory

• arranging the records into a particular order

• setting the design structure of a database table

What is meant by a simple search?

• searching the table using one criterion or condition

• searching the table on more than one criteria or conditions

• sorting records using more than one field

• sorting records using one field

What is meant by a complex search?

• searching the table using one criterion or condition

• searching the table on more than one criteria or conditions

• sorting records using more than one field

• sorting records using one field

Conditions for searches can be set using relational operators. Which of the following symbols is used for 'greater than'?

• <

• >

• >=

• <>

Conditions for searches can be set using relational operators. Which of the following symbols is used for 'less than or equal to'?

• <=

• =

• >=

• <>

Conditions for searches can be set using relational operators. Which of the following symbols is used for 'not equal to'?

• <=

• =

• >=

• <>

Which term is used for the criteria for a search where a character is used in place of search criteria that you are unsure of?

• wildfire

• blankcard

• wildcard

• wildsearch