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