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