You lost a temporary file that belongs to the default temporary tablespace in your database. From the options provided， which approach would you take to solve the problem？（）

相似题目

• In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure？ How would you recover the lost redo log member？（）

  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 data file become corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）

  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.

  查看最佳答案

• Due to media failure you lost one of the data files belonging to the USERS tablespace， and the tablespace is not available to use. Which statement regarding the status of the database is true？（）

  A . The database remains open. B . The database gets dismounted. C . The database becomes read only. D . The database instance gets aborted. E . The database gets shut down automatically. F . The status of the database depends on the status of the USERS tablespace.

  查看最佳答案

• You are planning to anchor in an area where several anchors have been lost due to fouling.As a precaution，you should（）.

  A . anchor using both anchors B . anchor with scope of 8 or more to 1 C . use a stern anchor D . fit a crown strap and work wire to the anchor

  查看最佳答案

• You have a file server that runs Windows Server 2008. A user restores a large file by using thePrevious Versions tab. You need to view the progress of the file restoration. What should you do？ （）

  A .  From the command prompt， run shadow.exe B .  From the command prompt， run vssadmin.exe query reverts C .  From Computer Management， click on the Shared Folders node and then click on Sessions. D .  From Computer Management， click on the Shared Folders node and then click on Open File

  查看最佳答案

• Which are SRW package procedure or function could you use to create and then drop a temporary table in the sales report?（）

  A . SRW.BREAK  B . SRW.SET_ALTER  C . SRW.REFERENCE  D . SRW.DO_SQL  E . SRW.RUN_REPORT F . SRW.SET_FIELD

  查看最佳答案

• You encrypt three files to ensure the security of the files. You want to make a backup copy of these three files and maintain their security settings. You have the option of backing up to either the network or a floppy disk. What should you do？（）

  A . Copy the files to a network share on an NTFS volume. Do nothing further. B . Copy the files to a network share on a FAT32 volume. Do nothing further. C . Copy the files to a floppy disk that has been formatted by using Win2000 Professional. Do nothing further. D . Place the files in an encrypted folder. Then copy the folder to a floppy disk.

  查看最佳答案

• You have a portable computer that runs Windows 7. The computer is configured to keep an offline versionof files located in a network share. You need to identify whether you are working on an offline version of a file.  What should you do?（）

  A . From Sync Center， click View sync partnerships. B . From Action Center， click View archived messages. C . From Windows Explorer， select the file and then view the toolbar. D . From Windows Mobile Device Center， click the Connection settings.

  查看最佳答案

• In your database， online redo log files are multiplexed and one of the members in a group is lost due to media failure.  How would you recover the lost redo log member？（）

  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

  查看最佳答案

• If you are going to run a TSPITR recovery， which view will help you to determine which objects will be lost during the TSPITR？（）

  A .  TS_OBJECTS_TO_BE_DROPPED B .  TS_PTTR_OBJECT_DROPPED C .  TS_PITR_OBJECTS_TO_BE_DROPPED D .  TS_OBJECTS_DROPPED E .  TS_DROPPED_OBJECTS

  查看最佳答案

• You are designing a Windows Azure application that will use a worker role. The worker role will create temporary files.  You need to recommend an approach for creating the temporary files that minimizes storage transactions.  What should you recommend？（）

  A .  Create the files on a Windows Azure Drive. B .  Create the files in Windows Azure local storage. C .  Create the files in Windows Azure Storage page blobs. D .  Create the files in Windows Azure Storage block blobs.

  查看最佳答案

• The database is running in NOARCHIVELOG mode. A data file is lost. Which two are valid options for recover？（）

  A . Restore the data file and perform incomplete recovery. B . Restore the data file and perform point-in-time recover. C . Drop the tablespace and lose all data in the tablespace. D . Restore the database and lose all data since the last backup.

  查看最佳答案

