1Z0-072 Online Practice Questions and Answers

Which two are true about the default listener for a single instance database? (Choose two.)

A. It must be defined in the LISTENER.ORA file.

B. It must support at least one service on startup.

C. It must be defined by using the Listener Control utility.

D. It listens on the default port 1521.

E. It uses the settings of the INSTANCE_NAME and SERVICE_NAMES parameters from all databases using that listener.

orcl.dmp contains a full export of the ORCL database.

This command is executed to load data from orcl.dmp into the TESTDB database:

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.

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.

In the ORCL database, UNDOTBS1 is the active undo tablespace with a fixed size of 70 MB and RETENTION GUARANTEE.

UNDO_RETENTION is set to 15 minutes and the tablespace does not have AUTOEXTEND on.

Which statement is true about a transaction if UNDOTBS1 fills with uncommitted undo within 10 minutes of the transaction's first update?

A. It succeeds and the generated undo is stored in SYSAUX.

B. It succeeds and the generated undo is stored in TEMP.

C. It fails and returns the error message "Snapshot too old".

D. It succeeds and the generated undo is stored in SYSTEM.

E. It fails and returns the error message "ORA=30036": unable to extend segment by 8 in undo tablespace `UNDOTBS1'".

F. It succeeds and the least recently used undo block UNDOTBS1 is overwritten by the generated undo.

Which three actions are required to manually upgrade a database to Oracle Database 12c Release 2? (Choose three.)

A. Run the Pre-Upgrade information tool on the source database.

B. Take all user tablespaces offline before starting the upgrade.

C. Copy the network configuration files from the existing database home to the new Oracle home location.

D. Run the Parallel Upgrade utility from the new Oracle home.

E. Run Oracle Net Configuration Assistant (NETCA) to configure the listening protocol address and service information for the new release of Oracle Database.

F. Make all user tablespaces "read only" before starting the upgrade.

G. Start the existing database in upgrade mode.

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.

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

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

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.

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:

The TESTDB database has a TBS1 tablespace but no TBS2. The SYSTEM user in TESTDB executes this command:

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.