Examine the description of the SALES1 table:

SALES2 is a table with the same description as SALES1.
Some sales data is duplicated in both tables.
You want to display the rows from the SALES1 table which are not present in the SALES2 table.
Which set operator generates the required output?

• A.UNION
• B.SUBTRACT
• C.UNION ALL
• D.INTERSECT
• E.MINUS

Comment: *

Name: *

Email: *

Verification: *

The SALES_Q1 and USERS tablespaces exist in one of your databases and TEMP is a temporary tablespace.
Segment creation is not deferred.
You execute this command:

Which three statements must be true so that the SALES user can create tables in SALES_Q1?
(Choose three.)

• A.The sales user must have been granted the CREATE SESSION privilege
• B.The sales user must have a quota on the SALES_Q1 tablespace to hold all the rows to be inserted into any table in their schema
• C.The sales user must have a quota on the TEMP tablespace
• D.The sales user must have a quota on the SALES_Q1 tablespace to hold the initial extends of all tables they plan to create in their schema
• E.The sales user must have their quota on the users tablespace removed
• F.The sales user must have been granted the CREATE TABLE privilege

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: *

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: *

You execute this query:
SELECT TO_CHAR(NEXT_DAY(LAST_DAY(SYSDATE), 'MON'), 'dd "Monday for" fmMonth rrrr') What is the result?

• A.It generates an error
• B.It returns the date for the last Monday of the current month
• C.It returns the date for the first Monday of the next month
• D.It executes successfully but does not return any result

Comment: *

Name: *

Email: *

Verification: *