网友您好， 请在下方输入框内输入要搜索的题目：
题目内容
（请给出正确答案）
单选题
Which of the following views must you query to identify any corrupt data file blocks that have been detected during backup set creation？（）
A
V$COPY_CORRUPT
B
V$COPY_CORRUPTION
C
V$BACKUP_CORRUPT
D
V$BACKUP_CORRUPTION
参考答案
参考解析
解析：
暂无解析
更多 “单选题Which of the following views must you query to identify any corrupt data file blocks that have been detected during backup set creation？（）A V$COPY_CORRUPTB V$COPY_CORRUPTIONC V$BACKUP_CORRUPTD V$BACKUP_CORRUPTION” 相关考题
考题
You have an SQL query that takes one minute to execute. You use the following code segment to execute theSQL query asynchronously.Dim ar As IAsyncResult = cmd.BeginExecuteReader()You need to execute a method named DoWork() that takes one second to run while the SQL query is executing.DoWork() must run as many times as possible while the SQL query is executing.Which code segment should you use?（）A.B.C.D.
考题
I must hold ______ for any damage which may result from the accidents you have caused．A.your responsibleB.you responsibleC.you are responsibleD.your are responsible
考题
Which of the following steps in the troubleshooting and repair process is MOST effectivereduce redundant effort？ （）A、Discuss the problem with the user and identify any recent changes.B、Identify the root cause of the failure.C、Verify the problem resolution.D、Document activities and outcomes of repair steps.
考题
You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature？（）A、 You must use automatic undo management in the database.B、 You must configure OMF in your database.C、 You must configure ASM for storing the datafiles.D、 You must multiplex the online redo log file.
考题
Which of the following is a typical data warehouse query?（）A、What is this customers address?B、Does this customer have any unpaid bills?C、What is the balance in this customers account?D、What are the total sales for each of the last 6 months?
考题
Which two statements are correct regarding the Flashback Versions Query feature？（）A、 You can use this feature to identify the committed versions of the rows， but not the uncommitted versions.B、 You can use this feature to identify the versions of V$ views.C、 You can use this feature to identify the inserts， deletes， and updates performed on a particular row but not the data definition language （DDL） operations performed on the table.D、 You can use this feature for a table only if row movement is enabled for the table.E、 You can use this feature to identify the versions of external and fixed tables.
考题
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 use the Flashback Version Query feature？（）A、 when you want to restore a table that has been dropped from the Recycle BinB、 when you want to identify the transaction ID of the transaction that deleted some important records from a tableC、 when you want to recover the schema of a dropped userD、when you want to restore a dropped tablespace
考题
By mistake， you ran the batch job （for updating the BILL_DETAILS table） twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify： a） A list of changes made along with the transaction identifier of each change. b） The necessary SQL statements to undo the erroneous changes. Which option would you choose？（）A、 RMAN only.B、 Flashback Table only.C、 Flashback Version Query only.D、 Flashback Database and Flashback Transaction Query.E、 Flashback Version Query and Flashback Transaction Query.
考题
Which pseudocolumn could you use to identify a unique row in a Flashback Versions Query？（）A、 XIDB、 VERSIONS_PKC、 VERSIONS_XIDD、 VERSIONS_UNIQUE
考题
At 10：30 A.M.， you ran a batch job by mistake， which executed a transaction in the database. The transaction identifier of the transaction that made to the changes in the database is 0500A00627B000. At 11：10 A.M.， you stopped the batch job. Now， you want to identify the changes made to the database tables by the batch job. Which view will you query？（）A、 DBA_PENDING_TRANSACTIONSB、 DBA_AUDIT_STATEMENTC、 V$FLASHBACK_DATABASE_STATSD、 FLASHBACK_TRANSACTION_QUERY
考题
You are developing an application that receives events asynchronously.You create a WqlEventQuery instance to specify the events and event conditions to which the application must respond.You also create a ManagementEventWatcher instance to subscribe to events matching the query.You need to identify the other actions you must perform before the application can receive events asynchronously.Which two actions should you perform？（）A、Start listening for events by calling the Start method of the ManagementEventWatcher.B、Set up a listener for events by using the EventArrived event of the ManagementEventWatcher.C、Use the WaitForNextEvent method of the ManagementEventWatcher to wait for the events.D、Create an event handler class that has a method that receives an ObjectReadyEventArgs parameter.E、Set up a listener for events by using the Stopped event of the ManagementEventWatcher.
考题
You have an Exchange Server 2010 organization. Your network is separated from the Internet by a firewall. You need to identify the ports that must be opened on the firewall to allow clients from the Internet to usethe following connections methods：.Outlook Anywhere .Outlook Web App （OWA）.Exchange ActiveSync .IMAP4 over Secure Sockets Layer （SSL） Which TCP ports should you identify？（）A、25， 443 and 993B、26， 443 and 995C、25， 80， 143， and 3269D、80， 143， 443， and 389
考题
单选题In which scenario will you use the Flashback Version Query feature？（）A
when you want to restore a table that has been dropped from the Recycle BinB
when you want to identify the transaction ID of the transaction that deleted some important records from a tableC
when you want to recover the schema of a dropped userD
when you want to restore a dropped tablespace
考题
单选题Which of the following views must you query to identify any corrupt data file blocks that have been detected during backup set creation？（）A
V$COPY_CORRUPTB
V$COPY_CORRUPTIONC
V$BACKUP_CORRUPTD
V$BACKUP_CORRUPTION
考题
单选题Which of the following dynamic view would you query to identify the online CURRENT redo log group？（）A
V$LOGB
V$LOFHISTC
V$LOGFILED
V$LOG_HISTORY
考题
单选题Which pseudocolumn could you use to identify a unique row in a Flashback Versions Query？（）A
XIDB
VERSIONS_PKC
VERSIONS_XIDD
VERSIONS_UNIQUE
考题
单选题You want to use the Flashback Transaction Query feature to identify all the changes made to your database within a specific time period. What is a prerequisite for using the Flashback Transaction Query feature？（）A
You must use automatic undo management in the database.B
You must configure OMF in your database.C
You must configure ASM for storing the datafiles.D
You must multiplex the online redo log file.
考题
问答题Task II (20 marks) Write an essay of no less than 160 words in which you discuss the moral of the following passage and express your personal views on the subject. Now write the letter on the answer sheet. Courage is the greatest of all virtues, because if you don’t have courage, you will not have an opportunity to use any of the others.—Samuel Johnson
考题
单选题Before starting any diesel or gasoline engine，which of the following must be checked? （）A
Oil levelB
Flow of cooling waterC
Exhaust dischargeD
All of the above
考题
单选题You have an Exchange Server 2010 organization.You need to identify the following information for a user’s ailbox： The size of items in the Inbox folder The number of items in the Deleted Items folder You must achieve this goal by using the minimum amount of administrative effort. Which cmdlet should you run？（）A
Get-Mailbox FolderB
Get-Mailbox Folder StatisticsC
Get-Mailbox StatisticsD
Get-Store Usage Statistics
考题
单选题You manage a SQL Server 2005 database that contains a table with many indexes. You notice that data modification performance has degraded over time. You suspect that some of the indexes are unused. You need to identify which indexes were not used by any queries since the last time SQL Server 2005 started. Which dynamic management view should you use？（）A
sys.dm fts index populationB
sys.dm exec query statsC
sys. dm db index usage statsD
sys.dm db index physical stats
考题
多选题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.
考题
单选题You need to identify which tool the help desk users must use to perform administrative tasks. Which tool should you identify？（）A
RemoteAppB
Remote AssistanceC
Remote DesktopD
Remote Server Administration Tools （RSAT）
考题
单选题A user named Arren is executing this query： select table_name，operation，undo_sql from flashback_transaction_query t， （select versions_xid as xid from employees versions between scn minvalue and maxvalue where employee_id = 123） e where t.xid = e.xid； When the query runs，he receives an ORA-01031： insufficient privileges error. Since the user owns the employees table，you know that it is not the problem. Which of the following SQL statements will correct this problem？（）A
GRANT SELECT ANY TRANSACTION TO ARRENB
GRANT SELECT ON FLASHBACK_TRANSACTION_QUERY TO ARRENC
GRANT SELECT_ANY_TRANSACTION TO ARREND
GRANT FLASHBACK TO ARRENE
GRANT SELECT ANY VIEW TO ARREN
考题
单选题At 10：30 A.M.， you ran a batch job by mistake， which executed a transaction in the database. The transaction identifier of the transaction that made to the changes in the database is 0500A00627B000. At 11：10 A.M.， you stopped the batch job. Now， you want to identify the changes made to the database tables by the batch job. Which view will you query？（）A
DBA_PENDING_TRANSACTIONSB
DBA_AUDIT_STATEMENTC
V$FLASHBACK_DATABASE_STATSD
FLASHBACK_TRANSACTION_QUERY
考题
单选题By mistake， you ran the batch job （for updating the BILL_DETAILS table） twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify： a） a list of changes made along with the transaction identifier of each change b） the necessary SQL statements to undo the erroneous changes Which option would you choose？（）A
RMAN onlyB
Flashback Table onlyC
Flashback Versions Query onlyD
Flashback Database and Flashback Transaction QueryE
Flashback Versions Query and Flashback Transaction Query
考题
单选题By mistake， you ran the batch job （for updating the BILL_DETAILS table） twice. You are not sure which rows in the BILL_DETAILS table were affected. You need to identify： a） A list of changes made along with the transaction identifier of each change. b） The necessary SQL statements to undo the erroneous changes. Which option would you choose？（）A
RMAN only.B
Flashback Table only.C
Flashback Version Query only.D
Flashback Database and Flashback Transaction Query.E
Flashback Version Query and Flashback Transaction Query.
热门标签
最新试卷
