易截截图软件、单文件、免安装、纯绿色、仅160KB

killtest 分享最新的oracle 1z0 047题库资料下载

1z0-047 资料的最新分享,下面一些题目是从最新的题库中精心整理出来的,质量很高,需要的朋友看过来的啊。
1. Which statements are true? (Choose all that apply.)
A. The data dictionary is created and maintained by the database administrator.
B. The data dictionary views can consist of joins of dictionary base tables and user-defined tables.
C. The usernames of all the users including the database administrators are stored in the data dictionary.
D. The USER_CONS_COLUMNS view should be queried to find the names of the columns to which a constraint applies.
E. Both USER_OBJECTS and CAT views provide the same information about all the objects that are owned by the user.
F. Views with the same name but different prefixes, such as DBA, ALL and USER, use the same base tables from the data dictionary
Answer: CDF
2. Which three statements are true regarding single-row functions? (Choose three.)
A. They can accept only one argument.
B. They can be nested up to only two levels.
C. They can return multiple values of more than one data type.
D. They can be used in SELECT, WHERE, and ORDER BY clauses.
E. They can modify the data type of the argument that is referenced.
F. They can accept a column name, expression, variable name, or a user-supplied constant as arguments.
Answer: DEF
3. Which two statements are true regarding operators used with subqueries? (Choose two.)
A. The NOT IN operator is equivalent to IS NULL.
B. The <ANY operator means less than the maximum.
C. =ANY and =ALL operators have the same functionality.
D. The IN operator cannot be used in single-row subqueries.
E. The NOT operator can be used with IN, ANY and ALL operators.
Answer: BE
4. Which two statements are true regarding views? (Choose two.)
A. A simple view in which column aliases have been used cannot be updated.
B. A subquery used in a complex view definition cannot contain group functions or joins.
C. Rows cannot be deleted through a view if the view definition contains the DI


相关文档:

Oracle与AIX的角色

1.2.1  Oracle与AIX的角色
Oracle运行在AIX上,提供着数据的存储和管理服务。数据即信息,Oracle数据库就是应用系统中存储数据信息的一个集中存储位置、一种存取方法的商品化实现。AIX是承载Oracle运行的底层平台,进行着CPU调度、内存调度、存储管理、文件管理、网络驱动等系统运行和维护工作。
作为对应用系统的支 ......

oracle 关于ID自增和在原有ID的基础上自增

我是个新手,所以有些说的可能会不好,希望阅读这文章的人见谅啊.
一般关于ID自增的网上都有了很多了,呵呵^那我就简单的说一下: 先创建表,再创建序列:
                  create sequence 序列名
   &nb ......

北大青鸟oracle学习笔记11

簇:
有公共列的两个或多个表的集合
簇表中的数据存储在公共数据块中
簇键:
唯一标识符
创建簇:
减少I/O操作,减少磁盘空间,但是插入性能降低。
两张表中有共同的列,比如学生表中有班级编号,班级表中也有班级编号,可以将班级编号存放在簇中
create cluster 簇名(
字段名 类型
)tablespace 表命名空间;
cr ......

oracle连接远程数据库

D:\oracle\product\10.2.0\db_2\NETWORK\ADMIN
6、修改oracle安装路径下D:\oracle\product\10.2.0\db_2\NETWORK\ADMIN\tnsnames.ora的tnsnames.ora文件,添加
XXX =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.12.42 ......

Oracle RAC 常用维护工具和命令


Oracle 的管理可以通过OEM或者命令行接口。 Oracle Clusterware的命令集可以分为以下4种:
节点层:osnodes
网络层:oifcfg
集群层:crsctl, ocrcheck,ocrdump,ocrconfig
应用层:srvctl,onsctl,crs_stat
下面分别来介绍这些命令。 
一. 节点层
只有一个命令: osnodes, 这 ......
© 2009 ej38.com All Rights Reserved. 关于E健网联系我们 | 站点地图 | 赣ICP备09004571号