# A Level Computer Science Quiz 2018 Part 2

#### Quiz Description

Just like the law of conservation of energy which says energy cannot be created nor destroyed but can be transformed from one form to another. Students are yet to realize that questions cannot be created but are mostly created from the already questions. So, at this rate it is integral for any student going in for any examination to answer as many questions as possible.

Computer science being one of the most influential subjects in the 21st century is defined as study of computers and algorithmic processes, including their principles, their hardware and software designs, their applications, and their impact on society.

A computer science student must never stop learning, and always tries to stay up to date with the latest questions and how they can approach them. To solve this problem, this question has been created. The quiz is made up of the most recent questions in the advanced level syllabus and contains questions of the most recent years.

Just like the questions, you can visit our website to gain more recent materials.

Good luck!!!

A foreign key in a relational database table is a(n):

Correct
• Set of attribute values in a table
• Combination of attributes in a table
• Attribute in one table that is an attribute in another table
• Column of a table

The attribute, name, could be structured as an attribute consisting of first name, middle initial, and last name. this type of attribute is called:

Correct
• Simple attribute
• Composite attribute
• Distributed attribute
• Multivalued attribute

The attribute AGE is calculated from DATE_OF_BIRTH. The attribute AGE is:

Correct
• Single valued
• Multivalued
• Derived
• Composite

The descriptive property possessed by each entity set is a(n):

Correct
• Attribute
• Instance
• Relation
• Model

The “turn-around” time of a user’s job is the:

Correct
• Time since its submission to the time its results become available
• Time duration for which the CPU is allotted to the job
• Total time taken to execute the job
• Time taken from the job to move from assembly phase to completion phase

Which module gives control of the CPU to the process selected by the short-term scheduler?

Correct
• Dispatcher
• Interrupt
• Scheduler
• Scheduler None of the above

Before proceeding with its execution, each process must acquire all the resources it needs. This is described as:

Correct
• Hold and wait
• Non pre-emption
• Circular wait
• Starvation

A technique of temporarily removing in-active programs from the memory of a computer system is:

Correct
• Swapping
• Spooling
• Semaphore
• Scheduler

A reusable resource is one that:

Correct
• Can be used by one process at a time and is not depleted by the use
• Can be used by more than one process at a time
• Can be shared between various threads
• All of the above

A problem encountered in multitasking when a process is perpetually denied necessary resources is:

Correct
• Starvation
• Inversion
• Aging

A pointer variable cannot be:

Correct
• Passed to a function as argument
• Changed within the function
• Returned by a function
• Assigned as an integer value

If the processor is executing a main program that calls a subroutine, then after executing the main program up to the CALL instruction, the control will be transferred to the:

Correct
• Address of the CALL instruction

Which of the following allows many users to use the computer simultaneously?

Correct
• Time Sharing operating system
• Real Time operating system
• Interactive operating system
• Batch processing system

One of the following is NOT a memory performance parameter:

Correct
• Access time
• Cycle time
• Transfer rate
• Time location

If a node having two children is deleted from a binary search tree, it is replaced by its:

Correct
• In order predecessor
• Post order successor
• Pre order predecessor
• Post order predecessor