Far Out Oracle Database 12cR2 Administration 1Z0-072 Pdf Exam

NEW QUESTION 1
Which is true about unexpired undo?

• A. It is required when a transaction rolls back.
• B. It may be used to support flashback queries.
• C. It consists of undo only for uncommitted transactions.
• D. It is always retained for the time specified in UNDO RETENTION.
• E. It is the first type of undo overwritten when trying to avoid out-of-space errors.

Answer: D

NEW QUESTION 2
Which two are true about incomplete recovery? (Choose two.)

• A. Incremental backups cannot be used to roll forward the database while performing it.
• B. Uncommitted transactions will be rolled back after it completes.
• C. It is possible only when the database is in MOUNT state.
• D. The database must have FLASHBACK enabled in order to perform it.
• E. Only RMAN backupsets can be used to restore a database as part of it.

Answer: DE

NEW QUESTION 3
DATADIR1 and DATADIR2 are database directory objects.
Examine this command:
[oracle@host01 ~] expdp system/oracle \
> FULL=y \
> DUMPFILE=datadir1:full%U.dmp, datadir2: full2%U.dmp \
> FILESIZE=2G \
> PARALLEL=4 \
> LOGFILE= datadir1:/expfull.log
> JOB_NAME= expfull
Which two are true about the expdp operation? (Choose two.)

• A. It creates a dump file for the entire database.
• B. It fails if the total size of the dump file is more than 2 GB.
• C. It creates a dump file only for objects in the SYSTEM schema.
• D. It creates a master table to store details of the export operation.
• E. It starts only when four worker processes are available.

Answer: AE

NEW QUESTION 4
Your database instance is started by using an spfile. You want to modify the value of a static initialization parameter.
Examine these steps:
1. Shut down the database instance.
2. Modify the parameter in the spfile with scope = SPFILE.
3. Modify the parameter in a pfile.
4. Use the spfile to create a pfile.
5. Use the pfile to create a spfile.
6. Modify the parameter in the spfile with scope = BOTH.
7. Start up the database instance.
Which are the minimum required steps in the correct order?

• A. 2, 1, 7
• B. 1, 7, 2
• C. 1, 2, 7
• D. 6, 1, 7
• E. 1, 4, 3, 5, 7

Answer: C

NEW QUESTION 5
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 6
Which two tasks can you perform by using DBCA for a new database?

• A. Register it with an available Enterprise Manager Management server.
• B. Configure a nonstandard block size.
• C. Configure incremental backups.
• D. Enable flashback.
• E. Create user tablespaces.

Answer: AE

NEW QUESTION 7
Which two functions are performed by a listener?

• A. creating a user session in the System Global Area (SGA)
• B. verifying the service name in an incoming user request
• C. verifying a user’s authentication credentials
• D. maintaining the connection to a client’s user process until the user request is completed
• E. returning the results of processing from the server process to the user process
• F. connecting a user process to a server process

Answer: EF

NEW QUESTION 8
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 9
As the DBA, you execute this command:
GRANT SELECT ON hr.emp TO brown WITH GRANT OPTION;
BROWN then executes this command:
GRANT SELECT ON hr.emp TO scott WITH GRANT OPTION;
Which is true?

• A. You can revoke only WITH GRANT OPTION from BROWN.
• B. BROWN can revoke only WITH GRANT OPTION from SCOTT.
• C. When you revoke the SELECT privilege from BROWN, it is automatically revoked from SCOTT.
• D. When you revoke the SELECT privilege from BROWN, nothing is revoked from SCOTT.
• E. When you revoke the SELECT privilege from BROWN, only the WITH GRANT OPTION is revoked from SCOTT.

Answer: B

NEW QUESTION 10
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 11
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 12
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 13
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 14
Which is true about roles?

• A. A role can be granted to other roles.
• B. Roles can be created only by SYS or SYSTEM.
• C. Roles containing object privileges can be created only by the object owner.
• D. All roles belong to the SYSTEM schema.
• E. A role can be password-protected only if it has been granted system privileges.

Answer: E

NEW QUESTION 15
Which two are segment types? (Choose two.)

• A. table partition
• B. materialized views on a prebuilt container
• C. stored procedure
• D. sequence
• E. table
• F. view

Answer: AE

NEW QUESTION 16
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. Oracle-supplied tools can be used with database instances in the cloud.
• C. Database instances in the cloud can be accessed only by using SSH.
• D. DBCS only creates compute nodes; the Oracle Database software must be installed and the database created.
• E. Database instances in the cloud can be accessed only by using Oracle*Net.

Answer: BC

NEW QUESTION 17
Which two are true about the roles? (Choose two.)

• A. All privileges and roles granted to a user are enabled by default when the user logs in.
• B. The SET ROLE statement can be used once per session.
• C. The SET ROLE statement enables as well as disables roles in a session.
• D. A role must be disabled before it can be revoked from a user.
• E. The ALTER USER statement must be used to set specific default roles for a user.

Answer: AC

NEW QUESTION 18
Which two are responsibilities of an Oracle DBA regarding database availability, backup, and recovery?

• A. decreasing Mean Time Between Failures (MTBF) by configuring FLASHBACK mode
• B. implementing FLASHBACK DATA ARCHIVE to decrease MTBF
• C. ensuring that critical components are protected by implementing redundancy
• D. decreasing Mean Time to Recover (MTTR) by configuring FLASHBACK mode
• E. implementing FLASHBACK DATA ARCHIVE to decrease MTTR

Answer: CD

NEW QUESTION 19
Which two are true about the AL32UTF8 character set? (Choose two.)

• A. It is used to encode data for columns of any data type.
• B. It supports multilingual databases.
• C. It uses less space than other character sets, for all data types.
• D. It is used to store PL/SQL source code.
• E. It improves the I/O performance of a database compared to other character sets.

Answer: BC

NEW QUESTION 20
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 21
......