Principles Of Computer Programming NCV Level 3 — Exam Paper
November 2023 — NCV Level 3 — Principles Of Computer Programming
NCV Level 3
2023
NCV IT
Preparing document
📋 Document Analysis
See full analysis
Questions — A Preview of What to Expect in the Document
82
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 following VB.NET statements will correctly resize an array called intArr Results to an upper bound of
1.2Option Strict switch is set to Off
1.3search is a searching algorithm used in a sorted array for finding an repeatedly dividing the search interval in half.
1.4Which combinations o f the following statements (i iv\about the Visual Basic statement Dim strArrBuildings(10, 20\ As String
1.5Which combination of the following options is examples of event procedures of VB.NET ombo ox
1.6Which ONE of the following VB.Net datatypes uses 16 bytes of memory?
1.7Math.Ceiling(24. will produce an answer of
24.524 .3
1.8In SQL, the GROUP BY statement to arrange identical data into groups
1.9Buffered Stream File Stream Binary
1.10/an key in the context of relational databases, is a column or group of columns in a table that links to a column or group of columns in another table.
Q2— Section header —
2.10\in the ANSWER BOOK.
2.1The default access modifier for a Sub procedure is Public
2.2The VB.Net String function Substring(\ returns a new string in which all occurrences of a specified character or string in the current string are replaced with another specified character or string.
2.3The SQL COUNT(\ function returns the number of rows that matches a specified criterion.
2.4In VB.NET the FileMode.Append enumerator opens an existing file and puts the cursor at the end of the file, or creates the file, if the file does not exist.
2.5An endless loop is also referred to as an infinite loop.
2.6nested loop is where one loop is put inside another loop.
2.8The VB.NET statement Delete will delete an array.
2.9The Integer.TryParse( function returns an integer value.
2.10The VB.NET MOD operator returns the remainder when one number is divided by another. (10 1\ [10] (10041023\10
Q3— Section header —
3.1of program execution.
3.2A language that has been developed specifically for querying and manipulating data in database systems is known
3.3programming is an approach in which code is written to respond to events.
3.4control is a graphical control element used to visuali e the progression of an extended computer operation, such as a download, file transfer, or installation.
3.55
Q4— Section header —
4.5\n the ANSWER BOOK. COLUMN A COLUMN B
4.5A VB.NET program will not compile if this type of error is detected The method of managing simultaneous operations on a database An examp le of a cryptographic algorithm Can be used to
Q5— Section header —
5.1Study the diagram labelled as FIGURE 1 below and answer the questions FIGURE 1 INTEGRATED CIRCUIT SYMBOL
5.1.1Identify the TWO names given to the integrated circuit depicted in FIGURE 1. (2\
5.1.2List TWO purposes of the circuit depicted in FIGURE 1. (2 2\ (4\
5.2Study the diagram labelled as FIGURE 2 below and answer the questions FIGURE 2 LOGIC DIAGRAM SYMBOL (10041023\ Copyright reserved
5.2.1Identify the number of inputs in the logic gate, depicted in FIGURE 2. (1\
5.2.2Translate the logic diagram shown in FIGURE 2 to a Boolean expression. (3\ [10]10
Q6— Section header —
6.1Read the following sentence and answer the questions below. A variable is a value that can change, depending on conditions or information passed to a program.
6.1.1Explain the term constant (2\
6.1.2The table below lists the data type name, variable prefix and an example of the data that can be stored with various data types in VB.Net. Complete the following table in your ANSWER BOOK by writing only
6.1.2c\in the ANSWER BOOK. Data type Prefix Example of Data String
6.1.2(a\
6.1.2(b\ Chr Boolean Bln
6.1.2(c\ TABLE 1 VB.NET DATA TYPES (3\
6.1.3List FOUR different numeric data types used in VB.Net (4\
6.2Study the diagrams labelled as FIGURE 3, FIGURE 4 and FIGURE 5 below and answer the questions. FIGURE 3 LOOP FLOWCHART 1 FIGURE 4 LOOP FLOWCHART 2 (10041023\
6.2.1Define the term loop (2\
6.2.2Identify EACH type of loop that is represented by FIGURES 3, 4 and 5 respectively. (3\
6.2.3Identify ONE other type of loop that is not represented in the diagrams above. (1\
6.2.4Differentiate between the loop represented by FIGURE 4 and FIGURE 5 respectively. (2 2\ (4\ (10041023\
6.3Study the diagram labelled as FIGURE 6 and answer the questions. FIGURE 6 LISTBOX CONTROL NOTE: Assume the name of the list box control is MyListBox
6.3.1State the prefix that will be used when naming a List ox control. (1\
6.3.2Provide the VB.N ET code that will INSERT the text indicated by label (2\
6.3.3Provide the VB.N ET code that will REMOVE the text indicated by label (2\
6.3.4List TWO differences between a ombo ox control and a ListBox
6.3.5Identify an event procedure in VB.N ET that can be used to determine wh n the selected
Q7— Section header —
7.1Study the following scenario and answer the questions. The Principles of Computer Programming at Mzansi TVET College developed the following VB.Net program. The user interface (UI\of the program is shown
7.1.1The user interface (FIGURE 9\provides a sorting functionality for the data indicated by label Identify any TWO different sorting algorithms. (2\
7.1.2What is a CSV file? (2\
7.1.3The lecturer has told you that for the above program to work there has to be a reference to a VB.N ET amespace.
7.2Study the following snippet of code and answer the questions.
7.2.1Identify the TYPE of single dimensional array declared at line 13. (1\
7.2.2Explain the purpose of the StreamReader keyword in line 3. (2\
7.2.3Give the purpose of the VB.N ET keyword in line 7. (1\ [10]10
Q8— Section header —
8.1Study the diagram labelled as FIGURE 10 and answer the questions. FIGURE 10 DATABASE TABLE (10041023\ 15 Copyright reserved
8.1.1Explain the purpose of a database table. (2\
8.1.2Give TWO reasons why a database is a far better storage structure than a text file (2 2\
8.1.3Suggest a field name that can be used as the primary key of the database table (FIGURE 10\ (1\
8.1.4Identify the name of the data TABLE shown in FIGURE 10. (1\
8.1.5Identify the names of ANY TWO data attributes shown in FIGURE 10. (2\
8.1.6What maximum limit could you as a programmer set for the size of the field name Marks (1\
Q8— Section header —
8.1.8Suppose you wanted to insert a new record into the database table (FIGURE 10\ Provide the SQL statement that would add the following record. 22 THABISO 12 MALE 88
8.2Consider the following statement: One supplier can supply more than one product, but each product can only be supplied by one supplier.
8.2.1What type of database relationship exists between the Supplier and the Product?
8.2.2Explain the purpose of database relationships. (2 2\ (4\ [20] TOTAL SECTION B: 70 GRAND TOTAL:20
Mark Allocation
Total100 marks
Sections10 + 10 + 5 + 5 + 10 + 30 + 10 + 20 = 100 marks
Paper information
TitleExam Paper
SubjectPrinciples Of Computer Programming
LevelNCV Level 3
Document typeQuestion paper
Year2023
MonthNovember
Pages15
Downloads2
Examination context
Decade2020s
Years ago3y
SeasonSpring (SH)
Start dayWednesday
Exam periodNovember 2023
Days since exam1,075
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 size981.7 KB
Pages15
Archived on8 September 2026
File age46d
ContributorFreeMode
Fingerprint431233030168
Questions and learner discussion
Log in to ask a question or leave a review.
No questions or discussions have been posted yet.