1Z0-082 무료 덤프문제 온라인 액세스

Which three statements are true about a self join? (Choose three.)

• A.It must be an equijoin
• B.It can be an outer join
• C.It must be an inner join
• D.The ON clause must be used
• E.The ON clause can be used
• F.The query must use two different aliases for the table

Which is true about roles?

• A.A role can be granted to other roles.
• B.All roles belong to the SYSTEM schema.
• C.Roles can be created only by SYS or SYSTEM.
• D.Roles containing object privileges can be created only by the object owner.
• E.A role can be password-protected only if it has been granted system privileges.

Which two functions are performed by a listener?

• A.verifying a user's authentication credentials
• B.creating a user session in the System Global Area (SGA)
• C.maintaining the connection to a client's user process until the user request is completed
• D.returning the results of processing from the server process to the user process
• E.connecting a user process to a server process
• F.verifying the service name in an incoming user request

Table EMPLOYEES contains columns including EMPLOYEE_ID, JOB_ID and SALARY.
Only the EMPLOYEE_ID column is indexed.
Rows exist for employees 100 and 200.
Examine this statement:

Which two statements are true? (Choose two.)

• A.Employees 100 and 200 will have the same JOB_ID as before the update command
• B.Employees 100 and 200 will have the same SALARY as before the update command
• C.Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200
• D.Employee 200 will have SALARY set to the same value as the SALARY of employee 100
• E.Employee 100 will have SALARY set to the same value as the SALARY of employee 200
• F.Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100

Which three statements are true about single-row functions? (Choose three.)

• A.The argument can be a column name, variable, literal or an expression
• B.They can be used only in the WHERE clause of a SELECT statement
• C.The data type returned can be different from the data type of the argument
• D.They return a single result row per table
• E.They can be nested to any level
• F.They can accept only one argument