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