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