A. If Oracle Managed Files (OMF) is used, then the file is renamed but moved to DB_CREATE_FILE_DEST.

B. The tablespace containing SALES1.DBF must be altered READ ONLY before executing the command.

C. The file is renamed and stored in the same location.

D. DML may be performed on tables with one or more extents in this data file during the execution of this command.

E. The tablespace containing SALES1.DBF must be altered OFFLINE before executing the command.

A. To protect against data corruption.

B. To protect against data theft by a non-authorized user.

C. To monitor proper usage of the system and data by privileged users.

D. To alert DBAs about system issues.

E. To monitor suspicious activity.

A. It overwrites the data for Alan and adds data for Curl and Bob.

B. It generates a log that contains control file entries, which can be used with normal SQL*Loader operations.

C. It appends data from EMP.DAT to EMP.

D. It generates a SQL script that it uses to load data from EMP.DAT to EMP.

E. It overwrites all data in EMP with data from EMP.DAT.

A. Oracle Managed Files (OMF).

B. Online index segment shrink.

C. Online table segment shrink.

D. Automatic data file extension (AUTOEXTEND).

E. Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR).

A. 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.

B. If DB_CREATE_ONLINE_LOG_DEST_1 is specified but DB_CREATE_FILE_DEST is not, new data files and temp files are stored in DB_CREATE_ONLINE_LOG_DEST_1 by default.

C. If DB_CREATE_FILE_DEST is specified but DB_CREATE_ONLINE_LOG_DEST_n is not, new redo logs and control files are stored in DB_CREATE_FILE_DEST by default.

D. If DB_RECOVERY_FILE_DEST is specified, at least two different locations must be specified for DB_CREATE_ONLINE_LOG_DEST_n.

E. If only DB_CREATE_ONLINE_LOG_DEST_1 is specified, only redo logs and control files are Oracle Managed.

F. If only DB_CREATE_FILE_DEST is specified, only data files and temp files are Oracle managed.

A. DB_32K_CACHE_SIZE should be set to a value greater than DB_CACHE_SIZE.

B. DB_32K_CACHE_SIZE must be less than DB_CACHE_SIZE.

C. The operating system must use a 32K block size.

D. DB_32K_CACHE_SIZE must be set to a value that can be accommodated in the SGA.

E. The /u02 file system must have at least 100G space for the datafile.

A. Optimizer Statistics are collected automatically by Automatic Workload Repository (AWR) Snapshot.

B. Optimizer Statistics can be manually collected at multiple levels using DBMS_STATS.GATHER_*_STATS PL/SQL procedures.

C. Optimizer Statistics are collected in real-time as data is inserted, deleted, or updated.

D. Optimizer Statistics are collected by the Statistics Advisor.

E. Optimizer Statistics are collected automatically by an automatic maintenance job that runsduring predefined maintenance windows.

A. Dynamic service registration cannot be used for this database instance.

B. There are two listeners named LISTENER and LISTENER_1 running simultaneously using port 1521 on the same host as the database in LISTENERS.

C. The LREG process registers services dynamically with the LISTENER_1 listener.

D. LISTENER_1 must also be defined in the LISTENER.ORA file to enable dynamic service registration.

E. The definition for LISTENER_1 requires a CONNECT_DATA section to enable dynamic service registration.

A. Memory is allocated for the SGA.

B. All required background processes are started.

C. The consistency of the database is checked.

D. The control files are opened.

E. SYS can access the database.

A. Insert operations always insert new rows into blocks with free space appropriate to the length of the row being inserted.

B. PCTFREE defaults to 10% for all blocks in all segments for all compression methods.

C. The first block with enough free space to accommodate a row being inserted will always be used for that row.

D. Update operations always relocate rows into blocks with free space appropriate to the length of the row being updated.

E. ASSM assigns blocks to one of the four fullness categories based on what percentage of the block is allocated for rows.