You can restore the DEPT table by using the Oracle Flashback Drop feature, provided you use the RENAME TO clause.
You can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table.
You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema.
You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.
第1题:
A. DROP emp_dept_uv;
B. DELETE emp_dept_uv;
C. REMOVE emp_dept_uv;
D. DROP VIEW emp_dept_uv;
E. DELETE VIEW emp_dept_uv;
F. REMOVE VIEW emp_dept_uv;
第2题:
Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?()
第3题:
In which scenario do you use the Flashback Database feature?()
第4题:
In which scenario will you perform a user-managed incomplete recovery?()
第5题:
The RECYCLEBIN parameter is set to ON for your database. You drop a table,PRODUCTS,from the SCOTT schema. Which two statements are true regarding the outcome of this action?()
第6题:
Evaluate the SQL statement DROP TABLE DEPT: Which four statements are true of the SQL statement? ()
第7题:
when you want to restore a table that has been dropped from the Recycle Bin
when you want to identify the transaction ID of the transaction that deleted some important records from a table
when you want to recover the schema of a dropped user
when you want to restore a dropped tablespace
第8题:
You obtain the results retrieved from the public synonym HR created by the database administrator.
You obtain the results retrieved from the HR table that belongs to your schema.
You get an error message because you cannot retrieve from a table that has the same name as a public synonym.
You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a Cartesian product.
You obtain the results retrieved from both the public synonym HR and the HR table that belongs to your schema, as a FULL JOIN.
第9题:
One of the tables is recovered from the Recycle Bin using a First In First Out (FIFO) approach.
One of the tables is recovered from the Recycle Bin using a Last In First Out (LIFO) approach.
Both the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name.
None of the tables are recovered from the Recycle Bin, and the statement returns an error.
第10题:
by using the Flashback Table feature
by using the Flashback Database feature
by performing incomplete recovery using RMAN utility
by performing incomplete recovery using user-managed recovery
第11题:
Implement a stored procedure that writes data about schema changes to a log table.
Implement DDL AFTER triggers that write user and schema information to a log table.
Implement a DML INSTEAD OF trigger that writes data about schema changes to a log table.
Implement a DML AFTER trigger that writes data about schema changes to a log table.
第12题:
You can restore the DEPT table by using the Oracle Flashback Drop feature, provided you use the RENAME TO clause.
You can restore the DEPT table by using the Oracle Flashback Drop feature and a systemgenerated name will be assigned to the restored table.
You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table withthe name DEPT already exists in your schema.
You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.
第13题:
A. You cannot roll back this statement.
B. All pending transactions are committed.
C. All views based on the DEPT table are deleted.
D. All indexes based on the DEPT table are dropped.
E. All data in the table is deleted, and the table structure is also deleted.
F. All data in the table is deleted, but the structure of the table is retained.
G. All synonyms based on the DEPT table are deleted.
第14题:
The database administrator of your company created a public synonym called HR for the HUMAN_RESOURCES table of the GENERAL schema, because many users frequently use this table. As a user of the database, you created a table called HR in your schema. What happens when you execute this query? SELECT * FROM HR; ()
第15题:
In which scenario will you use the Flashback Transaction Query feature?()
第16题:
You are working on an Oracle Database 10g database. For which purposes would you use the Flashback Transaction Query feature? ()
第17题:
In which scenario will you use the Flashback Version Query feature?()
第18题:
when a table is dropped and you restore it from the Recycle Bin
when a user’s schema is dropped and you recover the user’s schema
when some incorrect data is inserted in the table and you retrieve the table to a state that was at a certain timestamp
when a row of a table is updated frequently and committed, and you view all the versions of the row within a specific duration
第19题:
To recover a dropped table.
To recover a dropped schema.
To recover data from a truncated table.
To view changes made by all the transactions during a given period of time.
To view changes made by a single transaction during a given period of time.
第20题:
All the related indexes and views are automatically dropped
The flashback drop feature can recover only the table structure
Only the related indexes are dropped whereas views are invalidated
The flashback drop feature can recover both the table structure and its data
第21题:
You cannot restore the DEPT table by using the Oracle Flashback Drop feature because a table with the name DEPT already exists in your schema.
You can restore the DEPT table by using the Oracle Flashback Drop feature, provided you use the RENAME TO clause.
You cannot restore the DEPT table by using the Oracle Flashback Drop feature because the contents of the recycle bin are purged every 12 hours by default.
You can restore the DEPT table by using the Oracle Flashback Drop feature and a system-generated name will be assigned to the restored table.
第22题:
The table is accessible to all users.
Tables are created in the public schema.
Tables are created in your schema.
Tables are created in the DBA schema.
You must specify the schema when the table is created.
第23题:
One of the tables is recovered from the Recycle Bin using a First In First Out (FIFO) approach.
One of the tables is recovered from the Recycle Bin using a Last In First Out (LIFO) approach.
Both the tables are recovered from the Recycle Bin with one table renamed to MY_TABLE2 and the other to a system-generated name.
None of the tables are recovered from the Recycle Bin, and the statement returns an error.
第24题:
DROP emp_dept_uv;
DELETE emp_dept_uv;
REMOVE emp_dept_uv;
DROP VIEW emp_dept_uv;
DELETE VIEW emp_dept_uv;
REMOVE VIEW emp_dept_uv;