Test Your Oracle NOT LIKE Operator Knowledge with This SQL Quiz

Progress

True / False

The NOT LIKE operator in Oracle is used to exclude rows that match a specified pattern.

True False

The NOT LIKE operator is used to filter out rows that match a specified pattern.

True / False

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

True False

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

True / False

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

True False

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

True / False

The NOT LIKE operator in Oracle is case-sensitive by default.

True False

The NOT LIKE operator is case-sensitive by default. 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 NOT 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 NOT LIKE operator can be used with numeric data types in Oracle.

True False

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

True / False

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

True False

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

True / False

Using the NOT 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 NOT LIKE operator can be used in subqueries to filter rows based on pattern matching in the subquery results.

True False

The NOT 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 NOT 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 NOT LIKE operator, optimizing its performance, and understanding its impact on SQL queries.

Q11

Single Choice

What will the following Oracle SQL query return?

SQL Code

SELECT employee_name
FROM employees
WHERE employee_name NOT LIKE 'J%';

Employees whose names start with 'J' Employees whose names do not start with 'J' Employees whose names contain 'J'Employees whose names do not contain 'J'

The NOT LIKE 'J%' pattern excludes any employee name that starts with 'J'.

Q12

Single Choice

Which of the following Oracle SQL queries retrieves products whose names do not contain the word 'Phone'?

SQL Code

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

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

The NOT LIKE '%Phone%' pattern excludes any product name that contains the word 'Phone'.

Q13

Single Choice

What does the following Oracle SQL query do?

SQL Code

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

Selects departments where the name starts with 'R' Selects departments where the name does not start with 'R' Selects departments where the second character is 'R'Selects departments where the second character is not 'R'

The NOT LIKE '_R%' pattern excludes any department name where 'R' is the second character.

Q14

Single Choice

Which of the following Oracle SQL queries selects employees whose names do not end with 'son'?

SQL Code

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

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

The NOT LIKE '%son' pattern excludes 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 NOT LIKE 'M%';

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

The NOT LIKE 'M%' pattern excludes any customer name that starts with 'M'.

Q16

Single Choice

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

SQL Code

SELECT employee_name
FROM employees
WHERE employee_name NOT LIKE '_____';

It selects all employees whose names have 5 characters It selects all employees whose names do not have 5 characters It selects all employees whose names start with 5 lettersIt selects all employees whose names end with 5 characters

The NOT LIKE '_____' pattern excludes any employee name that is exactly 5 characters long.

Q17

Single Choice

What will the following Oracle SQL query return?

SQL Code

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

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

The NOT LIKE '%ville' pattern excludes 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 NOT LIKE '%Table%Chair%';

Selects products that contain both 'Table' and 'Chair' in that order Selects products that contain 'Table' but not 'Chair' Selects products that contain 'Chair' but not 'Table'Selects products that do not contain both 'Table' and 'Chair' in that order

The NOT LIKE '%Table%Chair%' pattern excludes any product name that contains both 'Table' and 'Chair' in the specified order.

Q19

Single Choice

What will the following Oracle SQL query return?

SQL Code

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

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

The NOT LIKE 'Jo%n' pattern excludes any employee name that starts with 'Jo' and ends with 'n'.

Q20

Single Choice

Which of the following Oracle SQL statements will return records where the order_description does not contain 'urgent' and does not end with 'today'?

SQL Code

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

Orders containing 'urgent' but not 'today' Orders that do not contain 'urgent' and do not end with 'today' Orders ending with 'today' but not containing 'urgent'Orders containing 'urgent' but not ending with 'today'

The NOT LIKE '%urgent%today' pattern excludes any order_description that contains 'urgent' and ends with 'today'.

Q21

Multiple Choice

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

SQL Code

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

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

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

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

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

Q22

Multiple Choice

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

SQL Code

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

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

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

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

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

Q23

Multiple Choice

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

SQL Code

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

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

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

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

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

Q24

Multiple Choice

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

SQL Code

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

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

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

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

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

Q25

Multiple Choice

Which SQL code snippet uses the NOT LIKE operator to filter inventory items where the SKU does not contain 'ABC' in Oracle?

SQL Code

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

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

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

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

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

Q26

Multiple Choice

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

SQL Code

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

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

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

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

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

Q27

Multiple Choice

Which SQL code snippet uses the NOT LIKE operator to filter orders where the customer name does not include 'John' in Oracle?

SQL Code

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

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

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

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

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

Q28

Multiple Choice

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

SQL Code

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

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

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

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

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

Q29

Multiple Choice

Which SQL code snippet uses the NOT LIKE operator to filter customers whose address does not contain 'Street' in Oracle?

SQL Code

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

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

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

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

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

Q30

Multiple Choice

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

SQL Code

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

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

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

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

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

Oracle Database Quiz Questions