多选题You have a database with the following tablespaces： SYSTEM， SYSAUX， UNDO， USERS， TEMP. You want to"roll back" the data in the USERS tablespace to the way it looked yesterday. Which tablespaces do you need to perform a point-in-time restore operation on in order to complete this task？（）ASYSTEMBSYSAUXCUNDODUSERSETEMPFThis restore is not possible
多选题
You have a database with the following tablespaces： SYSTEM， SYSAUX， UNDO， USERS， TEMP. You want to"roll back" the data in the USERS tablespace to the way it looked yesterday. Which tablespaces do you need to perform a point-in-time restore operation on in order to complete this task？（）
A
SYSTEM
B
SYSAUX
C
UNDO
D
USERS
E
TEMP
F
This restore is not possible
参考解析
解析：
暂无解析
相关考题：
Examine the following command that is used to duplicate a database on the same host:Which two statements describe the effect after the database is duplicated successfully? () A. The data files of the read-only tablespaces in the target database are not duplicatedB. The read-only tablespaces in the target database are still defined in new the databaseC. The read-only tablespaces in the target database are changed to online after duplicationD. The data files of the read-only tablespaces in the target database get duplicatedE. The read-only tablespaces in the target database are not defined in the new database
You are managing the APPPROD database as a DBA. You plan to duplicate this database in the same system with the name DUPDB.You issued the following RMAN commands to create a duplicate database:Which three are the prerequisites for the successful execution of the above command?（）A. The source database should be openB. The target database should be in ARCHIVELOG mode if it is openC. RMAN should be connected to both the instances as SYSDBAD. The target database backups should be copied to the source database backup directoriesE. The password file must exist for the source database and have the same SYS user password as the target
You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for yourproduction 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 youwant them to be included in backups.Identify two options for completing this task. （）(Choose two.)A. Reregistering the target database in recovery catalogB. Transporting the new tablespaces to the recovery catalog databaseC. Syncronizing the recovery catalog with the target database control fileD. Performing a fresh backup of the target database to include the new data files in the catalog database
The database instance has the following parameter setting： OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0 You have a local operating system user SKD. You create a database user OPS$SKD， and then assignexternal authentication. The user OPS$SKD has the CREATE SESSION privilege. What would youachieve by the above process（）A、The database user OPS$SKD will be able to administer the database.B、The authentication detail for the database user OPS$SKD is recorded in the password file.C、The local operating system user SKD will be able to access the database instance without specifying the username and password.D、The database user OPS$SKD has to login with the password of the local operating system user SKD to access the database instance.
Which of the following restrictions are not true with respect to tablespace point-in-time recovery？（）A、 The target database must be in NOARCHIVELOG mode.B、 No backup is required of the database before you perform a TSPITR.C、 You must have all archived redo logs generated since the last backup up to the point to which you want to restore the transport set.D、 If you rename a tablespace， you can not perform a TSPITR to any point in time before that rename operation occurred.E、 If you have tables in tablespace_1 that have associated constraints in tablespace_2，then you must transport both tablespaces.
Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt： RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON； After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）A、 when you change the name of a datafileB、 when you drop a table from the databaseC、 when you take an export of the databaseD、 when you back up the database using OS utilitiesE、 when you issue an ALTER SYSTEM SWITCH LOGFILE statementF、 when you issue a BACKUP command from inside the RMAN run block
You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA. While observing the server settings， you find that the following parameter has been set in the parameter file of the database： REMOTE_OS_AUTHENT = TRUE What could have been the reason to set this parameter as TRUE？（）A、to enable operating system authentication for a remote clientB、to restrict the scope of administration to identical operating systemsC、to allow the start up and shut down of the database from a remote clientD、to enable the administration of the operating system from a remote clientE、to disable the administration of the operating system from a remote client
You have three databases， FINDB， PAYDB and ADMINDB， located in Sydney， Tokyo and Singapore respectively. You want to perform administrative tasks which include starting up and shutting down the databases， creating and managing tablespaces and database users， and taking regular backups， for all of the three databases from London. Which component must be enabled and running on each host machine to achieve your objective？（）A、Oracle Management AgentB、Enterprise Manager with Grid ControlC、Enterprise Manager with Database ControlD、Operating System Socket for incoming requestsE、Real Application Cluster （RAC） with three instancesF、Enterprise Manager with Generic Database Management
Examine the following command that is used to duplicate a database on the same host: RMAN RUN { ALLOCATE AUXILIARY CHANNEL, aux 1 DEVICE TYPE DISK; DUPLICATE TARGET DATABASE TO auxdb SKIP READONLY; / } Which two statements describe the effect after the database is duplicated successfully? （）(Choose two)A、The data files of the read-only tablespaces in the target database are not duplicatedB、The read-only tablespaces in the target database are still defined in new the databaseC、The read-only tablespaces in the target database are changed to online after duplicationD、The data files of the read-only tablespaces in the target database get duplicatedE、The read-only tablespaces in the target database are not defined in the new database
You are about to create your Oracle data dictionary for use with the database. Which of the following users would you connect to the database as for this purpose in Oracle9i and later releases?（）A、SYSTEM B、OUTLN C、INTERNAL D、SYS
单选题You are designing the physical database layout on your host machine. What is the relationship between tablespaces and datafiles in the Oracle database?（）AOne tablespace has only one datafileBMany tablespaces can share one datafileCOne tablespace can have many datafilesDOne datafile can contain many tablespaces
单选题You have been recently hired as a database administrator. Your senior manager asks you to study the production database server and submit a report on the settings done by the previous DBA. While observing the server settings， you find that the following parameter has been set in the parameter file of the database： REMOTE_OS_AUTHENT = TRUE What could have been the reason to set this parameter as TRUE？（）Ato enable operating system authentication for a remote clientBto restrict the scope of administration to identical operating systemsCto allow the start up and shut down of the database from a remote clientDto enable the administration of the operating system from a remote clientEto disable the administration of the operating system from a remote client
多选题You are using a recovery catalog to maintain Recovery Manager (RMAN) backup information for yourproduction 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 youwant them to be included in backups.Identify two options for completing this task. （）(Choose two.)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
多选题In your database， all the tablespaces are locally managed. You started Recovery Manager （RMAN） using recovery catalog and restored the control file by using the following command： RMAN RESTORE CONTROLFILE； Which two operations do you need to perform after restoring the control file from backup？（）Ashut down and restart the instanceBadd new tempfiles to the temporary tablespaces after recoveryCperform a media recovery and open the database with the RESETLOGS optionDperform a media recovery and bring the database to NOARCHIVELOG mode
多选题Which three statements are true about logical structures of the Oracle database（）AEach segment contains one or more extents.BMultiple tablespaces can share a single data file.CA data block is the smallest unit of input/output （I/O） in data files.DIt is possible to have tablespaces of different block sizes in a database.EEach data block in the database always corresponds to one operating system block.
单选题You have three databases， FINDB， PAYDB and ADMINDB， located in Sydney， Tokyo and Singapore respectively. You want to perform administrative tasks which include starting up and shutting down the databases， creating and managing tablespaces and database users， and taking regular backups， for all of the three databases from London. Which component must be enabled and running on each host machine to achieve your objective？（）AOracle Management AgentBEnterprise Manager with Grid ControlCEnterprise Manager with Database ControlDOperating System Socket for incoming requestsEReal Application Cluster （RAC） with three instancesFEnterprise Manager with Generic Database Management
多选题Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process？ （）Aopen the database with the RESETLOGS optionBopen the database with the RESTRICTED optionCrecover all the data files to the same system change number （SCN）Drecover to the required SCN only that data file in which the error occurred
单选题The database instance has the following parameter setting： OS_AUTHENT_PREFIX = OPS$ OS_ROLES = FALSE REMOTE_OS_AUTHENT = FALSE REMOTE_OS_ROLES = FALSE TIMED_OS_STATISTICS = 0 You have a local operating system user SKD.You create a database user OPS$SKD， and then assign external authentication. The user OPS$SKD has theCREATE SESSION privilege. What would you achieve by the above process（）AThe database user OPS$SKD will be able to administer the database.BThe authentication detail for the database user OPS$SKD is recorded in the password file.CThe local operating system user SKD will be able to access the database instance without specifying theusername and password.DThe database user OPS$SKD has to login with the password of the local operating system user SKD toaccess the database instance.
单选题Two data files have been deleted at the operating system level by accident. Your database is running in ARCHIVELOG mode and online backups are taken nightly. One of the data files that has been deleted belongs to the USERS tablespace on the other belongs to the SYSTEM tablespace. How can you recover from this situation？（）AShut down the database, restore the two data files and then start up the database. BTake the system and users tablespace offline, restore the two data files, recover the two datafiles, and then bring the SYSTEM and USERS tablespaces online. CShut down the database, restore the two data files, start up the database in MOUNT mode, recover the two data files, and then alter the database open. DTake the SYSTEM and USERS tablespaces offline, recover the two datafiles and then bring the SYSTEM and USERS tablespaces online.
多选题Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups. Which two backups would you be able to perform when the database is being accessed by users？（）Abackup of offline tablespacesBbackup of readonly tablespacesCbackup of systemcritical tablespacesDbackup of online， locally managed tablespacesEbackup of read/write dictionarymanaged tablespaces
单选题You are creating tablespaces in Oracle. Which of the following keywords or clauses permits the datafiles of a database to grow automatically in order to accommodate data growth?（）ADEFAULT STORAGE BEXTENT MANAGEMENT CAUTOEXTEND DDATAFILE
多选题You have a database with the following tablespaces： SYSTEM， SYSAUX， UNDO， USERS， TEMP. You want to"roll back" the data in the USERS tablespace to the way it looked yesterday. Which tablespaces do you need to perform a point-in-time restore operation on in order to complete this task？（）ASYSTEMBSYSAUXCUNDODUSERSETEMPFThis restore is not possible
多选题Your database is functioning in NOARCHIVELOG mode. Your database contains 15 tablespaces. You want to use Recovery Manager （RMAN） to perform backups. Which two backups would you be able to perform when the database is being accessed by users？（）ABackup of offline tablespaces.BBackup of read-only tablespaces.CBackup of system-critical tablespaces.DBackup of online， locally managed tablespaces.EBackup of read/write dictionary-managed tablespaces.
多选题Which statements are true about logical structures of the Oracle database（）AEach segment contains one or more extents.BMultiple tablespaces can share a single data fileCA data block is the smallest unit of input/output （I/O） in data files.DIt is possible to have tablespaces of different block sizes in a database.EEach data block in the database always corresponds to one operating system block
多选题Your database operates in ARCHIVELOG mode and all the tablespaces are online. Due to a user error， you decided to perform an incomplete recovery. Which two tasks would you be required to perform in the recovery process？（）Aopen the database with the RESTRICTED optionBopen the database with the RESETLOGS optionCrecover to the required SCN only that data file in which the error occurredDrecover all the data files to the same system change number （SCN）
多选题Which of the following restrictions are not true with respect to tablespace point-in-time recovery？（）AThe target database must be in NOARCHIVELOG mode.BNo backup is required of the database before you perform a TSPITR.CYou must have all archived redo logs generated since the last backup up to the point to which you want to restore the transport set.DIf you rename a tablespace， you can not perform a TSPITR to any point in time before that rename operation occurred.EIf you have tables in tablespace_1 that have associated constraints in tablespace_2，then you must transport both tablespaces.
多选题Your database is running in the ARCHIVELOG mode. You have configured RMAN for backup and recovery operations. You execute the following command from the RMAN prompt： RMAN CONFIGURE CONTROLFILE AUTOBACKUP ON； After executing this command， in which of the following cases will RMAN make an auto-backup of the control file？ （）Awhen you change the name of a datafileBwhen you drop a table from the databaseCwhen you take an export of the databaseDwhen you back up the database using OS utilitiesEwhen you issue an ALTER SYSTEM SWITCH LOGFILE statementFwhen you issue a BACKUP command from inside the RMAN run block
多选题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