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