WorksheetsFinal Exam: IT and Web Development
Total questions: 60
Worksheet time: 3600secs
Which device is primarily responsible for processing instructions in a computer system?
RAM
CPU
GPU
Hard Drive
What is the main function of a router in a network?
Store files for users
Direct network traffic between devices
Increase computer speed
Display web pages
Which protocol is commonly used to secure data transmitted over the web?
HTTP
FTP
HTTPS
SMTP
Which component is responsible for temporarily storing data that is actively being used by the CPU?
SSD
RAM
Power Supply
NIC
Which markup language is used to structure content on the web?
CSS
HTML
JavaScript
SQL
What is the primary purpose of a database management system (DBMS)?
Design web pages
Store and organize data
Connect to the internet
Render graphics
Which software type manages hardware resources and provides common services for computer programs?
Application software
Operating system
Utility software
Firmware
Which of the following is a basic principle of least privilege in cybersecurity?
Users should have access to all files
Users should have only the access necessary to perform their job
All users should be administrators
Passwords should be shared
Which device connects a computer to a wired network?
GPU
NIC
SSD
Router
Which of the following is a common reason for system performance degradation?
Excessive RAM
Overheating components
High-speed SSD
Updated drivers
A user reports that their web page is not displaying styles correctly. Which file type should you check first?
.html
.css
.js
.sql
You are designing a login page. Which UI design principle should you prioritize to help users avoid errors?
Use bright colors
Provide clear feedback for incorrect input
Hide error messages
Require complex passwords only
A company wants to ensure only authorized employees can access sensitive files. Which security measure should be implemented?
Public file sharing
Role-based access control
Open network ports
Disable all passwords
You notice that a web application is loading slowly for users. Which infrastructure component should you check first?
Power supply
Network bandwidth
Monitor resolution
Mouse driver
A user is unable to connect to the internet via Wi-Fi but can connect using an Ethernet cable. What is the most likely cause?
Faulty GPU
Wireless NIC issue
Broken monitor
Overloaded CPU
You are tasked with designing a database for a retail store. Which table would most likely include a foreign key?
Products
Orders
Employees
Operating Systems
A web developer wants to ensure their site is accessible to users with disabilities. Which design feature should they implement?
Use only images for navigation
Provide text alternatives for images
Use small font sizes
Avoid keyboard navigation
A company’s website is frequently targeted by phishing attacks. Which security practice should be emphasized to employees?
Ignore suspicious emails
Click all links in emails
Report and avoid suspicious emails
Share passwords with coworkers
A user complains that their computer is running slowly after installing new software. What is a likely cause?
Increased CPU usage
Improved cooling
Upgraded RAM
Faster SSD
You are asked to select a storage solution for a database that requires fast read/write speeds. Which option is best?
HDD
SSD
DVD
USB 2.0 flash drive
A web application is experiencing frequent downtime. After investigation, you find the server is overloaded during peak hours. What is the most strategic solution?
Increase server RAM and CPU resources
Reduce the number of users
Change the website color scheme
Remove all images
You are designing a user interface for a banking app. How would you ensure both usability and security for login?
Allow unlimited login attempts
Implement two-factor authentication and clear error messages
Use only password authentication
Hide all error messages
A company wants to migrate its database to the cloud. What should be considered to ensure data integrity and security during migration?
Use unsecured public Wi-Fi
Encrypt data and verify backups before migration
Ignore user permissions
Delete all old data
You are troubleshooting a network where some devices can access the internet and others cannot. What is your first step in diagnosing the issue?
Replace all cables
Check IP configuration and network settings on affected devices
Reinstall the operating system
Upgrade the monitor
A web developer is tasked with improving page load times. Which strategy would be most effective?
Increase image sizes
Minimize CSS and JavaScript files
Add more animations
Use outdated browsers
You are asked to design a database for a hospital. How would you ensure patient privacy and data security?
Allow all staff access to all records
Implement access controls and encrypt sensitive data
Store data in plain text
Use public cloud without security measures
A company’s network is experiencing slow performance. After analysis, you find excessive broadcast traffic. What is a strategic solution?
Replace all computers
Segment the network using switches and VLANs
Increase monitor resolution
Disable all firewalls
You are leading a software development team. How would you ensure the project meets user requirements and is delivered on time?
Skip planning and start coding immediately
Use an SDLC model with regular user feedback and milestones
Ignore user input
Only test after deployment
You are asked to design a network for a new office. What is the most important factor to consider for future scalability?
Use only one switch for all devices
Plan for modular expansion and flexible infrastructure
Limit the number of network ports
Avoid wireless connectivity
Which of the following best describes informed consent in the context of data collection?
Sharing user data with third parties without disclosure
Informing users about data collection and obtaining their permission
Collecting data without notifying users
Allowing users to opt out after data is collected
What is a potential ethical issue when using artificial intelligence to analyze personal data?
Increasing the speed of data processing
Ensuring data is stored in the cloud
Bias in algorithms leading to unfair outcomes
Using only open-source software
Why is data anonymization important in ethical data handling?
It protects individual privacy by removing identifying information
It prevents unauthorized access to raw data
It increases the amount of data collected
It makes data easier to sell
Which of the following best describes structured data?
Data stored as free-form text
Data represented only as images
Data organized in rows and columns, such as in a database table
Data with no defined format
What is the primary purpose of a data backup strategy?
To recover information in case of data loss
To improve display resolution
To increase network speed
To reduce storage costs
Which of the following is an example of unstructured data?
An Excel spreadsheet with formulas
An email message with attachments
A relational database table
A CSV file with customer records
Which of the following is most likely to improve the performance of a web server experiencing high traffic?
Upgrade network bandwidth
Reduce RAM
Install a larger monitor
Change the mouse
What is the main benefit of using encryption for sensitive data stored in a database?
Faster data retrieval
Protection against unauthorized access
Lower hardware costs
Improved display quality
Which device is essential for connecting multiple computers within a local area network?
Keyboard
Printer
Switch
Monitor
Which of the following is an important consideration for making a website accessible to users with visual impairments?
Adding background music
Disabling keyboard navigation
Using high-contrast color schemes
Using only images for content
What is the purpose of using semantic HTML elements in accessible design?
To provide meaning and structure for assistive technologies
To improve search engine ranking only
To increase the number of images on a page
To make the website load faster
Which feature helps users with motor disabilities navigate a website more easily?
Complex mouse gestures
Keyboard shortcuts and tab navigation
Hidden navigation menus
Animated backgrounds
Which of the following is a primary benefit of implementing centralized logging in an IT infrastructure?
Eliminates the need for monitoring tools
Automatically encrypts all data
Enables easier troubleshooting and incident response
Reduces network bandwidth usage
What is the main purpose of setting up monitoring for a web application?
To detect performance issues and ensure uptime
To automatically update the application
To increase the number of users
To reduce hardware costs
Which metric is most useful for gaining visibility into application health?
Screen resolution
Application error rate
Number of active user sessions
CPU temperature
What is a key benefit of implementing real-time monitoring for critical infrastructure?
It increases manual intervention requirements
It hides system errors from administrators
It allows immediate detection and response to incidents
It reduces the need for any logging
Which of the following metrics would most help in gaining visibility into network performance issues?
CPU fan speed
Network latency and packet loss
Monitor brightness
Number of installed applications
Which of the following is the most effective way to ensure clear communication with a client during a project?
Share only technical documentation
Rely solely on email updates
Schedule regular meetings and provide written summaries
Wait for the client to reach out if they have questions
What should you do if a client provides feedback that conflicts with the original project requirements?
Delay the project until the client changes their mind
Make changes without informing the team
Discuss the feedback with the client to clarify expectations
Ignore the feedback and follow the original plan
When communicating technical information to a non-technical client, what is the best approach?
Avoid answering their questions
Only provide written documentation
Use technical jargon to demonstrate expertise
Explain concepts using simple language and analogies
Which result reflects an IT project that is poorly managed?
Project tasks take longer to complete, requiring more company resources and money.
The IT project's lack of success will cause other departments to work together more amicably to make up for the project's deficiencies.
IT training and support is discontinued because non-IT personnel did not welcome or utilize the support.
Fewer alternatives are provided to employees to manage their workload during system downtime.
A 9-hole golf course is introducing an app to replace paper scorecards. The total score is the number of times the player hits the ball to complete all 9 holes.
The shown user interface is designed for the player to enter their score for each hole.
Choose two reasons why this user interface design is not fit for purpose.
No next hole button
No submit button
Some text is too small
No colour display
Does not show total score
Which of the following best describes the main purpose of version control systems?
To increase the speed of code execution
To manage and track changes to source code over time
To monitor network traffic
To design user interfaces
What is a common benefit of using distributed version control systems like Git?
They prevent any changes from being reverted
They automatically deploy code to production
They allow multiple developers to work independently and merge changes
They require a constant internet connection
When collaborating on a project, which version control feature helps resolve conflicting changes made by different team members?
Branching
Tagging
Cloning
Merging
Which of the following is most important when designing a game's core mechanics?
Visual effects
Player engagement and feedback
Marketing budget
Soundtrack length
What is the primary purpose of playtesting during game development?
To release the game early
To increase the game's price
To identify and fix gameplay issues
To finalize the game's artwork
Which element is essential for creating a balanced multiplayer game?
Equal access to powerful items for all players
Unpredictable server downtime
Randomly assigned controls
Complex user interface
Which command is written correctly?
Move
move
Move();
move();
Copyright law protects authored works; _________ law protects invention.
Patent
Copyright
Trade Mark
Trade Secret
What does a trademark protect?
An invention
A work of art
Logos and names
A secret formula
