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