OceanBase OBCA Question AnalysisQuestion 4 The following describes the use of middleware sharding in

Mondo Education Updated on 2024-02-01

Exam subject: Oceanbase OBCA

Exam question volume: 50 questions.

Pass Score: 60%.

What is the correct description of the traditional DB using middleware database sharding and table sharding?

a. Horizontal expansion can be achieved without any impact on the business

b. All database and table sharding products cannot support cross-database distributed transactions

c. The database core engine does not have distributed capabilities, and can only complete distributed processing through middleware, but it is difficult for middleware to achieve RPO=0, so it cannot guarantee 100% of the ACID capability of distributed transactions in the event of exceptions and failures

d. Be able to ensure global consistency

Cf. ***c

Resolution: Global consistency: It is difficult to ensure the global consistency of data version numbers among multiple databases due to inconsistent timestamps across multiple database servers.

Cross-database complex SQL operations: Complex SQL operations across databases (such as shard-related queries for multiple tables) can only be performed in middleware, which does not have distributed parallel computing capabilities, which ultimately restricts the use of SQL statements by applications and makes business invasive.

The Oceanbase OBCA exam is a theory exam, and you need to pass the theory exam to get the "Oceanbase Database Certified Specialist (OBCA) Certificate".

The following is the exam fee on the official website of Oceanbase, which can be 19941464235 + Yunbei Education Course Consultant, ** discount.

The Oceanbase OBCA certificate is as follows:(After the theory test, you can check the test results in your personal account on the same day, and you can collect the certificate in your personal account after 5 working days.) )

2024 Travel Guide

Related Pages