Online Access Free 1z1-072 Exam Questions

Which three object types support deferred segment creation? (Choose three.)

• A.heap organized tables
• B.temporary tables
• C.external tables
• D.partitioned tables
• E.index organized tables
• F.clustered tables

Which three are true about the Oracle Optimizer? (Choose three.)

• A.It determines the optimal table join order and method.
• B.It can re-optimize execution plans after previous executions detect suboptimal plans.
• C.It will only generate SQL Plan Directives specific to a given SQL statement.
• D.It generates execution plans for SQL statements based on relevant schema objects, system and session parameters, and information found in the Data Dictionary.
• E.It updates stale object statistics in the Data Dictionary.
• F.It can optimize only SELECT statements.

Which two statements are true about Oracle Data Pump? (Choose two.)

• A.impdp always uses conventional path inserts when importing data.
• B.expdp and impdp are its client components.
• C.The DBMS_DATAPUMP package can be used only with Data Pump clients
• D.impdp can change target data file names, schemas, and tablespaces during import.
• E.It cannot be used to export data as of a previous SCN.

Which is always true about privileges?

• A.Connections as SYS must be made using the SYSDBA privilege
• B.The SYSDBA privilege can be granted to a user or role.
• C.The owner of a schema is granted all object privileges within the schema by default.
• D.Connections as SYSTEM can use only the SYSOPER privilege.
• E.System privileges can be granted only to users.

Which three are true about Oracle Database backup taken with RMAN?

• A.RMAN cannot backup REDO logs.
• B.Only offline backup are consistent.
• C.An RMAN image copy can be written only to disk.
• D.RMAN always includes the control file in a backup.
• E.A full backup contains all data blocks from one or more data files.
• F.A whole backup contains all data blocks of all data files.