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

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

Comment: *

Name: *

Email: *

Verification: *

Which two queries execute successfully?

• A.SELECT COALESCE (100, 'AM FROM DUAL;
• B.SELECT NULLIF(NULL, 100) FROM DUAL;
• C.SELECT 2TOLLIF(100, 'A') FROM DUAL;
• D.SELECT COALESCE(100, NULL, 200) FROM DUAL;
• E.SELECT NULLIF(100,100) FROM DUAL;

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about external tables in Oracle 18c and later releases? (Choose three.)

• A.External table files can be used for other external tables in a different database
• B.They cannot be partitioned
• C.The ORACLE_LOADER access driver can be used to unload data from a database into an external table
• D.The ORACLE_DATAPUMP access driver can be used to load data into a database from an external table
• E.They support UPDATEs but not INSERTs and DELETEs
• F.The ORACLE_DATAPUMP access driver can be used to unload data from a database into an external table

Comment: *

Name: *

Email: *

Verification: *

In one of your databases, the user HR has the password HRMGR.
You want to connect to a database instance whose listener listens on port 1531 by using this statement:
CONNECT HR/HRMGR@orcl
No name server is used.
Which statement is true about ORCL?

• A.It must resolve to a valid connect descriptor in the server's tnsnames.ora file
• B.It must be the name of the server running the database to whose instance HR wishes to connect
• C.It must be the name of the database to whose instance HR wishes to connect
• D.It must be the value of the SERVICE_NAMES parameter on the client side
• E.It must resolve to a valid connect descriptor in the client's tnsnames.ora file

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about Deferred Segment Creation in Oracle databases?

• A.Indexes inherit the deferred or immediate segment creation attribute from their parent table
• B.Sessions may dynamically switch back and forth from deferred to immediate segment creation.
• C.It Is supported for Index Organized Tables (IOTs) contained in locally managed tablespaces.
• D.It Is the default behavior for tables and indexes.
• E.It is supported for SYS-owned tables contained in locally managed tablespaces.

Comment: *

Name: *

Email: *

Verification: *