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

Which two MySQL Server accounts are locked by default? (Choose two.)

• A.any internal system accounts
• B.any user created without a password
• C.any user created with a username, but missing the host name
• D.any user set as DEFINER for stored programs
• E.any new ROLE accounts

Examine this SQL statement:

Which set of privileges will allow Tom to execute this SQL statement?

• A.GRANT UPDATE ON 'world'.'city' TO 'tom'@'%'; GRANT SELECT ON 'world'.* TO 'tom'@'%';
• B.GRANT UPDATE ON 'world'.'city' TO 'tom'@'%'; GRANT SELECT ON 'world'.'country' TO
  'tom'@'%';
• C.GRANT ALL PRIVILEGES ON 'world'.'city' TO 'tom'@'%';
  GRANT SELECT ('code') ON 'world'.'country' TO 'tom'@'%';
• D.GRANT UPDATE ON 'world'.* TO 'tom'@'%';
  GRANT ALL PRIVILEGES ON 'world'.'country' TO 'tom'@'%';

You execute this command:
shell> mysqlpump --exclude-databases=% --users
Which statement is true?

• A.It returns an error because the mysqldump command should have been used.
• B.It creates a logical backup of all MySQL user accounts.
• C.It creates a logical backup of only the users database.
• D.It creates a logical backup of all metadata, but contains no table data.

Examine these commands and output:

Which connection ID is holding the metadata lock?

• A.22
• B.21
• C.24
• D.25
• E.20
• F.6

Which two queries are examples of successful SQL injection attacks? (Choose two.)

• A.SELECT email,passwd FROM members
  WHERE email = 'INSERT INTO members('email','passwd') VALUES ('[email protected]',
  'secret');--';
• B.SELECT id, name FROM user WHERE user.id=(SELECT members.id FROM members);
• C.SELECT user, phone FROM customers WHERE name = '\; DROP TABLE users; --';
• D.SELECT id, name FROM user WHERE id=23 OR id=32 OR 1=1;
• E.SELECT user,passwd FROM members
  WHERE user = '?';INSERT INTO members('user','passwd') VALUES
  ('[email protected]','secret');--';
• F.SELECT id, name FROM user WHERE id=23 OR id=32 AND 1=1;