Oracle Database 23ai SQL Associate (1Z1-171) Free Practice Test

Question 1

How does SQL handle NULL values in arithmetic expressions?

A. Produces an error

B. Treats them as the largest possible number

C. Treats them as zero

D. Produces a NULL result

Correct Answer: D

Question 2

Which of the following ensures that a relational database enforces data integrity?

A. Hierarchical data organization

B. Indexes on all columns

C. Redundant data storage

D. Constraints such as primary keys, foreign keys, and unique constraints

Correct Answer: D

Question 3

Which of the following is true about foreign key constraints in SQL?

A. They define a relationship between two tables.

B. They enforce the uniqueness of values in a column.

C. They ensure that a column only contains NULL values.

Correct Answer: A

Question 4

Which of the following data dictionary views provides information about constraints on tables?

A. All of the above

B. DBA_CONSTRAINTS

C. ALL_CONSTRAINTS

D. USER_CONSTRAINTS

Correct Answer: A

Question 5

What will the following SQL query do?
UPDATE employees
SET salary = salary * 1.1
WHERE department_id = 10;

A. Decrease the salary of employees in department 10 by 10%

B. Increase the salary of all employees by 10%

C. Set the salary to 1.1 for employees in department 10

D. Increase the salary of employees in department 10 by 10%

Correct Answer: D

Question 6

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

A. Ovals

B. Arrows

C. Rectangles

D. Diamonds

Correct Answer: A

Welcome to TestSimulate