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