Test Your Oracle STRING Functions Knowledge: Quiz

Progress

True / False

In Oracle, the UPPER function converts all characters in a string to uppercase.

True False

The UPPER function takes a string and converts all its characters to uppercase.

True / False

The LOWER function in Oracle converts all characters in a string to lowercase.

True False

The LOWER function converts all characters in a string to lowercase.

True / False

In Oracle, the LENGTH function returns the number of characters in a string.

True False

The LENGTH function returns the length of a string, measured in the number of characters.

True / False

In Oracle, the SUBSTR function extracts a substring from a string, starting at a specified position and for a specified length.

True False

The SUBSTR function extracts a substring from a given string starting at a specified position for a specified length.

True / False

The INSTR function in Oracle returns the position of a specified substring within a string, or zero if the substring is not found.

True False

The INSTR function returns the position of the first occurrence of a specified substring within a string, or zero if it is not found.

True / False

In Oracle, the TRIM function removes leading and trailing spaces from a string.

True False

The TRIM function removes leading and trailing spaces (or other specified characters) from a string.

True / False

In Oracle, the REPLACE function can be used to replace all occurrences of a substring within a string with another substring.

True False

The REPLACE function replaces all occurrences of a specified substring within a string with another substring.

True / False

The REGEXP_SUBSTR function in Oracle is used to extract a substring from a string using regular expressions.

True False

The REGEXP_SUBSTR function extracts a substring from a string based on a regular expression pattern.

True / False

In Oracle, the CONCAT function can concatenate more than two strings in a single call.

True False

The CONCAT function in Oracle can only concatenate two strings at a time. To concatenate more than two strings, multiple CONCAT calls or the || operator must be used.

Q10

True / False

The Oracle Certified Professional (OCP) exam includes knowledge on using string functions effectively, understanding their syntax, and optimizing their performance in SQL queries.

True False

The OCP certification covers advanced topics, including the effective use of string functions, understanding their syntax, and optimizing their performance in SQL queries.

Q11

Single Choice

Which Oracle SQL function is used to return the length of a string?

SUBSTR LENGTH CONCATINSTR

The LENGTH function in Oracle returns the number of characters in a string.

Q12

Single Choice

What will be the result of the following Oracle SQL expression?

SQL Code

SELECT UPPER('oracle') FROM dual;

oracle ORACLE Oracleoracle SQL

The UPPER function converts all characters in a string to uppercase.

Q13

Single Choice

Which Oracle SQL function can you use to concatenate two strings?

CONCAT SUBSTR LENGTHINSTR

The CONCAT function in Oracle is used to join two strings together.

Q14

Single Choice

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

SQL Code

SELECT SUBSTR('ORACLE SQL', 8, 3) FROM dual;

SQL ORA CLERAC

The SUBSTR function extracts a substring starting from the 8th character and returns the next 3 characters, which is SQL.

Q15

Single Choice

Which Oracle SQL function is used to find the position of a substring within a string?

LENGTH SUBSTR INSTRTRIM

The INSTR function returns the position of a substring within a string, starting from a specified position.

Q16

Single Choice

Given the Oracle SQL query:What will be the result?

Oracle Ora ***OracleOracle****

The RPAD function pads the string 'Oracle' with * characters on the right to a total length of 10 characters.

Q17

Single Choice

What will be the result of the following Oracle SQL query?

SQL Code

SELECT REPLACE('ORACLE SQL', 'SQL', 'PL/SQL') FROM dual;

ORACLE PL/SQL PL/SQL ORACLE ORACLE SQLPL/SQL

The REPLACE function replaces all occurrences of the substring 'SQL' with 'PL/SQL' in the given string.

Q18

Single Choice

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

SQL Code

SELECT INITCAP('oracle sql functions') FROM dual;

ORACLE SQL FUNCTIONS oracle sql functions Oracle Sql FunctionsORACLE SQL

The INITCAP function capitalizes the first letter of each word in the string, converting the remaining letters to lowercase.

Q19

Single Choice

Which Oracle SQL function can be used to remove leading and trailing spaces from a string?

SUBSTR TRIM LPADLENGTH

The TRIM function removes specified characters (by default, spaces) from both the beginning and the end of a string.

Q20

Single Choice

What is the result of the following Oracle SQL query?

SQL Code

SELECT REGEXP_REPLACE('Oracle 123 PL/SQL', '[0-9]', '') FROM dual;

Oracle PL/SQL Oracle 123 PL/SQL Oracle PL/SQL 123Oracle123PL/SQL

The REGEXP_REPLACE function replaces all occurrences of the pattern [0-9] (any digit) with an empty string, effectively removing all digits from the string.

Q21

Multiple Choice

Which SQL code snippet uses the `SUBSTR` function to extract the first 3 characters of the employee's first name in Oracle?

