SUBJECTS
|
BROWSE
|
CAREER CENTER
|
POPULAR
|
JOIN
|
LOGIN
Business Skills
|
Soft Skills
|
Basic Literacy
|
Certifications
About
|
Help
|
Privacy
|
Terms
|
Email
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. Used to identify inputs - outputs - and the processing steps required to transform the inputs into the outputs.
Data types
Data structure diagram
Relationships
IPO chart
2. A relational database management system.
Data structure diagram
RDBMS
Macro
Input mask
3. Contains the same type of data for a series of records.
Data integrity
Manual validation
Field
Layout diagram
4. Used to enter the name - size and data type of each field in a table.
Data structure diagram
Data structure table
Query
Manual validation
5. Used to direct the entry of data where there is a limited number of allowed values.
Data integrity
Relational database
List tool
Flowchart
6. Stores data tables that are arranged in rows and columns. Tables are linked by a common field.
Validation rule
Entity-relationship diagram
Relational database
Sorting
7. The use of software features such as spelling and grammar checking to verify accuracy - completeness and reasonableness.
List tool
Data types
Manual validation
Electronic validation
8. Determines what formatting is used for a field based on its size and type. E.g. "Fixed decimal places" & "12 or 24-hour clock."
Data formats
Test plan
Flowchart
List tool
9. 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.
Layout diagram
IPO chart
Data types
Manual validation
10. A set of information about one entity. E.g. a person - event or object.
Test plan
Entity-relationship diagram
Record
IPO chart
11. Shows the interrelationships between different data elements.
Flowchart
Layout diagram
Flat file
Entity-relationship diagram
12. Used in databases to filter out only those records that meet the query criteria.
Validation rule
Input mask
Query
Entity-relationship diagram
13. Involves testing the overall solution after it has been completed.
Formal testing
Relationships
Input mask
Data types
14. A type of database that involves storing data in tables consisting of rows or columns.
Formal testing
Flat file
Manual validation
Flowchart
15. Used to enter the name - size and data type of each field in a table.
Manual validation
Data formats
Sorting
Data structure table
16. Used to control how data is entered.
Data structure diagram
Entity-relationship diagram
Data structure table
Input mask
17. Shows the relationship between the table and fields in a relational database.
Test plan
Informal testing
Data structure diagram
Validation rule
18. Used to identify inputs - outputs - and the processing steps required to transform the inputs into the outputs.
Manual validation
Formal testing
RDBMS
IPO chart
19. Shows the relationship between the table and fields in a relational database.
Data structure diagram
Flowchart
Flowchart
Electronic validation
20. Used as part of the bench test of a database solution.
Informal testing
Data structure table
RDBMS
Test plan
21. Used with databases and include entity-relationship diagrams - data structure diagrams - data structure tables - flowcharts - IPO charts and layout diagrams.
Design tools
Informal testing
Query
Macro
22. 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.
Relationships
Validation rule
Bench test
RDBMS
23. A set of commands that are run automatically.
Bench test
Macro
Query
Manual validation
24. Involves testing the overall solution after it has been completed.
Formal testing
IPO chart
Macro
Layout diagram
25. A hand-written sketch that shows the elements to be included on an input form or a report.
Sorting
Layout diagram
Flat file
Manual validation
26. Applied to fields in databases. Examples include: Text and Boolean.
Relational database
Formal testing
RDBMS
Data types
27. The connection between data in a database.
Input mask
Data types
Relationships
Flat file
28. Applied to fields in databases. Examples include: Text and Boolean.
Table normalisation
Data types
Relational database
List tool
29. Used to determine how the solution - or a component of a solution - would behave with a range of test data.
Bench test
Table normalisation
Relational database
Relationships
30. The use of software features such as spelling and grammar checking to verify accuracy - completeness and reasonableness.
Data structure table
Electronic validation
Data types
Relationships
31. Ensures that all data in a database is complete.
Data integrity
Manual validation
IPO chart
Data structure table
32. The connection between data in a database.
Sorting
Relationships
Design tools
Field
33. Shows the interrelationships between different data elements.
Data types
Entity-relationship diagram
Query
Relational database
34. 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.
Manual validation
Macro
Electronic validation
List tool
35. 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.
Informal testing
Primary key
List tool
Validation rule
36. Performed by the solution developer to ensure that the components and functions are operating correctly.
Sorting
Formal testing
Informal testing
IPO chart
37. A hand-written sketch that shows the elements to be included on an input form or a report.
Manual validation
Layout diagram
Relationships
Flowchart
38. Used with databases and include entity-relationship diagrams - data structure diagrams - data structure tables - flowcharts - IPO charts and layout diagrams.
Flowchart
Macro
Table normalisation
Design tools
39. Uniquely identifies each record in a database table.
Primary key
Table normalisation
Formal testing
Macro
40. A set of commands that are run automatically.
Macro
RDBMS
Relational database
Design tools
41. Involves following a systematic set of rules to check for anomilies or deviations in data structure - which ensures fields are in the correct tables.
Table normalisation
Primary key
IPO chart
Flowchart
42. Used in databases to filter out only those records that meet the query criteria.
Query
Test plan
Data formats
Flat file
43. Show the series of steps to follow in order to create a solution.
Data structure table
Flowchart
Manual validation
Table normalisation
44. Stores data tables that are arranged in rows and columns. Tables are linked by a common field.
List tool
Relational database
Macro
Query
45. Uniquely identifies each record in a database table.
Primary key
Bench test
Data formats
IPO chart
46. Determines what formatting is used for a field based on its size and type. E.g. "Fixed decimal places" & "12 or 24-hour clock."
Data formats
Flowchart
Design tools
Field
47. Involves following a systematic set of rules to check for anomilies or deviations in data structure - which ensures fields are in the correct tables.
Macro
Table normalisation
Bench test
Layout diagram
48. The display of results in an organised and usable manner.
RDBMS
Formal testing
Input mask
Sorting
49. Performed by the solution developer to ensure that the components and functions are operating correctly.
Informal testing
Flowchart
RDBMS
RDBMS
50. Used to determine how the solution - or a component of a solution - would behave with a range of test data.
Design tools
Bench test
Data formats
Primary key