Test: SQL Operators - 1 - Software Development MCQ

The equals operator (=) is used to compare two values for equality in SQL. It returns true if the values are equal and false otherwise.

The not equals operator (<> or !=) is used to check if a value is not equal to another value in SQL. It returns true if the values are not equal and false if they are equal.

The greater than operator (>) is used to compare two values in SQL and check if one value is greater than the other.

The BETWEEN operator is used to check if a value falls within a specified range. It is commonly used with numerical and date values.

The LIKE operator is used to check if a value matches a specified pattern in SQL. It is commonly used with string values and supports wildcard characters.

The query selects all rows from the "employees" table where the "salary" column is greater than 50000. Therefore, the output will be employees with a salary greater than 50000.

The query selects all rows from the "customers" table where the "country" column is equal to 'USA'. Therefore, the output will be customers from the USA.

The query selects all rows from the "products" table where the "category" column is either 'Electronics' or 'Appliances'. Therefore, the output will be products belonging to either the 'Electronics' or 'Appliances' category.

The query selects all rows from the "orders" table where the "order_date" column falls between '2022-01-01' and '2022-12-31'. Therefore, the output will be orders placed between 2022-01-01 and 2022-12-31.

The query selects all rows from the "products" table where the "product_name" column starts with 'Ap'. Therefore, the output will be products with a name starting with 'Ap'.

The query selects all rows from the "employees" table where the "salary" column falls between 30000 and 40000 (inclusive). Therefore, the output will be employees with a salary between 30000 and 40000.

The query selects all rows from the "customers" table where the "country" column is not equal to 'USA' and the "city" column is equal to 'London'. Therefore, the output will be customers from countries other than the USA and with a city name of London.

The query selects all rows from the "orders" table where the "order_date" column is greater than '2022-01-01' and orders the results in descending order of the "order_date" column. Therefore, the output will be orders placed after 2022-01-01 in descending order of date.

The query selects all rows from the "products" table where the "product_name" column contains the word 'book' anywhere in the name. Therefore, the output will be products with a name containing 'book'.

The query selects all rows from the "orders" table where the "order_id" column matches any "order_id" values returned by the subquery, which selects order IDs from the "order_items" table where the "quantity" is greater than 10. Therefore, the output will be orders with at least one order item having a quantity greater than 10.