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