Tables and Queries (Grade 11 NSC Matric Computer Application Technology): Quizzes
📚Quizzes
Practise the questions
10 questions from this quiz
ShowHide
Practise the questions
10 questions from this quiz
What do queries act as in a database?
What do queries act as in a database?
Bridge between you and database info
How do queries improve database efficiency?
How do queries improve database efficiency?
They gather data quickly without manual work
What are the two main categories of queries?
What are the two main categories of queries?
Select queries and Action queries
What do select queries do?
What do select queries do?
Retrieve & display info, perform calculations
Why must you be cautious with action queries?
Why must you be cautious with action queries?
They permanently modify database content
What happens if you don't specify criteria in a query?
What happens if you don't specify criteria in a query?
You'll see all records from tables
What does 'Not' do in query criteria?
What does 'Not' do in query criteria?
Excludes certain records
When do you use 'And' in query criteria?
When do you use 'And' in query criteria?
To match two or more conditions at once
What advantage does Query Wizard offer?
What advantage does Query Wizard offer?
Quicker & less prone to errors
How do query results display after clicking Run?
How do query results display after clicking Run?
In Datasheet View like a spreadsheet