Online Access Free 1z1-072 Practice Test

Which three are true about Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), and the MMON background process? (Choose three.)

• A.By default, MMON creates an AWR snapshot every 30 minutes.
• B.AWR snapshots must be deleted when no longer required by ADDM.
• C.ADDM performs its analysis only whenever a DBA requests it.
• D.ADDM can recommend extending the buffer cache.
• E.By default, AWR snapshots are automatically purged after eight days.
• F.ADDM can recommend shrinking the buffer cache.

EMP_IDX is an index on the EMP.ENO column.
EMP and EMP_IDX reside in the TBS1 tablespace.
During an INSERT into EMP, you get this error:
ERROR at line 1:
ORA-01654: unable to extend index USERS.EMP_IDX BY 8 in tablespace TBS1 Which two actions would you take to correct the space problem in TBS1 without affecting uncommitted transactions on EMP? (Choose two.)

• A.Drop and re-create EMP_IDX.
• B.Coalesce EMP_IDX.
• C.Shrink TBS1.
• D.Shrink EMP.
• E.Rebuild EMP_IDX online in a tablespace with sufficient space.

Which two are true about Oracle Database Cloud Service (DBCS)? (Choose two.)

• A.Third-party tools can be used with database instances in the cloud.
• B.Database instances in the cloud can be accessed only by using SSH.
• C.Database instances in the cloud can be accessed only by using Oracle*Net.
• D.Oracle-supplied tools can be used with database instances in the cloud.
• E.DBCS only creates compute nodes; the Oracle Database software must be installed and the database created.

TBS1 is a permanent user-defined tablespace created with Oracle Managed Files (OMF).
Examine this command:
DROP TABLESPACE tbs1;
Which is required to ensure that TBS1 is dropped and its datafiles are deleted from their file system?

• A.DB_CREATE_FILE_DEST must refer to an Oracle Automatic Storage Management (ASM)disk group.
• B.The INCLUDING CONTENTS AND DATAFILES clause must be added to the command.
• C.TBS1 must be placed in READ ONLY state.
• D.Objects in TBS1 must not be in use when the command is executed.
• E.TBS1 must not contain any temp files.

You execute this command to connect to an instance from a client on a different machine:
CONNECT username/password@net_service_name
No name servers are configured.
Which two are true about net_service_name? (Choose two.)

• A.It must contain only one address protocol for one listener.
• B.It must have the same name as the SERVICE_NAME defined in it.
• C.It must contain the address protocol for only one listener.
• D.It must be defined in the tnsnames.ora file on the server side.
• E.It must be defined in the tnsnames.ora file on the client side.