In your database， you discovered that a tempfile in a locally managed temporary tablespace has been deleted at the operating system level. How would you recover the tablespace？（）

A .  ALTER DATABASE DROP LOGFILE GROUP 1 B .  ALTER DATABASE CLEAR LOGFILE GROUP 1 C .  ALTER DATABASE CLEAR UNARCHIVED LOGFILE GROUP 1 D .  ALTER DATABASE DROP LOGFILE MEMBER ’D：\REDO01.LOG&rsquo

A . The database is in mount state. B . One of the tablespaces is offline. C . One of the tablespaces is read only. D . The database operates in ARCHIEVELOG mode. E . The database operates in NOARCHIEVELOG mode.

A . RCO1 only. B . DB01 only. C . DB02 only. D . DB01 and DB02 only. E . DB01，DB02，and RC01.

A . Running a query on a table returns "ORA-600： Internal Error." B . Inserting a value in a table returns "ORA-01722： invalid number." C . Creating a table returns "ORA-00955： name is already used by an existing object." D . Inserting a value in a table returns "ORA-00001： unique constraint （SYS.PK_TECHP） violated." E . Inserting a row in a table returns "ORA-00060： deadlock detected while waiting for resource.&quot

A .  You find that one of the redo log members in each redo log group is lost. B .  You find that a data file that belongs to the USERS tablespace is damaged. C .  You find that a data file that belongs to the SYSTEM tablespace is damaged. D .  You find that the current redo log group is damaged and is not available for recovery. E .  You realized while performing a recovery that an archived redo log file needed for recovery is lost.

A .  the system change number B .  the locations of the redo log files C .  the locations of the datafiles D .  the physical location of all the database change

A . renaming the control files B . dropping a user in your database C . enabling or disabling redo log archiving D . dropping a tablespace in your database E . re-creating the control files， after you lost all the control files in your database

A . backup of offline tablespaces B . backup of read­only tablespaces C . backup of system­critical tablespaces D . backup of online， locally managed tablespaces E . backup of read/write dictionary­managed tablespace

A . Only the SET command must be within a RUN block. B . All commands should be executed at the RMAN prompt. C . All three commands must be within a single RUN block. D . Only the RESTORE and RECOVER commands must be within a single RUN block.

A . Running a query on a table returns "ORA-600： Internal Error." B . Inserting a value in a table returns "ORA-01722： invalid number." C . Creating a table returns "ORA-00955： name is already used by an existing object." D . Inserting a value in a table returns "ORA-00001： unique constraint （SYS.PK_TECHP） violated."  E . Inserting a row in a table returns "ORA-00060： deadlock detected while waiting for resource.&quot

A .  online redo log files B .  alert log files C .  control file D .  datafiles associated with the SYSTEM tablespace

A . The C # # ROLE1 role is created in the root database and all the PDBs. B . The C # # ROLE1 role is created only in the root database because the container clause is not used. C . Privileges are granted to the C##A_ADMIN user only in the root database. D . Privileges are granted to the C##A_ADMIN user in the root database and all PDBs. E . The statement for granting a role to a user fails because the CONTAINER clause is not used.

A . One tablespace has only one datafile B . Many tablespaces can share one datafile C . One tablespace can have many datafiles D . One datafile can contain many tablespace

A . You find that one of the redo log members in each redo log group is lost. B . You find that a data file that belongs to the USERS tablespace is damaged. C . You find that a data file that belongs to the SYSTEM tablespace is damaged. D . You find that the current redo log group is damaged and is not available for recovery. E . You realized while performing a recovery that an archived redo log file needed for recovery is lost.

A . The database is in mount state. B . One of the tablespaces is offline. C . One of the tablespaces is read only. D . The database operates in ARCHIEVELOG mode.  E . The database operates in NOARCHIEVELOG mode.

A . adding a new user to the database B . dropping a user from the database C . dropping a table from the database D . dropping a data file from a tablespace E . adding a new tablespace to the database

A .  Backup of offline tablespaces. B .  Backup of read-only tablespaces. C .  Backup of system-critical tablespaces. D .  Backup of online， locally managed tablespaces. E .  Backup of read/write dictionary-managed tablespaces.

A .  Put the database in hot backup mode and perform an online backup，including backing up the  archived redo logs. B .  Just back up the database datafiles without shutting down the database. C .  You will have to wait until you can shut down the database to perform the backup. D .  Mark each datafile as backup in progress， back them up individually，and then mark them as backup not in progress. No archived redo logs will need to be backed up. E .  Only back up the datafiles that the user will not be touching. Once the user has finished what they were doing，you can shut down the database and back up the datafiles the user changed during the  course of the remaining backu

A . the time when the last flashback operation in your database was performed B . the time when the first flashback operation in your database was performed C . a list of flashback operations performed in your database using SCN and time D . the approximate time and the lowest system change number （SCN） to which you can flash back your database

A . Hot backup B . Online backup C . consistent backup D . incremental backup E . inconsistent backu

A . The destination must be global only. B . A maximum of five destinations can be assigned. C . A maximum of ten different destinations can be assigned. D . All the destinations are determined by the server automatically. E . The destination may be local or remote for a Standby Database. F . The destination can be changed by setting the LOG_ARCHIVE_FORMAT initialization parameter.

A . You performed rollback after commit. B . If a log switch occurs in your database. C . Thearchiverfails to generate an archived log file. D . Instance recovery fails to find one of the redo log files. E . A long-running query is unable to get read-consistent image. F . If you perform manual undo management operations in auto mode.

A . Hot backup B . Online backup C . consistent backup D . incremental backup E . inconsistent backu

A . The database instance aborts. B . The database operation temporarily halts till the member becomes available. C . Writing proceeds as normal. LGWR writes to the available members of a group and ignores the unavailable members. D . The member would be marked as STALE and an error message would be written to the alert log file and LGWR trace file. E . The status of the group changes to INACTIVE and an error message would be written to the alert log file and LGWR trace file.

A . Execute the ALTER DATABASE ARCHIVELOG statement B . Select ARCHIVELOG option in the database control and restart the database to apply the changes. C . Shut down and start the instance， and in the NOMOUNT state execute the ALTER DATABASE ARCHIVELOG statement. D . Shut down and start the instance， mount the database， then execute the ALTER DATABASE ARCHIVELOG statement.