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