What is the best way to store an individual’s name in a table?
(Points: 2)
As three separate fields for first name, last name, and middle initial
As two fields, one for the last name, and one for the first name and
middle initial
As a single field consisting of the first name, last name, and middle
initial, in that order
As a single field consisting of the last name, first name, and middle
initial, in that order
2. Which of the following should be defined as a text field? (Points:
2)
Telephone number
Zip code
Social Security number
All of these are correct
3. Which of the following field types can be used in calculations?
(Points: 2)
Number
Currency
Both Number and Currency
Neither Number nor Currency
4. If you wanted to store text data that may be very long, you would
put it into a ____________ field. (Points: 2)
memo
text
data
long
5. Which view can be used to enter or modify the data in the underlying
table? (Points: 2)
Form view
Table Design view
Form Design view
New Table view
6. Which of the following is true about forms? (Points: 2)
Forms consist of controls that accept and display data
A form has different views
A form provides an easy way to enter and display data.
All of these are correct
7. Which of the following decisions must be made when developing a
personal computer database? (Points: 2)
Buy or make
Database design
Who is responsible for data accuracy
All of the above.
8. Which of the following is NOT an advantage of database systems?
(Points: 2)
Redundant data
Program-data independence
Better data quality
Reduced program maintenance
9. Which of the following functions does a database application program
perform? (Points: 2)
Create data
Retrieve data
Delete data
All of the above.
10. A rule that can NOT be violated by database users is called a:
(Points: 2)
password.
constraint.
program.
view.
11. In a file processing environment, descriptions for data and the
logic for accessing the data is built into: (Points: 2)
application programs.
database descriptors.
fields.
records.
12. Older systems that often contain data of poor quality are called
_____ systems. (Points: 2)
controlled
legacy
database
mainframe
13. E. F. Codd developed the relational model in the: (Points: 2)
1960s.
1970s.
1980s.
1990s.
14. The most common source of database failures in organizations is:
(Points: 2)
lack of planning.
inadequate budget.
inadequate hardware.
failure to implement a strong database administration function.
15. A user view is: (Points: 2)
what a user sees when he or she looks out the window.
a table or set of tables.
a logical description of some portion of the database.
a procedure stored on the server.
16. The results of a query are displayed in a: (Points: 2)
Form
Design grid
Report
Datasheet View
17. Which of the following entries in a Design grid will return the
record Anderson? (Points: 2)
Ander?
Ander*
Both Ander? and Ander*
Neither Ander? nor Ander*
18. If you wanted to record a salary and use it in future calculations,
you would put it into a ____________ field. (Points: 2)
memo
numeric
text
object
19. In SQL, the ____________ keyword is used to indicate which fields
to include in the data to display. (Points: 2)
FROM
WHERE
SELECT
INCLUDE
20. If you want to access certain records that share some common
characteristics, you will need to ____________ the database. (Points: 2)
synchronize
constrain
index
query
21. Which of the following controls is used to enter or modify the data
in a table? (Points: 2)
Bound control
Unbound control
Calculated control
Expression control
22. The count function is a type of summary calculation. It calculates:
(Points: 2)
The total of all values in a specified field
The number of records with an entry in a specified field
The average of values in a field
The number of times the data in a field has been requested through a
query
23. If you had a form for your fantasy football team, what type of
control would you use to display a players’ yards per game average?
(Points: 2)
Calculated control
Bound control
Unbound control
Graph control
24. A relation that contains no multivalued attributes, and has nonkey
attributes solely dependent on the primary key, but contains transitive
dependencies is in which normal form? (Points: 2)
First
Second
Third
Fourth
25. When the value of every field in a table is dependent on the
primary key of that table and nothing else, that table is said to be in:
(Points: 2)
second normal form.
a one-to-many relationship.
third normal form.
good normal form.
Computer Science Homework Solutions
#68076
Multiple choice questions
Need answers to multiple choice practice test so that I can compare my answers. This is not a graded project.
---
1. What is the best way to store an individual's name in a table? (Points: 2)
As three separate fields for first name, last name, and middle initial
As two fields, one for the last name, and one for the first name and middle initial
As a single field consisting of the first name, last name, and middle initial, in that order
As a single field consisting of the last name, first name, and middle initial, in that order
2. Which of the following should be defined as a text field? (Points: 2)
Telephone number
Zip code
Social Security number
All of these are correct
3. Which of the following field types can be used in calculations? (Points: 2)
Number
Currency
Both Number and Currency
Neither Number nor Currency
4. If you wanted to store text data that may be very long, you would put it into a ____________ field. (Points: 2)
memo
text
data
long
5. Which view can be used to enter or modify the data in the underlying table? (Points: 2)
Form view
Table Design view
Form Design view
New Table view
6. Which of the following is true about forms? (Points: 2)
Forms consist of controls that accept and display data
A form has different views
A form provides an easy way to enter and display data.
All of these are correct
7. Which of the following decisions must be made when developing a personal computer database? (Points: 2)
Buy or make
Database design
Who is responsible for data accuracy
All of the above.
8. Which of the following is NOT an advantage of database systems? (Points: 2)
Redundant data
Program-data independence
Better data quality
Reduced program maintenance
9. Which of the following functions does a database application program perform? (Points: 2)
Create data
Retrieve data
Delete data
All of the above.
10. A rule that can NOT be violated by database users is called a: (Points: 2)
password.
constraint.
program.
view.
11. In a file processing environment, descriptions for data and the logic for accessing the data is built into: (Points: 2)
application programs.
database descriptors.
fields.
records.
12. Older systems that often contain data of poor quality are called _____ systems. (Points: 2)
controlled
legacy
database
mainframe
13. E. F. Codd developed the relational model in the: (Points: 2)
1960s.
1970s.
1980s.
1990s.
14. The most common source of database failures in organizations is: (Points: 2)
lack of planning.
inadequate budget.
inadequate hardware.
failure to implement a strong database administration function.
15. A user view is: (Points: 2)
what a user sees when he or she looks out the window.
a table or set of tables.
a logical description of some portion of the database.
a procedure stored on the server.
16. The results of a query are displayed in a: (Points: 2)
Form
Design grid
Report
Datasheet View
17. Which of the following entries in a Design grid will return the record Anderson? (Points: 2)
Ander?
Ander*
Both Ander? and Ander*
Neither Ander? nor Ander*
18. If you wanted to record a salary and use it in future calculations, you would put it into a ____________ field. (Points: 2)
memo
numeric
text
object
19. In SQL, the ____________ keyword is used to indicate which fields to include in the data to display. (Points: 2)
FROM
WHERE
SELECT
INCLUDE
20. If you want to access certain records that share some common characteristics, you will need to ____________ the database. (Points: 2)
synchronize
constrain
index
query
21. Which of the following controls is used to enter or modify the data in a table? (Points: 2)
Bound control
Unbound control
Calculated control
Expression control
22. The count function is a type of summary calculation. It calculates: (Points: 2)
The total of all values in a specified field
The number of records with an entry in a specified field
The average of values in a field
The number of times the data in a field has been requested through a query
23. If you had a form for your fantasy football team, what type of control would you use to display a players' yards per game average? (Points: 2)
Calculated control
Bound control
Unbound control
Graph control
24. A relation that contains no multivalued attributes, and has nonkey attributes solely dependent on the primary key, but contains transitive dependencies is in which normal form? (Points: 2)
First
Second
Third
Fourth
25. When the value of every field in a table is dependent on the primary key of that table and nothing else, that table is said to be in: (Points: 2)
second normal form.
a one-to-many relationship.
third normal form.
good normal form.
---
What is this?
By OTA - Overall OTA Rating
Rajender Kumar, MCom - 4.8/5
Purchase Cost Now
$2.19 CAD (was ~$59.85)
Included in Download
- Plain text response
- Attached file(s):
- MTDBMS solution.doc
Why you can trust BrainMass.com
- Your Information is Secure
- Best Online Academic Help Service
- Students find real academic Success
- Relational schema diagram (ID all dependencies to include transitive) - Using the STUDENT table structure attached, write the relational schema and draw its diagram. Identify all dependencies (including all transitive dependencies)
- Implement the spreadsheet in the MS access and list all assumptions and functional dependencies - (See attached file for full problem description) --- Implement the database in MS access with Relationships, tables, keys, indexes and a view(query) that duplicated the spreadsheet and list all fu ...
- Database Concept - Why is normalization important?
- Database Administration - Do all databases need to have an administration capability? Why or why not? If why, what type of activities should be included in database administration?
- The Relational Model and Data Normalization - 1. Define functional dependency and give an example. 2. What are insertion and deletions anomalies? 3. List and briefly describe first, second and third normal form. 4. Descri ...
