1z1-883 試験問題を無料オンラインアクセス

When designing an InnoDB table, identify an advantage of using the BIT datatype Instead of one of the integer datatypes.

• A.BIT (8) takes less space than eight TINYINT fields.
• B.Multiple BIT columns pack tightly into a row, using less space.
• C.The BIT columns can be manipulated with the bitwise operators &, |, ~, ^, <<, and >>. The other integer types cannot.
• D.BIT columns are written by InnoDB at the head of the row, meaning they are always the first to be retrieved.

Consider the following statement on a RANGE partitioned table:
ALTER TABLE orders DROP PARTITION p1, p3;
What is the outcome of executing the above statement?

• A.Only the first partition (p1) will be dropped as only one can be dropped at any time.
• B.A syntax error will result as you cannot specify more than one partition in the same statement.
• C.All data in p1 and p3 partitions are removed, but the table definition remains unchanged.
• D.All data in pi and p3 partitions are removed and the table definition is changed.

User A issues the command:
LOCK TABLES pets READ;
Which command can User B execute against the pets table?

• A.ALTER TABLE pets...
• B.INSERT INTO pets...
• C.UPDATE pets...
• D.SELECT....FROM pets

You inherit a legacy database system when the previous DBA, Bob, leaves the company. You are notified that users are getting the following error:
mysql> CALL film_in_stock (40, 2, @count);
ERROR 1449 (HY000): The user specified as a definer ('bon'@'localhost') does not exist
How would you identify all stored procedures that pose the same problem?

• A.Execute SELECT * FROM INFORMATION_SCHEMA. PROCESSLIST WHERE USER='bob' and HOST=' localhost';.
• B.Execute SELECT * FROM INFORMATION_SCHEMA. ROUTINES WHERE DEFINER='bob@localhost';.
• C.Examine the Mysql error log for other ERROR 1449 messages.
• D.Execute SHOW ROUTINES WHERE DEFINER='bob@localhost'.
• E.Execute SELECT * FROM mysql.routines WHERE DEFINER='bob@localhost';.

You are attempting to secure a MySQL server by using SSL encryption.
On starting MySQL, you get this error:
130123 10:38:02 [ERROR] mysqld: unknown option '-ssl'
What is the cause of the error?

• A.The mysqld binary was not compiled with SSL support.
• B.The --- ssl level was not specified.
• C.The server's SSL certificate was invalid.
• D.The server was not started with the - enable--ssl-plugin option.
• E.-- ssl is not a valid server option.