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