You lost the PRODSTD tablespace， which was read/write. The tablespace was read­only when the last backup was performed. How would you recover the tablespace？（）

A .  import the database from the last export B .  restore all the members in the group from the last backup C .  drop the lost member from the database and then add a new member to the group D .  restore all the database files from the backup and then perform a complete recovery E .  restore all the database files from the backup and then perform an incomplete recovery

A .  restore the tablespace from the backup， and then perform an incomplete recovery B .  restore the tablespace from the backup， and then apply all the redo information C .  restore all the data files in the database， and then perform an incomplete recovery D .  restore the tablespace from the backu

A .  Flash back all the tables in the data file， one by one. B .  Restore the data file to a new location and perform a media recovery. C .  Flash back the database， there is no need to restore the data file. D .  Restore the data file from the most recent backup and flash the database.

A . Data Pump B . SQL scripts C . SQL*Loader D . Flashback database E . Recovery Manager （RMAN） script

A . import the database from the last export B . restore all the members in the group from the last backup C . drop the lost member from the database， and then add a new member to the group D . restore all the database files from the backup， and then perform a complete recovery  E . restore all the database files from the backup， and then perform an incomplete recovery

A . Restore and recover the datafile.  B . Restore and recover the tablespace.  C . Restore and recover the database.  D . Restore and recover the control file.  E . Restore and recover the parameter file.

A .  flash back the database B .  import the temporary tablespace from the last export C .  restore all the data files and temporary files from the last full database backup and perform a recovery D .  not perform a recovery， but create a new temporary tablespace， make it the default temporary tablespace and then drop the old tablespace

A . Design a trigger that verifies that the first names and surnames are not empty strings. B . Design a check constraint that verifies that the first names and surnames are not empty strings. C . Design a check constraint that uses a CLR user-defined function to verify that either the phone number is a null value or the format of the phone number is valid. D . Design a trigger that uses a CLR user-defined function to verify that either the phone number is a null value or the format of the phone number is valid. E . Design a check constraint that ensures that the phone number cannot be changed from a valid format to a null value or to an invalid format. F . Design a trigger that ensures that the phone number cannot be changed from a valid format to a null value.

A . You can restore the DEPT table by using the Oracle Flashback Drop feature， provided you use the RENAME TO clause. B . You can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table. C . You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema. D . You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of  the recycle bin are purged every 12 hours by default.

A . table  B . transactional trigger  C . stored procedure  D . FROM clause query

A .  The index tablespace contains bitmap indexes. B .  The index tablespace contains more than one data file. C .  The index tablespace supports only complete recovery. D .  The index tablespace is not a dictionary-managed tablespace. E .  There is a dependency relationship between a table and its indexes.

A .  You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema. B .  You can restore the DEPT table by using the Oracle Flashback Drop feature， provided you use the RENAME TO clause. C .  You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default. D .  You can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table.

A . a packet of prawn B . two packets of prawn C . a packet of praw

A .  SQL scripts B .  Recovery Manager （RMAN） script C .  Data Pump D .  SQL*Loader E .  Flashback database

A .  You must enable the row movement on the SCOTT.EMP table. B .  You must define the tablespace of the SCOTT.EMP table for automatic segment space management. C .  You must use the CASCADE clause in the ALTER TABLE SHRINK SPACE statement. D .  You must use the COMPACT clause in the ALTER TABLE SHRINK SPACE statement.

A . the DBNEWID utility B . the ANALYZE command C . the RMAN LIST command D . the RMAN REPORT command E . the RMAN CROSSCHECK command F . the RMAN BLOCKRECOVER command

A .  Restore and recover the datafile. B .  Restore and recover the tablespace. C .  Restore and recover the database. D .  Restore and recover the control file. E .  Restore and recover the parameter file.

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 . flash back all the tables in the data file， one by one B . restore the data file to a new location and perform a media recovery C . flash back the database; there is no need to restore the data file D . restore the data file from the most recent backup and flash back the database

是 否

<img src='https://img2.soutiyun.com/ask/uploadfile/10848001-10851000/1ad7fe7719e497f145de7e12382fb5a2.gif' /> 第 6 题 第1题的答案是_____

A、if B、whether C、even if