A new subject of the National Computer Rank Level 2 Examination—openGauss database programming
Published: 2023-02-27 02:31:48

National Computer Rank Examination


The National Computer Rank Examination (NCRE for short), approved by the Ministry of Education and sponsored by the Educational Examination Institute of the Ministry of Education, is a national computer proficiency assessment system for the society to test the computer application knowledge and skills of test takers.

In September 2022, the Educational Examination Institute will adjust the subjects of the NCRE examination, among which openGauss database programming (subject code 68) will be added in the second level . Candidates are welcome to study and apply for the examination.

openGauss database


openGauss is a world-leading enterprise-level open-source relational database built with partners, providing ultimate multi-core performance, full-link business and data security, AI-based tuning, and efficient O&M capabilities. openGauss is fully friendly and open. It is released under the Mulan loose license v2. It deeply integrates Huawei's years of research and development experience in the database field, and combines enterprise-level scenario requirements to continuously build competitive features.

Key features of openGauss database


1. High performance
① Two-way Kunpeng performance of 1.5 million tpmC:

Concurrency control technology for multi-core architecture;

NUMA-aware data structures;

SQL-Bypass intelligent routing execution technology;
② Memory engine for real-time high-performance scenarios.

2. High availability & high security
③ Business is worry-free, failover time RTO<10s:

Fine-grained security management: fine-grained access control, multi-dimensional audit.
④ All-round data protection: storage & transmission & export encryption, dynamic desensitization, fully encrypted computing.
3. Easy operation and maintenance
⑤ AI-based intelligent parameter tuning, providing automatic recommendation of AI parameters:

Slow SQL diagnosis, multi-dimensional performance self-monitoring view, real-time control of system performance;

Provide online self-learning SQL time prediction, fast positioning, and rapid tuning.
4. Fully open

Adopt the Mulan loose license agreement, allowing free modification, use and reference of the code;

The core capabilities of the database are fully open;

Open operation and maintenance monitoring, opening and migration tools;

Open partner certification, training system and college courses.

Introduction to Exam Subjects—openGauss Database Programming


Level 2: programming/office software advanced application level. The assessment content includes computer language and basic programming ability. Participants are required to master a computer language. Optional categories include advanced language programming, database programming, etc. The second-level certificate indicates that the holder has basic computer knowledge and basic application ability, can write programs in high-level computer languages, and can engage in computer program compilation, elementary computer teaching and training, and business and marketing services related to informatization in enterprises.

1. 201 Course Information: 201-Level 2 Public Basic Knowledge
2. Examination form: unified proposition, unified examination, computer-based examination
3. Question type and score value: 40 points for multiple choice questions (including 10 points for common basic knowledge), 60 points for operation questions (including 25 points for basic operation questions, 20 points for simple application questions and 15 points for comprehensive application questions)
4. Examination environment

Database management system: openGauss1.0.1

Examination and learning environment: You can download the VirtualBox installation package to install the virtual machine software (version 6.1.16) on a 64-bit Win7/Win10 personal notebook/desktop by visiting the China Education Examination Network, and load the official virtual machine image file. Complete environment deployment
5. Grades and certificates: NCRE exams are scored using a percentage system, but in the form of grades (divided into "excellent" (100-90), "good" (89-80), "pass" (79-60), "failure" Pass" (59-0)) notifies candidates of the grade and is noted on the certificate.

Learning Resources


1. Exam syllabus: National Computer Rank Examination Level 2 OpenGauss Database Programming Exam Outline (2022 Edition), which can be queried through the China Education Examination Network (https://www.neea.edu.cn/).
2. Study materials: "National Computer Rank Examination Level 2 Course - Public Basic Knowledge", "National Computer Level Examination Level 2 Course - OpenGauss Database Programming", the textbooks are exclusively published by Higher Education Press.


![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/b2lrozn376b02ukt68io.png)

exam registration


1. The NCRE exams are held in March, May, September, and December each year, of which all subjects at all levels are tested from March to September, and all subjects at the first and second levels are held in May and December. The organization decides whether to start the exam in May and December according to the situation; the specific registration time for each exam is stipulated by each provincial organizer, and can be found on the website of each provincial organizer (https://ncre-bm.neea.cn/ ).
2. Applicants are not restricted by age, occupation, education, etc., and can choose corresponding levels and subjects according to their own learning situation and actual ability. Candidates can register online in accordance with the procedures announced by the provincial organizers.
3. Candidates do not need to participate in the pre-examination training, but directly register for the examination.