Multimedia Service NCV Level 4 — Document P1
November 2018 — NCV Level 4 — Multimedia Service
NCV Level 4
2018
NCV IT
Preparing document
📋 Document Analysis
See full analysis
Questions — A Preview of What to Expect in the Document
57
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.1Indicate whether the following statements are TRUE or FALSE. Choose the answer and write only 'True' or 'False' next to the question number (1.1.1
1.1.15\the ANSWER BOOK.
1.1.15A communications protocol (protocol\ is a set of rules that every computer follows to transfer information. Integrity is not a primary goal of security. A peer to peer network is the most complicated type of network.
1.2Various options are given as possible answers to the following questions. Choose the answer and write only the letter (A D\ next to the question number (1.2.1
1.2.15\in the ANSWER BOOK.
1.2.1The HTML tag ... produces the biggest heading
1.2.2... sorts rows in SQL SORT BY ALIGN BY
1.2.3The benefits of a standard relational language include ... Reduced training costs Increased dependence on a single vendor Applications are not needed.
1.2.4he five built in functions provided by SQL are ...
1.2.5as HTML. SEMANTICS SYNTAX TAGS FRAME
1.2.6To remove duplicate rows from the results of an SQL SELECT only unique distinct
1.2.7report. form. file. table.
1.2.8An ... tag is used to display a picture in a HTML page
1.2.9... is the correct order of keywords for SQL SELECT statements SELECT, FROM, WHERE FROM, WHERE, SELECT
1.2.10... is the correct CSS syntax. body:color=black {body;color:black}
1.2.11he difference between margins and padding Margins add white space
1.2.12With ... y ou can add a row using SQL in a database ADD
1.2.13... is t he command to remove rows from a table 'CUSTOMER' REMOVE FROM CUSTOMER ... DROP FROM CUSTOMER ...
1.2.14... is t he SQL WHERE clause Limits the column data that are returned. Limits the row data are returned.
1.2.15... is t he command to eliminate a table from a database REMOVE TABLE CUSTOMER
1.3Give ONE word or term for each of the following descriptions. Write only the word or term next to the question number (1.3.1 1.
3.15\in the ANSWER BOOK.
1.3.10A collection of dots that make up a monitor's display A program that searches documents (i.e. web pages, which are HTML documents\ for specified keywords and returns the list of documents A software application that serves requests initiated by client
1.3.15text box, usually at the top of your browser window, which displays the address of the web page you're looking at, or which a web address can be typed into It makes files smaller for faster upload/download times, and less
1.4Give the full term for the following abbreviations. Write only the term next to the question number (1.4.1
1.4.5\the ANSWER BOOK.
1.4.1DoS
1.4.2PIN
1.4.3DDoS
1.4.4IPS
1.4.5IDS (5 1\ (5\ [50] TOTAL SECTION A: [50] SECTION B50
Q2— Section header —
2.1Briefly explain why a network administrator would recommend the installation of a proxy server (2\
2.2Tabulate any THREE differences between domains and workgroups (3 2\
2.3Briefly discuss any TWO advantages of fibre optic cables over twisted pair cables in a computer network. (2
2.4Describe how a client server network model works (4\
2.5Explain the purpose of ARP in a network. (2\ [20] (10040184\ NC2140 (E\20
Q3— Section header —
3.1All statements related to Data Definition Language (DDL\can be used in defining/creating a database structure or schema. Identify any THREE DDL statements. (3
3.2Study the table below and answer the following questions. The name of the table is Enrolments. SUBJECT COURSE NUMBER OF STUDENTS Graphic Design Marketing 35
3.2.1Write a que ry that will show all subjects where the number of students is greater than 30. (3\
3.2.2Write a query that will add a record for the subject Computer Programming, ICT course where the number of students is 27. (3\
3.2.3Write a query that will update the number of enrolments for Multimedia Service from 27students to 38. (3\ 3. Highlight any THREE advantages or benefits of using SQL on your (3
Q4— Section header —
Q5— Section header —
5.1The website below shows a drop down list. Produce the HTML code that will generate the drop down list
5.2Study the HTML code given below and answer the questions that follow: <img href = 'mypotrait.jpeg' alt = 'MyPicture'/>.
5.2.1Briefly explain the purpose of the code: <img href. (1\
5.2.2Explain the importance of including Alt = 'MyPicture' .in this code (1\
5.3Produce the full JavaScript code that will give you the web page below. (6\
5.4Explain the purpose of Functions as used in JavaScript. (2\ [20] (10040184\ 1020
Q6— Section header —
6.1Define the term web attack toolkits (2\
6.2Compare any THREE differences between an Intrusion Detection System (IDS\ and ntivirus software. (6
6.3You have been trying to log onto your bank account using internet banking You keep getting an error saying, The server has failed to uthenticate your
6.4Explain the purpose of a Virtual Private Network (VPN\ that is used by or ganisations. (6 [20]20
Topics Identified
5
Business EnvironmentsForms of OwnershipBusiness FunctionsLeadershipBusiness Plan
Mark Allocation
Total150 marks
Sections50 + 50 + 20 + 20 + 20 + 20 + 20 = 200 marks
Paper information
TitleDocument
SubjectMultimedia Service
LevelNCV Level 4
Document typeQuestion paper
Year2018
MonthNovember
Pages10
Downloads4
Examination context
Decade2010s
Years ago8y
SeasonSpring (SH)
Start dayThursday
Exam periodNovember 2018
Days since exam2,900
About Multimedia Service 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 size276 KB
Pages10
Archived on8 September 2026
File age45d
ContributorFreeMode
Fingerprint591B257B1969
Questions and learner discussion
Log in to ask a question or leave a review.
No questions or discussions have been posted yet.