Advanced level 2024 North West mock computer science 1
Advanced level 2024 North West mock computer science 1
19. Prototype is a
A. Working model of an existing system
B. Mini model of an existing system
C . Mini model of processed system
p. None of the above
20.The most creative and challenging phase of
cycle is
A. Feasibility study
B. Maintenance
C. Design
D. None of the above
21.Which stage of system development deals with ~
analyzing the skills and capabilities of the software
development team?
A. Technical Feasibility
B. Operational Feasibility
C. Economic Feasibility
D. Feasibility study
22.It specifies the tasks to be carried out irTtlic backend for
proper functioning of the product
A. Functional requirement
B. Transitional requirement
C. Technical requirement
D. Operation requirement
23.Software is created by an organisation and the process is
divided into 3 parts. The design team is working on part
A, the analysis team is working on part B and the
implementation team is working on part C. What model
does this scenario represent?
A. Waterfall
mud*: In the *y*trm MMJY %< \ nfugx‘ *>how up in
A , System design
B, Syrian conMruclion
C, Maintenance
I). Implementation
2 { ). I he design Minlegy that iilcntilien Mibhi .1 * ha – nj on the
opemlion* carried out in them to provide a service or
feature is known HI:
A. Modular design ,
B, Functional design,
0, Bottom–up design,
\ ). I op:down design,
30.( iiven the basic HR and relational models, which of the
following is INCOKKIX I ?
A. An attribute of an entity can have more than one
value
B. An attribute of an Entity can be composite
C. In a row of a relational table, a primary key uniquely
identifies each record
D. In a row of a relational table, an attribute can have
exactly one value or a NULL value
31. When the state ol tire database no longer reflects a real
state of the world that the database is supposed to
capture, then such a state is called a(n)
A. Consistent state.
B. Parallel state.
C. Durable state
D. Inconsistent state
32. When a non–prime attribute determines another nonprime attribute , the dependency is called
A. Partial
.
B. Transitive
C. Multi–valued
D. None–trivial
system life
B. RAD
C. Spiral D. Agile
24.In software development models are created at
A. The analysis stage
B. The design stage
C. At the analysis and design stages
D. At the testing stage
25. Which activity doesn’t take place during the
construction stage?
A. Creating the database
B. Drawing flowcharts
C. Writing program codes
D. Buying various equipment
26.A program has been written to read a student maik
between 0 and 20 and display if it is a pass mark or not.
Which test plan is the best suited?
A. Test 0, 5, 7 and 14
B. TestO, 10, 15 and 20
C. TestO, 5, U>, 15, 20
D. Test –1,25, 8 and 11 _
27
. Which conversion method requires the operation of the
old system and the newly developed system for a
specific time period?
A. Pilot conversion
B. Phased conversion
C. Parallel conversion
D. Direct conversion
33.The relation R ( AIL , A2, A3 , A4) with the
dependency A3 –> A4 can be normalized into 3NF as?
A. Rl ( A3 , A4) and R( A1, A2, #A3)
B. fil(A3, AA ) and R( Al . # A3 , A2 )
C . R1(44, A3 ) andR( Ai , A2. KAA)
D. AA) and R( A1, A2 )
34.Referential integrity is achieved in a database by
A. Referencing data
B. The foreign key (in the associated table) references a
primary key value
C. Candidate key references a primary‘ key
D. Making data consistent
35. Pick the most meaningful relationship between entities.
A. Teacher Is teaching
B. Students Taught by teacher
C. Teacher talks with Colleagues
F). Students Argue School fee