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