• You need to restore some files from a file system. The file system was backed up from a snapshot.  Which command will correctly restore these files？（）

  A .  fssnap -i B .  fssnap -r C .  ufsrestore -i D .  snaprestore -i

  查看最佳答案

• You are developing an application to create a new file on the local file system.You need to define specific security settings for the file. You must deny the file inheritance of any default security settings during creation.What should you do？（）

  A . Create the file by using a new FileStream object by passing the FileSecurity object as a parameter to the FileStream constructor. B . Create a new FileSecurity object. C . Apply the permissions by using the File class. D . Create a new FileSystem Access Rule object for each permission that you need，and add each rule to the FileSecurity object. E . Create a new FileSystem Audit Rule object and add it to the FileSecurity object.

  查看最佳答案

• You want to create a temporary table while executing a procedure in a form. Which statement is true?（）

  A . You cannot create a table form within Forms.  B . You must use the FORMS_DDL built-in to create the table.  C . You must use the DBMS_DYNAMIC_DDL package to create the table.  D . You can write the CREATE TABLE statement directly into the trigger.

  查看最佳答案

• 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 . flash back the database B . perform point-in-time recovery C . perform a full database recovery D . drop and re-create the tablespace E . use Recovery Manager （RMAN） to recover the database

  查看最佳答案

• You have a file server that runs Windows Server 2008. A user restores a large file by using the Previous Versions tab. You need to view the progress of the file restoration  what should you do（）？   

  A . From the command prompt， rum shadow.exe /v B . From the command prompt， run vssadmin.exe query reverts C . From Computer management， click on the shared folders node and then click on sessions D . From computer management， click on the shared folders node and then click on open files.

  查看最佳答案

• When you create a backup control file， where is the resulting file written to？（）  

  A .  The database user dump destination directory B .  The database diagnostic destination directory C .  To $ORACLE_HOME/rdbms D .  To $ORACLE_HOME/admin E .  To the directory and filename you specify in the command

  查看最佳答案

• You have a computer that runs Windows Vista. You need to ensure that the temporary Internet files are deleted when you close Windows Internet Explorer. What should you do?（） https://assets.asklib.com/images/image2/2018073115050493733.jpg

  A . A B . B C . C D . D

  查看最佳答案

• You lost a data file that belongs to an index tablespace in your database， which operates in ARCHIVELOG mode. Loss of the data file resulted in increased response time on your queries. Which two options would you use to solve this problem？ （）

  A .  Restore the lost data file from the backup， and then flash back the database. B .  Restore the data file pertaining to index tablespace， and then recover the tablespace. C .  Restore all the data files， and then perform an incomplete recovery to get the tablespace back. D .  Restore all the data files， and then perform an incomplete recovery using the backup control file. E .  Drop and re-create the index tablespace， and then re-create all of the indexes in that tablespace.

  查看最佳答案

• If you lost your entire database，including the database spfile，control files，online redo logs，and database datafiles，what kind of recovery would be required with RMAN？（）  

  A .  Complete database recovery. B .  Incomplete database recovery. C .  Approximate database recovery. D .  Archived database recovery. E .  The database could not be recovered with RMAN.

  查看最佳答案

• While creating a database using Database Configuration Assistant tool， you created a database default temporary tablespace. Which activity would cause the default temporary tablespace of the database to be used？（）

  A . the CREATE TABLE .. command B . sorting of the SYSTEM tablespace’s data C . sorting of data required by recursive SQL statements D . the CREATE TABLE .. ORGANIZATION EXTERNAL .. command E . sorting of data if the users have not been allocated temporary tablespace explicitly F . sorting of data if the users have been allocated temporary tablespace explicitly

  查看最佳答案

• A data file became corrupted in your database due to bad sectors on the disk. Because of corruption， you lost all the important tables in that data file. Which method would you use for recovery？（）

  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

  查看最佳答案

• 1. Admit that you're lost. The first step in getting help is recognizing that you have a________.

  查看最佳答案