← Back to exam page

1z0-882 – MySQL 5.6 Developer

Loading demo links...

Showing 1–3 of 10 questions

Question 2

Which two statements provide the definition for a view named view1 in the test database?

Select all that apply, then click Submit answer.

  • ○

    SHOW CREATE VIEW view1 FROM test
  • ○

    SHOW CREATE VIEW test-view1
  • ○

    SELECT VIEW_DEFINITION_SCHEMA.VIEWS
    FROM INFORMATION _SCHEMA.VIEWS
    WHERE TABLE_NAME=”view1”
    AND TABLE_SCHEMA = “test”
  • ○

    SELECT DEFINITION
    FROM INFORMATION_SCHEMA.VIEWS
    WHERE NAME = “test”
  • ○

    SHOW DEFINITION FOR test.view
Question 3

An application packs several fields of information into the details column of the table sensors. The first six characters of that data represent a location code.

Example: “ABCDEFOO –ooozzz comments will be here FIELDS----FIELD64”

Given the query pattern:

SELECT … FROM sensors WHERE details LIKE ‘ABCDEF%’

Which three ALTER TABLE commands enable the optimizer to user an index for this WHERE patterns?

Select all that apply, then click Submit answer.

  • ○

    ALTER TABLE sensors ADD KEY (details ) USING BTREE
  • ○

    ALTER TABLE sensors ADD KEY (details) USING HASH
  • ○

    ALTER TABLE sensors ADD KEY (details (8)) USING BTREE
  • ○

    ALTER TABLE sensors ADD KEY (details (8) ) USING HASH
  • ○

    ALTER TABLE sensors ADD FULLTEX (details)