1Z0-035 試験問題を無料オンラインアクセス

Which two data types can be converted to LOBs using an ALTER TABLEODIFY command? (Choose two.)

• A.LONG
• B.LONG RAW
• C.VARCHAR
• D.RAW

What criterion does Oracle9i use to determine whether a database file is an Oracle Managed File?

• A.information stored inside the corresponding initialization parameter file for the instance
• B.information stored inside a data dictionary table
• C.the filename format
• D.information stored in the ALERT.LOG file for the corresponding instance

If you create your database using Oracle Managed Files (OMF), what is true?

• A.If your CREATE DATABASE command fails, any OMF database files that have already been created will be dropped automatically.
• B.You must define directories for two online redo log groups and three copies of the control file.
• C.You must use only OMF data files when adding new tablespaces or data files to your database in the future.
• D.You must use Oracle predefined names to identify raw partitions that will hold OMF structures.

What are three advantages of index-organized tables? (Choose three.)

• A.Fewer I/O operations are needed to retrieve data.
• B.Less physical storage space is needed for the data.
• C.Data is stored in primary key sequence.
• D.The table needs to be analyzed less frequently.

When querying the new v$spparameter view, the column ISSPECIFIED displays the value TRUE for a number of parameters. What does this mean?

• A.The parameters are specified in the PFILE parameter file.
• B.Changes to the parameter are only in the currently running instance.
• C.The parameters are specified in the SPFILE parameter file.
• D.The value for the parameters is TRUE.