1Z0-922 무료 덤프문제 온라인 액세스

How would you ensure that a column cannot contain NULL values in a MySQL table?

• A.Use the INDEX constraint on the column
• B.Use the UNIQUE constraint on the column
• C.Add the NULL constraint to the column definition
• D.Add the NOT NULL constraint to the column definition

Which of the following best describes synchronous replication in MySQL?

• A.The primary server waits for all replicas to confirm that changes are applied
• B.The replica updates once every hour
• C.The replica applies changes in batches
• D.The primary server commits changes without waiting for replicas

What does the InnoDB redo log store in MySQL?

• A.Completed transaction history All
• B.executed SELECT statements
• C.Uncommitted transaction data
• D.Binary logs for replication

What does the log-bin setting enable in MySQL?

• A.Storing binary data in tables
• B.Enabling transaction logs
• C.Writing binary logs for replication
• D.Caching of SELECT queries

In MySQL, what is the Information Schema used for?

• A.To back up MySQL databases
• B.To store user data
• C.To provide metadata about the database structure
• D.To manage replication