WorksheetsSU2 QUIZ 22/12/2025
Total questions: 30
Worksheet time: 26mins
Which is the best example of a Primary Key?
Price
Name
Address
IC No
Which of the following is NOT an example of a database?
telephone book
real estate listing
online library catalog
DVD
GRANT & REVOKE IS THE
DDL
DML
DCL
TCL
OPERATIONS OF DATABASE
INSERT
DELETE
RECORD
SAVE
------------------- is software package for creating and managing databases.
(a)
In preorder traversal of a binary tree the second step is ____________
traverse the right subtree
traverse the left subtree
traverse right subtree and visit the root
visit the root
The decision tree structure begins at a node called the _____.
span
top
root
branch
How many leaf are there in the tree?
1
3
4
7
Which of these tree traversal methods is used to output the contents of a binary tree in ascending order?
Pre-Order
In-Order
Post-Order
Monastic Orders
When traversing a binary tree, which diagram is post-order?
A Data Structure is:
A C++ vector
A way of organizing, storing and performing operations on data.
A function in any programming language
A sequence of steps to solve a problem.
Given a sequence of number below:
50,60,40,70,45,55,30,80,65,35,25,75,85
When creating a binary search tree, what is the height of the tree?
3
4
5
6
Given a binary search tree, insert 27, 15, 63, 99, 70 and 85 (in this order) into the binary search tree. What is the post-order traversal?
5,15,27,34,47,54,63,70,72,75,83,85,88,94,99,101
72,54,34,5,27,15,47,63,70,83,75,88,85,101,94,99
15,27,5,47,34,70,63,54,75,85,99,94,101,88,83,72
15,27,5,47,34,63,54,70,75,85,99,94,101,88,83,72
none of the above
Choose the correct statement
A data structure is a specialised format for organising and storing data
A data structure is a specialised format for organising and storing information
A data structure is a format for organising and storing only one data type
A data structure is too complicated to truly understand or use
What is a characteristic of a multi-processor system?
It cannot increase overall system performance.
It allows multiple processors to work together concurrently.
It contains only one CPU.
It is limited to single-threaded applications.
What defines a distributed system?
A system that only serves one user at a time.
A system that operates without any network connection.
A collection of autonomous computers linked by a network.
A single computer with multiple CPUs.
Which architecture organizes the system into hierarchical layers?
Event Based Architecture
Layered Architecture
Data Centred Architecture
Object Based Architecture
In Object Based Architecture, how do objects communicate?
Through method calls.
By using shared global variables.
By sending emails to each other.
Through direct memory access.
What is the focus of Data Centred Architecture?
Central management of application logic.
Central management and utilization of data.
Event-driven interactions.
Decoupling of components.
What are Event Producers in Event Based Architecture?
Components that store data.
Components that manage resources.
Components that consume events.
Components that generate events.
What is a key feature of Loose Coupling in Event Based Architecture?
Direct calls are preferred over events.
All components must be on the same server.
Producers and consumers interact through events.
Producers and consumers are tightly integrated.
Which mechanism is used for object interaction in Object Based Architecture?
Remote Procedure Call (RPC)
Shared Memory Access
Synchronous Data Transfer
Direct Memory Access (DMA)
What is the role of Event Channels in Event Based Architecture?
To store data permanently.
To transmit events between producers and consumers.
To create user interfaces.
To manage CPU resources.
What does Layered Architecture promote?
Single-layered systems.
Direct interaction between all layers.
Complexity in system design.
Separation of concerns.
What is marshaling in the context of RPC?
Assigning a unique identifier to each remote procedure
Encrypting messages exchanged between client and server
Converting procedure parameters into a format suitable for transmission
Establishing a secure communication channel
What is the primary purpose of RPC in distributed systems?
To enable file sharing across networks
To invoke procedures on remote machines as if they were local
To ensure fault tolerance in distributed databases
To manage concurrency in multi-threaded applications
