Reports and Queries in Databases (Grade 12 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 is a database?
What is a database?
A collection of related information
What does data integrity refer to?
What does data integrity refer to?
How accurate & consistent info remains
What problem does data redundancy cause?
What problem does data redundancy cause?
Same info in multiple locations
Which three characteristics define quality database information?
Which three characteristics define quality database information?
Up to date, complete, and relevant
What are the four main components of modern database systems?
What are the four main components of modern database systems?
Tables, forms, queries, reports
In Access databases, what are records and fields?
In Access databases, what are records and fields?
Records are rows, fields are columns
Which data type stores very lengthy text like memos?
Which data type stores very lengthy text like memos?
Long text
What is the purpose of a primary key?
What is the purpose of a primary key?
Uniquely identify each record
Which operator returns results when both conditions are true?
Which operator returns results when both conditions are true?
AND
Which query criteria finds exact matches for a specified value?
Which query criteria finds exact matches for a specified value?
Like