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