Practice questions

Let’s try to practice the material in this chapter with a few example questions.

Questions

1. In regard to the following table, you can state:

   ID	Sex	Male	Female
   84927	M	TRUE	FALSE
   69427	M	TRUE	FALSE
   69427	M	TRUE	FALSE
   10374	F	FALSE	TRUE
   58264	M	TRUE	FALSE
   90162	F	FALSE	TRUE

1. This table has redundant data
2. This table has duplicate data
3. This table has redundant data and duplicate data
4. This table has neither redundant data nor duplicate data

2. When dealing with missing data, which of the following is not a type of deletion?
   1. Listwise
   2. Singlewise
   3. Pairwise
   4. Variable
3. Which types of errors can be found in the following table?

Employee ID	LastName	FirstName	Department	Years With Company
83784	Benhill	Floyd ...