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