Which three statements are true about dropping and unused columns in an Oracle database?
(Choose three.)

• A.An UNUSED column's space is reclaimed automatically when the row containing that column is next queried.
• B.A column that is set to UNUSED still counts towards the limit of 1000 columns per table
• C.A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option.
• D.A DROP COLUMN command can be rolled back
• E.An UNUSED column's space is reclaimed automatically when the block containing that column is next queried.
• F.Partition key columns cannot be dropped.

Comment: *

Name: *

Email: *

Verification: *

Which three statements are true about GLOBAL TEMPORARY TABLES? (Choose three.)

• A.A TRUNCATE command issued in a session causes all rows in a GLOBAL TEMPORARY TABLE for the issuing session to be deleted.
• B.Any GLOBAL TEMPORARY TABLE rows existing at session termination will be deleted.
• C.A GLOBAL TEMPORARY TABLE'S definition is available to multiple sessions.
• D.GLOBAL TEMPORARY TABLE rows inserted by a session are available to any other session whose user has been granted select on the table.
• E.A DELETE command on a GLOBAL TEMPORARY TABLE cannot be rolled back.
• F.GLOBAL TEMPORARY TABLE space allocation occurs at session start.

Comment: *

Name: *

Email: *

Verification: *

You execute this command:

During the export operation, you detach from the job by using CTRL+C and then execute this command:
Export> STOP_JOB=immediate
Are you sure you wish to stop the job ([yes]/no): yes
Which two statements are true about the job? (Choose two.)

• A.You can no longer monitor it
• B.You can reattach to it and monitor it
• C.It is paused and can be resumed
• D.It continues to run in the background
• E.It terminates

Comment: *

Name: *

Email: *

Verification: *

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 statements are true concerning logical and physical database structures? (Choose three.)

• A.A segment can span multiple data files in some tablespaces
• B.A segment's blocks can be of different sizes
• C.A smallfile tablespace might be bigger than a bigfile tablespace
• D.All tablespaces may have one or more data files
• E.Segments can span multiple tablespaces
• F.The extents of a segment must always reside in the same datafile
• G.A segment might have only one extent

Comment: *

Name: *

Email: *

Verification: *