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