Test Your Oracle LIKE Operator Skills with Our Quiz

Progress

True / False

The LIKE operator in Oracle is used to search for a specified pattern in a column.

True False

The LIKE operator is used to search for a specified pattern in a column's values.

True / False

In Oracle, the percent sign (%) is used as a wildcard character in the LIKE operator to match zero or more characters.

True False

The percent sign (%) is a wildcard that matches zero or more characters in the pattern.

True / False

The underscore (_) is used as a wildcard character in the LIKE operator to match exactly one character in Oracle.

True False

The underscore (_) matches exactly one character in the pattern.

True / False

The LIKE operator in Oracle is case-insensitive by default.

True False

The LIKE operator is case-sensitive by default in Oracle. To perform case-insensitive searches, you need to use functions like UPPER or LOWER.

True / False

In Oracle, you can use the ESCAPE keyword with the LIKE operator to search for wildcard characters as literals.

True False

The ESCAPE keyword allows you to specify an escape character that can be used to search for wildcard characters as literals.

True / False

The LIKE operator can be used with numeric data types in Oracle.

True False

The LIKE operator is used with character data types. Numeric data types need to be converted to character types to use LIKE.

True / False

In Oracle, the LIKE operator can be used in combination with the AND and OR operators to create complex search conditions.

True False

The LIKE operator can be combined with AND and OR operators to create complex search conditions in the WHERE clause.

True / False

Using the LIKE operator with leading wildcards (e.g., %pattern) can impact query performance in Oracle.

True False

Using leading wildcards can impact performance because it prevents the use of indexes and requires a full table scan.

True / False

In Oracle, the LIKE operator can be used in subqueries to filter rows based on pattern matching in the subquery results.

True False

The LIKE operator can be used in subqueries to filter rows based on pattern matching.

Q10

True / False

The Oracle Certified Professional (OCP) exam includes knowledge on using the LIKE operator effectively, optimizing its performance, and understanding its impact on SQL queries.

True False

The OCP certification covers advanced topics, including the effective use of the LIKE operator, optimizing its performance, and understanding its impact on SQL queries.

Q11

Single Choice

What does the following Oracle SQL query do?

SQL Code

SELECT employee_name
FROM employees
WHERE employee_name LIKE 'A%';

Selects employees whose names start with 'A' Selects employees whose names contain 'A' Selects employees whose names end with 'A'Selects employees whose names do not contain 'A'

The LIKE operator with 'A%' matches any name that starts with 'A', where '%' is a wildcard for any sequence of characters.

Q12

Single Choice

In Oracle SQL, which query retrieves all product names that contain the word 'Phone'?

SQL Code

SELECT product_name
FROM products
WHERE product_name LIKE '%Phone%';

It retrieves all product names that start with 'Phone' It retrieves all product names that end with 'Phone' It retrieves all product names that contain 'Phone'It retrieves all product names that do not contain 'Phone'

The %Phone% pattern in the LIKE operator matches any product name that contains the substring 'Phone' anywhere in the string.

Q13

Single Choice

What will the following Oracle SQL query return?

SQL Code

SELECT department_name
FROM departments
WHERE department_name LIKE '_R%';

Departments where the name ends with 'R' Departments where the name starts with 'R' Departments where the second character is 'R'Departments where the name contains 'R' anywhere

The underscore '_' is a wildcard that matches exactly one character, so '_R%' matches any department name where 'R' is the second character.

Q14

Single Choice

Which of the following Oracle SQL queries will select employees whose names end with 'son'?

SQL Code

SELECT employee_name
FROM employees
WHERE employee_name LIKE '%son';

Selects employees whose names start with 'son' Selects employees whose names contain 'son' Selects employees whose names end with 'son'Selects employees whose names do not contain 'son'

The LIKE pattern '%son' matches any employee name that ends with 'son'.

Q15

Single Choice

What will the following Oracle SQL query return?

SQL Code

SELECT customer_name
FROM customers
WHERE customer_name LIKE 'M_%';

Customers whose names start with 'M' Customers whose names end with 'M' Customers whose names have 'M' as the second characterCustomers whose names contain 'M'

The 'M_%' pattern matches any name that starts with 'M' followed by at least one more character.

Q16

Single Choice

In Oracle SQL, how would you find all employees whose names have exactly 5 characters?

SQL Code

SELECT employee_name
FROM employees
WHERE employee_name LIKE '_____';

It selects all employees whose names start with 5 letters It selects all employees whose names have 5 characters It selects all employees whose names end with 5 charactersIt selects all employees whose names contain 5 letters anywhere

The LIKE pattern with exactly 5 underscores '_____' matches names that are exactly 5 characters long.

Q17

Single Choice

What will the following Oracle SQL query return?

SQL Code

SELECT city
FROM locations
WHERE city LIKE '%ville';

Cities that contain 'ville' anywhere in the name Cities that end with 'ville' Cities that start with 'ville'Cities that do not contain 'ville'

The '%ville' pattern matches any city name that ends with 'ville'.

