← Back to exam page

1z0-882 – MySQL 5.6 Developer

Loading demo links...

Showing 7–9 of 10 questions

Question 7

A floating- point column defined as FLOAT(7,5)allows___________

Select an option, then click Submit answer.

  • ○

    7 digits to the left of the decimal point and 5 digits to the right
  • ○

    5 digits to the left of the decimal point and 7 digits to the right
  • ○

    7 digits in total, of which 5 are to the right of the decimal point
  • ○

    7 digits in total, of which 5 are to the left of the decimal point
Question 8

Which statement describes the process of normalizing databases?

Select an option, then click Submit answer.

  • ○

    All text is trimmed to fit into the appropriate fields. Capitalization and spelling errors are corrected.
  • ○

    Redundant tables are combined into one larger table to simplify the schema design.
  • ○

    Numeric values are checked against upper and lower accepted bounds. All text is purged of illegal characters.
  • ○

    Columns that contain repeating data values are split into separate tables to reduce item duplication.
  • ○

    Indexes are created to improve query performance. The data of types of columns are adjusted to use the smallest allocation.
Question 9

An application tracks usage of educational courses in a company. Many people can take one course. Each person can take multiple courses. The data has been stored in one table but it is growing too large. You decide to normalize the table.

What would a normalized data model contain?

Select an option, then click Submit answer.

  • ○

    Two tables: employee and course, with foreign keys on employee ID and course ID.
  • ○

    Three tables: employee, course, and a table cross-referencing employee IDs and course IDs
  • ○

    Two tables: an employee table with multiple course IDs , and a course table
  • ○

    Four tables: employee, course, courses by employee, and employees by course