How Many Questions Of 1Z0-072 Answers

NEW QUESTION 1
Examine this extract from the show parameters command:


How are SGA and PGA memory managed by an instance using these parameter settings?

• A. SGA memory is manually managed and PGA memory is managed by using Automated SQL Execution Memory Management.
• B. SGA memory is managed by using Automatic Shared Memory Management (ASMM) and PGA memory is managed by using Automated SQL Execution Memory Management.
• C. SGA and PGA memory are managed by using Automatic Memory Management (AMM).
• D. SGA memory is managed by using Automatic Shared Memory Management (ASMM) and PGA memory is manually managed.
• E. SGA and PGA memory are manually managed.

Answer: C

NEW QUESTION 2
Which two are true about users who are granted SYSDBA or SYSOPER privileges? (Choose two.)

• A. Only users granted SYSDBA can query or update tables in all user schemas.
• B. Only users granted SYSDBA can take a complete backup of a database.
• C. Users granted either SYSDBA or SYSOPER connect to an instance as SYS.
• D. Users granted either SYSDBA or SYSOPER can mount or open a database.
• E. Only users granted SYSDBA can start up and shut down a database instance.
• F. Users granted either SYSDBA or SYSOPER can query data in all user schemas.

Answer: BC

NEW QUESTION 3
Which is a machine image in Oracle Cloud?

• A. the number of OCPUs and amount of memory allocated to an instance
• B. the physical persistent block storage space allocated to an instance
• C. the number of OCPUs, amount of memory, and persistent block storage space allocated to an instance
• D. a template of a virtual hard disk of specific size without an operating system installed
• E. a template of a virtual hard disk of specific size with an installed operating system

Answer: E

NEW QUESTION 4
Which two operations can be performed on external tables? (Choose two.)

• A. creating invisible indexes
• B. creating views
• C. creating partitions
• D. creating public synonyms
• E. executing UPDATE statements

Answer: BD

NEW QUESTION 5
orcl.dmp contains a full export of the ORCL database.
This command is executed to load data from orcl.dmp into the TESTDB database: [oracle@host01 ~] impdp system/oracle \
> SHEMAS=sh,oe \
> REMAP_SCHEMA=sh:hr \
> DUMPFILE=orcl.dmp \
> EXCLUDE=index \
> TABLE_EXISTS_ACTION=replace \
> LOGFILE=impdp.log
Which two are true? (Choose two.)

• A. It skips only tables that exist in both ORCL:SH and TESTDB:HR.
• B. It drops and recreates tables that exist in both ORCL:SH and TESTDB:HR.
• C. It skips all indexes of ORCL:SH and ORCL:OE.
• D. It skips only indexes that exist in both ORCL:SH and TESTDB:HR.
• E. It drops and re-creates indexes that exist in both ORCL:SH and TESTDB:HR.

Answer: DE

NEW QUESTION 6
Which is true about revoking roles?

• A. Only users who are granted the DBA role can revoke a role.
• B. Only users who are granted SYSDBA can revoke a role.
• C. Users who have the GRANT ANY ROLE privilege can revoke any role.
• D. Users who are granted a role with ADMIN OPTION can revoke that role only from users to whom they have granted the role.
• E. Users can revoke a role that is granted to them through other roles.

Answer: D

NEW QUESTION 7
A user complains about poor database performance. You suspect that the user’s session is waiting for an event to complete.
You want to verify this.
Which two views may reveal for what the user’s session is currently waiting? (Choose two.)

• A. V$SYSTEM_EVENT
• B. V$SESSION_EVENT
• C. V$SESSION_WAIT_CLASS
• D. V$SESSION_WAIT
• E. V$SESSION

Answer: BD

NEW QUESTION 8
Which three are true about Oracle Managed Files (OMF)? (Choose three.)

• A. If DB_CREATE_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, the redo logs and control files are placed in DB_CREATE_FILE_DEST by default.
• B. If DB_RECOVERY_FILE_DEST is specified, at least two different locations must be specified for DB_CREATE_ONLINE_LOG_DEST_n.
• C. If only DB_CREATE_FILE_DEST is specified, only the data files and temp files are OMF.
• D. If DB_RECOVERY_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, the redo logs and control files are placed in DB_RECOVERY_FILE_DEST by default.
• E. If DB_CREATE_ONLINE_LOG_DEST_1 is specified but DB_CREATE_FILE_DEST is not, the data files and temp files are placed in DB_CREATE_ONLINE_LOG_DEST_1 by default.
• F. If only DB_CREATE_ONLINE_LOG_DEST_n is specified, only the redo logs and control files are OMF.

Answer: ABF

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

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

Answer: CDF

NEW QUESTION 10
Which is true about the UNLIMITED TABLESPACE SYSTEM privilege?

• A. It can be granted to any user and any role.
• B. It is overridden by any specified user space quota.
• C. It allows a user to have unlimited space in any tablespace in the database.
• D. It allows a user to have unlimited space only in his or her default permanent tablespace.
• E. It can be revoked from a user and replaced with a specific space quota only if no user schema objects exist.

Answer: C

NEW QUESTION 11
Yom database is in ARCHIEVELOG mode. The USER)! tablespace is online in read write and no error conditions exists for any of its data files.
You want to take USER01 offline so that all existing transactions involving objects in it can complete. What must yon do?