Q18

Single Choice

Consider the following Oracle SQL query:What does this query return?

SQL Code

SELECT product_name
FROM products
WHERE product_name LIKE '%Table%Chair%';

Selects products containing 'Table' but not 'Chair' Selects products containing 'Chair' but not 'Table' Selects products containing both 'Table' and 'Chair' anywhere in the nameSelects products that do not contain 'Table' or 'Chair'

The '%Table%Chair%' pattern matches any product name containing both 'Table' and 'Chair' in that order.

Q19

Single Choice

What will the following Oracle SQL query return?

SQL Code

SELECT employee_name
FROM employees
WHERE employee_name LIKE 'Jo%n';

Employees whose names start with 'Jo' and end with 'n' Employees whose names contain 'Jo' anywhere Employees whose names contain 'n' anywhereEmployees whose names do not contain 'n'

The 'Jo%n' pattern matches any name starting with 'Jo' and ending with 'n', with any number of characters in between.

Q20

Single Choice

Which of the following Oracle SQL statements will return records where the order_description contains 'urgent' and ends with 'today'?

SQL Code

SELECT order_id, order_description
FROM orders
WHERE order_description LIKE '%urgent%today';

Orders containing 'urgent' but not 'today' Orders ending with 'today' but not containing 'urgent' Orders containing 'urgent' and ending with 'today'Orders starting with 'urgent' and containing 'today'

The '%urgent%today' pattern matches any order_description that contains 'urgent' anywhere in the text and ends with 'today'.

Q21

Multiple Choice

Which SQL code snippet correctly uses the LIKE operator to filter employees whose name starts with 'A' in Oracle?

SQL Code

SELECT *
FROM employees
WHERE name LIKE 'A%';

SELECT *
FROM employees
WHERE name LIKE '%A';

SELECT employee_id, name
FROM employees
WHERE name LIKE 'A%';

SELECT * FROM employees WHERE name LIKE 'A%'; SELECT * FROM employees WHERE name LIKE '%A'; SELECT employee_id, name FROM employees WHERE name LIKE 'A%';SELECT * FROM employees WHERE name LIKE '_A%';

Options A and C correctly use the LIKE operator with 'A%' to filter employees whose name starts with 'A'. Option B incorrectly filters for names ending with 'A'.

Q22

Multiple Choice

Which SQL code snippet demonstrates how to use the LIKE operator to filter orders where the order ID contains '123' in Oracle?

SQL Code

SELECT *
FROM orders
WHERE order_id LIKE '%123%';

SELECT *
FROM orders
WHERE order_id LIKE '123%';

SELECT order_id, status
FROM orders
WHERE order_id LIKE '%123%';

SELECT * FROM orders WHERE order_id LIKE '%123%'; SELECT * FROM orders WHERE order_id LIKE '123%'; SELECT order_id, status FROM orders WHERE order_id LIKE '%123%';SELECT * FROM orders WHERE order_id LIKE '123';

Options A and C correctly use the LIKE operator with '%123%' to filter orders where the order ID contains '123'. Option B incorrectly filters for order IDs starting with '123'.

Q23

Multiple Choice

Which SQL code snippet uses the LIKE operator to filter products where the product name ends with 'Pro' in Oracle?

SQL Code

SELECT *
FROM products
WHERE product_name LIKE '%Pro';

SELECT *
FROM products
WHERE product_name LIKE 'Pro%';

SELECT product_id, product_name
FROM products
WHERE product_name LIKE '%Pro';

SELECT * FROM products WHERE product_name LIKE '%Pro'; SELECT * FROM products WHERE product_name LIKE 'Pro%'; SELECT product_id, product_name FROM products WHERE product_name LIKE '%Pro';SELECT * FROM products WHERE product_name LIKE '%Pro%';

Options A and C correctly use the LIKE operator with '%Pro' to filter products where the product name ends with 'Pro'. Option B incorrectly filters for product names starting with 'Pro'.

Q24

Multiple Choice

Which SQL code snippet demonstrates how to use the LIKE operator to filter customers whose phone number starts with '555' in Oracle?

SQL Code

SELECT *
FROM customers
WHERE phone_number LIKE '555%';

SELECT *
FROM customers
WHERE phone_number LIKE '%555';

SELECT customer_id, phone_number
FROM customers
WHERE phone_number LIKE '555%';

SELECT * FROM customers WHERE phone_number LIKE '555%'; SELECT * FROM customers WHERE phone_number LIKE '%555'; SELECT customer_id, phone_number FROM customers WHERE phone_number LIKE '555%';SELECT * FROM customers WHERE phone_number LIKE '%555%';

Options A and C correctly use the LIKE operator with '555%' to filter customers whose phone number starts with '555'. Option B incorrectly filters for phone numbers ending with '555'.

Q25

Multiple Choice

Which SQL code snippet uses the LIKE operator to filter inventory items where the SKU contains 'ABC' in Oracle?

SQL Code

