多选题These are the details about V$FLASHBACK_DATABASE_STAT：  SQL> DESC V$FLASHBACK_DATABASE_STAT Name Null？ Type  ------------- -------- --------------  BEGIN_TIME DATE END_TIME DATE  FLASHBACK_DATA NUMBER  DB_DATA NUMBER REDO_DATA NUMBER  ESTIMATED_FLASHBA

题目
多选题
These are the details about V$FLASHBACK_DATABASE_STAT：  SQL> DESC V$FLASHBACK_DATABASE_STAT Name Null？ Type  ------------- -------- --------------  BEGIN_TIME DATE END_TIME DATE  FLASHBACK_DATA NUMBER  DB_DATA NUMBER REDO_DATA NUMBER  ESTIMATED_FLASHBACK_SIZE NUMBER  Which two statements regarding the V$FLASHBACK_DATABASE_STAT view are true？ （）
A

BEGIN_TIME is the time at which Flashback logging is enabled.

B

END_TIME is the time at which the query is executed on the view.

C

REDO_DATA is the number of bytes of redo data written during the interval.

D

This view contains information about flashback data pertaining to the last 24 hours.

E

FLASHBACK_DATA is the amount of flashback data generated since the database was opened.

相似考题

1.In order to prove that you would be a valuable problem solver for the employer, you need to write on your résumé about the details on how you solved a problem and what wanted consequences your solution brought about.()

2.____________ me all the details of the meeting －－－ just tell me about what they decided.A.SpareB.AvoidC.ObtainD.Remind

3.View the Exhibit to examine the Automatic SQL Tuning result details.Which action would you suggest for the selected SQL statement in the Exhibit?()A. Accept the recommended SQL profile.B.Collect statistics for the related objects.C. Run the Access Advisor for the SQL statement.D. Run the Segment Advisor for recommendations.

4.We would be ________ if you could send us full details about your products.A.wonderfulB.hopefulC.regretfulD.grateful

