Oracle Database 23ai SQL Associate - 1Z0-171 Exam Practice Test

A. ENABLE SELECT ON table_name TO user_name;

B. ALLOW SELECT ON table_name TO user_name;

C. GRANT ALL ON table_name TO user_name;

D. GRANT SELECT ON table_name TO user_name;

A. UPDATE

B. ALTER

C. INSERT

D. SELECT

A. FROM

B. GROUP BY

C. WHERE

D. SELECT

A. To create new tables and indexes

B. To increase query performance

C. To define the structure of database tables

D. To control user access to database objects and operations

A. To list all users in the database

B. To monitor system performance

C. To show the current session details

D. To provide information about all objects in the database

A. Constraints can only be added when creating a table.

B. Constraints cannot reference other tables.

C. Constraints are automatically dropped when rows are deleted.

D. Constraints can be added or modified using the ALTER TABLE statement.