WGU C954 Information Technology Management Objective Assessment | OA V1 and V2 | Questions and Answers | 2026 Update | 100% Correct.

WGU C954 Information Technology Management Objective Assessment | OA V1 and V2 |
Questions and Answers | 2026 Update | 100% Correct.

1. Which language is primarily used to query relational databases?
A. HTML
B. SQL
C. Java
D. Python

2. Which database model organizes data into rows and tables?
A. Hierarchical
B. Network
C. Relational
D. Object

3. What ensures that a database transaction is processed reliably?
A. RAID
B. ACID properties
C. Encryption
D. Virtualization

4. What does the “C” in ACID stand for?
A. Control
B. Consistency
C. Communication
D. Capacity

5. Which tool allows users to retrieve data without writing SQL code?
A. Query-by-example
B. Compiler
C. Firewall
D. Hypervisor

6. A primary key must be:
A. Repeated
B. Unique
C. Encrypted
D. Optional

7. A foreign key is used to:
A. Encrypt data
B. Link tables
C. Delete records
D. Compress storage

,8. Data redundancy increases the risk of:
A. Faster access
B. Inconsistency
C. Virtualization
D. Encryption

9. Which system integrates all business functions?
A. CRM
B. ERP
C. DSS
D. TPS

10. Which system supports executive-level strategic decisions?
A. ESS
B. TPS
C. MIS
D. Firewall

11. Which system processes day-to-day transactions?
A. ERP
B. ESS
C. TPS
D. CRM

12. Which application increases team collaboration?
A. Utility software
B. Collaborative systems
C. BIOS
D. Firmware

13. Cloud computing primarily provides:
A. Local-only storage
B. Shared computing resources over the internet
C. Manual processing
D. Physical isolation

14. SaaS stands for:
A. Software as a Service
B. Storage as a System
C. Security as Software
D. Server as Storage

15. IaaS provides:
A. Infrastructure resources
B. Email services only

,C. Hardware repairs
D. Manual backups

16. A data warehouse is used for:
A. Daily transactions
B. Long-term storage for analysis
C. Virus protection
D. Hardware upgrades

17. Data mining is used to:
A. Delete data
B. Discover patterns
C. Encrypt files
D. Compress storage

18. Big data is characterized by:
A. Small volume
B. Structured format only
C. High volume, velocity, variety
D. Manual processing

19. RAID improves:
A. Data redundancy and performance
B. CPU speed
C. Internet bandwidth
D. Software licensing

20. Which storage is non-volatile?
A. RAM
B. Cache
C. ROM
D. Registers

21. Which device performs arithmetic and logical operations?
A. SSD
B. ALU
C. BIOS
D. Router

22. Virtualization allows:
A. One OS per server only
B. Multiple virtual machines on one physical machine
C. Manual backups
D. Slower systems

, 23. A hypervisor is used to:
A. Manage virtual machines
B. Encrypt emails
C. Monitor spam
D. Create spreadsheets

24. Green computing focuses on:
A. Faster processing
B. Environmental responsibility
C. Larger data centers
D. More power usage

25. Which device connects multiple networks?
A. Switch
B. Hub
C. Router
D. Repeater

26. Which network topology fails completely if the main backbone cable breaks?
A. Star
B. Bus
C. Mesh
D. Hybrid

27. In a star topology, the central connecting device is typically a:
A. Router
B. Switch
C. Modem
D. Firewall

28. Which protocol is used to manage devices on IP networks?
A. HTTP
B. FTP
C. SNMP
D. SMTP

29. HTTPS differs from HTTP because it:
A. Uses encryption
B. Transfers files
C. Is slower
D. Uses UDP

30. Which protocol sends email between servers?
A. POP3
B. IMAP