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