Which three functions are performed by dispatchers in a shared server configuration? (Choose three.)

• A.sending each connection input request to the appropriate shared server input queue
• B.writing inbound request to the common request queue from all shared server connections
• C.receiving inbound requests from processes using shared server connections
• D.sending shared server session responses back to requesters on the appropriate connection
• E.checking for outbound shared server responses on the common outbound response queue
• F.broadcasting shared server session responses back to requesters on all connections

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 functions are performed by dispatchers in a shared server configuration? (Choose three.)

• A.writing inbound request to the common request queue from all shared server connections
• B.checking for outbound shared server responses on the common outbound response queue
• C.receiving inbound requests from processes using shared server connections
• D.sending each connection input request to the appropriate shared server input queue
• E.broadcasting shared server session responses back to requesters on all connections
• F.sending shared server session responses back to requesters on the appropriate connection

Comment: *

Name: *

Email: *

Verification: *

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 block 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.An UNUSED column's space is reclaimed automatically when the row containing that column is next queried.
• D.Partition key columns cannot be dropped.
• E.A DROP COLUMN command can be rolled back
• F.A primary key column referenced by another column as a foreign key can be dropped if using the CASCADE option.

Comment: *

Name: *

Email: *

Verification: *

You execute this command:

Sufficient storage is available in filesystem /u01.
Which two statements are true about the BIG_TBStablespace? (Choose two.)

• A.It will be a dictionary-managed tablespace by default
• B.It must be bigger than the largest SMALLFILE tablespace
• C.AUTOEXTEND is possible for the datafile
• D.Additional data files may not be added
• E.It will always have a 32K blocksize

Comment: *

Name: *

Email: *

Verification: *