C. Bigfile tablespaces are new to Oracle10g and can have only a single datafile. The traditional or smallfile tablespace can have many datafiles.

D. Segment space management refers to free space management, with automatic segment space management using bitmaps instead of FREELISTS, PCTFREE, and PCTUSED.

B. Indexes, constraints, and triggers all have separate namespaces. Tables share a namespace with views, sequences, private synonyms, procedures, functions, packages, materialized views, and user-defined types. Objects within the same schema sharing a namespace must have unique names.

B. Redo information is not stored in a segment; it is stored in the redo logs. Undo segments are stored in the undo tablespace, temporary segments are in the temporary tablespace, and permanent segments go into all the other tablespaces.

A. The autoextend MAXSIZE parameter tells Oracle how large a data or temp file can grow to. UNLIMITED specifies no bounds to the automatic growth.

D. The character datatypes include char, nchar, varchar, varchar2, nvarchar2, and long but do not include string.

C. With Oracle 6 through Oracle 9i, infinity could not be represented in the database. With Oracle10g, however, binary_float and binary_double can represent infinity, not a number (NAN), as well as several other special values.

B. Objects in an Oracle10g database can always include letters, numbers, and the characters $, _, and # (dollar sign, underscore, and pound sign). Names can include any other character only if they are enclosed in double quotes. The character dollar sign is not a special meta-character in an Oracle10g database.

A. There is no time or datetime datatype in Oracle10g. The date datatype cannot store subsecond granularity. The timestamp datatype stores subsecond granularity, defaulting to six digits of precision.

C. Heap organized is a table that is not index organized; it is not an index type. XOR is bitwise function and not an index type. Bitmap is an index type, but cannot be used for a unique index. Btree indexes make fine unique indexes.

E. You can rename both a constraint and an index to the same name as a table—they are in separate namespaces. Columns can be added, and owner is a valid column name. If the check constraint condition evaluates to FALSE, the data value will not be allowed; if the condition evaluates to either TRUE or NULL, the value is allowed.

D. A default clause ensures that the column does not contain a NULL after an insert, but not after an update. MAKE is not a reserved word, and an index will be created on the primary key.

B. Constraints can be created as deferrable and initially deferred, but deferred constraint checking is not the default.

D. Views can be created on one or more base table. Views share the same namespace as tables and therefore cannot have the same name; columns, however, can be named the same as the base table. SELECT, INSERT, UPDATE, and DELETE are all valid operations on a view. One of the uses for a view is to hide portions of the base table, by granting different privileges to the view than the base table.

D. The primary use for a tablespace is to organize tables and indexes into manageable units. Some of the manageable operations that you can do to a tablespace include making it read-only or moving it from one database to another.

C. An extent is composed of two or more data blocks; a segment is composed of one or more extents, and a datafile houses all these.

B. A tablespace can have either dictionary extent management or local extent management.

B. Although binary_float and binary_double are valid datatypes, binary is not.

A. The options for temporary tables are either ON COMMIT DELETE ROWS, with causes the table to flush at the end of each transaction, or ON COMMIT PRESERVE ROWS, which causes the table to flush at the end of each session.

D. You assign or change comments on a column with the COMMENT ON COLUMN statement. The COMMENT ON TABLE statement is used to add or change the comment assigned to a table.