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 are types of segments in an Oracle Database? (Choose three.)

1. A. undo
2. B. index
3. C. stored procedures
4. D. sequences
5. E. tables
6. F. clusters

Correct Answer: BEF

Which two statements are true regarding the UNION and UNION ALL operators? (Choose two.)

1. A. Duplicates are eliminated automatically by the UNION ALL operator
2. B. The number of columns selected in each SELECT statement must be identical
3. C. The names of columns selected in each SELECT statement must be identical
4. D. The output is sorted by the UNION ALL operator
5. E. NULLS are not ignored during duplicate checking

Correct Answer: BE

Which three statements are true about advanced connection options supported by Oracle Net for connection to Oracle Database instances? (Choose three.)

1. A. Connect Time Failover requires the use of Transparent Application Failover (TAF)
2. B. Source Routing requires the use of a name server
3. C. Source Routing enables the use of Connection Manager (CMAN) which enables network traffic to be routed through a firewall
4. D. Load Balancing can balance the number of connections to dispatchers when using a Shared Server configuration
5. E. Load Balancing requires the use of a name server
6. F. Connect Time Failover requires the connect string to have two or more listener addresses configured

Correct Answer: BCF

Which three statements are true about the Oracle Data Dictionary? (Choose three.)

1. A. Data dictionary views are created by joins of dictionary base tables and DBA-defined tables
2. B. The data dictionary is created and maintained by the database administrator
3. C. Views with the same name but different prefixes, such as CDB, DBA, ALL and USER, reference the same base tables from the data dictionary
4. D. Base tables can be queried directly
5. E. It is owned by the SYSTEM user
6. F. Usernames of all users including database administrators are stored in the data dictionary

Correct Answer: CDF