SELECT *
FROM inventory
WHERE sku LIKE '%ABC%';

SELECT *
FROM inventory
WHERE sku LIKE 'ABC%';

SELECT item_id, sku
FROM inventory
WHERE sku LIKE '%ABC%';

SELECT * FROM inventory WHERE sku LIKE '%ABC%'; SELECT * FROM inventory WHERE sku LIKE 'ABC%'; SELECT item_id, sku FROM inventory WHERE sku LIKE '%ABC%';SELECT * FROM inventory WHERE sku LIKE 'ABC';

Options A and C correctly use the LIKE operator with '%ABC%' to filter inventory items where the SKU contains 'ABC'. Option B incorrectly filters for SKUs starting with 'ABC'.

Q26

Multiple Choice

Which SQL code snippet demonstrates advanced use of the LIKE operator to filter employees whose email domain is '@example.com' in Oracle?

SQL Code

SELECT *
FROM employees
WHERE email LIKE '%@example.com';

SELECT *
FROM employees
WHERE email LIKE '@example.com%';

SELECT employee_id, email
FROM employees
WHERE email LIKE '%@example.com';

SELECT * FROM employees WHERE email LIKE '%@example.com'; SELECT * FROM employees WHERE email LIKE '@example.com%'; SELECT employee_id, email FROM employees WHERE email LIKE '%@example.com';SELECT * FROM employees WHERE email LIKE '%@example.com%';

Options A and C correctly use the LIKE operator with '%@example.com' to filter employees whose email domain is '@example.com'. Option B incorrectly filters for emails starting with '@example.com'.

Q27

Multiple Choice

Which SQL code snippet uses the LIKE operator to filter orders where the customer name includes 'John' in Oracle?

SQL Code

SELECT *
FROM orders
WHERE customer_name LIKE '%John%';

SELECT *
FROM orders
WHERE customer_name LIKE 'John%';

SELECT order_id, customer_name
FROM orders
WHERE customer_name LIKE '%John%';

SELECT * FROM orders WHERE customer_name LIKE '%John%'; SELECT * FROM orders WHERE customer_name LIKE 'John%'; SELECT order_id, customer_name FROM orders WHERE customer_name LIKE '%John%';SELECT * FROM orders WHERE customer_name LIKE '%John';

Options A and C correctly use the LIKE operator with '%John%' to filter orders where the customer name includes 'John'. Option B incorrectly filters for customer names starting with 'John'.

Q28

Multiple Choice

Which SQL code snippet demonstrates advanced use of the LIKE operator to filter products whose description starts with 'New' in Oracle?

SQL Code

SELECT *
FROM products
WHERE description LIKE 'New%';

SELECT *
FROM products
WHERE description LIKE '%New';

SELECT product_id, description
FROM products
WHERE description LIKE 'New%';

SELECT * FROM products WHERE description LIKE 'New%'; SELECT * FROM products WHERE description LIKE '%New'; SELECT product_id, description FROM products WHERE description LIKE 'New%';SELECT * FROM products WHERE description LIKE '%New%';

Options A and C correctly use the LIKE operator with 'New%' to filter products whose description starts with 'New'. Option B incorrectly filters for descriptions ending with 'New'.

Q29

Multiple Choice

Which SQL code snippet uses the LIKE operator to filter customers whose address contains 'Street' in Oracle?

SQL Code

SELECT *
FROM customers
WHERE address LIKE '%Street%';

SELECT *
FROM customers
WHERE address LIKE 'Street%';

SELECT customer_id, address
FROM customers
WHERE address LIKE '%Street%';

SELECT * FROM customers WHERE address LIKE '%Street%'; SELECT * FROM customers WHERE address LIKE 'Street%'; SELECT customer_id, address FROM customers WHERE address LIKE '%Street%';SELECT * FROM customers WHERE address LIKE '%Street';

Options A and C correctly use the LIKE operator with '%Street%' to filter customers whose address contains 'Street'. Option B incorrectly filters for addresses starting with 'Street'.

Q30

Multiple Choice

Which SQL code snippet demonstrates the certification-level use of the LIKE operator to filter transactions where the transaction code starts with 'TXN' in Oracle?

SQL Code

SELECT *
FROM transactions
WHERE transaction_code LIKE 'TXN%';

SELECT *
FROM transactions
WHERE transaction_code LIKE '%TXN';

SELECT transaction_id, transaction_code
FROM transactions
WHERE transaction_code LIKE 'TXN%';

SELECT * FROM transactions WHERE transaction_code LIKE 'TXN%'; SELECT * FROM transactions WHERE transaction_code LIKE '%TXN'; SELECT transaction_id, transaction_code FROM transactions WHERE transaction_code LIKE 'TXN%';SELECT * FROM transactions WHERE transaction_code LIKE '%TXN%';

Options A and C correctly use the LIKE operator with 'TXN%' to filter transactions where the transaction code starts with 'TXN'. Option B incorrectly filters for transaction codes ending with 'TXN'.

Oracle Database Quiz Questions