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