You issued the following command on the temporary tablespace LMTEMP in your database：   SQL>ALTER TABLESPACE lmtemp SHRINK SPACE KEEP 20M；   Which requirement must be fulfilled for this command to succeed？（）  

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 .  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 .  After two days， the backup will be marked obsolete. B .  After two days， the backup will be deleted from the media. C .  If the RMAN repository has records of two or more recent backups of a file， then the older backup will be deleted from the media. D .  If the RMAN repository has records of two or more recent backups of a file， then the older backup will be marked obsolete.

A .  The current control file is not automatically backed up every time you perform a backup. B .  The backups save space on the storage media. C .  While performing backups across a network， the network bandwidth is reduced. D .  The backups consist of backup pieces.

A . The command will not execute successfully because TIMEOUT is an invalid clause with the ALTER DATABASE ENABLE RESUMABLE command. B .  The command will not execute successfully because resumable space allocation is enabled at the session level. C .  The command will execute successfully and resumable space will be allocated at the session level. D .  The command will execute successfully and resumable space will be allocated at the instance level.

A .  The control file will be multiplexed. B .  The control file will be recreated. C . The script containing the CREATE CONTROLFILE statement will be created. D .  The binary backup of the control file will be created.

A . Archived redo log files are backed up along with data files. B . Only data files are backed up and a restore point named FY06Q4 is created. C . Archived log files are backed up along with data files, and the archived log files are deleted. D . The command creates a restore point named FY06Q4 to match the SCN at which this backup is consistent.

A .  It enables a PVST+ instance of 10 for vlan 11 and vlan 12 B .  It enables vlan 11 and vlan 12 to be part of the MST region 10 C .  It maps vlan 11 and vlan 12 to the MST instance of 10. D .  It creates an Internal Spanning Tree （IST） instance of 10 for vlan 11 and vlan 12   E .  It create a Common Spanning Tree （CST） instance of 10 for vlan 11 and vlan 12 F .  It starts two instances of MST， one instance for vlan 11 and another instance for vlan 12.

A . Immediately following statement execution  B . After the ALTER TABLE DROP UNUSED COLUMNS command is issued  C . After the ALTER TABLE SET UNUSED COLUMN command is issued  D . After the ALTER TABLE MODIFY command is issued

A .  The client RDBMS instance can access the file as a read-only file. B .  A new disk cannot be added to a disk group. C .  A disk in a disk group can be taken offline. D .  The client RDBMS instance cannot access the files in the disk group.

A .  The operating system local time zone will be set for a user session using the operating system environment variable. B .  The database local time zone will be set for a user session using the operating system environment variable. C .  The operating system local time zone will be set for the database using the operating system environment D .  The database local time zone will be set for the database using the operating system environment variable.

A . It returns an error because the range partitions P1 and P2 should be of the same range. B . It creates two range partitions (P1, P2). Within each range partition, it creates monthwise subpartitions. C . It creates two range partitions of varying range. For data beyond '1-1-2007,' it creates partitions with a width of one month each. D . It returns an error because the number of tablespaces (TBS1,TBS2,TBS3)specified does not match the number of range partitions (P1,P2) specified.

A .  when the schema of the user， SCOTT， was deleted by mistake 15 minutes ago B .  when the table EMP of the SCOTT schema was dropped by mistake 15 minutes ago C .  when some rows of the table， EMP， in the SCOTT schema were deleted by mistake 15 minutes ago D .  when some incorrect values were inserted in the EMP table in the user Scott’s schema during the last 15 minutes E .  never， because FLASHBACK TABLE is not a valid command in Oracle 10g.

A .  When a successful backup is recorded in the RMAN repository， then a backup of the current control file is performed. B .  When a structural change is made to the database， then a backup of the current control file is performed. C .  When a successful backup is performed in the RMAN repository， then a backup of the spfile is performed. D .  When a structural change is made to the database， then a backup of the alert log file will be performed.

A .  An incremental backup strategy will be used automatically. B .  Read-only datafiles will not be backed up as long as backups of those files already exist and those backups meet established retention criteria. C .  RMAN will configure itself for maximum performance at the cost of CPU. D .  RMAN will configure itself for minimal OS/CPU impact at the cost of time to back up the database. E .  RMAN will automatically compress backups.

A .  when all the control files are missing and only a binary backup of the current control file exists B .  when a multiplexed copy of the current control file is missing C . when all the control files are missing and only a script containing the CREATE CONTROLFILE statement exists D .  when the SPFILE is missing

A .  After two days，a backup will be marked obsolete B .  After two days，a backup will be deleted from the media C .  If the RMAN repository has records of two or more recent backups of a file，then older backups will be deleted from the media. D .  If the RMAN repository has records of two or more recent backups of a file then older backups will be marked obsolete.

A .  to configure RMAN to maintain backup information in the RMAN repository for seven days B .  to configure RMAN to maintain backup information in the control file for at least seven days C .  to display the list of files that have not been backed up for the last seven days D .  to display the list of files that must be backed up within seven day

A .  If you perform a backup across a network， then the backup will reduce the bandwidth. B .  If you perform a backup of a datafile， then the backup will be the same as the operating system copy of the datafile. C .  If you perform a backup of a single datafile， then the control file will not be backed up.  D .  The maximum size of each backup set is 10MB E .  The backups will be performed on the disk.

A . All data along with the table structure is deleted  B . The pending transaction in the session is committed  C . All indexes on the table will remain but they are invalidated  D . All views and synonyms will remain but they are invalidated  E . All data in the table are deleted but the table structure will remai

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 . After two days, a backup will be marked obsolete B . After two days, a backup will be deleted from the media C . If the RMAN repository has records of two or more recent backups of a file, then older backups will be deleted from the media. D . If the RMAN repository has records of two or more recent backups of a file, then older backups will be marked obsolete.

A. All database operations performed by the impdp command are logged. B. Only CREATE INDEX and CREATE TABLE statements generated by the import are logged. C. Only CREATE TABLE and ALTER TABLE statements generated by the import are logged. D. None of the operations against the master table used by Oracle Data Pump to coordinate its activities are logged.

A. ALTER DISKGROUP dg1 UNDROP disk2, disk3, disk5; B. ALTER DISKGROUP dg1 UNDROP; C. ALTER DISKGROUP dg1 UNDROP DISKS; D. You cannot cancel the pending disk drops.

A. TK1 show version B. TK1 show protocols C. TK1 show interfaces D. TK1 show controllers E. TK1 show ip interface F. TK1 show startup-config