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