PracticeVideosBlogFlashcardsEspañol
All Practice Exams

Free Practice Questions for Computer Specialist in Spreadsheet & Database Level 1

Exam-style questions and explanations by OpenExamPrep.

✓ No registration✓ No credit card
100+ Questions
100% Free

Loading practice questions...

Same family resources

Explore More South Korea Computer Specialist in Spreadsheet & Database Examinations (컴퓨터활용능력 1급·2급 — KCCI)

Continue into nearby exams from the same family. Each card keeps practice questions, study guides, flashcards, videos, and articles in one place.

Computer Specialist in Spreadsheet Level 2 (컴퓨터활용능력 2급, South Korea)

Practice Questions
Exam Review

Key Facts: Computer Specialist in Spreadsheet & Database Level 1 Exam

60 items

Official written paper length (3 subjects × 20)

KCCI qualification portal (license.korcham.net)

60 minutes

Official written examination duration

KCCI qualification portal

40 / 60

Written passing threshold (40 floor / 60 avg)

KCCI examination regulations

70 / 70

Practical passing threshold (70+ in both Excel & Access)

KCCI examination regulations

KRW 20,500

Written exam registration fee (2026)

KCCI qualification portal (license.korcham.net)

KRW 25,000

Practical exam registration fee (2026)

KCCI qualification portal (license.korcham.net)

2 years

Written pass exemption period for practical exam

National Technical Qualifications Act Enforcement Decree

컴퓨터활용능력 1급 is KCCI's top-tier national technical qualification in data processing. The written paper features 60 four-option items in 3 subjects (Computer General, Spreadsheet General, Database General; 20 items each in 60 minutes), requiring at least 40 points per subject and a 60-point overall average. Passing yields a 2-year practical eligibility window for the 90-minute hands-on Excel and Access test (requiring 70+ in both). Official fees are KRW 20,500 written and KRW 25,000 practical. OpenExamPrep provides independent English study MCQs for written concepts, not an official translation or software simulation.

Sample Computer Specialist in Spreadsheet & Database Level 1 Practice Questions

Try these sample questions to review concepts for the Computer Specialist in Spreadsheet & Database Level 1 exam. Each question includes a detailed explanation. Start the interactive quiz above for the full 100+ question experience with AI tutoring.

