-
编辑 删除
关于表空间本地管理一题
103. You want to create a tablespace with the following specifications:1. The tablespace extends automatically.2. Used and free extents should be managed by bitmaps.3. Default PCTUSED attribute is se...
-
编辑 删除
public synonym的定义可以在哪个视图查到？
public synonym的定义可以在哪个视图查到？
-
编辑 删除
关于CREATE TABLESPACE USERS;
98. View this parameter setting in your database:DB_CREATE_FILE_DEST='D:\oracle\product\10.2.0\oradata\oracle'You created a tablespace by using this command:CREATE TABLESPACE USERS;Which two stat...
-
编辑 删除
USER能够flashback to bedore drop?
042中有一题68. Which two operations can be flashed back using the Flashback technology? (Choose two.)A. DROP USER SMITH;B. DROP TABLE EMPLOYEES;C. DROP TABLESPACE USERS;D. ALTER TABLE ...
-
编辑 删除
奇怪的DELETE
OCP 047有道关于DELETE的题目中，其中一个选项：DELETE FROM (SELECT * FROM oe.order_items i, oe.orders o WHERE i.order_id = o.order_id AND order_status IN (0,1));表面看很容易误解，把它判为错误的答案，...
-
编辑 删除
解读047关于正则表达式'[^Ale|ax.r$]'
92. Evaluate the following expression using meta. character for regular expression:'[^Ale|ax.r$]'Which two matches would be returned by this expression? (Choose two.)A. AlexB. AlaxC. AlxerD. Alaxendar...
-
编辑 删除
查看ORACLE权限
--查看Oracle系统权限select * from system_privilege_map;--查看用户权限1）系统权限： select * from dba_sys_privs; --所有用户的系统权限 select * from user_sys_privs; --当前...
-
编辑 删除
ORACLE约束(constraint)：对象的强制规定
ORACLE约束(constraint)：对象的强制规定5种约束：NOT NULL 非空 NNUNIQUE 唯一 UKPRIMARY KEY 主键 PKFOREIGN KEY 外键 FKCHECK &...
-
编辑 删除
多表 INSERT
ORACLE insert 详解多表 INSERT 语句概述:: INSERT...SELECT 语句能够作为单个的 DML 语句的一部分用于插入行到多表中:: 多表 INSERT 语句能够被用在数据仓库系统中从一个或多个操作源转移数据到一组目的表中:: 下...
-
编辑 删除
带CHECK选项的INSERT
--带check option的insertinsert into(select order_id,order_date,customer_id, order_totalfrom oe.orderswhere order_total = 1000with check option)values (14, sysdate, 105, 1000);select * from oe.o...
-
编辑 删除
请教047中一题目
4. View the Exhibit and examine the structure of the EMP table which is not partitioned and not anindexorganizedtable.Evaluate the following SQL statement:ALTER TABLE empDROP COLUMN first_name;Wh...
