PCSD Exam Preparation

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: PCSD备考

| username: zxgaa

Just finished the exam, it covered SEQUENCES, time zones, enum fields, transactions, prepared statements, sql_mode, TiKV pushdown, etc. Some parts were difficult and there were some contents not covered in the study videos.
Here are my study notes for your reference:
PCSD Study Notes.docx (14.5 MB)

| username: Hacker_8Yfzq2KF | Original post link

I also just finished the exam, and my score is lower than yours. When will the certificate be issued?

| username: TiDBer_NyrdmE3Q | Original post link

Tomorrow.

| username: ShawnYan | Original post link

Congratulations :tada::tada::tada:

| username: Kongdom | Original post link

Congratulations :tada: :tada: :tada:

| username: zxgaa | Original post link

Yesterday, the first question was “select now() where null=null,” which confused me. I feel like returning null or an empty result would both be acceptable.
For prepared statements, is it prepare or execute that generates the execution plan, and is it prepare or execute that caches the execution plan? I feel like it’s execute that generates it, but I still chose prepare when answering.

| username: Kongdom | Original post link

:yum: Always remember, null is not equal to any value, including null.

| username: zhanggame1 | Original post link

All nulls encountered return null, and comparisons are always false.

| username: 随缘天空 | Original post link

Is there any PCTP documentation?

| username: Kuber | Original post link

Which video series are you studying?

| username: zxgaa | Original post link

No, I am also preparing for the exam. I will share after finishing my notes.

| username: zxgaa | Original post link

The set from 201, if you have time, it’s best to also read the official documentation.

| username: TIDB-Learner | Original post link

Learn from everyone, I also want to try it next year in 2014.

| username: TIDB-Learner | Original post link

Are they all multiple-choice questions?

| username: ShawnYan | Original post link

Yes, there are no SQL programming questions.

| username: wangccsy | Original post link

Congratulations to the original poster.

| username: zhanggame1 | Original post link

As long as you pass, it’s fine. I missed passing by one point the first time.

| username: TIDB-Learner | Original post link

Is this answer empty?

| username: Kongdom | Original post link

That’s right.