Practice questions, with answers and explanations included

Convert: 5120 KB = ______ MB.

An attribute used in the GROUP BY clause must also appear:

How many times does the loop body execute? for(int count=3; count<=15; count = count + 3)

A pen drive must be connected using a PS/2 port.

Convert: 2048 MB = ______ GB.

A SELECT query that finds no matching rows results in:

For String myString = "Computer Science"; what does myString.length() return?

What is the function of the Arithmetic Logic Unit (ALU)?

Convert: 3072 MB = ______ GB.

Using arithmetic operators (like *, +, -) is allowed directly within a SELECT clause, e.g., Salary*1.1 AS New_Salary.

For String myString = "Computer Science"; what does myString.toUpperCase() return?

Convert: 2 GB = ____ KB.

Convert: 4096 MB = ______ GB.

Boolean operators AND and OR can be used within a WHERE clause to combine multiple conditions.

For String myString = "Database System"; what does myString.length() return?

Explain the hierarchy of units used to measure storage capacity of a computer, starting from bits.

Convert: 5120 MB = ______ GB.

A nested (subquery) approach can always be rewritten using an equivalent JOIN-based query for these kinds of examples.

For String myString = "Database System"; what does myString.toUpperCase() return?

List and briefly describe five common input devices of a computer.