WorksheetsDatabase Management Systems Worksheet
Total questions: 79
Worksheet time: 40mins
What is the primary function of a DBMS?
Storing and retrieving data efficiently.
Managing network connections.
Compiling programming code.
Designing user interfaces.
Which of the following best describes the term 'Normalization' in databases?
A process of reducing redundancy in a database.
A technique for speeding up query execution.
A method of encrypting database records.
A way to back up database files.
The internetworked organizational databases at different sites to be integrated and synchronized with all the facilities of database approach is _____________.
Centralized database
Distributed database
Localized database
Globalized database
Which of the following best describes query optimization?
A process of rewriting queries to improve efficiency.
A technique to ensure transaction durability.
A method to normalize database schemas.
A security mechanism for access control.
Suppose a banking system has a Transactions table. To ensure that withdrawals do not exceed available balance, which database constraint should be applied?
FOREIGN KEY
NOT NULL
CHECK
UNIQUE
What will be the output of the following SQL query? SELECT COUNT (*) FROM Employees WHERE Salary > 50000;
The total salary of employees earning more than 50,000
The number of employees earning more than 50,000
The number of employees in the Employees table
The maximum salary in the Employees table
Database administrators want to improve the performance of a complex SQL query. Which technique should they consider first?
Using query optimization techniques.
Adding more tables to the database.
Increasing the number of indexes.
Reducing data redundancy.
In a banking system within a certain Ethiopian business banks, two transactions attempt to withdraw from the same account simultaneously. Which technique helps prevent data inconsistency?
Implementing Two-Phase Locking (2PL).
Running both transactions in parallel.
Creating more database indexes.
Using a NoSQL database.
If a database system frequently experiences deadlocks, which of the following would be the best approach to handle the issue?
Implementing deadlock detection and resolution.
Removing all foreign key constraints.
Avoiding the use of ACID properties.
Increasing the database cache size.
A distributed database system is experiencing slow query performance. What is the most likely reason?
Using a Relational Database Management System (RDBMS) instead of a NoSQL database.
High network latency and inefficient query execution.
Too many foreign key constraints.
Lack of data replication.
In an Ethiopian airline ticket reservation system, multiple users are trying to book the last available seat at the same time. What database feature helps prevent conflicts?
Concurrency control
Query optimization
Data redundancy
Data replication
A database is in BCNF but still has redundancy. What could be the possible reason?
It still contains transitive dependencies.
It has overlapping candidate keys.
It lacks a foreign key constraint.
It does not have a primary key.
Which one of the following types of database schema is used for organizing data in single, two dimensional displays?
Flat model
Hierarchical model
Network model
Relational model
Which one of the following schema development practice is used for optimizing database performance?
Name conventions
Data security
Normalization
Documentation
Which one of the following is unshielded twisted pair cable connector?
BNC connector
subscriber channel connector
RJ-45 connector
straight-tip connector
Which mode of transmission sender act as sender and act as receiver after some time interval?
Simplex
Half duplex
Full duplex
Unidirectional
Which topology the failure one computer affects the entire network?
Ring
Bus
Star
Mesh
When analog signal to another analog signal conversion is required?
To extend the area coverage of wires signal
To transmit analog signal through cables
To extend network cable
To connect computer with connectivity devices
Which one of the following protocols includes under internet/internetworking layer TCP/IP layer?
Transmission Control Protocol
File Transfer Protocol
Simple Mail Transfer Protocol
Address Resolution Protocol
Which data link layer device is used to prepare a MAC table and send packets for the selected device only?
Switch
Router
Bridge
Repeater
Among OSI layers, which one provides user interfaces and support for services such as electronic mail, remote file access and transfer?
Session layer
Application layer
Presentation layer
Transport layer
Which one of the following correctly differentiates data link layer and physical layer in the concept of OSI layer?
Physical layer is responsible for packaging raw bits while data link layer is responsible for handling beat stream or bit transmission.
Data link provides access to the cable while physical layer provides physical addressing.
Data link layer provides hop-to-hop delivery while physical layer provides mechanical and electrical specifications.
Wires and connectors are included in data link layer while bridges and switches operate at physical layer.
Which one of the following OSI layer is responsible if the website loads slowly but the network connection is stable?
Application layer
Physical layer
Network layer
Transport layer
What type of devices do straight-through cables connect?
Computer to computer without any connectivity device
Computer to switch
Switch to switch
Switch to hub
What is the requirement to share files with peer-to-peer network?
Two computers should have the same name and host address
Two computers should have the same network address but different host address
File sharing, network sharing and printer sharing should be disabled
Two computers should have the same network and host address
There are six computers to be connected with each other through a connectivity device called hub. What will you do to create this connection?
Create bus topology with straight line cable
Create ring topology by cyclic process
Create star topology by using connectivity device
Create mesh topology by connecting each other
An operating system function that memorizes track of information regarding the creation, deletion, transfer, copy, and storage of files in an organized manner is related to ________.
Memory Management
Device Management
File Management
Security Management
When a process is waiting for some I/O events, after the waiting process is completed, to what state does the process transition next?
Terminated state
Running state
Ready state
New state
Which one of the following matches the functions of a contemporary operating system?
It does not ensure security and access control.
It manages human resources.
It enables single tasking.
It enables multitasking.
What is the core part of an operating system that directly interacts with hardware?
Shell
Kernel
GUI
API
If a process of operating system is ready to execute, but waiting for availability of resources, then the possible state in this process could be identified as ________________.
New Born State
Ready State
Waiting State
Exit State
Among the following Operating Systems, which one describes the first operating systems for the personal computer that could be operated using the command prompt?
Macintosh operating system (MacOS)
Disk Operating System (DOS)
Windows operating system
Linux operating system
Which one of the following statements selects the correct one about the process and tread states?
Both process state and treads are active (running) at a time.
All threads cannot access every address in the task.
Both process state and treads do not share CPU.
Both process state and treads share CPU.
Which one of the following is used to explain the objectives modern operating systems?
To provide a platform on which a user can design hardware.
To make the computer environment less convenient to use.
To use the computer resources efficiently.
To design algorithms.
Among the following computer system components, which one is responsible to manage and control the overall tasks in the computer system?
Central processing unit (CPU)
Operating system
High level languages
Application software
In processes or threads concepts, there is a blocking of processes or treads that either compete for system resources or communicate with each other when each process or thread is waiting for a resource to be freed which is controlled by another process. These processes or treads could be examined with ___________.
Process Control Block
Deadlock
Deadblock
Multithreading
Which one of the following programing states a conceptual framework of object model and is implemented by writing classes and objects.
Object oriented programming
Declarative programming
Imperative programing
Procedural programing
In any programming paradigms, the primary function that every programing must have is:
main()
void()
user_defined()
define()
Object-Oriented Programming is differ from any other programing by its building blocks of:
Static development.
Encapsulation.
Java language.
Functionality.
Which one of the following programing models is the most recent concept that used to write dynamic program?
Object oriented programming.
Imperative programing.
Functional programing.
Logic programming.
Which one of the following statements correctly defines the term Polymorphism?
It is the capability of a method to do different things based on the object that it is acting upon.
It is the process where one class acquires the properties (methods and fields) of another class.
It is a process of hiding the implementation details from the user, only the functionality will be provided to the user.
It is binding or wrapping data(variables) and functionality(methods) together as a single unit provided to the user.
As a programmer, you might use comments while writing the object oriented programming using Java. How could you express such comments in Java programming?
%...
/* ... */
#...
/...
In object oriented programming, which feature indicates the code reusability?
Polymorphism
Encapsulation
Inheritance
Abstraction
In object oriented programming, which feature indicates the code reusability?
Polymorphism
Encapsulation
Inheritance
Abstraction
Given the following Java code, what will be printed? public class Test { public static void main(String[] args) { int x = 10; int y = 0; try { System.out.println(x / y); } catch (ArithmeticException e) { System.out.println("Cannot divide by zero"); } } }
10
0
Cannot divide by zero
Compilation error
While practicing object oriented programming using Java, the execution of every Java program is under the control of:
Java Virtual Machine (JVM).
Java Virtual class (JVC).
Java application.
Java applet.
To write programs using Java, which Java IDE is widely used for development?
IDLE
Anaconda
NetBeans
CMD prompt
Which keyword is used to declare a static member in Java?
Constant
Global
Static
Final
Which modeling technique shows the message flow between objects in an Object Oriented application and also implies the basic associations between classes?
Sequence Diagram
Collaboration Diagram
Activity Diagram
Class Diagram
How does method overloading differ from method overriding?
Overloading is defining methods with the same name in different classes, while overriding is defining methods with the same name in the same class.
Overloading changes the method signature, while overriding keeps the method signature the same.
Overloading requires final methods, while overriding does not.
Overloading requires inheritance, whereas overriding does not.
What is the main advantage of using polymorphism in Java?
It allows methods to be overloaded and overridden for flexibility.
It forces all methods to have the same name.
It eliminates the need for classes.
It prevents code reuse.
Why is encapsulation important in object-oriented programming?
It hides implementation details and only exposes necessary data through methods.
It allows methods from different classes to be accessed directly.
It prevents the use of multiple classes in a single program.
It forces all classes to have only public variables.
What is the key difference between composition and inheritance?
Composition allows greater flexibility by using objects within objects, whereas inheritance establishes a strict parent-child hierarchy.
Inheritance is used when one class "has-a" another class, whereas composition is used when one class "is-a" another class.
Inheritance supports polymorphism, while composition does not.
Composition requires an interface, while inheritance does not.
Which of the following is an example of markup languages?
JavaScript
Python
HTML
PHP
What does URL stand for?
Universal Reference Locator.
Uniform Resource Locator.
Uniform Resource Link.
Unique Resource Link.
Which of the following is a dynamic web technology?
JavaScript
HTML
XML
CSS
What is the primary function of a web browser?
To retrieve and display web content.
To develop web applications.
To host websites.
To send emails.
Which CSS property is used to change the text color of an element?
background-color
font-color
text-color
color
If we might write the following internet program, then what type of CSS is applying for displaying the text color in red?
This is your exit exam! It should appear in red
External.
Internal.
Inline.
Browser default styles.
Which tag is used to define an image in an HTML document?
A website developer wants to create a dynamic web application that updates content without reloading the page. Which web technology should he/she use?
HTML5
AJAX
CSS3
FTP
Which combination of programming languages is combined in the right manner?
HTML is used to manage data in relational databases, while Javascript used to cascade style formatting.
HTML is used to cascade style formatting, while Javascript used to manage data in relational databases.
HTML is representation of semantic structured data, while CSS used to cascade style formatting.
CSS is representation of semantic structured data, while HTML used to cascade style formatting.
Which protocol ensures secure communication over the web?
HTTPS
HTTP
SMTP
FTP
Which of the following is a characteristic of client-side programming?
Processes requests on the web server.
Manages database connections.
Runs on the client’s browser.
Generates dynamic content.
What is the main purpose of AJAX in web development?
Load data asynchronously without reloading the page.
Improve website aesthetics.
Encrypt web traffic.
Validate form data.
If a website developer wants to create a form where users can input their email and submit it, then which HTML tag should he/she use?
