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