1Z1-171 試験問題を無料オンラインアクセス

Which function is used to convert a string to uppercase in SQL?

• A.TO_UPPERCASE
• B.CONVERT_UPPER
• C.UPPER
• D.CASE_UPPER

Which command creates a new role in Oracle Database?

• A.ADD ROLE role_name;
• B.CREATE NEW ROLE role_name;
• C.CREATE ROLE role_name;

What is the result of the following query?
SELECT employee_id
FROM employees
WHERE EXISTS (SELECT 1 FROM departments WHERE department_id = 10);

• A.All employee IDs
• B.Employee IDs from department 10
• C.Employees with salaries greater than 10
• D.Employee IDs from departments with no employees

What is a subquery in SQL?

• A.A query used to create a table
• B.A query used for joining two or more tables
• C.A query inside another query
• D.A query that combines data from multiple tables

Which SQL keyword is used to remove duplicate rows from the result set of a query?

• A.DISTINCT
• B.ONLY
• C.UNIQUE
• D.DISTINCTROW