1Which central processing unit (CPU) register holds the memory address of the next instruction waiting to be fetched and executed?
A.Accumulator (AC / 누산기)
B.Instruction Register (IR / 명령어 레지스터)
C.Memory Buffer Register (MBR / 메모리 버퍼 레지스터)
D.Program Counter (PC / 프로그램 카운터)
Explanation: The Program Counter (PC / 프로그램 카운터) is a dedicated CPU register that constantly tracks and stores the memory address of the next sequential instruction to be fetched from primary storage. Once the instruction at that address is retrieved into the Instruction Register, the PC is automatically incremented to point to the subsequent instruction.
2Which type of semiconductor random-access memory uses flip-flop circuits to store bit states, requires no periodic electrical refresh cycle, and is predominantly deployed as high-speed CPU cache memory?
A.Dynamic RAM (DRAM / 동적 램)
B.Static RAM (SRAM / 정적 램)
C.Flash EEPROM (플래시 메모리)
D.Mask ROM (마스크 롬)
Explanation: Static RAM (SRAM / 정적 램) stores each bit using bistable flip-flop circuitry composed of transistors. Because SRAM holds its data continuously as long as electric power is supplied without needing capacitive recharging cycles, it delivers very fast access times (sub-nanosecond) and is used for L1, L2, and L3 processor caches.
3In central processor architecture, which operational design philosophy fundamentally distinguishes a RISC (Reduced Instruction Set Computer) processor from a CISC (Complex Instruction Set Computer) processor?
A.Heavy reliance on microcoded control units with variable instruction formats and complex memory-to-memory addressing modes
B.Extensive instruction repertoires with multi-cycle hardware decoding to minimize compiler optimization complexity
C.Exclusively software-based emulation of floating-point arithmetic without hardware pipeline stages
D.Fixed instruction lengths, hardwired control logic, single-clock execution per instruction, and a load/store register architecture
Explanation: RISC (Reduced Instruction Set Computer) architectures employ uniform fixed-length instructions, hardwired control units rather than microcode, and strict load/store semantics where data processing operations occur strictly between general-purpose registers. This simplicity enables deep, efficient instruction pipelining and single-cycle execution rates.
4In an 8-bit binary computer arithmetic system using two's complement (2의 보수) representation for signed integers, what is the exact bit pattern for the decimal integer -43?
A.10101011
B.11010100
C.11010101
D.11101011
Explanation: To represent -43 in 8-bit two's complement, first find the binary representation of positive +43, which is 00101011. Next, compute the one's complement by inverting all bits, resulting in 11010100. Finally, add 1 to the least significant bit: 11010100 + 1 = 11010101.
5In a demand-paging virtual memory (가상기억장치) system, what term describes the destructive condition where the operating system spends virtually all its processing time servicing page faults and swapping pages between RAM and disk rather than executing user processes?
A.Locality of Reference (구역성 / 국부성)
B.Working Set Expansion (워킹셋 확장)
C.Thrashing (스레싱)
D.Belady's Anomaly (벨레이디의 모순)
Explanation: Thrashing (스레싱) occurs when the total memory requirements of active processes exceed available physical RAM (i.e., the sum of working sets is larger than physical memory). As a result, pages are continually evicted and immediately needed again, causing the paging disk queue to saturate while CPU utilization plunges toward zero.
6Which input/output data transfer technique grants peripheral interface controllers direct access to system main memory across the bus, bypassing CPU registers during high-volume bulk transfers?
A.Direct Memory Access (DMA / 직접 메모리 접근)
B.Programmed I/O (프로그램된 입출력)
C.Interrupt-Driven Polling (폴링 기반 인터럽트)
D.Channel Control Emulation (채널 제어 에뮬레이션)
Explanation: Direct Memory Access (DMA / 직접 메모리 접근) allows hardware subsystems such as storage controllers, network cards, and GPUs to read and write blocks of data directly to and from system RAM without routing each word through the CPU's internal registers. The CPU merely initiates the DMA controller with transfer parameters and receives an interrupt when the block transfer finishes.
7When multiple concurrent hardware interrupt signals are received by the interrupt controller, which interrupt event is assigned the highest servicing priority?
A.Power failure interrupt (정전 인터럽트)
B.I/O device completion interrupt (입출력 완료 인터럽트)
C.Hardware timer clock interrupt (타이머 인터럽트)
D.Keyboard input signal interrupt (키보드 인터럽트)
Explanation: Power failure interrupts (정전 인터럽트) and catastrophic machine check hardware failures hold the absolute highest priority among all interrupt sources. Because power loss threatens immediate hardware shutdown and volatile memory erasure, the system must immediately invoke an emergency routine to flush volatile CPU registers and cache contents into non-volatile storage.
8What is the primary operational purpose of the Print Spooler (스풀러) service in the Microsoft Windows operating system?
A.To automatically verify printer driver cryptographic signatures and block network-shared print queues
B.To render vector TrueType fonts directly into physical toner micro-droplets without intermediate rasterization
C.To inspect incoming print payloads for malicious macros and convert them into encrypted PDF archives
D.To buffer print jobs on disk or in memory so that client applications can immediately resume work while printing proceeds in the background
Explanation: Print spooling (스풀 / Simultaneous Peripheral Operations On-Line) intercepts print output generated by an application and writes it as an intermediate spool file (EMF or RAW) onto disk or memory. This decouples the fast CPU execution from the slow mechanical printing device, allowing the application program to regain user control immediately.
9Which file system used by Microsoft Windows supports file-level encryption (EFS), granular discretionary access control permissions (ACLs), volume sizes exceeding 2 TB, and transaction journaling for metadata recovery?
A.FAT16
B.FAT32
C.NTFS
D.exFAT
Explanation: NTFS (New Technology File System) is the default file system for modern Windows installations. It provides enterprise-grade capabilities including Encrypting File System (EFS), granular Access Control Lists (ACL) for user and group security permissions, file compression, disk quotas, and a USN journal to guarantee metadata integrity after unexpected crashes.
10In the Microsoft Windows operating system, which administrative configuration tool is launched by entering the command `regedit` in the Run (실행) dialog?
A.Local Group Policy Editor (로컬 그룹 정책 편집기)
B.Registry Editor (레지스트리 편집기)
C.Disk Management Console (디스크 관리)
D.System Configuration Utility (시스템 구성 / msconfig)
Explanation: Entering `regedit` (or `regedt32`) opens the Windows Registry Editor (레지스트리 편집기). The registry is a hierarchical database that stores low-level configuration settings, hardware driver preferences, operating system parameters, and installed software keys divided across root hives such as HKEY_LOCAL_MACHINE and HKEY_CURRENT_USER.

About the Computer Specialist in Spreadsheet & Database Level 1 Exam

Computer Specialist in Spreadsheet & Database Level 1 (컴퓨터활용능력 1급) is South Korea's premier national technical qualification for office automation, administered by the Korea Chamber of Commerce and Industry (KCCI / 대한상공회의소). Widely sought after for public service recruitment extra points and private sector corporate hiring, Level 1 evaluates mastery across computer architecture, Windows OS, networking, security, advanced spreadsheet analysis (formulas, pivot tables, array formulas, VBA), and relational databases (table schema design, relational integrity, SQL queries, forms, reports). The official written test consists of 60 four-option multiple-choice items over 60 minutes. Following a written pass, candidates undertake a demanding 90-minute practical hands-on test in Microsoft Excel and Access. This page provides independent English-language MCQ practice for the written syllabus; it is not an official translation, CBT test engine, or practical software simulation.

