网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)

Your database operates in ARCHIVELOG mode. User/x7fmanaged consistent backups are performed every Sunday night.  On Tuesday, client A drops a table at 8:00 a.m. as follows:  SQL> DROP TABLE cust_ord PURGE;  Table dropped.  Client B executes a query at 9:00 a.m. on the same table as follows:  SQL> SELECT * FROM cust_ord; SELECT * FROM cust_ord *  ERROR at line 1:  ORA/x7f00942: table or view does not exist  Client B needs the dropped table and reports the problem to you. With reference to this scenario, which action should you take?()

  • A、retrieve the table by using the flashback feature
  • B、restore all the data files from last Sunday’s backup, and then perform a time­based recovery
  • C、restore all the data files from last Sunday’s backup, and then perform a log sequence recovery
  • D、restore all the data files from last Sunday’s backup, and then perform a cancel­based recovery
  • E、restore from last Sunday’s backup only data files that belong to the tablespace in which the table was stored, and then perform a complete recovery

参考答案

更多 “ Your database operates in ARCHIVELOG mode. User/x7fmanaged consistent backups are performed every Sunday night.  On Tuesday, client A drops a table at 8:00 a.m. as follows:  SQL DROP TABLE cust_ord PURGE;  Table dropped.  Client B executes a query at 9:00 a.m. on the same table as follows:  SQL SELECT * FROM cust_ord; SELECT * FROM cust_ord *  ERROR at line 1:  ORA/x7f00942: table or view does not exist  Client B needs the dropped table and reports the problem to you. With reference to this scenario, which action should you take?()A、retrieve the table by using the flashback featureB、restore all the data files from last Sunday’s backup, and then perform a time­based recoveryC、restore all the data files from last Sunday’s backup, and then perform a log sequence recoveryD、restore all the data files from last Sunday’s backup, and then perform a cancel­based recoveryE、restore from last Sunday’s backup only data files that belong to the tablespace in which the table was stored, and then perform a complete recovery” 相关考题
考题 To get help from a venture-captial company, you may have to__________.A.put up with unfair terms B.change your business line C..enlarge your business scope D.let them operate your business

考题 You have lost datafile 4 from your database. Which is typically the fastest way to restore your database?()  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.

考题 Your boss at Supportcenter.cn wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups?()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.

考题 You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set.   How will you migrate your database from UTF8 to AL16UTF16?()  A、 by using the RMAN utilityB、 by using the export/import utilityC、 by using the ALTER DATABASE commandD、 by enabling the change tracking feature

考题 You are working on a new Oracle Database 11g server, where only the software is installed and nodatabase is created. You plan to create a database on this server using the Database Configuration Assistant (DBCA).  Some of the requirements set for your database creation task are:  1:Configure the database to operate in shared server mode.  2:Disable automatic maintenance tasks such as optimizer statistics collection.  3:Configure a naming method to help the remote user connect to the database instance.  4:Use Automatic Storage Management (ASM) for storing the database files.  5:Configure daily database backup to flash recovery area.  6:Configure Enterprise Manager Database Control to manage the database.  Which of these requirements can be met while creating the database()A、4 and 6B、2,3,4,and 6C、1,2,4,5,and 6D、1,2,3,4,5,and 6

考题 For which database operation would you need the database to be in the MOUNT state()A、renaming the control filesB、re-creating the control filesC、dropping a user in your databaseD、dropping a tablespace in your databaseE、configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes

考题 Last night, a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database?()A、 The database writer writes to a trace file, indicating that the temporary file is not found.B、 The database prompts for a database recovery.C、 The database opens normally.D、 The database gets mounted and throws an error indicating that the temporary file requires recovery.

考题 You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state?()A、renaming the control filesB、dropping a user in your databaseC、enabling or disabling redo log archivingD、dropping a tablespace in your databaseE、re-creating the control files, after you lost all the control files in your database

考题 Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database?()  A、 Yes, if the database is in ARCHIVELOG modeB、 Yes, if the database is in NOARCHIVELOG modeC、 No, the backup is not usable in any wayD、 Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE

考题 You executed the following query in your database:  FROM V$FLASHBACK_DATABASE_LOG;  What would you determine from the output?()A、the time when the last flashback operation in your database was performedB、the time when the first flashback operation in your database was performedC、a list of flashback operations performed in your database using SCN and timeD、the approximate time and the lowest system change number (SCN) to which you can flash back your database

考题 A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java.  Knowing that your database is in danger,which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression?()A、 backup database allB、 backup compressed databaseC、 backup as compressed backupset databaseD、 backup as compressed backup database plus archivelog allE、 backup as compressed backupset database plus compress archivelog all

考题 You have lost all your database control files. To recover them, you are going to use the results of the alter database backup controlfile to trace command. Your datafiles and your online redo logs are all intact.  Which of the following is true regarding your recovery?()  A、 You will need to open the database with the resetlogs command.B、 All you need to do is execute the trace file from SQL*Plus and it will perform the recovery for you.C、 You will use the resetlogs version of the create controlfile command.D、 You will use the noresetlogs version of the create controlfile command.E、 You will use the trace file to create a backup control file, and then you will recover the database with the recover database using backup controlfile command

