1Z0-035 무료 덤프문제 온라인 액세스

The new time and date data types support greater precision for capturing fractional seconds and time zone information. This gives the Oracle9i database greater flexibility in supporting locality preferences. What is the default degree of precision of fractional seconds when specifying the TIMESTAMP data type?

• A.22 digits
• B.6 digits
• C.9 digits
• D.12 digits

In order to speed foreign key creation, Oracle9i will cache the first _____ primary key values only where there are multirow DML statements.

• A.512
• B.32
• C.256
• D.128

Your database has tablespaces with different block sizes. What must you do to back these up with RMAN?

• A.You need to issue a separate RMAN BACKUP command to group tablespaces with the same block size.
• B.You can simply issue the RMAN BACKUP command, because a backup set can contain tablespaces of different block sizes.
• C.You need to use RMAN BACKUP BLOCKSIZE=nK to select tablespaces that are not the same size as the standard block size.
• D.You must allow for the fact that RMAN will generate several backupsets, one for each block size, when you issue the RMAN BACKUP command.

You need to add a column to a table that holds updateable image data. Which data type should you use for this column?

• A.BFILE
• B.CLOB
• C.LOBFILE
• D.BLOB

Which statement correctly describes the function of the Oracle9i Cache Fusion feature?

• A.It lets you dynamically reassign memory in your database buffer cache to different block buffer sizes.
• B.It allows you to add new sites to multimaster replication environment without quiescing the master definition site.
• C.It enables you to execute scalable applications on a clustered database without having to partition the users or the database tables.
• D.It provides each session with its own view of the database at a different point in the past.