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