SQL Code

SELECT employee_id, first_name, SUBSTR(first_name, 1, 3) AS short_name
FROM employees;

SELECT employee_id, first_name, SUBSTR(first_name, 1, 3) AS short_name
FROM employees;

SELECT employee_id, first_name, SUBSTR(first_name, 1, 3) AS short_name
FROM employees;

SELECT employee_id, first_name, SUBSTR(first_name, 1, 3) AS short_name FROM employees; SELECT employee_id, first_name, SUBSTR(first_name, 1, 3) AS short_name FROM employees; SELECT employee_id, first_name, SUBSTR(first_name, 1, 3) AS short_name FROM employees;SELECT employee_id, first_name FROM employees;

Options A, B, and C correctly demonstrate the use of the `SUBSTR` function to extract the first 3 characters of the employee's first name. Option D is incorrect because it does not use the `SUBSTR` function.

Q22

Multiple Choice

Which SQL code snippet uses the `INSTR` function to find the position of the letter 'a' in the employee's first name in Oracle?

SQL Code

SELECT employee_id, first_name, INSTR(first_name, 'a') AS position
FROM employees;

SELECT employee_id, first_name, INSTR(first_name, 'a') AS position
FROM employees;

SELECT employee_id, first_name, INSTR(first_name, 'a') AS position
FROM employees;

SELECT employee_id, first_name, INSTR(first_name, 'a') AS position FROM employees; SELECT employee_id, first_name, INSTR(first_name, 'a') AS position FROM employees; SELECT employee_id, first_name, INSTR(first_name, 'a') AS position FROM employees;SELECT employee_id, first_name FROM employees;

Options A, B, and C correctly demonstrate the use of the `INSTR` function to find the position of the letter 'a' in the employee's first name. Option D is incorrect because it does not use the `INSTR` function.

Q23

Multiple Choice

Which SQL code snippet uses the `LENGTH` function to determine the length of the employee's last name in Oracle?

SQL Code

SELECT employee_id, last_name, LENGTH(last_name) AS name_length
FROM employees;

SELECT employee_id, last_name, LENGTH(last_name) AS name_length
FROM employees;

SELECT employee_id, last_name, LENGTH(last_name) AS name_length
FROM employees;

SELECT employee_id, last_name, LENGTH(last_name) AS name_length FROM employees; SELECT employee_id, last_name, LENGTH(last_name) AS name_length FROM employees; SELECT employee_id, last_name, LENGTH(last_name) AS name_length FROM employees;SELECT employee_id, last_name FROM employees;

Options A, B, and C correctly demonstrate the use of the `LENGTH` function to determine the length of the employee's last name. Option D is incorrect because it does not use the `LENGTH` function.

Q24

Multiple Choice

Which SQL code snippet uses the `UPPER` function to convert the employee's last name to uppercase in Oracle?

SQL Code

SELECT employee_id, last_name, UPPER(last_name) AS upper_name
FROM employees;

SELECT employee_id, last_name, UPPER(last_name) AS upper_name
FROM employees;

SELECT employee_id, last_name, UPPER(last_name) AS upper_name
FROM employees;

SELECT employee_id, last_name, UPPER(last_name) AS upper_name FROM employees; SELECT employee_id, last_name, UPPER(last_name) AS upper_name FROM employees; SELECT employee_id, last_name, UPPER(last_name) AS upper_name FROM employees;SELECT employee_id, last_name FROM employees;

Options A, B, and C correctly demonstrate the use of the `UPPER` function to convert the employee's last name to uppercase. Option D is incorrect because it does not use the `UPPER` function.

Q25

Multiple Choice

Which SQL code snippet uses the `LOWER` function to convert the department name to lowercase in Oracle?

SQL Code

SELECT department_id, department_name, LOWER(department_name) AS lower_name
FROM departments;

SELECT department_id, department_name, LOWER(department_name) AS lower_name
FROM departments;

SELECT department_id, department_name, LOWER(department_name) AS lower_name
FROM departments;

SELECT department_id, department_name, LOWER(department_name) AS lower_name FROM departments; SELECT department_id, department_name, LOWER(department_name) AS lower_name FROM departments; SELECT department_id, department_name, LOWER(department_name) AS lower_name FROM departments;SELECT department_id, department_name FROM departments;

Options A, B, and C correctly demonstrate the use of the `LOWER` function to convert the department name to lowercase. Option D is incorrect because it does not use the `LOWER` function.

Q26

Multiple Choice

Which SQL code snippet demonstrates advanced use of the `REPLACE` function to replace all occurrences of 'Inc.' with 'LLC' in the company names in Oracle?

SQL Code

SELECT company_id, company_name, REPLACE(company_name, 'Inc.', 'LLC') AS updated_name
FROM companies;

