1Z0-908 Exam Question 61

A clean shutdown was performed with innodb_fast_shutdown=0.
While you were manipulating files, all files were accidentally deleted from the top-level data directory.
Which two files must be restored from backup to allow the DB to restart cleanly? (Choose two.)
  • 1Z0-908 Exam Question 62

    You are upgrading a MySQL instance to the latest 8.0 version.
    Examine this output:

    You plan to add this parameter to the configuration: innodb_directories='/innodb_extras' Which statement is true?
  • 1Z0-908 Exam Question 63

    Which three are characteristics of a newly created role? (Choose three.)
  • 1Z0-908 Exam Question 64

    Examine this command and output:

    Which two statements are true? (Choose two.)
  • 1Z0-908 Exam Question 65

    Examine these statements, which execute successfully:
    TRUNCATE test; BEGIN;
    INSERT INTO test(id, name) VALUES(1, "Hello"); ROLLBACK;
    SELECT id FROM test;
    Which three storage engines would return a nonempty recordset for the test table when executing the statements? (Choose three.)