The underlying tables must have data.
You need SELECT privileges on the view.
The underlying tables must be in the same schema.
You need SELECT privileges only on the underlying tables.
第1题：
Examine the following commands and their output:View the exhibit and examine the Flashback Version Query that was executed after the preceding commands.What could be the possible cause for the query not displaying any row?（）
A. Flashback logging is not enabled for the database.
B. The changes made to the table are not committed.
C. Supplemental logging is not enabled for the database.
D. The database is not configured in ARCHIVELOG mode.
第2题：
You share your computer with other users. You install a new Microsoft add-on to view videos on the computer. You discover that this add-on conflicts with existing add-ons that other users frequently require.You need to ensure that you are able to view videos without affecting other users.What should you do?（）
A.A
B.B
C.C
D.D
第3题：
A. Create a table view.
B. Create a view in any schema.
C. Create a view in your schema.
D. Create a sequence view in any schema.
E. Create a view that is accessible by everyone.
F. Create a view only of it is based on tables that you created.
第4题：
You need to perform certain data manipulation operations through a view called EMP_DEPT_VU, which you previously created. You want to look at the definition of the view (the SELECT statement on which the view was create.) How do you obtain the definition of the view? （）
第5题：
Which of the following statements best describes Flashback Versions Query？（）
第6题：
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.
第7题：
If there were only one question left ,what would it most probably be?
A.What was your childhood dream?
B.What is your biggest achievement?
C.What is your parents view of you?
D.What was your handest expenrience in the war?
第8题：
A. The underlying tables must have data.
B. You need SELECT privileges on the view.
C. The underlying tables must be in the same schema.
D. You need SELECT privileges only on the underlying tables.
第9题：
You are granted the CREATE VIEW privilege. What does this allow you to do?（）
第10题：
In your database， the STATISTICS_LEVEL initialization parameter is set to BASIC. What is the impact of this setting？（）