SUBJECTS
|
BROWSE
|
CAREER CENTER
|
POPULAR
|
JOIN
|
LOGIN
Business Skills
|
Soft Skills
|
Basic Literacy
|
Certifications
About
|
Help
|
Privacy
|
Terms
Search
Test your basic knowledge |
RDBMS
Start Test
Study First
Subject
:
it-skills
Instructions:
Answer 50 questions in 15 minutes.
If you are not ready to take this test, you can
study here
.
Match each statement with the correct term.
Don't refresh. All questions and answers are randomly picked and ordered every time you load a test.
This is a study tool. The 3 wrong answers for each question are randomly chosen from answers to other questions. So, you might find at times the answers obvious, but you will see it re-enforces your understanding as you take the test each time.
1. Involves following a systematic set of rules to check for anomilies or deviations in data structure - which ensures fields are in the correct tables.
Relational database
Table normalisation
Formal testing
Data integrity
2. A set of information about one entity. E.g. a person - event or object.
Record
RDBMS
Validation rule
Primary key
3. Performed by the solution developer to ensure that the components and functions are operating correctly.
Informal testing
Test plan
Primary key
Data integrity
4. Show the series of steps to follow in order to create a solution.
Flowchart
Entity-relationship diagram
Relational database
Layout diagram
5. A hand-written sketch that shows the elements to be included on an input form or a report.
Layout diagram
Entity-relationship diagram
List tool
Data structure table
6. Uniquely identifies each record in a database table.
Primary key
Relational database
Record
Electronic validation
7. Involves testing the overall solution after it has been completed.
Input mask
Field
Data types
Formal testing
8. Stores data tables that are arranged in rows and columns. Tables are linked by a common field.
Formal testing
Relational database
Design tools
Formal testing
9. Applied to fields in databases. Examples include: Text and Boolean.
Electronic validation
Data types
RDBMS
Table normalisation
10. Used to direct the entry of data where there is a limited number of allowed values.
Manual validation
List tool
Relational database
Table normalisation
11. A type of database that involves storing data in tables consisting of rows or columns.
Flat file
Validation rule
Query
Data types
12. Performed by the solution developer to ensure that the components and functions are operating correctly.
Test plan
Informal testing
Entity-relationship diagram
List tool
13. Used as part of the bench test of a database solution.
Test plan
RDBMS
Data integrity
Relational database
14. A relational database management system.
RDBMS
Design tools
Query
Sorting
15. Used to control how data is entered.
Test plan
Table normalisation
Query
Input mask
16. A hand-written sketch that shows the elements to be included on an input form or a report.
Entity-relationship diagram
Record
Design tools
Layout diagram
17. Shows the interrelationships between different data elements.
IPO chart
Bench test
Entity-relationship diagram
Validation rule
18. Determines what formatting is used for a field based on its size and type. E.g. "Fixed decimal places" & "12 or 24-hour clock."
Flowchart
Design tools
Relationships
Data formats
19. Used with databases and include entity-relationship diagrams - data structure diagrams - data structure tables - flowcharts - IPO charts and layout diagrams.
Design tools
Data formats
Electronic validation
Primary key
20. Uniquely identifies each record in a database table.
Input mask
Test plan
Relational database
Primary key
21. The manual checking of data to ensure that it is correct and/or reasonable via means such as proofreading a document - checking for spelling - grammer and punctuation.
Primary key
Manual validation
Data formats
Field
22. A set of commands that are run automatically.
Macro
Data structure diagram
Input mask
Query
23. Show the series of steps to follow in order to create a solution.
Relationships
Flowchart
Electronic validation
Input mask
24. Contains the same type of data for a series of records.
Table normalisation
Data structure table
Field
Data formats
25. Used in databases to filter out only those records that meet the query criteria.
Data structure table
Entity-relationship diagram
Query
Data integrity
26. Shows the interrelationships between different data elements.
Entity-relationship diagram
Relationships
IPO chart
Flowchart
27. The display of results in an organised and usable manner.
Macro
Test plan
Sorting
List tool
28. Used with databases and include entity-relationship diagrams - data structure diagrams - data structure tables - flowcharts - IPO charts and layout diagrams.
Design tools
Macro
Layout diagram
Data structure diagram
29. Used as part of the bench test of a database solution.
Test plan
Manual validation
Relational database
Validation rule
30. The connection between data in a database.
Relationships
Sorting
Data types
Flowchart
31. Used to control how data is entered.
Input mask
Bench test
Macro
Data structure diagram
32. Used to direct the entry of data where there is a limited number of allowed values.
Manual validation
List tool
Flowchart
IPO chart
33. Used in databases to filter out only those records that meet the query criteria.
Data structure diagram
Field
Electronic validation
Query
34. Determines what formatting is used for a field based on its size and type. E.g. "Fixed decimal places" & "12 or 24-hour clock."
Electronic validation
Relationships
Bench test
Data formats
35. Used to identify inputs - outputs - and the processing steps required to transform the inputs into the outputs.
Layout diagram
IPO chart
Input mask
Design tools
36. Applied to fields in databases. Examples include: Text and Boolean.
Data formats
Data formats
Data types
Informal testing
37. Involves following a systematic set of rules to check for anomilies or deviations in data structure - which ensures fields are in the correct tables.
Data structure table
Query
Table normalisation
Data integrity
38. Allows data to be entered into a form or table only if it obeys the specified rule. If the data does not meet the criteria - a message box displays an error message with the data deleted.
Validation rule
Data structure table
Data types
Data formats
39. Used to identify inputs - outputs - and the processing steps required to transform the inputs into the outputs.
Manual validation
Data structure table
Flowchart
IPO chart
40. Shows the relationship between the table and fields in a relational database.
Table normalisation
Relational database
Data structure diagram
Input mask
41. The manual checking of data to ensure that it is correct and/or reasonable via means such as proofreading a document - checking for spelling - grammer and punctuation.
Macro
Manual validation
IPO chart
Formal testing
42. The connection between data in a database.
Relationships
Macro
Layout diagram
Layout diagram
43. Ensures that all data in a database is complete.
Flat file
Formal testing
Data structure table
Data integrity
44. Used to enter the name - size and data type of each field in a table.
Relational database
Layout diagram
Data structure table
Flowchart
45. Stores data tables that are arranged in rows and columns. Tables are linked by a common field.
Data integrity
Bench test
Entity-relationship diagram
Relational database
46. The use of software features such as spelling and grammar checking to verify accuracy - completeness and reasonableness.
RDBMS
Data structure diagram
Electronic validation
Entity-relationship diagram
47. Allows data to be entered into a form or table only if it obeys the specified rule. If the data does not meet the criteria - a message box displays an error message with the data deleted.
Data formats
Validation rule
Formal testing
Data structure diagram
48. Shows the relationship between the table and fields in a relational database.
Table normalisation
Design tools
Flowchart
Data structure diagram
49. Involves testing the overall solution after it has been completed.
Data types
Manual validation
Formal testing
Electronic validation
50. Used to determine how the solution - or a component of a solution - would behave with a range of test data.
Bench test
Primary key
Data structure diagram
Macro