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

• A.VSTABLESPACE displays information that is contained in the controlfile about tablespaces
• B.VSTABLESPACE displays information about tablespaces contained in the data dictionary
• C.Tablespace free space can be viewed in VSTABLESPACE
• D.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
• E.Tablespace free space can be viewed in DBA_TABLESPACES

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.Specify a path in the DATAFILE clause of the command specifying a location with at least 100M of available space.
• B.Ensure that DB_RECOVERY_FILE_DEST and DB_CREATE_FILE_DEST each specify with at least 50 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.Ensure that DB_CREATE_FILE_DEST specifies a location with at least 100 Mb of available space.
• E.Add the AUTOEXTEND ON clause with NEXT set to 100M.

Comment: *

Name: *

Email: *

Verification: *

Examine these commands:

Which two statements are true about the sqlldr execution? (Choose two.)

• A.It generates a sql script that it uses to load data from EMP.DAT to EMP
• B.It generates a log that contains control file entries, which can be used with normal SQL*Loader operations
• C.It uses the database buffer cache to load data
• D.It appends data from EMP.DAT to EMP
• E.It overwrites data in EMP with data in EMP.DAT

Comment: *

Name: *

Email: *

Verification: *

The ORCL database has RESUMABLE__TIMEOUT = 7200 and DEFERRED_SEGMENT_CREATION = FALSE User U1 has a 1 MB quota in tablespace DATA.
U1 executes this command:
SQL> CREATE TABLE t1 AS
(SELECT object_name, sharing, created
FROM dba_objects);
U1 complains that the command is taking too long to execute.
In the alert log, the database administrator (DBA) finds this:
2017-03-06T12:15:17.183438+05:30
statement in resumable session 'User U1(136), Session 1, Instance 1' was suspended due to ORA-01536: space quota exceeded for tablespace 'DATA' Which are three actions any one of which the DBA could take to resume the session? (Choose three.)

• A.Increase U1's quota sufficiently in DATA
• B.Grant UNLIMITED TABLESPACE to U1
• C.Drop other U1 objects in DATA
• D.Set DEFERRED_SEGMENT_CREATION to TRUE
• E.Set AUTOEXTEND ON for data files in DATA
• F.Add a data file to DATA

Comment: *

Name: *

Email: *

Verification: *

You want to use table compression suitable for OLTP that will:
1. Compress rows for all DML statements on that table
2. 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 BASIC
• C.COLUMN STORE COMPRESS FOR ARCHIVE LOW
• D.COLUMN STORE COMPRESS FOR ARCHIVE HIGH
• E.ROW STORE COMPRESS ADVANCED

Comment: *

Name: *

Email: *

Verification: *