• A. Change its state to read only, and then take it offline with the temporary option.
• B. Take it offline with the normal option.
• C. Take it offline with the temporary option.
• D. Take it offline with the immediate option.
• E. Change its state to read only, and then take it offline with the normal option.
• F. Change its state to read only, and then take it offline with the immediate option.

Answer: E

NEW QUESTION 12
In the ORCL database, USER1 has unlimited quota on TBS1 and TBS2. The USER1.EMP table with primary key EMP_ENO_PK resides in TBS1. USER1.EMP_IDX residing in TBS2 is an index on U1.EMP.ENAME. TBS1 is exported from ORCL by using this command:
[oracle@host01 ~]$ expdp system/oracle tablespace=tbs1 directory=exp_dir dumpfile=tbs1.dmp The TESTDB database has a TBS1 tablespace but no TBS2.
The SYSTEM user in TESTDB executes this command:
[oracle@host01 ~]$ impdp system/oracle directory=exp_dir dumpfile=u1.dmp tablespace=tbs1 What is the result and why?

• A. It imports EMP, EMP_ENO_PK, and the unique index associated with EMP_ENO_PK and EMP_IDX.
• B. It imports only EMP, EMP_ENO_PK, and the unique index associated with EMP_ENO_PK.
• C. It fails because TESTDB has TBS1.
• D. It imports only EMP.
• E. It fails because TESTDB does not have TBS2 to create EMP_IDX.

Answer: B

NEW QUESTION 13
Which two are true about conventional path SQL load? (Choose two.)

• A. It does not generate UNDO.
• B. It cannot load data into clustered tables.
• C. It locks objects being processed.
• D. It enforces referential integrity constraints.
• E. It always generates redo.

Answer: AD

NEW QUESTION 14
Which three failures require intervention for recovery? (Choose three.)

• A. a user error such as dropping the wrong table
• B. network interface card (NIC) failure
• C. user process failure
• D. statement failure
• E. media failure

Answer: ACE

NEW QUESTION 15
Examine this command:
CREATE TEMPORARY TABLESPACE temp_tbs TEMPFILE ‘temp01.dbf’ SIZE 10M AUTOEXTEND ON ONLINE
SEGMENT MANAGEMENT AUTO;
Which two changes must you make so that TEMP_TBS is created? (Choose two.)

• A. Add the EXTENT MANAGEMENT LOCAL UNIFORM clause.
• B. Add the NOLOGGING clause.
• C. Remove the SEGMENT MANAGEMENT AUTO clause.
• D. Remove the AUTOEXTEND ON clause.
• E. Remove the ONLINE clause.
• F. Add MAXSIZE for the AUTOEXTEND ON clause.

Answer: AF

NEW QUESTION 16
Which two are true about direct path load?

• A. It enforces only primary key, unique, and not NULL, constraints.
• B. DML statements may occur on tables being loaded.
• C. It fires insert triggers, if any.
• D. It writes only to blocks above the high-water mark.
• E. It uses the database buffer cache.

Answer: BC

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

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

Answer: ABC

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

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

Answer: BEF

NEW QUESTION 19
Which two are prerequisites for shrinking a table online?

• A. It must have a unique key constraint.
• B. It must not have any referential integrity constraints.
• C. It must not have any DML triggers.
• D. It must be in a tablespace that uses Automatic Segment Space Management (ASSM) .
• E. It must have row movement enabled.

Answer: AB

NEW QUESTION 20
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 EMP.
• D. Rebuild EMP_IDX online in a tablespace with sufficient space.
• E. Shrink TBS1.

Answer: AB

NEW QUESTION 21
Which two can you use to recover a dropped table? (Choose two.)

• A. FLASHBACK QUERY
• B. FLASHBACK DATABASE
• C. FLASHBACK TRANSACTION
• D. FLASHBACK TABLE TO SCN
• E. FLASHBACK DROP

Answer: DE

NEW QUESTION 22
Examine the command: CREATE USER user1 IDENTIFIED BY user123
DEFAULT TEMPORARY TABLESPACE temp
QUOTA 5M ON system PROFILE hr_user PASSWORD EXPIRE;
Which two are true? (Choose two.)

• A. The PASSWORD EXPIRE clause is invalid because passwords are controlled by the HR_USER profile.
• B. USER1 requires a quota to be able to store objects in the default permanent tablespace.
• C. USER1 will be prompted for a new passport at first login.
• D. A quota on the temporary tablespace must be specified to enable USER1 to perform queries and transactions.
• E. USER1’s account is locked.

Answer: BD

NEW QUESTION 23
In a database, the default temporary tablespace is TEMP and USER1’s default tablespace is DATA. Examine these parameters:

Which tablespace stores UNDO generated by USER1’s DML on temporary tables?

• A. DATA
• B. SYSTEM
• C. SYSAUX
• D. TEMP
• E. UNDOTBS1

Answer: D

NEW QUESTION 24
Which three failures do not require intervention for recovery? (Choose three.)

• A. user process failure
• B. media failure
• C. statement failure
• D. network interface card (NIC) failure
• E. transaction failure

Answer: ACE

NEW QUESTION 25
......