Explore BrainMass

Multiple choice questions

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

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)
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)

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)

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.

12. Older systems that often contain data of poor quality are called _____ systems. (Points: 2)

13. E. F. Codd developed the relational model in the: (Points: 2)

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)
Design grid
Datasheet View

17. Which of the following entries in a Design grid will return the record Anderson? (Points: 2)
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)

19. In SQL, the ____________ keyword is used to indicate which fields to include in the data to display. (Points: 2)

20. If you want to access certain records that share some common characteristics, you will need to ____________ the database. (Points: 2)

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)

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.

© BrainMass Inc. brainmass.com October 16, 2018, 5:55 pm ad1c9bdddf


Similar Posting

Amino acids multiple choice questions

Which statement is incorrect about the classification of amino acids?
a. Alanine and valine are neutral, nonpolar amino acids.
b. Lysine and arginine are basic amino acids.
c. Tryptophan and phenylalanine are aromatic amino acids.
d. Aspartic acid and aspargine are acidic amino acids.

Which of the following amino acids is the least water soluble at pH 7.0?
a. Tryptophan
b. Glutamic acid
c. Cysteine
d. Histidine

Which amino acid would migrate the furthest toward the anode (positive electrode) during paper electrophoresis at pH 7.0?
a. Aspartic acid
b. Alanine
c. Lysin
d. Glutamine

Which of the following functional groups, attached to an inert matrix, could function as a cation exchanger?
a. Diethylaminoethyl-
b. p-aminobenzyl-
c. Carboxymethyl-
d. Trimethylammonium-

Which of the following amino acids would make the best buffer at pH 4.5?
a. Histidine
b. Alanine
c. Glutamine
d. Aspartic acid

Which fact is incorrect about stereoisomers?
a. A diastereomer is a nonsuperimposable non-mirror image.
b. An enantiomer is a nonsuperimposible mirror image.
c. Diastereomers have different melting points.
d. Diastereomers rotate plane polarized light in equal but opposite direction.

Which statement is incorrect about L-isoleucine?
a. Its enantiomer is named O-isoleucine.
b. It contains a total of two asymmetric or chiral carbons.
c. It can also be named as (28, 38)-isoleucine using the (R,8) system.
d. Its diastereomer would be named O-alloisoleucine.

An isoelectric amino acid was dissolved in water and the resulting pH was approximately 7.6. What amino acid would possess this property?
a. Alanine
b. Glutamic acid
c. Histidine
d. Lysine

What volume of NaOH is required to adjust the solution of monosodium aspartate to pH 9.8?
a. 1 ml
b. 2 ml
c. 3 ml
d. 6 ml or more

What volume of 2 N Hel is required to completely titrate the 4 mmol of monosodium aspartate?
a. 2 ml
b. 3ml
c. Aml
d. 6 ml or more

Which statement is correct about the peptide ala-ser?
a. Alanine is at the N-terminal of the peptide.
b. There are a total six atoms that lie in the plane of the peptide bond linking alanine to serine.
c. The alpha-carbon of alanine is sp3 hybridized d All the above are correct statements.

What is the product formed from the acid hydrolysis of a simple amide?
a. Acid & base
b. Aldehyde & alcohol
c. Acid & amine
d. Ester & alcohol

The complete acid hydrolysis of the peptide ala-gln-trp-ser would yield:
a. Ala, gin, trp, ser
b. Ala, glu, ser
c. Ala, glu, trp, ser
d. Ala. ser

Fibrous proteins, such as collagen, have which of the following properties?
a. Highly soluble in water
b. Their hydrophilic residues are directed into the interior of the protein
c. Exhibit enzymatic activity
d. Serve structural roles in the cell

Quaternary structure is associated with:
a. The overall shape of a polypeptide chain
b. The sum of the secondary and tertiary interactions
c. Simple proteins with only one subunit
d. The relative orientation of one polypeptide to another polypeptide in a multi-subunit protein.

The information needed to define the structure of a protein is essentially contained in:
a. Amino acid composition
b. Amino acid sequence
c. Secondary structure
d. Tertiary structure.

Insulin is a polypeptide hormone that contains two short polypeptide chains linked by two interstrand disulfide bonds. The most logical order of events to perform in order to sequence this protein would be:
A: The peptides are reduced with mercaptoethanol.
B: The peptides are sequenced using Edman chemistry .
C: The peptides are separated by chromatography techniques. 0: The peptides are alkylated with iodoacetamide.
a. A, D,C, B b.C,A, 0, B
c. C, B, A, 0
d. A, B, C, 0

Which statement is incorrect about the peptide val-asp-trp-asn-ser?
a. This peptide would show a strong absorption band at 280 nm.
b. Reaction with chymotrypsin would yield two peptides.
c. To synthesize this peptide using the solid phase method of Merrifield, the amino acid directly attached to the resin would be serine.
d. After the second round of Edman chemistry using the reagent PITC, the PTH -amino acid residue released would be PTH-asn.

Which statement is incorrect about the reaction of the peptide ser-Iys-asp-trp-cys-metasn-phe-ala with the following reagents?
a. Reaction with cyanogens bromide would yield two peptides.
b. Reaction with trypsin would result in three peptides. The smallest of three peptides would have the highest pi of the three.
c. Reaciton with chymotrypsin would result in the peptides ser-Iys-asp & try-cys-met-Iysasn-phe-ala .
d. Reaction with chymotrypsin would yield a different set of peptides that overlap those obtained with tryspsin

Determine the amino acid sequence of the following oligopeptide from the experimental data below:
The amino acid composition is found the be ala, Iys, phe, met, cys plus some
decompsition products.
2. The peptide has a molecular weight around 700 Da and absorbs at 280 nm.
3. Treatment with carboxypeptidase results in tryptophan and a peptide.
4. CNBr treatment yields a tetrapeptide and a dipeptide.
5. Trypsine digestion produces an amino acid and a pentapeptide with met on the amino end.
6. Chymotrypsin digestion yields a dipeptide and a tetrapeptide.
a. trp-Iys-met-cys-met-ala
b. Iys-met-cys-phe-ala-trp
c. trp-ala-phe-cys-met-Iys
d. Iys-ala-cys-phe-met -trp

View Full Posting Details