多选题These are the details about V$FLASHBACK_DATABASE_STAT： SQL> DESC v$FLASHBACK_DATABASE_STAT Name Null？ Type ------------- -------- -------------- BEGIN_TIME DATE END_TIME

题目

多选题

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？（）

BEGIN_TIME is the time at which Flashback logging is enabled.

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

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

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

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

更多“多选题These are the details about V$FLASHBACK_DATABASE_STAT： SQL DESC v$FLASHBACK_DATABASE_STAT Name Null？ Type ------------- -------- -------------- BEGIN_TIME DATE END_TIME ”相关问题

第1题

以下的PL/SQL声明哪个是正确的？（）A、v_id NUMBER(4);B、v_x, v_y, v_z VARCHAR2(10);C、v_birthdate DATE NOT NULL;D、v_in_stock BOOLEAN := 1;

点击查看答案
第2题

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 fileB、Query the V$FLASHBACK_DATABASE_LOG viewC、Query the V$RECOVERY_FILE_DEST_SIZE viewD、Query the V$FLASHBACK_DATABASE_STAT viewE、Check the value assigned for the UNDO_RETENTION parameter

点击查看答案
第3题

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.

点击查看答案
第4题

Examine the structure of the STUDENTS table: STUDENT_ID NUMBER NOT NULL, Primary Key STUDENT_NAME VARCHAR2(30) COURSE_ID VARCHAR2(10) NOT NULL MARKS NUMBER START_DATE DATE FINISH_DATE DATE You need to create a report of the 10 students who achieved the highest ranking in the course INT SQL and who completed the course in the year 1999. Which SQL statement accomplishes this task? （）A、SELECT student_ id, marks, ROWNUM "Rank" FROM students WHERE ROWNUM <= 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC-99 AND course_id = 'INT_SQL' ORDER BY mark DESC;B、SELECT student_id, marks, ROWID "Rank" FROM students WHERE ROWID <= 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC-99' AND course_id = 'INT_SQL' ORDER BY mark;C、SELECT student_id, marks, ROWNUM "Rank" FROM (SELECT student_id, marks FROM students WHERE ROWNUM <= 10 AND finish_date BETWEEN '01-JAN-99' AND '31-DEC- 99' AND course_id = 'INT_SQL' ORDER BY mark DESC;D、SELECT student_id, marks, ROWNUM "Rank" FROM (SELECT student_id, marks FROM students WHERE (finish_date BETWEEN '01-JAN-99 AND '31-DEC-99' AND course_id = 'INT_SQL' ORDER BY marks DESC) WHERE ROWNUM <= 10;E、SELECT student id, marks, ROWNUM "Rank" FROM (SELECT student_id, marks FROM students ORDER BY marks) WHERE ROWNUM <= 10 AND finish date BETWEEN '01-JAN-99' AND '31-DEC-99' AND course _ id 'INT_SQL';

点击查看答案
第5题

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.

点击查看答案
第6题

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.

点击查看答案
第7题

The following command is executed to create the baseline template： SQL> EXECUTEDBMS_WORKLOAD_REPOSITORY.CREATE_BASELINE_TEMPLATE（START_TIME=> TO_TIESTAMP（SYSDATE+2）， END_TIME=>TO_TIMESTAMP（SYSDATE+10）， BASELINE_NAME=>’Mybase4’， TEMPLATE_NAME=>’Mytemp4’， EXPIRATION=>NULL）； Which statement is true about the effect of the above command？（） A、 It creates a baseline template that never expires.B、 It produces an error because no snapshot information is provided to create the baseline.C、 It creates a baseline template that expires after the Automatic Workload Repository （AWR） retention period.D、 It creates a repeating baseline template that repeats after the Automatic Workload Repository （AWR） retention period.

点击查看答案

多选题These are the details about V$FLASHBACK_DATABASE_STAT： SQL DESC v$FLASHBACK_DATABASE_STAT Name Null？ Type ------------- -------- -------------- BEGIN_TIME DATE END_TIME

题目

更多“多选题These are the details about V$FLASHBACK_DATABASE_STAT： SQL DESC v$FLASHBACK_DATABASE_STAT Name Null？ Type ------------- -------- -------------- BEGIN_TIME DATE END_TIME ”相关问题

第1题

第2题

第3题

第4题

第5题

第6题

第7题

相关内容