Which three statements are true about table data storage in an Oracle Database? (Choose three.)

• A.Data block headers contain their own Data Block Address (DBA)
• B.A table row piece can be chained across several database blocks
• C.Multiple row pieces from the same row may be stored in different database blocks
• D.Multiple row pieces from the same row may be stored in the same block
• E.Data block free space is always contiguous in the middle of the block
• F.Index block free space is always contiguous in the middle of the block

Comment: *

Name: *

Email: *

Verification: *

Which three are types of segments in an Oracle Database? (Choose three.)

• A.undo
• B.index
• C.stored procedures
• D.sequences
• E.tables
• F.clusters

Comment: *

Name: *

Email: *

Verification: *

You execute this command:
CREATE SMALLFILE TABLESPACE sales
DATAFILE '/u01/app/oracle/sales01.dbf
SIZE 5G
SEGMENT SPACE MANAGEMENT AUTO;
Which two actions must you take to ensure UNDOTBS01 is used as the default UNDO tablespace? (Choose two.)

• A.It must be smaller than the smallest BIGFILE tablespace
• B.Free space is managed using freelists
• C.Any data files added to the tablespace must have a size of 5 gigabytes
• D.It uses the database default blocksize
• E.It is a locally managed tablespace

Comment: *

Name: *

Email: *

Verification: *

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

• A.They cannot be partitioned
• B.The ORACLE_LOADER access driver can be used to unload data from a database into an external table
• C.The ORACLE_DATAPUMP 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.External table files can be used for other external tables in a different database

Comment: *

Name: *

Email: *

Verification: *

In the spfile of a single instance database, LOCAL_LISTENER is set to LISTENER_1.
The TNSNAMES.ORA file in $ORACLE_HOME/network/admin in the database home contains:

Which statement is true?

• A.Dynamic service registration cannot be used for this database instance
• B.The LREG process registers services dynamically with the LISTENER_1 listener
• C.LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration
• D.There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database instances
• E.The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration

Comment: *

Name: *

Email: *

Verification: *