Fast2test 1Z1-171問題集でリアル試験問題でテストエンジン問題集でトレーニング
Oracle 1Z1-171テスト問題集とオンライン試験エンジン
質問 # 34
Which clause in a SQL SELECT statement is used to define the columns to be retrieved?
- A. FROM
- B. SELECT
- C. GROUP BY
- D. WHERE
正解：B
質問 # 35
What is a SELF JOIN in SQL?
- A. A join of a table with itself
- B. A join used for Cartesian products
- C. A join between tables with identical structures
- D. A join that does not require a WHERE clause
正解：A
質問 # 36
What is the result of the following query?
SELECT employee_id
FROM employees
WHERE EXISTS (SELECT 1 FROM departments WHERE department_id = 10);
- A. Employee IDs from department 10
- B. Employee IDs from departments with no employees
- C. Employees with salaries greater than 10
- D. All employee IDs
正解：D
質問 # 37
Which SQL statement is used to insert a new row into a table?
- A. ALTER
- B. SELECT
- C. INSERT
- D. UPDATE
正解：C
質問 # 38
How are NULL values treated in relational databases?
- A. NULL values are treated as zero.
- B. NULL values are treated as empty strings.
- C. NULL values are not allowed in relational databases.
- D. NULL values represent missing or unknown data.
正解：D
質問 # 39
Which SQL function converts a string representation of a date into a date data type?
- A. DATE_CONVERT
- B. CONVERT_TO_DATE
- C. TO_DATE
- D. CAST_TO_DATE
正解：C
質問 # 40
What does the INTERSECT operator do in SQL?
- A. Returns rows from the first query that are not present in the second query
- B. Combines rows from two queries and includes all duplicates
- C. Combines all rows from two queries without any conditions
- D. Returns rows that are present in both queries
正解：D
質問 # 41
What does the UNION ALL operation do when selecting matching columns from different tables?
SELECT employee_id, salary FROM employees
UNION ALL
SELECT employee_id, bonus FROM bonuses;
- A. Returns only the employees with salaries and bonuses
- B. Returns only employees with duplicate employee IDs in both tables
- C. Combines all employee IDs, salaries, and bonuses, including duplicates
- D. Combines the salaries and bonuses for employees, removing duplicates
正解：C
質問 # 42
Which component of an ERD (Entity-Relationship Diagram) represents the attributes of an entity?
- A. Ovals
- B. Rectangles
- C. Arrows
- D. Diamonds
正解：A
質問 # 43
How does SQL handle NULL values in arithmetic expressions?
- A. Produces a NULL result
- B. Treats them as zero
- C. Produces an error
- D. Treats them as the largest possible number
正解：A
質問 # 44
Which command is used to add a new column to an existing table?
- A. ADD COLUMN
- B. ALTER TABLE
- C. MODIFY COLUMN
- D. ALTER COLUMN
正解：B
質問 # 45
What is the primary purpose of a primary key in a relational database?
- A. To sort data in ascending order
- B. To establish relationships between tables
- C. To store duplicate data in a table
- D. To uniquely identify each record in a table
正解：D
質問 # 46
Which clause can be used with SET operators to sort the final result set?
- A. ORDER BY
- B. HAVING
- C. GROUP BY
- D. WHERE
正解：A
質問 # 47
Which data dictionary view provides information about all tables accessible to the current user?
- A. ALL_TABLES
- B. DBA_TABLES
- C. USER_TABLES
- D. SESSION_TABLES
正解：A
質問 # 48
Which SQL function calculates the number of months between two dates?
Response:
- A. DATE_DIFF
- B. DATE_CALC
- C. MONTHS_BETWEEN
- D. TIME_DIFF
正解：C
質問 # 49
What is the purpose of the DBA_OBJECTS data dictionary view?
- A. To show the current session details
- B. To provide information about all objects in the database
- C. To list all users in the database
- D. To monitor system performance
正解：B
質問 # 50
Which of the following statements is true about constraints in Oracle Database?
- A. Constraints can be added or modified using the ALTER TABLE statement.
- B. Constraints cannot reference other tables.
- C. Constraints can only be added when creating a table.
- D. Constraints are automatically dropped when rows are deleted.
正解：A
質問 # 51
Which SQL clause is used to specify the source table in a query?
- A. SELECT
- B. GROUP BY
- C. FROM
- D. WHERE
正解：C
質問 # 52
Which SQL keyword is used to remove duplicate rows from the result set of a query?
- A. ONLY
- B. DISTINCTROW
- C. DISTINCT
- D. UNIQUE
正解：C
質問 # 53
What does the following SQL query do?
SELECT *
FROM employees e
JOIN employees m ON e.manager_id = m.employee_id;
- A. Lists employees who are not managers
- B. Lists employees without departments
- C. Lists employees and their corresponding managers
- D. Lists employees who are managers
正解：C
質問 # 54
What does the following command do?
GRANT CREATE SESSION TO user_name;
- A. Allows the user to create database objects
- B. Grants the user the ability to connect to the database
- C. Allows the user to create new sessions for other users
- D. Assigns the user to a specific role
正解：B
質問 # 55
Which SET operator returns rows from the first query that are not present in the second query?
- A. UNION
- B. UNION ALL
- C. INTERSECT
- D. MINUS
正解：D
質問 # 56
Which SQL keyword is used to define a substitution variable in a SQL statement?
- A. DEFINE
- B. VAR
- C. SUBSTITUTION
- D. SET
正解：A
質問 # 57
Which command revokes a user's privilege to update a table?
- A. DENY UPDATE ON table_name FROM user_name;
- B. REMOVE UPDATE ON table_name FROM user_name;
- C. DELETE UPDATE ON table_name FROM user_name;
- D. REVOKE UPDATE ON table_name FROM user_name;
正解：D
質問 # 58
Which clause in an UPDATE statement typically uses a subquery to assign values to columns?
- A. FROM
- B. SET
- C. HAVING
- D. WHERE
正解：B
質問 # 59
......
Oracle 1Z1-171問題を提供していますOracle Database問題集と完璧な解答付き：https://jp.fast2test.com/1Z1-171-premium-file.html