更多“These are the details about V$FLASHBACK_DATABASE_STAT：  SQL>”相关问题

  • 第1题：

    Inwhatviewareyoulikelytoseethefollowingoutput?()SIDSERIALEVENTSECONDS_IN_WAIT121269RMANbackup&recoveryI／O2129415SQL*Netmessagefromclient63130270SQL*Netmessagefromclient

    A.V$SESSION_EVENT

    B.V$SESSION

    C.V$WAITS

    D.V$WAITSTAT

    E.V$SYSSTAT


    参考答案：B

  • 第2题：

    Directions:Suppose your class is to holda charity sale for kids in need of help.Write your classmates an email to inform them about the details,and encourage them to participate.You should write about 100 words on the ANSWER SHEET.Do not use your own name;use"Li Ming”instead.Do not write your address.


    答案：
    解析：
    My dear classmates,
    May I have your attention,please?On the evening of January 4th,2013,namely,this Friday night,we will holda charity sale at the school auditorium in the purpose of helping the children who need help.Those kids who come from remote areas lack proper and fine education.Our assistance can improve theirlives and even may change their destinies.Some stars,local industrial bosses and all the staff of our schoolwill attend the activity.I trust that everyone has a kind heart and believe that our help can really make a big difference.Thank youvery much for your kindness and I am looking forward seeing you on time.
    Yours sincerely,
    Li Ming

  • 第3题：

    Which statement is true about "full state backup" in a Cisco Unified Computing System？（）

    • A、 An XML file containing all details of the system， including IP address and cluster details 
    • B、 A binary file containing only service profiles， pools， and other items configured after initial configuration
    • C、 A binary file containing all details of the system， including IP address and cluster details
    • D、 An XML file containing only service profiles， pools， and other items configured after initial configuration
    • E、 A text file with the NX-OS running configuration

    正确答案:C

  • 第4题：

    On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30 am. Which option must you use to check whether a flashback operation can recover the database to the specified time? （）

    • A、Check the alert log file
    • B、Query the V$FLASHBACK_DATABASE_LOG view
    • C、Query the V$RECOVERY_FILE_DEST_SIZE view
    • D、Query the V$FLASHBACK_DATABASE_STAT view
    • E、Check the value assigned for the UNDO_RETENTION parameter

    正确答案:B

  • 第5题：

    In what view are you likely to see the following output？（）   SID SERIAL# EVENT SECONDS_IN_WAIT  121 269 RMAN backup & recovery I/O 2  129 415 SQL*Net message from client 63 130 270 SQL*Net message from client  

    • A、 V$SESSION_EVENT
    • B、 V$SESSION
    • C、 V$WAITS
    • D、 V$WAITSTAT
    • E、 V$SYSSTAT

    正确答案:B

  • 第6题：

    You are implementing an ASP.NET MVC 2 Web application. The URL with path /Home/Details/{country} will return a page that provides information about the named country. You need to ensure that requests for this URL that contain an unrecognized country value will not be processed by the Details action of HomeController. What should you do？（）

    • A、Add the ValidateAntiForgeryToken attribute to the Details action method.
    • B、Add the Bind attribute to the country parameter of the Details action method. Set the attribute’s Prefix property to Country.
    • C、Create a class that implements the IRouteConstraint interface. Configure the default route to use this class.
    • D、Create a class that implements the IRouteHandler interface. Configure the default route to use this class.

    正确答案:C

  • 第7题：

    单选题
    P300 is the brainwave _____.
    A

    which may confirm that the person knows no details about the question

    B

    lack of which may confirm that the person knows details about the question

    C

    which may help prove that the suspect hasn’t committed a crime

    D

    lack of which may mean that the suspect hasn’t committed a crime


    正确答案： A
    解析：
    第四段第三、四句说MERMER的原理是将人与EEG机器相连并询问他有关犯罪现场的具体细节。如果没有被称为P300的脑波就说明对所问问题并不熟悉，也就是说如果此人否认知情，应该认为他说的是实话。

  • 第8题：

    单选题
    You received complaints about the degradation of SQL query performance. You identified top SQL queries that consume time. What would be your next step to find out recommendations about statistics collection and restructuring of the SQL statement to improve query performance？（）
    A

    run Segment Advisor

    B

    run SQL Tuning Advisor on top SQL statements

    C

    run the Automatic Workload Repository （AWR） report

    D

    run the Automatic Database Diagnostic Monitor （ADDM）on top SQL statements


    正确答案： D
    解析： 暂无解析

  • 第9题：

    多选题
    Which two statements are true about Shared SQL Area and Private SQL Areas（）
    A

    Shared SQL Area will be allocated in the shared pool.

    B

    Shared SQL Area will be allocated when a session starts.

    C

    Shared SQL Area will be allocated in the large pool always.

    D

    The whole of Private SQL Area will be allocated in the Program Global Area （PGA） always.

    E

    Shared SQL Area and Private SQL Area will be allocated in the PGA or large pool.

    F

    The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter.


    正确答案： D,B
    解析： 暂无解析

  • 第10题：

    多选题
    Which two statements are true about Shared SQL Area and Private SQL Area（）
    A

    Shared SQL Area will be allocated in the shared pool.

    B

    Shared SQL Area will be allocated when a session starts.

    C

    Shared SQL Area will be allocated in the large pool always.

    D

    Private SQL Area will be allocated in the Program Global Area （PGA） always.

    E

    Shared SQL Area and Private SQL Area will be allocated in the PGA or large pool.

    F

    The number of Private SQL Area allocations is dependent on the OPEN_CURSORS parameter.


    正确答案： E,A
    解析： 暂无解析

  • 第11题：

    单选题
    On Friday at 11:30 am you decided to flash back the database because of a user error that occurred at 8:30am. Which option must you use to check whether a flashback operation can recover the database to the specified time?（）
    A

    Check the alert log file

    B

    Query the V$FLASHBACK_DATABASE_LOG view

    C

    Query the V$RECOVERY_FILE_DEST_SIZE view

    D

    Query the V$FLASHBACK_DATABASE_STAT view

    E

    Check the value assigned for the UNDO_RETENTION parameter


    正确答案： B
    解析： 暂无解析

  • 第12题：

    单选题
    TestKing.com has two SQL Server 2005 computers named SQL1 and SQL2. Both servers take part in replication. SQL1 is both the Publisher and its own Distributor of a publication named Pub1. Pub1 is the only publication on SQL1， and SQL2 is the only Subscriber. Your supervisor requests a status report about the replication latencies. Using Replication Monitor on SQL1， you need to find out the current latencies between the Publisher and Distributor as well as between the Distributor and Subscriber. What should you do？（）
    A

    Select the Subscription Watch List tab for SQL1. View the Latency column for the SQL2 subscription.

    B

    Select the All Subscriptions tab for the Pub1 publication. View the Latency column for the SQL2 subscription.

    C

    Select the Tracer Tokens tab for the Pub1 publication. Select the Insert Tracer Option and wait for the requested latency values for the SQL2 subscription to appear.

    D

    Select the Subscription Watch List tab for SQL1. Double-click the SQL2 subscription.View the duration details on the Publisher to Distributor History tab as well as on the Distributor to Subscriber History tab.


    正确答案： B
    解析： 暂无解析

  • 第13题：

    FlashbackDatabaseisenabledinyourOracle10gdatabase.Oneofyourdatabaseuserserroneouslypurgedanimportanttableresidinginhisschema.Thetablewaspurgedsometimebetween10：00P.M.and10：30P.M.Thenextday，youdecidetoflashbackthedatabase.Beforeyouflashbackthedatabase，youwanttoensurethatyouhaveallthenecessaryflashbackdata.Whichdynamicperformanceviewmustyouusetodeterminewhetheryouhavetherequiredflashbackdatatorecoverthepurgedtable？（）

    A.V$DATABASE

    B.V$UNDOSTAT

    C.V$FLASHBACK_DATABASE_LOG

    D.V$FLASHBACK_DATABASE_STAT


    参考答案：C

  • 第14题：



    According to the press release,what can be found on the company’s web site?
    A. News of future company project
    B. Details of the latest advertising campaign
    C. A statement about Mr. Charlie McGreger
    D. Information about Ms. Jackie Johnson


    答案：D
    解析：
    这道题的核心词汇web site出现在文章的最后一句话中，“可以在公司网站上看到MS. Jackie Johnson 的简历和职业成就（A short biography of Ms. Jackie Johnson and a list of her professional achievements) 因此正确答案是 D Information about Ms. Jackie Johnson(关于 Ms.Jackie Johnson 的介绍）。

  • 第15题：

    Which three statements about performance analysis by SQL Performance Analyzer are true? （）

    • A、It detects changes in SQL execution plans.
    • B、It produces results that can be used to create the SQL plan baseline.
    • C、The importance of SQL statements is based on the size of the objects accessed.
    • D、It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.
    • E、It shows only the overall impact on workload and not the net SQL impact on workload.

    正确答案:A,B,D

  • 第16题：

    These are the details about V$FLASHBACK_DATABASE_STAT：  SQL> DESC V$FLASHBACK_DATABASE_STAT Name Null？ Type  ------------- -------- --------------  BEGIN_TIME DATE END_TIME DATE  FLASHBACK_DATA NUMBER  DB_DATA NUMBER REDO_DATA NUMBER  ESTIMATED_FLASHBACK_SIZE NUMBER  Which two statements regarding the V$FLASHBACK_DATABASE_STAT view are true？ （）

    • A、BEGIN_TIME is the time at which Flashback logging is enabled.
    • B、END_TIME is the time at which the query is executed on the view.
    • C、REDO_DATA is the number of bytes of redo data written during the interval.
    • D、This view contains information about flashback data pertaining to the last 24 hours.
    • E、FLASHBACK_DATA is the amount of flashback data generated since the database was opened.

    正确答案:C,D

  • 第17题：

    You design a Business Intelligence （BI） solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services （SSRS） solution. The solution contains a report named Sales Details that displays sales information of all the employees. You create an SSRS report named Sales Summary that displays the total monthly sales of each employee. Users who view the Sales Summary report occasionally require the monthly sales details for a particular employee. You need to ensure that the users can click a value in the month column of the Sales Summary report to open and render the Sales Details report. What should you do？（）

    • A、 Use a subreport.
    • B、 Use a bookmark link.
    • C、 Use the drilldown functionality.
    • D、 Use a drillthrough report link.

    正确答案:D

  • 第18题：

    单选题
    You design a Business Intelligence （BI） solution by using SQL Server 2008. You create a SQL Server 2008 Reporting Services （SSRS） solution. The solution contains a report named Sales Details that displays sales information of all the employees. You create an SSRS report named Sales Summary that displays the total monthly sales of each employee. Users who view the Sales Summary report occasionally require the monthly sales details for a particular employee. You need to ensure that the users can click a value in the month column of the Sales Summary report to open and render the Sales Details report. What should you do？（）
    A

     Use a subreport.

    B

     Use a bookmark link.

    C

     Use the drilldown functionality.

    D

     Use a drillthrough report link.


    正确答案： D
    解析： 暂无解析

  • 第19题：

    单选题
    Which statement is true about "full state backup" in a Cisco Unified Computing System？（）
    A

     An XML file containing all details of the system， including IP address and cluster details 

    B

     A binary file containing only service profiles， pools， and other items configured after initial configuration

    C

     A binary file containing all details of the system， including IP address and cluster details

    D

     An XML file containing only service profiles， pools， and other items configured after initial configuration

    E

     A text file with the NX-OS running configuration


    正确答案： A
    解析： 暂无解析

  • 第20题：

    单选题
    A new report process containing a complex query is written, with high impact on the database. You wantto collect basic statistics about query, such as the level of parallelism, total database time, and the number of I/O requests. For the database instance STATISTICS_LEVEL, the initialization parameter is set to TYPICAL and theCONTROL_MANAGEMENT_PACK_ACCESS parameter is set to DIAGNOSTIC+TUNING. What should you do to accomplish this task?（）
    A

    Execute the query and view Active Session History (ASH) for information about the query.

    B

    Enable SQL trace for the query.

    C

    Create a database operation, execute the query, and use the DBMS_SQL_MONITOR. REPORT_SQL_MONITOR function to view the report.

    D

    Use the DBMS_APPLICATION_INFO.SET_SESSION_LONGOPS procedure to monitor query execution and view the information from the V$SESSION_LONGOPS view.


    正确答案： B
    解析： 暂无解析

  • 第21题：

    多选题
    These are the details about V$FLASHBACK_DATABASE_STAT： SQL> DESC v$FLASHBACK_DATABASE_STAT  Name                    Null？              Type  ------------- -------- --------------  BEGIN_TIME                               DATE  END_TIME                                 DATE  FLASHBACK_DATA                        NUMBER  DB_DATA                                  NUMBER  REDO_DATA                               NUMBER  ESTIMATED_FLASHBACK_SIZE             NUMBER  Which two statements regarding the V$FLASHBACK_DATABASE_STATview aretrue？ （）
    A

    BEGIN_TIME is the time at which Flashback logging is enabled.

    B

    END_TIME is the time at which the query is executed on the view.

    C

    REDO_DATA is the number of bytes of redo data written during the interval.

    D

    This view contains information about flashback data pertaining to the last 24 hours.

    E

    FLASHBACK_DATA is the amount of flashback data generated since the database was opened.


    正确答案： C,D
    解析： 暂无解析

  • 第22题：

    多选题
    Which three statements about performance analysis by SQL Performance Analyzer are true? （）
    A

    It detects changes in SQL execution plans.

    B

    It produces results that can be used to create the SQL plan baseline.

    C

    The importance of SQL statements is based on the size of the objects accessed.

    D

    It generates recommendations to run SQL Tuning Advisor to tune regressed SQLs.

    E

    It shows only the overall impact on workload and not the net SQL impact on workload.


    正确答案： A,B
    解析： 暂无解析

  • 第23题：

    单选题
    In what view are you likely to see the following output？（）   SID SERIAL# EVENT SECONDS_IN_WAIT  121 269 RMAN backup & recovery I/O 2  129 415 SQL*Net message from client 63 130 270 SQL*Net message from client
    A

     V$SESSION_EVENT

    B

     V$SESSION

    C

     V$WAITS

    D

     V$WAITSTAT

    E

     V$SYSSTAT


    正确答案： A
    解析： 暂无解析

  • 第24题：

    单选题
    Details about the packing,marking and stowing of（）are given in the International Maritime Dangerous Goods(IMDG)Code.
    A

    general cargoes

    B

    dry bulk cargoes

    C

    hazadous cargoes

    D

    manufactured goods of large size


    正确答案： B
    解析： 暂无解析

相关内容