Examine the command： SQL> DBMS_STATS.SET_TABLE_PREFS（’SH’， ’CUSTOMERS’， ’PUBLISH’， ’false’）；  Which statementdescribes the effect of the above command（）

A .  when ASM disk goes offline B .  when one or more ASM files are dropped C .  when some disks in a disk group are offline D .  when some disks in a failure group for a disk group are rebalancing

A . The shrink operation touches every block in the BOOKING table B . The high-water mark (HWM) for the BOOKING table is shifted from its original position C . The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table D . The data manipulation language (DML) triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operatio

A . The import operation must be performed by a user on the target database with the DATAPUMP_IMP_FULL_DATABASE role, and the database link must connect to a user on the source database with the DATAPUMP_EXD_FULL_DATABASE role. B . All the user-defined tablespaces must be in read-only mode on the source database. C . The export dump file must be created before starting the import on the target database. D . The source and target database must be running on the same platform with the same endianness. E . The path of data files on the target database must be the same as that on the source database. F . The impdp operation must be performed by the same user that performed the expdp operation.

A . The constraint remains valid. B . The index on the constraint is dropped. C . It allows the loading of data into the table using SQL *Loader. D . New data conforms to the constraint， but existing data is not checked. E . It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.

A . The backup piece is expired as the new backup is available. B . The backup piece is expired because the operating-system file was not found. C . The backup piece is expired because the retention period for the backup has expired. D . The backup piece is expired because the backup set to which it belongs is not complete

A . when ASM disk goes offline B . when one or more ASM files are dropped C . when some disks in a disk group are offline D . when some disks in a failure group for a disk group are rebalancing

A .  The shrink operation touches every block in the BOOKING table B .  The high-water mark （HWM） for the BOOKING table is shifted from its original position C .  The progress of the shrink operation is saved in the bitmap blocks of the BOOKING table D .  The data manipulation language （DML） triggers on the BOOKING table are executed because the shrink operation is internally handled by the INSERT/DELETE operatio

A . The SKD user cannot log in to the database instance. B . The objects owned by the SKD user are not accessible to any user. C . The other users can access the objects owned by the SKD user， on which they have access. D . The password for the SKD user expires and the user is forced to change the password at the next log in.

A . An EMP table is created if a table does not exist. Otherwise, if the EMP table is appended with the loaded data. B . The SQL* Loader data file myfile1.dat has the column names for the EMP table. C . The SQL* Loader operation fails because no record terminators are specified. D . Field names should be the first line in the both the SQL* Loader data files. E . The SQL* Loader operation assumes that the file must be a stream record format file with the normal carriage return string as the record terminator.

A . A CHECK constraint is created on the OID column. B . A NOT NULL constraint is created on the OID column. C . The ORDERS table is the only object created in the USERS tablespace. D . The ORDERS table and a unique index are created in the USERS tablespace. E . The ORDERS table is created in the USERS tablespace and a unique index is created on the OIDcolumn in the SYSTEM tablespace.

A . The constraint remains valid. B . The index on the constraint is dropped. C . It allows the loading of data into the table using SQL*Loader. D . New data conforms to the constraint， but existing data is not checked E . It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL statements.

A . It cancels all pending disk drops within the disk group. B . It restores disks that are being dropped as the result of a DROP DISKGROUP operation C . It mounts disks in the disk group for which the drop-disk operation has already been co pleted D . It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed E . It adds previously dropped disks back into the disk grou

A .  When two-way disk mirroring is required for the allocation units B .  When three-way disk mirroring is required for the allocation units C .  When using hardware mirroring or RAID D .  When disk mirroring is required for the Automatic Storage Management （ASM） disk

A . Automatic statistics collection is stopped for the CUSTOMERS table. B . Statistics for the CUSTOMERS table are locked and cannot be overwritten. C . Existing statistics for the CUSTOMERS table become unusable for the query optimizer. D . Subsequently， statistics gathered on the CUSTOMERS table are stored as pending statistics.

A . The SKD user cannot log in to the database instance. B . The objects owned by the SKD user are not accessible to any user. C . The other users can access the objects owned by the SKD user， on which they have access. D . The password for the SKD user expires and the user is forced to change the password at the next log i

A . A CHECK constraint is created on the OID column. B . A NOT NULL constraint is created on the OID column. C . The ORDERS table is the only object created in the USERS tablespace. D . The ORDERS table and a unique index are created in the USERS tablespace. E . The ORDERS table is created in the USERS tablespace and a unique index is created on the OID columnin the SYSTEM tablespace.

A .  It cancels all pending disk drops within the disk group. B .  It restores disks that are being dropped as the result of a DROP DISKGROUP operation C .  It mounts disks in the disk group for which the drop-disk operation has already been co pleted D .  It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed E .  It adds previously dropped disks back into the disk grou

A . The backup piece is expired as the new backup is available. B . The backup piece is expired because the operating-system file was not found. C . The backup piece is expired because the retention period for the backup has expired. D . The backup piece is expired because the backup set to which it belongs is not complete.

A . Statistics collection is not done for the CUSTOMERS table when schema stats are gathered. B . Statistics collection is not done for the CUSTOMERS table when database stats are gathered. C . Any existing statistics for the CUSTOMERS table are still available to the optimizer at parse time. D . Statistics gathered on the CUSTOMERS table when schema stats are gathered are stored as pending statistics. E . Statistics gathered on the CUSTOMERS table when database stats are gathered are stored as pending statistics.

A . Creates an additional copy of the database online redo log files.  B . Stores the primary key column values of each row involved in a DML operation in the online redo log files.  C . Stores the primary key column values of each row involved in a DML operation in the supplemental log files.  D . Stores the old and new primary key column values of each row involved in a DML operation only when the primary key is modified in the online redo log files.

A . Database operations will be monitored only when they consume a significant amount of resource. B . Database operations for all sessions will be monitored. C . Database operations will be monitored only if the STATISTICS_LEVEL parameter is set to TYPICAL and CONTROL_MANAGEMENT_PACK_ACCESS is set DIAGNISTIC + tuning. D . Only DML and DDL statements will be monitored for the session. E . All subsequent statements in the session will be treated as one database operation and will be monitored.

<img src='https://img2.soutiyun.com/ask/uploadfile/2019-03-27/a303b81782e5cc63228b13b8df2b43c9.jpg' /> A. Flashback logging is not enabled for the database. B. The changes made to the table are not committed. C. Supplemental logging is not enabled for the database. D. The database is not configured in ARCHIVELOG mode.

A. It cancels all pending disk drops within the disk group B. It restores disks that are being dropped as the result of a DROP DISKGROUP operation C. It mounts disks in the disk group for which the drop-disk operation has already been completed D. It restores all the dropped disks in the disk group for which the drop-disk operation has already been completed E. It adds previously dropped disks back into the disk group