Exam sponsor: Korea Chamber of Commerce and Industry (KCCI / 대한상공회의소). The requirements and fees below concern the certification or admission exam, separate from our free practice resources.

Assessment

The written test comprises Computer General (20 items), Spreadsheet General (20 items), and Database General (20 items), completed in 60 minutes. The practical test consists of two 45-minute computer operations (Spreadsheet 100 pts, Database 100 pts). OpenExamPrep study weights cover all three written subjects proportionally.

Time Limit

60 minutes written; 90 minutes practical

Passing Score

Written: 40+ per subject floor and 60 average; practical: 70/100 in both subjects

Exam / Certification Fees

KRW 20,500 written / KRW 25,000 practical (KCCI, 2026)

Exam sponsor website

Fees, eligibility, and exam policies can change. Confirm them with the exam sponsor before applying or paying.

Official sources

Our practice resources: topics covered

We aim to reflect publicly available exam outlines and topic information in our study resources. Coverage, format, and difficulty may differ from the actual exam, and we cannot guarantee that every detail is accurate or current. Confirm exam requirements, fees, and policies with the official exam sponsor.

33%

Computer General (컴퓨터 일반)

Computer architecture, data representation, operating system features, network topologies and protocols, multimedia standards, cybersecurity, and ethics.

34%

Spreadsheet General (스프레드시트 일반)

Worksheet formatting, standard and array formulas, lookup and reference functions, pivot tables and goal seek, charting, and Excel VBA programming.

33%

Database General (데이터베이스 일반)

Relational data modeling, table structures and data types, referential integrity, SQL queries (SELECT, UPDATE, INSERT, DELETE), form controls, and reporting.

Preparing for the Computer Specialist in Spreadsheet & Database Level 1 Exam

What You Need to Know

  • Passing score: Written: 40+ per subject floor and 60 average; practical: 70/100 in both subjects
  • Assessment: The written test comprises Computer General (20 items), Spreadsheet General (20 items), and Database General (20 items), completed in 60 minutes. The practical test consists of two 45-minute computer operations (Spreadsheet 100 pts, Database 100 pts). OpenExamPrep study weights cover all three written subjects proportionally.
  • Time limit: 60 minutes written; 90 minutes practical
  • Exam / certification fees: KRW 20,500 written / KRW 25,000 practical (KCCI, 2026) Official sources

Using Our Practice Resources

  • Work through all 100 available questions
  • Review every answer and explanation
  • Track weak areas and revisit them
  • Use our AI tutor for tough concepts

Computer Specialist in Spreadsheet & Database Level 1: Suggested Study Strategy

1Master the 40-point per-subject floor (과락) rule: scoring below 40 points in any single subject results in an automatic failure regardless of how high your total average is.
2In Spreadsheet General, focus intensely on array formulas, nested lookup functions (INDEX, MATCH, VLOOKUP), and VBA event procedures, which frequently appear in both written and practical tests.
3In Database General, memorize standard SQL clauses (SELECT, WHERE, GROUP BY, HAVING, ORDER BY) and relational integrity principles, including cascade update and cascade delete rules.
4Treat this English question bank as conceptual drill for the written exam, while reserving substantial time for hands-on practical practice in Korean-interface Microsoft Excel and Access.

Frequently Asked Questions

What is Computer Specialist in Spreadsheet & Database Level 1 (컴퓨터활용능력 1급)?

It is South Korea's highest-tier national technical qualification in office data processing and information literacy, administered by the Korea Chamber of Commerce and Industry (KCCI). It assesses advanced competence in computer hardware/software/networking concepts, spreadsheet automation (Excel), and relational database management (Access).

How is the official examination structured in 2026?

The examination consists of two stages: a 60-minute written CBT examination consisting of 60 four-option multiple-choice questions across three subjects (Computer General, Spreadsheet General, and Database General; 20 questions each), followed by a 90-minute computer-based practical examination consisting of 45 minutes of Microsoft Excel and 45 minutes of Microsoft Access.

What are the passing thresholds for written and practical examinations?

For the written examination, candidates must achieve at least 40 points in each subject (the 과락 floor rule) and attain an overall average of at least 60 points out of 100. For the practical examination, candidates must score at least 70 points out of 100 in BOTH spreadsheet and database subjects to pass.

What language is used in the official exam, and how should I use this study bank?

The official KCCI examinations are conducted exclusively in Korean using Korean versions of Windows and Microsoft Office (Excel and Access). This study bank offers independent English-language multiple-choice questions adapted to drill and reinforce the conceptual syllabus tested on the written examination. It is not an official translation and does not replace hands-on software practice for the practical stage.

How long is the written exam pass valid, and what are the 2026 registration fees?

Under Article 21 of the National Technical Qualifications Act Enforcement Decree, passing the written examination grants an exemption from the written test for two full years from the announcement date. As of 2026, registration fees published by KCCI are KRW 20,500 for the written CBT exam and KRW 25,000 for the hands-on practical exam.