Online Access Free 1Z1-922 Exam Questions

How does MySQL Enterprise Authentication enhance database security?

• A.By integrating with external systems like LDAP and Active Directory for centralized authentication
• B.By encrypting data in real time
• C.By enabling automatic backups of database tables
• D.By optimizing database query performance

Which of the following configurations does MySQL Enterprise Authentication provide for password security?

• A.Allowing plain-text password storage
• B.Enforcing password expiration
• C.Disabling password history
• D.Disabling password complexity

What does the FOREIGN KEY constraint do in MySQL?

• A.Creates an index for a column
• B.Prevents NULL values in a column
• C.Ensures that all values in a column are unique
• D.Enforces a relationship between two tables

Which two statements are used to grant privileges to MySQL users?

• A.REVOKE
• B.ALTER USER
• C.CREATE USER
• D.GRANT

Which component of MySQL is responsible for executing SQL statements?

• A.Storage Engine
• B.MySQL Server
• C.Query Optimizer
• D.Information Schema