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