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