92 Examine the output of the query that you executed to list the objects in the recycle bin: SQL> SE
来源:互联网 发布:国网内网网络大学地址 编辑:程序博客网 时间:2024/06/11 19:54
Examine the output of the query that you executed to list the objects in the recycle bin: SQL>
SELECT original_name, droptime, dropscn FROM user_recyclebin; ORIGINAL_NAME
DROPTIME DROPSCN
--------- ----------- -------
SALES_TAB 2007-12-11:13:37:11 4472036
SALES_TAB 2007-12-11:13:49:30 4472988
SALES_TAB 2007-12-11:13:55:39 4473100
You verified that no table named SALES_TAB exists in the schema. Then you executed the following
command to purge the objects in the recycle bin:
SQL> PURGE TABLE sales_tab;
What would be the outcome of this command?
A. All three tables in the recycle bin are purged
B. Only the table with the oldest DROPSCN is purged
C. The command returns an error because multiple entries with the same name exist in the recycle bin
D. Only the table with the latest DROPSCN is purged
Correct Answer: B
Section: (none)
Explanation
Explanation/Reference:
Explanation:
verified
http://download.oracle.com/docs/cd/B14117_01/server.101/b10759/statements_9018.htm
If you specify the user-specified name, and if the recycle bin contains more than one object of that name,
then the database purges the object that has been in the recycle bin the longest.
Use the PURGE statement to remove a table or index from your recycle bin and release all of the space
associated with the object, or to remove the entire recycle bin, or to remove part of all of a dropped
tablespace from the recycle bin.
When the database purges a table, all table partitions, LOBs and LOB partitions, indexes, and other
dependent objects of that table are also purged.
The database object must reside in your own schema or you must have the DROP ANY… system privilege
for the type of object to be purged, or you must have the SYSDBA system privilege.
- 92 Examine the output of the query that you executed to list the objects in the recycle bin: SQL> SE
- 119.View the Exhibit and examine the output of the query. What do you infer from this?
- 124.You executed the following commands to find the location of the alert log file: SQL> SHOW PARAME
- 49.View the Exhibit to examine the output of the DBA_OUTSTANDING_ALERTS view.
- Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL se
- 77.You executed the following command to perform a backup of the USERS tablespace: SQL> ALTER TABLES
- 55.View the Exhibit to examine the output produced by the following query at three different times s
- 145.Examine the commands executed in a DBA session: SQL> CREATE BIGFILE TABLESPACE MRKT 2 DATAFILE '
- 157.Examine the commands executed in the following sequence: 1: SQL> CREATE ROLE mgrrole; 2: SQL> G
- 13.You have executed this command to change the size of the database buffer cache:
- 35.You executed the command to create a password file in the database server:
- 91.View the Exhibit to examine the error that occurred during the database startup. You opened an RM
- 101.You want to move all objects of the APPS user in the test database to the DB_USER schema of the
- mysql建立数据库报错You have an error in your SQL syntax; check the manual that corresponds to your MySQL se
- 10.Examine the following statement that is used to modify the constraint on the SALES table:
- 126 You executed the following commands in a database session: SQL> SELECT object_name, original_nam
- 149.You executed the following command to create a tablespace called SALES_DATA: SQL> CREATE TABLESP
- 92.You executed the following commands in an RMAN session for your database instance that has failur
- JVM(3)--垃圾收集
- JAVA8新特性
- ContentProvider使用详解
- Vmware变慢的解决方案
- 取本周累计
- 92 Examine the output of the query that you executed to list the objects in the recycle bin: SQL> SE
- 让并发和容错更容易:Akka示例教程
- CentOS学习10_CentOS系统安装过程和配置细节
- CUDA环境搭建
- 04-树5 Root of AVL Tree
- awk行内去重
- kvm
- Facial Landmark Detection
- Android Activity 详述