[Oct 08, 2026] Uplift Your 1Z1-171 Exam Marks With The Help of 1Z1-171 Dumps [Q29-Q50]

QUESTION 29
Which component of an ERD (Entity-Relationship Diagram) represents the attributes of an entity?

QUESTION 30
Which data dictionary view lists all indexes created by the current user?

QUESTION 31
What type of join does the following query perform?
SELECT *
FROM employees e, departments d
WHERE e.department_id = d.department_id;

QUESTION 32
What happens when the TRUNCATE TABLE statement is executed?

QUESTION 33
The column data type is converted to a primary key.

QUESTION 34
Which of the following SET operators combines results from two queries and removes duplicates?

QUESTION 35
Which SQLPlus command displays defined substitution variable values?

QUESTION 36
What does the following query return?
SELECT ROUND(123.456, 1) AS rounded_value FROM dual;

QUESTION 37
What is the purpose of using external tables in Oracle Database?

QUESTION 38
Which SQL clause can be used in Oracle to limit the number of rows returned?

QUESTION 39
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;

QUESTION 40
Which SQL JOIN keyword retrieves all rows from both tables, including those without matches?

QUESTION 41
How are NULL values treated in relational databases?

QUESTION 42
Which function is used to extract the year from a date in SQL?

QUESTION 43
Which type of join returns all rows from the left table, even if there are no matches in the right table?

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

QUESTION 45
What will the following query return?
SELECT EXTRACT(YEAR FROM CURRENT_DATE) AS year FROM dual;

QUESTION 46
How can a synonym benefit database design?

QUESTION 47
Which SQL statement is used to insert a new row into a table?

QUESTION 48
What does the following SQL statement do?
ALTER TABLE employees DROP COLUMN salary;

QUESTION 49
What is the primary purpose of a primary key in a relational database?

QUESTION 50
Which of the following SQL commands retrieves data from a relational database?