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