考题 单选题You are working on a new Oracle Database 11g server, where only the software is installed and no database iscreated. You plan to create a database on this server using the Database Configuration Assistant (DBCA).Some of the requirements set for your database creation task are: 1.Configure the database to operate in shared server mode. 2.Disable automatic maintenance tasks such as optimizer statistics collection. 3.Configure a naming method to help the remote user connect to the database instance. 4.Use Automatic Storage Management (ASM) for storing the database files. 5.Configure daily database backup to flash recovery area. 6.Configure Enterprise Manager Database Control to manage the database.  Which of these requirements can be met while creating the database()A 4 and 6B 2,3,4,and 6C 1,2,4,5,and 6D 1,2,3,4,5,and 6

考题 单选题For which database operation would you need the database to be in the MOUNT state()A renaming the control filesB re-creating the control filesC dropping a user in your databaseD dropping a tablespace in your databaseE configuring the database instance to operate in the ARCHIVELOG or NOARCHIVELOG modes

考题 单选题You executed the STARTUP MOUNT command to start your database. For which database operation do you need to start the database in the MOUNT state?()A renaming the control filesB dropping a user in your databaseC enabling or disabling redo log archivingD dropping a tablespace in your databaseE re-creating the control files, after you lost all the control files in your database

考题 单选题You work as a database administrator for Certkiller .com. You enabled tracing while creating a listener to your database.  What additional information is available to you when you enable tracing?()A Information about each Oracle Net connection.B Information about each entry in theLinstener.orafileC Information about the changed done in the databaseD Information about the different listeners in your systemE Information about all thenondatabasefiles required to operate the database

考题 单选题A shoot-out has erupted between your MS development teams using .NET and your Linux development teams using Java.  Knowing that your database is in danger,which command would you use to back up your NOARCHIVELOG mode database using RMAN with compression?()A  backup database allB  backup compressed databaseC  backup as compressed backupset databaseD  backup as compressed backup database plus archivelog allE  backup as compressed backupset database plus compress archivelog all

考题 单选题Your database is in NOARCHIVELOG mode. The database has three online redo log groups, and each group contains three online redo log members. The online redo log members are stored across three hard disks, E, F, and G, respectively. Hard disk G crashed while the LGWR background process was writing redo information to the online redo log files. What effect will this crash have on the database?()A  The database will operate normally without generating any redo.B  The database will hang, and you must shut down and restart the instance.C  The database will crash, and you must recover the database from the point of failure.D  The database will operate normally and will generate minimal redo for the tables created with the NOLOGGING clause.

考题 单选题You executed the following query in your database: SELECT oldest_flashback_scn, oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG; What would you determine from the output?()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.

考题 单选题While setting up an Oracle database for one of your critical applications, you want to ensure that the database is backed up at regular intervals without your intervention.What should you do to achieve the objective?()A configure the database to run in ARCHIVELOG modeB configure the Flash Recovery Area to enable automatic database backupC schedule the database backup using DBMS_JOB package after creating the databaseD schedule the database backup using Recovery Manager (RMAN)commands after creating the databaseE schedule the database backup using Database Configuration Assistant (DBCA)while creating the database

考题 单选题You have lost datafile 4 from your database. Which is typically the fastest way to restore your database? ()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.

考题 单选题You are working on a new Oracle Database 11g server, where only the software is installed and no database iscreated. You plan to create a database on this server using the Database Configuration Assistant (DBCA).Some of the requirements set for your database creation task are: 1.Configure the database to operate in shared server mode. 2.Disable automatic maintenance tasks such as optimizer statistics collection. 3.Configure a naming method to help the remote user connect to the database instance. 4.Use Automatic Storage Management (ASM) for storing the database files. 5.Configure daily database backup to flash recovery area. 6.Configure Enterprise Manager Database Control to manage the database.  Which of these requirements can be met while creating the database()A 4 and 6B 2,3,4,and 6C 1,2,4,5,and 6D 1,2,3,4,5,and 6

考题 单选题Every Sunday the Unix system administrator has a job that executes a full backup of the entire Unix system your database is on. Is this backup usable for backup and recovery of your database?()A  Yes, if the database is in ARCHIVELOG modeB  Yes, if the database is in NOARCHIVELOG modeC  No, the backup is not usable in any wayD  Only if the ENABLE_ONLINE_BACKUP parameter is set to TRUE

考题 多选题Last night, a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database? ()AThe database opens normally.BThe database prompts for a database recovery.CThe database writer writes to a trace file, indicating that the temporary file is not found.DThe database gets mounted and throws an error indicating that the temporary file requires recovery.

考题 单选题You are maintaining your database in Oracle10g. You find that the number of languages that should be supported in your database has increased. The character set of your database is UTF8. You decide to migrate your database to the AL16UTF16 national character set.   How will you migrate your database from UTF8 to AL16UTF16?()A  by using the RMAN utilityB  by using the export/import utilityC  by using the ALTER DATABASE commandD  by enabling the change tracking feature

考题 单选题You executed the following query in your database:  FROM V$FLASHBACK_DATABASE_LOG;  What would you determine from the output?()A the time when the last flashback operation in your database was performedB the time when the first flashback operation in your database was performedC a list of flashback operations performed in your database using SCN and timeD the approximate time and the lowest system change number (SCN) to which you can flash back your database

考题 单选题Your boss at Certkiller .com wants you to clarify Oracle 10g. Which condition in your database forces you to perform only consistent backups?()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.

考题 多选题You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for your production database. You have registered your production database and are performing regular backups. Because of a new requirement you have added a few new tablespaces to your production database and you want them to be included in backups.  Identify two options for completing this task.()AReregistering the target database in recovery catalogBTransporting the new tablespaces to the recovery catalog databaseCSyncronizing the recovery catalog with the target database control fileDPerforming a fresh backup of the target database to include the new data files in the catalog database