Exploring Data Types and Queries

What is the primary data type used to represent whole numbers in Python?

• string

• int

• float

• boolean

Which data type in Python is used to represent text?

• float

• list

• str

• int

What is the data type used for floating-point numbers in Python?

• integer

• float

• string

• decimal

In Python, what is the data type for a single character?

• boolean

• string

• float

• integer

What is the Boolean data type in Python used to represent?

• Integer values, specifically 0 and 1

• String values, such as 'yes' and 'no'

• Floating-point numbers, like 1.0 and 2.5

• Truth values, specifically 'True' and 'False'

What SQL command is used to retrieve data from a database?

• SELECT

• RETRIEVE

• FETCH

• GET

Which SQL clause is used to filter records in a query?

• SELECT

• WHERE

• JOIN

• HAVING

What is the purpose of the SQL 'ORDER BY' clause?

• To limit the number of rows returned by a query.

• To sort the result set of a query.

• To group the result set of a query.

• To filter the result set of a query.

In SQL, which keyword is used to specify a condition in a query?

• GROUP BY

• SELECT

• WHERE

• FILTER

What does the SQL 'GROUP BY' clause do?

• The 'GROUP BY' clause groups rows that have the same values in specified columns into summary rows.

• The 'GROUP BY' clause combines all rows into a single row regardless of their values.

• The 'GROUP BY' clause filters out duplicate rows from the result set.

• The 'GROUP BY' clause sorts the rows in ascending order.