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