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

View the Exhibit and examine the setting for a table.

Which statement is true about the PCTFREE setting for the table?

• A.It sets the minimum percentage of a data block to be reserved to contain chained rows from other blocks.
• B.It sets the minimum percentage of a block that can be used for row data plus overhead before new rows are added to the block.
• C.It sets the minimum percentage of a data block to be reserved to contain the bitmap used to maintain the free block information.
• D.It sets the minimum percentage of a data block to be reserved as free space before the server prevents inserts into the block.

You are installing Oracle Database 11g on your server. During the installation Oracle Universal Installer (OUI) prompts you to enter the path of the inventory directory and also prompts you to specify an operating system group name.
Which statement is true in this case?

• A.The operating system group that will be specified should have root user as its member.
• B.The installation is being performed by the root user.
• C.The operating system group that will be specified must have permission to write to the inventory directory.
• D.The installation is being performed without the "Create Starter Database" option selected.
• E.The ORACLE_BASE parameter is not set.

You want to access employee details contained in flat files as part of the EMPLOYEE table.
You plan to add a new column to the EMPLOYEE table to achieve this.
Which data types would you use for the new column?

• A.LONG RAW
• B.BFILE
• C.BLOB
• D.CLOB

Which is true about enabling AUTOEXTEND for data files?

• A.It can be enabled for a new data file that is added to a tablespace only if the existing data files in that tablespace have autoextend enabled.
• B.It can be enabled for an existing data file in a tablespace by using the ALTER TABLESPACE command.
• C.It can be enabled only for data files only in smallfile tablespaces.
• D.It can be enabled only for data files in non-OMF tablespaces.
• E.It can be enabled only for data files only in biglfile tablespaces.

Examine the following output:

Which two statements about the above index are true? (Choose two.)

• A.The index cannot be rebuilt, and has to be re-created.
• B.It is ignored by the query optimizer.
• C.It is not used while the index is being rebuilt.
• D.The index is automatically rebuilt when used the next time.