Free 1z0-082 Exam Braindumps

Which three statements are true about Oracle synonyms? (Choose three.)

1. A. A synonym cannot be created for a PL/SQL package
2. B. A synonym can be available to all users
3. C. A SEQUENCE can have a synonym
4. D. A synonym created by one user can refer to an object belonging to another user
5. E. Any user can drop a PUBLIC synonym

Correct Answer: BCD

Which two statements are true about the WHERE and HAVING clauses in a SELECT statement? (Choose two.)

1. A. Aggregating functions and columns used in HAVING clauses must be specified in the SELECT list of a query
2. B. WHERE and HAVING clauses can be used in the same statement only if applied to different table columns
3. C. The HAVING clause can be used with aggregating functions in subqueries
4. D. The WHERE clause can be used to exclude rows before dividing them into groups
5. E. The WHERE clause can be used to exclude rows after dividing them into groups

Correct Answer: CD

Which three statements are true about undo segments and the use of undo by transactions in an Oracle database instance? (Choose three.)

1. A. An undo segment may be used by multiple transactions simultaneously
2. B. Undo segments can wrap around to the first extent when a transaction fills the last extend of the undo segment
3. C. Undo segments have a minimum of three extents
4. D. Undo segments can extend when a transaction fills the last extent of the undo segment
5. E. A single transaction may use multiple undo segments simultaneously
6. F. Undo segments must be stored in a BIGFILE tablespace
7. G. Undo segments must be stored in a SMALLFILE tablespace

Correct Answer: ADG

Which three statements are true about the tools used to configure Oracle Net Services? (Choose three.)

1. A. The Oracle Net Configuration Assistant is only used when running the Oracle installer
2. B. Oracle Net Manager can be used to centrally configure listeners on any database server target
3. C. The lsnrctl utility requires a listener.ora file to exist before it is started
4. D. Oracle Net Manager can be used to locally configure naming methods on a database server
5. E. Enterprise Manager Cloud Control can be used to centrally configure listeners on any managed database server
6. F. Enterprise Manager Cloud Control can be used to centrally configure net service names for any databaseserver target

Correct Answer: BDE

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.)

1. A. Employee 100 will have SALARY set to the same value as the SALARY of employee 200
2. B. Employee 200 will have JOB_ID set to the same value as the JOB_ID of employee 100
3. C. Employee 200 will have SALARY set to the same value as the SALARY of employee 100
4. D. Employee 100 will have JOB_ID set to the same value as the JOB_ID of employee 200
5. E. Employees 100 and 200 will have the same JOB_ID as before the update command
6. F. Employees 100 and 200 will have the same SALARY as before the update command

Correct Answer: AB