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