CIT208 Exam Practice Questions and Answers 2026
For more helpful exam preparation materials, request the EXAM KEYNOTE from Coach Ayo at a discounted price.
Visit www.coachayo.com for more!
Identify a key feature of service-orientated architecture (SOA).
a. It relies solely on HTTPS for security
b. It tags data for transfer
c. It allows for reusable service components
d. It lists available web services
What is a common criticism of RPC web services?
a. Limited support for XML
b. Complexity in deployment
c. High development costs
d. Slow data transfer rates
How can businesses use web services to enhance customer interaction?
a.By improving their internet connection speed
b. By enabling seamless data exchange between different applications
c. By reducing their IT infrastructure costs
d. By increasing their data storage capacity
How do web services handle transactions?
a. By listing available transactions
b. By tagging transaction data
c. By governing the outcome of atomic transactions
d. By describing transaction services
Which protocol is used to transfer data in web services?
a.WSDL
b.UDDI
c.XML
d.SOAP
Explain the concept of web service reliability.
a.Securing message exchanges
b.Tagging the data
c.Reliable messaging between two web services
d.Describing available services
How do web services facilitate interoperability between different IT systems?
a.By using standardized protocols like XML, SOAP, WSDL, and UDDI
b.By enhancing the speed of data transfer
c.By increasing data storage
d.By reducing the cost of software
Compare SOA and REST in the context of web services.
a.Both are common ways to use web services
b.Only SOA is used for remote procedure calls
c.SOA is faster than REST
d.REST uses more resources than SOA
What is a significant advantage of using web services for remote procedure calls (RPC)?
a.Reduced server load
b.Increased data storage
c.Familiar interface for developers
d.Enhanced internet speed
Which option is an application of web services in a real-world scenario.
a.Increasing data storage in cloud services
b.Enhancing local area network speed
c.Developing mobile applications without internet
d.Integrating web-based applications for business communication
Given the table Students with columns StudentID, Name, and Grade, which SQL statement correctly retrieves the names of all students who scored above 80?
a.SELECT Name FROM Students;
b.SELECT Name FROM Students WHERE Grade < 80;
c.SELECT Name FROM Students WHERE Grade >= 80;
d.SELECT Name FROM Students WHERE Grade > 80;
What does the acronym JDBC stand for in database programming?
a.Java Data Control
b.Joint Database Connection
c.Java Database Connectivity
d.Java Dynamic Connection
Write an SQL statement to create a table named Courses with columns CourseID, CourseName, Credits, and Department.
a.CREATE TABLE Courses (CourseID int, CourseName varchar(255), Credits int, Department varchar(255));
b.CREATE Courses TABLE (CourseID int, CourseName varchar(255), Credits int, Department varchar(255));
c.TABLE CREATE Courses (CourseID int, CourseName varchar(255), Credits int, Department varchar(255));
d.CREATE TABLE (CourseID int, CourseName varchar(255), Credits int, Department varchar(255)) Courses;
Which SQL keyword is used to sort the result-set?
a.GROUP BY
b.ORDER BY
c.SORT
d.FILTER BY
Which SQL statement correctly uses the HAVING clause to filter groups based on aggregate values?
a.SELECT Department, SUM(Salary) FROM Employees HAVING SUM(Salary) > 100000 GROUP BY Department;
b.HAVING SUM(Salary) > 100000 SELECT Department, SUM(Salary) FROM Employees GROUP BY Department;
c.SELECT Department, SUM(Salary) FROM Employees GROUP BY Department HAVING SUM(Salary) > 100000;
d.SELECT Department, SUM(Salary) HAVING SUM(Salary) > 100000 FROM Employees GROUP BY Department;
What is the purpose of the SQL GROUP BY clause?
a.To aggregate data based on one or more columns
b.To sort the results
c.To combine multiple columns into one
d.To filter results based on a condition
Given the table Orders with columns OrderID, CustomerID, and OrderDate, which SQL statement returns the number of orders for each customer?
a.SELECT COUNT(CustomerID), OrderID FROM Orders GROUP BY OrderID;
b.SELECT CustomerID, COUNT(OrderID) FROM Orders GROUP BY CustomerID;
c.SELECT CustomerID, COUNT(OrderID) FROM Orders GROUP BY OrderID;
d.SELECT COUNT(CustomerID), OrderID FROM Orders GROUP BY CustomerID;
Which of the following correctly describes the difference between DELETE and TRUNCATE commands in SQL?
a.DELETE removes all rows and cannot be rolled back, TRUNCATE removes specific rows and can be rolled back
b.DELETE removes specific rows and can be rolled back; TRUNCATE removes all rows and cannot be rolled back
c.DELETE and TRUNCATE are identical in their functionality
d.DELETE removes specific rows and cannot be rolled back, TRUNCATE removes all rows and can be rolled back
What is the function of the SQL JOIN clause?
a.To combine rows from two or more tables based on a related column
b.To create a new table
c.To insert records into multiple tables
d.To delete records from multiple tables
What is a primary key in a database?
a.A unique identifier for each record in a table
b.A foreign key linking two tables
c.A key used to encrypt the database
d.A key that speeds up query execution
In conclusion
Kindly note that the above practice questions and answers are not limited to the above questions and answers.
More practice questions and answers will bw updated from time to time. So do well to come back checking for more.
-
How to check NOUN E-EXAM TIMETABLE 2026
How to check NOUN E-EXAM TIMETABLE 2026 is a comprehensive guide for students of the National Open University of Nigeria,
-
Discover ACC206/SMS206: Introduction to Cost and Management Accounting Classes
Discover ACC206/SMS206: Introduction to Cost and Management Accounting Classes, specifically dedicated to covering each module and unit of the course
-
ENG224 Exam Practice Questions and Answers 2026
ENG224 Exam Practice Questions and Answers 2026 For more helpful exam preparation materials, request the EXAM KEYNOTE from Coach Ayo at