You work as a Database Administrator for Domain.com. The company uses MySQL as its
database.
You have written two statements, which are as follows:
1. SELECT DISTINCT OBJECT_TYPE
FROM USER_OBJECTS;
2. SELECT OBJECT_TYPE
FROM ALL_OBJECTS;
Which of the following options explains the difference between the results of these two
statements? Each correct answer represents a complete solution. Choose all that apply.
A.
The first statement will display distinct object types that can be accessed by the user.
B.
The second statement will display all object types that a user can access.
C.
The first statement will display distinct object types owned by a user.
D.
The second statement will display all object types owned by a user.