Master CompTIA ITF+ Fundamentals Part 4 Quiz

1. What is the basic purpose of a SELECT statement in SQL?

To insert new records into a table

To retrieve data from one or more database tables

To delete records from a table

To modify the structure of a database

Submit

5. In a database table storing employee information, which data type is most appropriate for storing an employee's email address?

Integer

Boolean

String

Date

6. Which scenario best represents an advantage of cloud-based software?

Works offline without any internet connection

Automatic updates and access from any device with internet

No recurring subscription costs

Faster processing than local installation

7. Which of the following is a typical bandwidth specification for a standard home internet connection?

50 Gbps

500 Mbps

1 Tbps

10 Kbps

8. A signal that continuously varies in amplitude and frequency is classified as which type?

Digital signal

Analog signal

Binary signal

Discrete signal

9. Which clause in a SELECT statement is used to filter records based on specific conditions?

FROM

ORDER BY

WHERE

GROUP BY

10. In the SQL statement SELECT * FROM Employees, what does the asterisk (*) represent?

All rows in the table

All columns in the table

A wildcard for any character

A multiplication operator

11. Which of the following best describes the difference between analog and digital signals?

Analog signals are continuous; digital signals are discrete (on/off)

Analog signals are faster than digital signals

Digital signals cannot travel long distances

Analog signals use only two voltage levels

12. In a database, which data type would you use to store a customer's age?

String

Boolean

Integer

Date

13. A boolean data type can hold which of the following values?

Any number between 0 and 1

Only true or false

Any text string

Only positive integers

14. What is the primary purpose of a string data type?

To store numerical calculations

To store sequences of text characters

To store only true or false values

To store floating-point decimal numbers

15. In programming, an integer data type is best used to store which of the following?

Decimal numbers like 3.14

Whole numbers like 42 or -7

Text characters like 'hello'

True or false values

16. What is a key disadvantage of locally installed software compared to cloud-based alternatives?

Local software requires internet connectivity to function

Local software must be manually updated on each device

Local software cannot be customized

Local software is always slower than cloud solutions

17. Which statement about cloud-based software is correct?

Cloud software is stored on your local computer

Cloud software is accessed via the internet and hosted on remote servers

Cloud software cannot be updated without reinstalling

Cloud software is always more expensive than locally installed software

18. A network connection provides 500 Mbps of bandwidth. How many Gbps is this?

0.5 Gbps

5 Gbps

50 Gbps

500 Gbps

19. Mbps stands for megabits per second. How many megabits equal one gigabit?

100 Mbps

500 Mbps

1,000 Mbps

10,000 Mbps

20. What is the primary advantage of digital signals over analog signals in modern computing?

Digital signals are easier to amplify without noise

Digital signals require less bandwidth

Digital signals are immune to electrical noise and interference

Digital signals travel at the speed of light

Master Quiz CompTIA IT Fundamentals Plus Part 4