You execute this command to drop the ITEM table， which has the primary key referred in the ORDERtable：  SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE；  Which two statements are true about the effect of the command（）

A . It will display a list of files that need incremental backup B . It will display a list of files that need backup after five days C . It will display a list of files that were backed up in the last five days D . It will display a list of files that have not been backed up in the last five days E . It will apply the current retention policy to determine the files that need to be backed u

A .  a list of files that require a backup within three days B .  a list of files that have not been backed up for three days C .  a list of files that RMAN recommends be backed up only once in every three days， based on low volatility D .  a list of files for which a backup has already been performed and may need a backup after three day

A . Because row IDs may change during the flashback operation B . Because the object number changes after the flashback operation C . Because the rows are retrieved from the recycle bin during the flashback operation D . Because the table is moved forward and back to a temporary during the flashback opertio

A . One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session. B . One audit record is created for every session when any user successfully drops a table owned by SCOTT. C . One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT. D . One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session. E . One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.

A .  It will display a list of files that need incremental backup B .  It will display a list of files that need backup after five days C .  It will display a list of files that were backed up in the last five days D .  It will display a list of files that have not been backed up in the last five days E .  It will apply the current retention policy to determine the files that need to be backed u

A . One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session. B . One audit record is created for every session when any user successfully drops a table owned by SCOTT. C . One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT. D . One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session. E . One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.

A . All control files are opened. B . All redo log files are opened C . The password file is opened. D . The parameter file is opened. E . All online data files are opened.

A . Oneauditrecord is created for every successful DROP TABLE command executed in the session ofSCOTT. B . Oneauditrecord is generated for the session when SCOTT grants the DROP ANY TABLE privilege toother users. C . One audit record is created for the whole session if user SCOTT successfully drops one or more tablesin his session. D . One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully. E . One audit record is created for every successful DROP TABLE command executed by any user to droptables owned by SCOTT.

A . All control files are opened B . All redo files are opened C . The password file is opened D . The parameter file is opened E . All online data files are opened

A .  A list of files that require a backup within 3 days B .  A list of files requiring more than 3 days of archivelogs to apply C .  A list of files that RMAN recommends be backed up only once in every three days，based on low volatility D .  A list of files for which a backup as already been performed in the last three days and which is  required to be backed up again based on the high number of transactions performed on them

A . SPFILE B . archive log C . control file D . system tablespace

A .  a list of files that require a backup within three days B .  a list of files requiring more than 3 days of archive logs to apply C .  a list of files that RMAN recommends be backed up only once in every three days，based on low volatility D .  a list of files for which a backup has already been performed in the last three days and which is required to be backed up again based on the high number of transactions performed on them

A . The database is in NOMOUNT state. B . The database is in ARCHIVELOG mode and the tablespace is online. C . The database is in ARCHIVELOG mode and the tablespace is offline. D . The database is in NOARCHIVELOG mode and the tablespace is online. E . The database is in NOARCHIVELOG mode and the tablespace is offline.

A . The command must be issued in MOUNT state. B . The command succeeds only if the data file is offline. C . The command must be issued when the database is in the archivelog mode. D . The command succeeds if no extent in the tablespace is currently allocated above the 150 MB boundary of the file.

A . back up the control file to trace B . bring database to the MOUNT state C . open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database D . set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

A . A list of files that require a backup within 3 days B . A list of files requiring more than 3 days of archivelogs to apply C . A list of files that RMAN recommends be backed up only once in every three days, based on low volatility D . A list of files for which a backup as already been performed in the last three days and which is required to be backed up again based on the high number of transactions performed on them

A .  The database is in NOMOUNT state. B .  The database is in NOARCHIVELOG mode and the tablespace is online. C .  The database is in NOARCHIVELOG mode and the tablespace is offline. D .  The database is in ARCHIVELOG mode and the tablespace is offline. E .  The database is in ARCHIVELOG mode and the tablespace is online.

A . a list of files that require a backup within three days B . a list of files that have not been backed up for three days C . a list of files that RMAN recommends be backed up only once in every three days， based on low volatility D . a list of files for which a backup has already been performed and may need a backup after three day

A .  back up the control file to trace B .  bring database to the MOUNT state C .  open a connection to the RMAN recovery catalog， which contains the RMAN metadata for the target database D .  set the database ID （DBID）， but only if the DB_NAME parameter associated with the target database is unique in the recovery catalog

A . One audit record is created for every successful DROP TABLE command executed in the session of SCOTT. B . One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to otherusers. C . One audit record is created for the whole session if user SCOTT successfully drops one or more tables inhis session. D . One audit record is created for every session of any other user in which a table owned by SCOTT isdropped successfully. E . One audit record is created for every successful DROP TABLE command executed by any user to drop Tables owned by SCOTT

A . It will permit the use of uppercase passwords for database users who have been granted the SYSOPER role. B . It contains username and passwords of database users who are members of the OSOPER operating system group. C . It contains usernames and passwords of database users who are members of the OSDBA operating system group. D . It will permit the use of lowercase passwords for database users who have granted the SYSDBA role. E . It will not permit the use of mixed case passwords for the database users who have been granted the SYSDBA role.

A .  It will display a list of files that need incremental backup. B .  It will display a list of files that need backup after five days. C .  It will display a list of files that were backed up in the last five days. D .  It will display a list of files that have not been backed up in the last five days. E .  It will apply the current retention policy to determine the files that need to be backed up.

A . One audit record is created for the whole session if user SCOTT successfully drops one or more tables in his session. B . One audit record is created for every session when any user successfully drops a table owned by SCOTT. C . One audit record is created for each successful DROP TABLE command executed by any user to drop tables owned by SCOTT. D . One audit record is generated for the session when SCOTT grants the DROP ANY TABLE privilege to other users in his session. E . One audit record is created for each successful DROP TABLE command executed in the session of SCOTT.

A .  Because row IDs may change during the flashback operation B .  Because the object number changes after the flashback operation C .  Because the rows are retrieved from the recycle bin during the flashback operation D .  Because the table is moved forward and back to a temporary during the flashback opertio

A. Because row IDs may change during the flashback operation B. Because the object number changes after the flashback operation C. Because the rows are retrieved from the recycle bin during the flashback operation D. Because the table is moved forward and back to a temporary during the flashback operation