Want to know Ucertify 1Z0-072 Exam practice test features? Want to lear more about Oracle Oracle Database 12cR2 Administration certification experience? Study Printable Oracle 1Z0-072 answers to Renew 1Z0-072 questions at Ucertify. Gat a success with an absolute guarantee to pass Oracle 1Z0-072 (Oracle Database 12cR2 Administration) test on your first attempt.
Also have 1Z0-072 free dumps questions for you:
NEW QUESTION 1
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 2
Which three types of files are created by expdp operations? (Choose three.)
- A. SQL files
- B. dump files
- C. reject files
- D. log files
- E. input data files
- F. bad files
- G. control files
Answer: ABD
NEW QUESTION 3
Examine this command and its partial output:
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 4
Which two are true about Oracle database wait events that are described in V$EVENT_NAME? (Choose two.)
- A. They reveal the cause of performance problems.
- B. They are grouped into classes.
- C. They are maintained at the session and system level.
- D. They display how often a database instance performs particular operations.
- E. All events might be used by an instance regardless of parameter settings.
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
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 7
The ORCL database has DEFERRED_SEGMENT_CREATION set to TRUE. UNDOTBS2 is the active undo tablespace.
Examine these commands:
USER1 executes DML, which generates more than 2 MB of UNDO. What is the result and why?
- A. It suspends the transaction, which can be resumed by increasing the size of UNDOTBS2.
- B. It returns an error because UNDOTBS2 is fixed size and has RETENTION GUARANTEE.
- C. It suspends the transaction, which can be resumed by increasing USER1’s quota on UNDOTBS2.
- D. It returns an error because UNDOTBS2 has RETENTION GUARANTEE.
- E. It suspends the transaction, which can be resumed by setting UNDOTBS1 as the active undo tablespace.
- F. It returns an error because UNDOTBS2 is fixed size.
Answer: F
NEW QUESTION 8
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 9
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 10
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 11
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 12
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 13
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 14
Which three types of files are used by conventional path SQL*Loader when the TABLE option is not specified? (Choose three.)
- A. control files
- B. bad files
- C. input files
- D. password files
- E. server parameter files (SPFILE)
- F. dump files
Answer: BCD
NEW QUESTION 15
Your database is configured for shared server and the SGA_TARGET parameter is set to a non-zero value. Which three actions could help in handling a large number of concurrent users?
- A. using Automatic SGA Memory Management (ASMM)
- B. setting the LARGE_POOL_SIZE parameter to a non-zero value
- C. increasing the size of the PGA
- D. setting the SHARED_POOL_SIZE parameter to a non-zero value
- E. increasing the number of dispatchers
Answer: BCD
NEW QUESTION 16
Your client application and Oracle database are located on different hosts. Which statement is true about establishing a connection between them?
- A. Oracle Connection Manager must be installed on the client.
- B. Net service names must be configured on both the client and database servers.
- C. The Listener Control utility must be installed on the client if you are using the default listener on the server.
- D. Only Oracle Net can be used.
- E. Oracle Net Listener is required.
Answer: D
NEW QUESTION 17
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 18
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 19
What two are benefits of Data Pump? (Choose two.)
- A. It can execute in parallel.
- B. It can restart failed export jobs.
- C. It makes use of client system resources.
- D. It can export data into sequential media, such as tapes.
- E. It represents database metadata information as DDL statements in the dump file.
Answer: AB
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
In your database, you create a user, HR, and then execute this command: GRANT CREATE SESSION TO hr WITH ADMIN OPTION;
Which three actions can HR perform? (Choose three.)
- A. Grant the CREATE SESSION privilege without ADMIN OPTION to other users.
- B. Grant the CREATE SESSION privilege with ADMIN OPTION to other users.
- C. Execute DML statements in the HR schema.
- D. Log in to the database instance.
- E. Revoke the CREATE SESSION privilege from other users.
- F. Execute DDL statements in the HR schema.
Answer: BDE
NEW QUESTION 22
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 23
What three are true about Oracle Flashback technology? (Choose three.)
- A. FLASHBACK TRANSACTION can be used to undo the changes made by a committed transaction.
- B. FLASHBACK TABLE can be used to rewind a table back in time.
- C. FLASHBACK DATABASE can be used to rewind a database back and forth in time.
- D. FLASHBACK TABLE can be used to undo dropping a column from a table.
- E. FLASHBACK QUERY can be used to view committed data at any given point in time.
Answer: ACD
NEW QUESTION 24
Which two statements are true about VSTABLESPACE and DBA_ TABLESPACE?
- A. VSTABLESPACE cab be queries by all users, but DBA_ TABLESPACEs cab be queries only by SYSDBA users.
- B. VSTABLESPACE is a dynamic view that is populated with data from th DBA_ TABLESPACE dictionary view.
- C. VSTABLESPACE is a dynamic view that is populated with data from the DBA_ TABLESPACES data queried only when a database is open.
- D. VSTABLESPACE and DBA_ TABLESPACES are view based on base tables in the data dictionary.
- E. VSTABLESPACE metadata is lost at shutdown, but DBA_ TABLESPACE metadata persists across shutdowns.
Answer: DE
NEW QUESTION 25
......
Thanks for reading the newest 1Z0-072 exam dumps! We recommend you to try the PREMIUM Allfreedumps.com 1Z0-072 dumps in VCE and PDF here: https://www.allfreedumps.com/1Z0-072-dumps.html (78 Q&As Dumps)
