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