Online Access Free 1Z0-182 Exam Questions

What are Optimizer Statistics?

• A.Optimizer Statistics are statistics about data distribution within Oracle Datafiles.
• B.Optimizer Statistics are part of system performance statistics stored in AWR required for calculating SQL execution plans.
• C.Optimizer Statistics are table, column, index, and system statistics used for generating efficient SQL execution plans.
• D.Optimizer Statistics are a set of data distribution statistics collected in real time as data is inserted, deleted, or updated, which are stored in AWR and used for generating SQL execution plans.

Which two statements are true about views used for viewing tablespace and datafile information?

• A.V$TABLESPACE displays information that is contained in the control file about tablespaces.
• B.Tablespace free space can be viewed in DBA_TABLESPACES.
• C.V$TABLESPACE displays information about tablespaces contained in the data dictionary.
• D.A datafile can be renamed when the database is in MOUNT state and the new file name is displayed when querying DBA_DATA_FILES after the database is opened.
• E.Tablespace free space can be viewed in V$TABLESPACE.

Which two tasks can you perform using DBCA for databases?

• A.Enable flashback database for an existing database.
• B.Configure a nonstandard block size for a new database.
• C.Change the standard block size of an existing database.
• D.Configure incremental backups for a new database.
• E.Register a new database with an available Enterprise Manager Management server.

Which three Oracle database space management features will work with both Dictionary and Locally managed tablespaces?

• A.Online index segment shrink.
• B.Capacity planning growth reports based on historical data in the Automatic Workload Repository (AWR).
• C.Online table segment shrink.
• D.Oracle Managed Files (OMF).
• E.Automatic data file extension (AUTOEXTEND).

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?

• A.It is a locally managed tablespace.
• B.It uses the database default block size.
• C.Free space is managed using freelists.
• D.It must be smaller than the smallest BIGFILE tablespace.
• E.Any data files added to the tablespace must have a size of 5 gigabytes.