网友您好, 请在下方输入框内输入要搜索的题目:
题目内容
(请给出正确答案)
单选题
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
参考答案
参考解析
解析:
暂无解析
更多 “单选题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_DROPPEDB TS_PTTR_OBJECT_DROPPEDC TS_PITR_OBJECTS_TO_BE_DROPPEDD TS_OBJECTS_DROPPEDE TS_DROPPED_OBJECTS” 相关考题
考题
Which command would you configure globally on a Cisco router that would allow you to view directly connected Cisco devices?()
A. enable cdpB. cdp enableC. cdp runD. run cdp
考题
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_DROPPEDB、 TS_PTTR_OBJECT_DROPPEDC、 TS_PITR_OBJECTS_TO_BE_DROPPEDD、 TS_OBJECTS_DROPPEDE、 TS_DROPPED_OBJECTS
考题
Which command would you configure globally on a Cisco router that would allow you to view directly connected Cisco devices?()A、enable cdpB、cdp enableC、cdp runD、run cdp
考题
Which version of a view would you use if you just want a quick, easy view within your XPage?()A、Data Table ControlB、View ControlC、Repeat ControlD、Filter by category View Control
考题
Which view will you use to view information regarding the jobs that are currently running in a database?()A、DBA_SCHEDULER_RUNNING_JOBSB、DBA_SCHEDULER_JOB_RUN_DETAILSC、DBA_SCHEDULER_JOBSD、DBA_SCHEDULER_JOB_LOG
考题
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.
考题
In which scenario will you perform a user-managed incomplete recovery?()A、 when a table is dropped and stored in the Recycle BinB、when a table is dropped and purged from the Recycle BinC、 when you are required to recover an existing table to its previous stateD、 when you are required to view all the versions of a row of an existing table between a specific time period
考题
You want to view the name of a program associated with a job for making some changes to the program. Which view will you query to find the name of the program associated with the job?()A、 DBA_SCHEDULER_JOB_RUN_DETAILSB、 DBA_SCHEDULER_RUNNING_JOBSC、 DBA_SCHEDULER_JOBSD、 DBA_SCHEDULER_JOB_LOG
考题
You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information?()A、 Query the V$FLASHBACK_DATABASE_LOG view.B、 Query the V$FLASHBACK_DATABASE_STAT view.C、 Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.D、 Query the V$RECOVERY_FILE_DEST view.
考题
Your network consists of a single Active Directory domain. All servers run Windows Server 2003 Service Pack 2 (SP2). All client computers run Windows XP Professional Service Pack 3 (SP3). You have a user account named User1. You need to identify which permissions User1 has on a file. What should you do? ()A、At a command prompt, run Net file.B、At a command prompt, run Attrib.exe.C、From the file properties, view the Summary settings.D、From the file properties, view the Advanced Security settings.
考题
You need to recommend a BitLocker recovery method that meets the company’s technical requirements. Which recovery method should you recommend?()A、a data recovery agentB、a recovery keyC、a recovery password printed and stored in a secure locationD、a recovery password stored in Active Directory
考题
多选题During recovery, you need to know if log sequence 11 is in the online redo logs, and if so, you need to know the names of the online redo logs so you can apply them during recovery. Which view or views would you use to determine this information?()AV$LOGFILEBV$RECOVER_LOGCV$RECOVER_DATABASEDV$LOG_RECOVEREV$LOG
考题
单选题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_DROPPEDB
TS_PTTR_OBJECT_DROPPEDC
TS_PITR_OBJECTS_TO_BE_DROPPEDD
TS_OBJECTS_DROPPEDE
TS_DROPPED_OBJECTS
考题
单选题Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery, you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?()A
Perform Export before TSPITR and Import after TSPITRB
Move objects to another schema that has the same tablespace assignedC
Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)D
Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)
考题
单选题You want to view the name of a program associated with a job for making some changes to the program. Which view will you query to find the name of the program associated with the job?()A
DBA_SCHEDULER_JOB_RUN_DETAILSB
DBA_SCHEDULER_RUNNING_JOBSC
DBA_SCHEDULER_JOBSD
DBA_SCHEDULER_JOB_LOG
考题
单选题Which options must you configure while performing an automated Tablespace Point-in-Time Recovery (TSPITR) by using Recovery Manager (RMAN)?()A
New channels for restore and recovery tasksB
New name for the data files of the tablespaceC
Auxiliary name for the data files of the tablespaceD
Auxiliary destinations for an auxiliary set of data files
考题
单选题You are maintaining the SALES database for an organization. You have enabled the Flashback Database feature and want to estimate the flashback space required for future operations. Which view would you query to estimate the flashback space required?()A
V$DATABASEB
V$FLASHBACK_DATABASE_STATC
V$FLASHBACK_DATABASE_LOGD
V$RECOVERY_FILE_DEST
考题
单选题In which scenario will you perform a user-managed incomplete recovery?()A
when a table is dropped and stored in the Recycle BinB
when a table is dropped and purged from the Recycle BinC
when you are required to recover an existing table to its previous stateD
when you are required to view all the versions of a row of an existing table between a specific time period
考题
单选题Because of a logical corruption in your production database, you wanted to perform Tablespace Point in Time Recovery (TSPITR). But before you start the recovery,you queried the TS_PITR_OBJECTS_TO_BE_DROPPED view and realized that there are a large number of objects that would be dropped when you start the recovery by using this method. You want to preserve these objects. Which option must you use to perform TSPITR and preserve the object?()A
Perform Export before TSPITR and Import after TSPITRB
Move objects to another schema that has the same tablespace assignedC
Perform Incomplete Recovery before TSPITR with the Log Sequence Number (LSN)D
Perform Incomplete Recovery before TSPITR with the System Change Number (SCN)
考题
单选题Which options must you configure while performing an automated Tablespace Point-in-Time Recovery (TSPITR) by using Recovery Manager (RMAN)?()A
New channels for restore and recovery tasksB
New name for the data files of the tablespaceC
Auxiliary name for the data files of the tablespaceD
Auxiliary destinations for an auxiliary set of data files
考题
单选题You are maintaining your database in Oracle10g. You have set the value of the STATISTICS_LEVEL initialization parameter to TYPICAL and the value of the FAST_START_MTTR_TARGET parameter to 900 seconds. To increase the performance of the database, you want to determine the log file size that should equal the minimum size of all the online redo log files. Which column will enable you to perform the desired task?()A
the WRITES_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY viewB
the column of the V$INSTANCE_RECOVERY viewC
the OPTIMAL_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY viewD
the LOG_FILE_SIZE_REDO_BLKS column of the V$INSTANCE_RECOVERY view
考题
单选题Which view will you use to view information regarding the jobs that are currently running in a database?()A
DBA_SCHEDULER_RUNNING_JOBSB
DBA_SCHEDULER_JOB_RUN_DETAILSC
DBA_SCHEDULER_JOBSD
DBA_SCHEDULER_JOB_LOG
考题
多选题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.
考题
单选题In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas. Which method must you use to recover the lost data?()A
Complete Recovery with online redo logB
Complete Recovery with archived redo logC
Tablespace Point-in-Time Recovery (TSPITR)D
Incomplete Recovery with system change number (SCN)
考题
单选题In your production database, users report that they are unable to generate reports on an important table because it does not contain any data. While investigating the reason, you realize that another user executed the TRUNCATE TABLE command, which accidentally caused the data to be lost. Now you want to recover the lost data of the table without affecting objects in other schemas. Which method must you use to recover the lost data?()A
Complete Recovery with online redo logB
Complete Recovery with archived redo logC
Tablespace Point-in-Time Recovery (TSPITR)D
Incomplete Recovery with system change number (SCN)
考题
单选题Your network consists of a single Active Directory domain. All servers run Windows Server 2003 Service Pack 2 (SP2). All client computers run Windows XP Professional Service Pack 3 (SP3). You have a user account named User1. You need to identify which permissions User1 has on a file. What should you do? ()A
At a command prompt, run Net file.B
At a command prompt, run Attrib.exe.C
From the file properties, view the Summary settings.D
From the file properties, view the Advanced Security settings.
考题
单选题Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object in that tablespace has a foreign key constraint owned by another object in the INDEX_TBS which statement is true?()A
You cannot perform the TSPITR with the constraints enabled.B
You must perform the TSPITR recovery of both tablespaces for it to be successful.C
You can perform TSPITR only on the USERS tablespace.D
RMAN will determine if the INDEX_TBS tablespace must also be duplicated and will duplicate it automatically.E
The TSPITR will only be successful if the constraint is enabled.
考题
单选题You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information?()A
Query the V$FLASHBACK_DATABASE_LOG view.B
Query the V$FLASHBACK_DATABASE_STAT view.C
Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.D
Query the V$RECOVERY_FILE_DEST view.
热门标签
最新试卷