1Z0-051 20. Which three statements are true regarding the data types in Oracle Database 10g/11g?
来源:互联网 发布:土方计算软件 编辑:程序博客网 时间:2024/05/21 17:42
20. Which threestatements are true regarding the data types in Oracle Database 10g/11g?(Choose
three.)
A. Only one LONG column can be used per table.
B. A TIMESTAMPdata type column stores only time values with fractional seconds.
C. The BLOB datatype column is used to store binary data in an operating system file.
D. The minimum column width that can be specified for aVARCHAR2 data type column is one.
E. The value for a CHAR data type column is blank-padded tothe maximum defined column width.
Answer: ADE
Long类型字段一个表只能有一个,不能使用子查询拷贝,不能使用在order by和group by子句中,并且long类型的字段不能有约束。所以A正确
Timestamp类型的列,默认秒后边跟六位,最多可跟九位,也可没有小数秒。所以B说只能跟小数秒是错误的。
BCLOB是存的二进制文件,bfile存的是外部的二进制文件即操作系统文件,所以C说bclob存的是操作系统二进制文件是错的。
D说varchar2最小可指定的宽度为1,最大为4000。E说char类型可以不指定也可以指定最大宽度,char不指定宽度默认为1,最大为2000.
所以DE是正确的- 1Z0-051 20. Which three statements are true regarding the data types in Oracle Database 10g/11g?
- 20.Which three statements are true regarding the data types in Oracle Database 10g/11g? (Choosethree
- 27.Which two statements are true regarding transactions in an Oracle database? (Choose two.)
- 103.Which two statements are true regarding the Oracle Data Pump export and import operations? (Choo
- 21.Which three statements are true about logical structures of the Oracle database? (Choose three.)
- 1Z0-051 35. Which two statements are true regarding constraints? (Choose two.)
- 42.Which three statements are true regarding views? (Choose three.)
- 135.Which three statements are true regarding subqueries? (Choose three.)
- 118.Which three statements regarding the server parameter file (SPFILE) are true? (Choose three.)
- Which three statements are true regarding the functioning of the Autotask Background Process (ABP)?
- 99.Which two statements are true regarding Oracle Data Pump? (Choose two.)
- 117.Which statements are true regarding the WHERE and HAVING clauses in a SELECT statement?
- 121.Which two statements are true regarding the USING clause in table joins? (Choose two .)
- 7.Which two statements are true regarding the USING and ON clauses in table joins? (Choose two.)
- 158.Which statements are true regarding the FOR UPDATE clause in a SELECT statement? (Choose all tha
- 98.Which two statements are true regarding the usage of the SQL*Loader utility? (Choose two.)
- 148.View the Exhibit. Which statements are true regarding the USERS tablespace? (Choose all that app
- 67.Which two statements are true regarding the ORDER BY clause? (Choose two.)
- 轮播图片转自http://blog.csdn.net/diligentkong/article/details/55209861
- Maven详解
- android actionbar searchview搜索提示
- JDBC数据库连接技术
- java foreach 风格遍历
- 1Z0-051 20. Which three statements are true regarding the data types in Oracle Database 10g/11g?
- 微信公众号杂文(1)access_token和open_id
- stm32 flash读写
- android fragment向action bar添加菜单处理,隐藏等
- 天生丽质小仙女java实训笔记02
- Jquery入门
- 欢迎使用CSDN-markdown编辑器
- java工程师需要会的
- Java面向对象_2