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