最新の1Z0-171合格保証付き試験問題集の認定サンプル問題 [Q40-Q54]

質問40、 What does the following query return?
SELECT ROUND(123.456, 1) AS rounded_value FROM dual;

質問41、 Which SQL statement is used to insert a new row into a table?

質問42、 The column data type is converted to a primary key.

質問43、 Which command grants a user the ability to query data from a specific table?

質問44、 Which function is used to extract the year from a date in SQL?

質問45、 What is a SELF JOIN in SQL?

質問46、 Which clause can be used with SET operators to sort the final result set?

質問47、 Which type of join retrieves only the rows with matching values in both tables?

質問48、 What happens if a privilege is revoked from a user who has granted the same privilege to others?

質問49、 What does the following SQL query do?
SELECT * FROM employees WHERE salary > 5000 ORDER BY department_id;

質問50、 What is the purpose of the MERGE statement in SQL?

質問51、 Which command is used to add a new column to an existing table?

質問52、 Which SQL function converts a string representation of a date into a date data type?

質問53、 What does the following SQL query return?
SELECT employee_id, salary * 12 AS annual_salary FROM employees;

質問54、 Which of the following data dictionary views provides information about constraints on tables?