Examine this command:

Which two statements are true? (Choose two.)

• A.The file is renamed and stored in the same location
• B.DML may be performed on tables with one or more extents in this data file during the execution of this command.
• C.If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.
• D.The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.
• E.The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.

Comment: *

Name: *

Email: *

Verification: *

Examine this command and some partial output:

Why does the DB01.abc.com service show unknown status?

• A.The listener is not listening on the default port 1521
• B.The service DB01.abc.com is dynamically registered
• C.The SID_LIST_LISTENER section is not contained in the LISTENER.ORA file
• D.The service DB01.abc.com is statically registered
• E.The LOCAL_LISTENER database parameter is not set to a service name that refers to LISTENER_1

Comment: *

Name: *

Email: *

Verification: *

You want to use table compression suitable for OLTP that will:
* Compress rows for all DML statements on that table
* Minimize the overheads associated with compression
Which compression option is best suited for this?

• A.COLUMN STORE COMPRESS FOR QUERY LOW
• B.ROW STORE COMPRESS ADVANCED
• C.ROW STORE COMPRESS BASIC
• D.COLUMN STORE COMPRESS FOR ARCHIVE HIGH
• E.COLUMN STORE COMPRESS FOR ARCHIVE LOW

Comment: *

Name: *

Email: *

Verification: *

Which two statements are true about views used for viewing tablespace and datafile information?
(Choose two.)

• A.Tablespace free space can be viewed in V$TABLESPACE
• B.A datafile can be renamed when the database is in MOUNT state and the new file name is displayed when querying DBA_DATA_FILES after the database is opened
• C.V$TABLESPACE displays information about tablespaces contained in the data dictionary
• D.Tablespace free space can be viewed in DBA_TABLESPACES
• E.V$TABLESPACE displays information that is contained in the controlfile about tablespaces

Comment: *

Name: *

Email: *

Verification: *

Which two are true about RETENTION GUARANTEE? (Choose two.)

• A.It is a tablespace attribute.
• B.It is a static parameter.
• C.It prevents "Snapshot too old" errors.
• D.It prevents out-of-space errors.
• E.It prevents FLASHBACK DATABASE operation failure.

Comment: *

Name: *

Email: *

Verification: *