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? ()
第1题:
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
第2题:
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?()
第3题:
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
第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? ()
第5题:
Evaluate these two SQL statements: SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY salary DESC; SELECT last_name, salary , hire_date FROM EMPLOYEES ORDER BY 2 DESC; What is true about them?()
第6题:
talbe :
pub(pub_code char(2),pub_name varchar2(32))
book(book_code char(8),book_name varhcar2(128),pub_code char92),author_code
char(4),book_mem varchar2(128))
author(author_code char(4),author_name varchar2(10),sex char(1), age
number(3),dir varchar2(64))
auth_list(auth_date date,author_code char(4))
在PL/SQL中有以下两种字义
v_book_row book%rowtype;
v_book_code book.bank_code%type;
请说明v_book_row,v_book_code变量的含义以及数据类型
第7题:
The EMPLOYEES table has these columns: LAST NAME VARCHAR2(35) SALARY NUMBER(8,2) HIRE_DATE DATE Management wants to add a default value to the SALARY column. You plan to alter the table by using this SQL statement: ALTER TABLE EMPLOYEES MODIFY ( SALARY DEFAULT 5000); What is true about your ALTER statement?()
第8题:
ThesearethedetailsaboutV$FLASHBACK_DATABASE_STAT:SQL>DESCV$FLASHBACK_DATABASE_STATNameNull?Type-----------------------------------BEGIN_TIMEDATEEND_TIMEDATEFLASHBACK_DATANUMBERDB_DATANUMBERREDO_DATANUMBERESTIMATED_FLASHBACK_SIZENUMBERWhichtwostatementsregardingtheV$FLASHBACK_DATABASE_STATviewaretrue?()
A.BEGIN_TIMEisthetimeatwhichFlashbackloggingisenabled.
B.END_TIMEisthetimeatwhichthequeryisexecutedontheview.
C.REDO_DATAisthenumberofbytesofredodatawrittenduringtheinterval.
D.Thisviewcontainsinformationaboutflashbackdatapertainingtothelast24hours.
E.FLASHBACK_DATAistheamountofflashbackdatageneratedsincethedatabasewasopened.
第9题:
以下的PL/SQL声明哪个是正确的?()
第10题:
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? ()