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