SELECT company_id, company_name, REPLACE(company_name, 'Inc.', 'LLC') AS updated_name
FROM companies;

SELECT company_id, company_name, REPLACE(company_name, 'Inc.', 'LLC') AS updated_name
FROM companies;

SELECT company_id, company_name, REPLACE(company_name, 'Inc.', 'LLC') AS updated_name FROM companies; SELECT company_id, company_name, REPLACE(company_name, 'Inc.', 'LLC') AS updated_name FROM companies; SELECT company_id, company_name, REPLACE(company_name, 'Inc.', 'LLC') AS updated_name FROM companies;SELECT company_id, company_name FROM companies;

Options A, B, and C correctly demonstrate advanced use of the `REPLACE` function to replace all occurrences of 'Inc.' with 'LLC' in the company names. Option D is incorrect because it does not use the `REPLACE` function.

Q27

Multiple Choice

Which SQL code snippet demonstrates advanced use of the `TRIM` function to remove leading and trailing spaces from the product names in Oracle?

SQL Code

SELECT product_id, product_name, TRIM(product_name) AS trimmed_name
FROM products;

SELECT product_id, product_name, TRIM(product_name) AS trimmed_name
FROM products;

SELECT product_id, product_name, TRIM(product_name) AS trimmed_name
FROM products;

SELECT product_id, product_name, TRIM(product_name) AS trimmed_name FROM products; SELECT product_id, product_name, TRIM(product_name) AS trimmed_name FROM products; SELECT product_id, product_name, TRIM(product_name) AS trimmed_name FROM products;SELECT product_id, product_name FROM products;

Options A, B, and C correctly demonstrate advanced use of the `TRIM` function to remove leading and trailing spaces from the product names. Option D is incorrect because it does not use the `TRIM` function.

Q28

Multiple Choice

Which SQL code snippet demonstrates certification-level use of the `CONCAT` function to concatenate first name and last name with a space in between in Oracle?

SQL Code

SELECT employee_id, first_name, last_name, CONCAT(first_name, ' ', last_name) AS full_name
FROM employees;

SELECT employee_id, first_name, last_name, CONCAT(first_name, ' ', last_name) AS full_name
FROM employees;

SELECT employee_id, first_name, last_name, CONCAT(first_name, ' ', last_name) AS full_name
FROM employees;

SELECT employee_id, first_name, last_name, CONCAT(first_name, ' ', last_name) AS full_name FROM employees; SELECT employee_id, first_name, last_name, CONCAT(first_name, ' ', last_name) AS full_name FROM employees; SELECT employee_id, first_name, last_name, CONCAT(first_name, ' ', last_name) AS full_name FROM employees;SELECT employee_id, first_name, last_name FROM employees;

Options A, B, and C correctly demonstrate certification-level use of the `CONCAT` function to concatenate first name and last name with a space in between. Option D is incorrect because it does not use the `CONCAT` function.

Q29

Multiple Choice

Which SQL code snippet demonstrates certification-level use of the `LPAD` function to pad the department names with leading asterisks in Oracle?

SQL Code

SELECT department_id, department_name, LPAD(department_name, 15, '*') AS padded_name
FROM departments;

SELECT department_id, department_name, LPAD(department_name, 15, '*') AS padded_name
FROM departments;

SELECT department_id, department_name, LPAD(department_name, 15, '*') AS padded_name
FROM departments;

SELECT department_id, department_name, LPAD(department_name, 15, '*') AS padded_name FROM departments; SELECT department_id, department_name, LPAD(department_name, 15, '*') AS padded_name FROM departments; SELECT department_id, department_name, LPAD(department_name, 15, '*') AS padded_name FROM departments;SELECT department_id, department_name FROM departments;

Options A, B, and C correctly demonstrate certification-level use of the `LPAD` function to pad the department names with leading asterisks. Option D is incorrect because it does not use the `LPAD` function.

Q30

Multiple Choice

Which SQL code snippet demonstrates certification-level use of the `INITCAP` function to capitalize the first letter of each word in the project titles in Oracle?

SQL Code

SELECT project_id, project_title, INITCAP(project_title) AS formatted_title
FROM projects;

SELECT project_id, project_title, INITCAP(project_title) AS formatted_title
FROM projects;

SELECT project_id, project_title, INITCAP(project_title) AS formatted_title
FROM projects;

SELECT project_id, project_title, INITCAP(project_title) AS formatted_title FROM projects; SELECT project_id, project_title, INITCAP(project_title) AS formatted_title FROM projects; SELECT project_id, project_title, INITCAP(project_title) AS formatted_title FROM projects;SELECT project_id, project_title FROM projects;

Options A, B, and C correctly demonstrate certification-level use of the `INITCAP` function to capitalize the first letter of each word in the project titles. Option D is incorrect because it does not use the `INITCAP` function.

Oracle Database Quiz Questions