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

Which of the following types of joins will include all rows from the left table, even if there is no match in the right table?

• A.CROSS JOIN
• B.FULL OUTER JOIN
• C.LEFT JOIN
• D.INNER JOIN

Which index type should be used for text searching in MySQL?

• A.HASH
• B.BTREE
• C.SPATIAL
• D.FULLTEXT

Which MySQL command is used to delete a table from a database?

• A.TRUNCATE TABLE
• B.REMOVE TABLE
• C.DROP TABLE
• D.DELETE TABLE

Which MySQL datatype would you use to store binary data such as images, videos, or files?

• A.TEXT
• B.BLOB
• C.CHAR
• D.VARCHAR

Which of the following is a characteristic of MySQL semi-synchronous replication?

• A.The primary server waits for at least one replica to apply the transaction before committing
• B.The primary server waits for at least one replica to acknowledge the receipt of the transaction before committing
• C.The replica server is always in sync with the primary
• D.All replicas must acknowledge the transaction before it is committed