Which two tasks does DBUA perform by default? (Choose two.)

A. setting user tablespaces to "read only" before starting the upgrade

B. adding more data files if there is insufficient disk space for the SYSTEM tablespace during the upgrade

C. running the Pre-Upgrade information tool

D. starting the source database instance if not started

E. enabling flashback in the source database if not enabled

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.

Examine this command:

Which two changes must you make so that TEMP_TBS is created? (Choose two.)

A. Add the EXTENT MANAGEMENT LOCAL UNIFORM clause.

B. Add the NOLOGGING clause.

C. Remove the SEGMENT MANAGEMENT AUTO clause.

D. Remove the AUTOEXTEND ON clause.

E. Remove the ONLINE clause.

F. Add MAXSIZE for the AUTOEXTEND ON clause.

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.

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.

You want to use table compression suitable for OLTP that will:

1.

Compress rows for all DML statements on that table

2.

Minimize the overheads associated with compression.

Which compression option is best suited for this?

A. COLUMN STORE COMPRESS FOR ARCHIVE HIGH

B. ROW STORE COMPRESS ADVANCED

C. COLUMN STORE COMPRESS FOR ARCHIVE LOW

D. ROW STORE COMPRESS BASIC

E. COLUMN STORE COMPRESS FOR QUERY LOW

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.

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.

Which statement is true about database links?

A. Private database link creation requires the same user to exist in both the local and the remote database.

B. A database link can be created only between Oracle databases.

C. A public database link can be used by a user in the local database to connect to any schema in the remote database.

D. A database link created in a database allows a connection from that database instance to another, but not vice versa.

E. A public database link can be created only by SYS.

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.