Which two are true about the roles? (Choose two.)

• A.The SET ROLE statement can be used once per session.
• B.All privileges and roles granted to a user are enabled by default when the user logs in.
• C.A role must be disabled before it can be revoked from a user.
• D.The SET ROLE statement enables as well as disables roles in a session.
• E.The ALTER USER statement must be used to set specific default roles for a user.

Comment: *

Name: *

Email: *

Verification: *

In your data center, Oracle Managed Files (OMF) is used for all databases.
All tablespaces are smallfile tablespaces.
SALES_Q1 is a permanent user-defined tablespace in the SALES database.
Examine this command which is about to be issued by a DBA logged in to the SALES database:
ALTER TABLESPACE sales_q1 ADD DATAFILE;
Which are two actions, either one of which you could take to ensure that the command executes successfully?
(Choose two.)

• A.Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify with at least 50 Mb of available space.
• B.Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available space.
• C.Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify locations with at least 50 Mb of available space.
• D.Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space.
• E.Add the AUTOEXTEND ON clause with NEXT set to 100M.

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

Examine the description of the PRODUCT_STATUS table:

The status column contains the values 'in stock' or 'out of stock' for each row.
Which two queries will execute successfully?

• A.SELECT prod_id I I q' ('s not available) * 'CURRENT AVAILABILITY' FROM product_status WHERE status = 'OUT OF STOCK
• B.SELECT prod_id Il q"'s not available" FROM product_status where status = 'OUT OF STOCK';
• C.SELECT prod_id "CURRENT AVAILABILITY" II q'<'s not available)' FROM product_status WHERE status = 'OUT OF STOCK
• D.SELECT prod_id q's not available" FROM product_status WHERE status = 'OUT OF STOCK*;
• E.SELECT prod_id II q'l's not available)' FROM product_status WHERE status = 'OUT OF STOCK';
• F.SELECT prod_id I I q' (*s not available)' "CURRENT AVAILABILITY" FROM product_status WHERE status = 'OUT OF STOCK

Comment: *

Name: *

Email: *

Verification: *

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

• A.It is supported for SYS-owned tables contained in locally managed tablespaces.
• 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.Indexes inherit the deferred or immediate segment creation attribute from their parent table

Comment: *

Name: *

Email: *

Verification: *