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