1Z0-072 Online Practice Questions and Answers

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.

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.

You execute this command to connect to an instance from a client on a different machine: No name servers are configured.

Which two are true about net_service_name? (Choose two.)

A. It must contain the address protocol for only one listener.

B. It must contain only one address protocol for one listener.

C. It must be defined in the tnsnames.ora file on the client side.

D. It must be defined in the tnsnames.ora file on the server side.

E. It must have the same name as the SERVICE_NAME defined in it.

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.

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.

The DATA tablespace uses Automatic Segment Space Management.

Examine this query and its output:

A block in EMP is 90% full.

At what percentage of free space will INSERT operations into the block again be possible?

A. 10%

B. 25%

C. 50%

D. 75%

E. 90%

For which three purposes is UNDO used? (Choose three.)

A. flashback queries

B. B. FLASHBACK TABLE TO BEFORE DROP operations

C. the roll forward phase of instance recovery

D. RESTORE DATABASE operations

E. ROLLBACK operations

F. read consistency

In your database, you create a user, HR, and then execute this command:

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.

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.