Online Access Free 1z1-882 Exam Questions

Which statement describes the process of normalizing databases?

• A.Indexes are created to improve query performance. The data of types of columns are adjusted to use the smallest
  allocation.
• B.Redundant tables are combined into one larger table to simplify the schema design.
• C.All text is trimmed to fit into the appropriate fields. Capitalization and spelling errors are corrected.
• D.Numeric values are checked against upper and lower accepted bounds. All text is purged of illegal characters.
• E.Columns that contain repeating data values are split into separate tables to reduce item duplication.

What are two ways in which normalizing your tables helps improve performance In MySQL?

• A.Separate tables allow indexing more columns.
• B.Smaller table sizes and row lengths improve sorting operations.
• C.Fewer nullable column improve index usage.
• D.Normalizing Improves the performance of innodb_file_per _table.

You have a database 'dev' that contains 15 tables, all of which use the CHARACTER SET 'utfs' and the COLLATION
'utfs_general_ci'.
You perform the command:
ALTER DATABASE 'dev' CHARACTER SET ='latin' COLLATION='latin1'_swedish_ci'
What is the result?

• A.The statement succeeds and new tables created in this database use the new settings as their default values.
• B.You get an error while trying to change from a more inclusive CHARACTER SET like 'utfs to a less' inclusive
  CHARACTER SET like 'latin'.
• C.The statement succeeds and all of the tables inside the database are converted to user the new settings.
• D.You get an error because changes to the CHARACTER SET or COLLATION attribute can happen only for empty
  databases.
• E.You get an error because database are not allowed to have CHARACTER SET or COLLATION attributes.
• F.You get an error because the settings for CHARACTER SET and COLLATION attributes do not match the settings for
  the tables inside the database.

You want to compare all columns of table A to columns with matching names in table B.
You want to select the rows where those have the same values on both tables.
Which query accomplishes this?

• A.SELECT * FROM tableA JOIN tableB
• B.SELECT * FROM table tableB
• C.SELECT * FROM tableA NATURAL JOIN tableB
• D.SELECT & FROM tableA STRAIGHT JOIN tableB
• E.SELECT * FROM table A INNER JOIN tableB

Examine the structure and content of the MemberLocation table:

You want to have the field location returned in all letters (example: BERLIN).
Which query would you use?

• A.SELECT UPPER (Location) as location FROM MemberLocation
• B.SELECT UPPER (location AS UPPER ) as location FROM Memberlocation
• C.SELECT CONVERT (Location AS UPPER ) as location FROM memberlocation
• D.SELECT UPPER (BINARY location) as location FROM MemberLocation