Principles Of Computer Programming NCV Level 3 — Exam Paper P1
November 2020 — NCV Level 3 — Principles Of Computer Programming
NCV Level 3
2020
NCV IT
Preparing document
📋 Document Analysis
See full analysis
Questions — A Preview of What to Expect in the Document
75
This section provides a quick preview of questions from the document. It may not display every question or the complete wording of each one. For the full content, including diagrams, tables and other information, view the original PDF above.
Q1— Section header —
1.10\in the ANSWER BOOK.
1.1Which of the f ollowing examples is a declaration of an abstract data typ e (ADT\ in Visual Basic.Net?
1.2Which of the following can be used to limit input errors? creen debugger
1.3The Binary Search abstract data type trace table
1.4Which combinations of the following statements (i iv \about the Visual Basic statement Dim strArrCars(99 are correct?
1.5Which combination of the following options are examples of event ha ndlers ii iii iv
1.6A ... nu mber can have either a positive value or negative value. igned string
1.7When passing multiple parameters to a function, each parameter must be separated by a ... omma
1.8ssignment addition assignment not is equal equals to more
1.9abstract datatypes fixed datatype
1.10Which ONE of the following is considered as a bad choice in an entity relationship in a database? 1 : 1 1 : M M : 1
Q2— Section header —
2.10\n the ANSWER BOOK.
2.1for statement must always be followed by a Next statement.
2.2The Visual Basic property ow(\ re turns a date value containing the current date and time according to your system.
2.3A database table can have TWO primary keys.
2.4The StreamWriter class is used to read data from a text file.
2.5An infinite loop is a loop that repea ts itself a million times.
2.6While loop is an example of an iteration structure.
2.7A database represents a highly organised collection of information.
2.8The ReDim statement can be used to change the dimension of a fixed array.
2.9Math.Ceiling( 1043.75133\ will produce an answer of 1043.
2.10constant is a named variable that keeps changing its value during program execution. (10 1\ [10]10
Q3— Section header —
3.5\n the ANSWER BOOK.
3.1very large integer number.
3.2more records from a table.
3.3and swaps them if they are in the wrong order.
3.4A single row of a table, which contains a single record for that relation is called
3.55
Q4— Section header —
4.1Translate the following truth table into a Boolean expression: Q (Output\
4.2Draw the truth table for the Boolean expression: A AND ( NOT B\ AND C (4\
4.3Explain the difference between static RAM and dynamic RAM. (2 1\ (2\
4.4Name TWO ad vantages of using a complex instruction set co mputer (CISC\. (2\ [10]10
Q5— Section header —
5.1Study the following VB.Net code snippet and answer the questions.
5.1.1Identify the type of VB.Net control structure that is being us ed in the code above. (2\
Q5— Section header —
5.1.3Identify FOUR other types of control structures that can be used in VB.Net. (4\
5.1.4
5.2.1Identify the value of the nteger variable intResult in line 9. (2\
5.2.2Identify the val ue of the nteger variable intResult in line 11. (2\
5.2.3Briefly explain the purpose of the function name Sqrt(\ (2 1\ (2\
5.2.4Identify the value of the tring variable strProgramme in line 15. (2\
5.3Explain the purpose of each o f the following VB.Net exception statements.
5.3.1Try
5.3.2Catch
5.3.3Throw (3 1\ (3\ [23] (10041023\23
Q6— Section header —
6.1Define the following terms with regards to file handling:
6.1.1Stream Reader
6.1.2Stream Writer
6.1.3Writeline
6.1.4Readline
6.1.5Concatenation (5 2\ (10\
6.2The following snippet of incomplete code relates to a commonly used sorting technique. The following sorting technique sorts SIX numbers in ascending order.
6.2.1Identify the sorting method used above. (1\
6.2.2Briefly explain TWO advantages of the sorting technique identified
Q6— Section header —
6.2.3Identify ONE other sorting method. (1\
6.2.4Complete the code above by providing a nswers for QUESTIONS 6.2.4 (a f\ (6\
6.2.522
Q7— Section header —
7.1Study the following diagram, FIGURE 1 and answer the questions STU_ID Text Students SA ID Number STU_FNAME Text
7.1.1Identify the structure represented by FIGURE 1. (1\
7.1.2Define the following terms: (a\ Primary Key (b\ Foreign Key (c\ Data type (d\
7.1.3Identify the field name of the primary key (1\
7.1.4Identify the name of the data entity in the example above. (1\
7.1.5From the example above list the names of ANY TWO data attributes. (2\
7.1.6What maximum limit could a programmer set for the size of the field name STU_ID (1\
Q7— Section header —
7.2Explain TWO re asons why a database is a more efficient structure than a text file or any other data structure. (2 2\ (4\
7.3Briefly explain what is meant by a one to many relationship. (1\ [20]20
Multiple Choice Options
1A).. nu
Mark Allocation
Total100 marks
Sections10 + 10 + 5 + 10 + 23 + 22 + 20 = 100 marks
Paper information
TitleExam Paper
SubjectPrinciples Of Computer Programming
LevelNCV Level 3
Document typeQuestion paper
Year2020
MonthNovember
Pages9
Downloads4
Examination context
Decade2020s
Years ago6y
SeasonSpring (SH)
Start daySunday
Exam periodNovember 2020
Days since exam2,168
About Principles Of Computer Programming examination preparation
This TVET examination resource can be used as part of a structured revision programme. Past papers are most useful when learners attempt questions independently, work within a realistic time limit, and review their answers afterwards.
How to use this resource for revision
A TVET past examination paper is most useful when it is treated as an active revision exercise. Try the questions yourself before checking the corresponding memorandum. Where you make an error, identify the reason — was it a knowledge gap, a calculation mistake, an interpretation issue, or an examination technique problem?
For stronger examination practice, complete the paper without unnecessary interruptions and keep track of the questions that take the most time. Afterwards, review the memorandum and separate knowledge gaps from mistakes caused by interpretation, calculation, structure, or examination technique.
understanding question requirements
applying subject knowledge
working under time constraints
checking answers
identifying revision priorities
A practical revision approach
Start by completing the resource without looking at the memorandum. Review incorrect and incomplete answers afterwards and make a short revision list based on the areas that caused difficulty.
File details
File size462.1 KB
Pages9
Archived on8 September 2026
File age45d
ContributorFreeMode
Fingerprint23295466EF81
Questions and learner discussion
Log in to ask a question or leave a review.
No questions or discussions have been posted yet.