Want to know Actualtests 1Z0-072 Exam practice test features? Want to lear more about Oracle Oracle Database 12cR2 Administration certification experience? Study Accurate Oracle 1Z0-072 answers to Renewal 1Z0-072 questions at Actualtests. Gat a success with an absolute guarantee to pass Oracle 1Z0-072 (Oracle Database 12cR2 Administration) test on your first attempt.

Online Oracle 1Z0-072 free dumps demo Below:

NEW QUESTION 1
Which two backup configurations are set by default when you choose Cloud Storage Only as the backup destination? (Choose two.)

  • A. encryption of backups only for Enterprise Edition databases
  • B. automatic daily full database backups
  • C. RMAN incremental backups in a seven-day cycle
  • D. encryption of backups only for High Performance and Extreme Performance database versions
  • E. on-demand backups that need to be scheduled
  • F. encryption for all backups

Answer: CD

NEW QUESTION 2
Examine this command and its partial output:
1Z0-072 dumps exhibit
Why does the DB01.abc.com service show unknown status?

  • A. The listener does not listen on the default port 1521.
  • B. The SID_LIST_LISTENER section is missing in the LISTENER.ORA file.
  • C. The service is dynamically registered.
  • D. The service is statically registered.
  • E. The LOCAL_LISTENER parameter list does not contain LISTENER_1.

Answer: B

NEW QUESTION 3
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 4
Which two are true about complete recovery? (Choose two.)

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

Answer: AB

NEW QUESTION 5
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 6
In your database, you want to create a tablespace of non-standard block size by using this command: CREATE TABLESPACE ns_tbs
DATAFILE ‘/u01oracle/data/nstbs_f01.dbf’ SIZE 100M BLOCKSIZE 16K;
Which is a requirement for this command to succeed?

  • A. All other DB_nK_CACHE_SIZE parameters should be set to zero.
  • B. The DB_16K_CACHE_SIZE parameter should be set to a value that can be accommodated in the available SGA.
  • C. The value of the DB_CACHE_SIZE parameter should not be 16 KB.
  • D. The DB_16K_CACHE_SIZE parameter should be set to a value less than that of DB_CACHE_SIZE.
  • E. The DB_BLOCK_SIZE parameter must be set to a value greater than 16 KB.

Answer: B

NEW QUESTION 7
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 8
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 9
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 10
For which three purposes is UNDO used? (Choose three.)

  • A. flashback queries
  • B. FLASHBACK TABLE <tablename> TO BEFORE DROP operations
  • C. the roll forward phase of instance recovery
  • D. RESTORE DATABASE operations
  • E. ROLLBACK operations
  • F. read consistency

Answer: AEF

NEW QUESTION 11
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 12
You execute this command:
CREATE SMALLFILE TABLESPACE sales
DATAFILE ‘/u01/app/oracle/sales01.dbf’ SIZE 5G SEGMENT SPACE MANAGEMENT AUTO;
Which two statements are true about the SALES tablespace? (Choose two.)

  • A. The FREELISTS and FREELIST GROUPS parameters are used to manage extent allocation.
  • B. It is read-only by default.
  • C. DML operations performed on objects in this tablespace are not logged by default.
  • D. It uses the default blocksize used at database creation.
  • E. It is a locally managed tablespace.
  • F. It is offline by default.

Answer: AD

NEW QUESTION 13
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 14
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 15
Which two are true about instance recovery for a database that is open in read write mode? (Choose two.)

  • A. It is guaranteed to complete within fast_start_mttr_target number of seconds.
  • B. No users can log on until instance recovery has completed.
  • C. Only the CURRENT REDO log group is required to perform instance recovery.
  • D. It is always performed when opening a database.
  • E. It always occurs during instance startup performed immediately after a SHUTDOWN ABORT.
  • F. The database opens after the roll forward phase of instance recovery has completed.

Answer: DE

NEW QUESTION 16
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 17
Which two statements are true about Oracle Data Pump? (Choose two.)

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

Answer: AC

NEW QUESTION 18
Which two are true about the default listener for a single instance database?

  • A. It listens on the default port 1521.
  • B. It must be defined in the listener, ORA file.
  • C. It uses the settings of the instance name and SERVICE_NAMES parameters from all databases using that listener.
  • D. It must be defined by using the Listener Control utility.
  • E. It must support at least one service on startup.

Answer: AB

NEW QUESTION 19
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 20
Which statement is true about an undo tablespace created using the Database Configuration Assistant (DBCA)?

  • A. It contains undo only for uncommitted transactions.
  • B. It is used for the FLASHBACK TABLE…TO BEFORE DROP operation.
  • C. It can be recovered while the instance is open in READ WRITE mode.
  • D. It must be a smallfile tablespace.
  • E. It is a locally managed tablespace.

Answer: AD

NEW QUESTION 21
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 22
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 23
Examine these commands:
1Z0-072 dumps exhibit
1Z0-072 dumps exhibit
What is the expected result?

  • A. It fails because EMP.DAT has some records with more than three characters corresponding to U1.EMP.ENAME.
  • B. Only the first row in EMP.DAT is inserted into U1.EMP.
  • C. Only the first and fourth rows in EMP.DAT are inserted into U1.EMP.
  • D. All rows in EMP.DAT are inserted into U1.EMP but ENAME is set to ### for the second and third rows.
  • E. All rows in EMP.DAT are inserted into U1.EMP but ENAME is set to NULL for the second and third rows.

Answer: D

NEW QUESTION 24
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 25
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 26
......

Thanks for reading the newest 1Z0-072 exam dumps! We recommend you to try the PREMIUM Surepassexam 1Z0-072 dumps in VCE and PDF here: https://www.surepassexam.com/1Z0-072-exam-dumps.html (78 Q&As Dumps)