1Z0-051 20. Which three statements are true regarding the data types in Oracle Database 10g/11g?

最新推荐文章于 2021-04-11 11:35:39 发布
最新推荐文章于 2021-04-11 11:35:39 发布
阅读量1.5k 收藏
点赞数
文章标签： OCP
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/u011622050/article/details/73825964
版权

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是正确的

路畅水远
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
1z0-062 .pdf
09-05
Which three statements are true about user account administration? (Choose three.) A. A user's current session is not affected when the user's profile is changed. B. Only users with the SYSDBA ...
ocp-1Z0-082
qq_36369239的博客
05-04 3168
C、私有临时表和全局临时表都有ON COMMIT DELETE ROWS和ON COMMIT PRESERVE ROWS的两种分类(delete rows用于事务相关,也就在事务结束后truncate data in the temporary table,preserve rows表示在会话结束后清除临时表的数据)A、不可用索引会自动删除segment,但是索引分区后，某个分区的索引不可用，其它索引段还在的。B、私有临时表这个特性18C才引入。答案： B E F。答案： A B D。
oracle metadata only,ocp 052 最新题库04
weixin_42400619的博客
04-11 262
97.In yourdatabase:SGA_TARGET =270M PGA_AGGREGATE_TARGET =90MThe MEMORY_TARGET and MEMORY_MAX_TARGET parameters are currently not configured. You execute the command:ALTER SYSTEM SET MEMORY_TARGET =...
OCP-1Z0-051-V9.02-117题
一抹曦阳-Oracle
10-19 1万+
117. Which statements are true regarding the WHERE and HAVING clauses in a SELECT statement? (Choose all that apply.) A. The HAVING clause can be used with aggregate functions in subqueries.  B. Th
20.Which three statements are true regarding the data types in Oracle Database 10g/11g? (Choosethree
dwj19830118的专栏
01-25 2039
20.Which three statements are true regarding the data types in Oracle Database 10g/11g? (Choosethree.)
42.Which three statements are true regarding views? (Choose three.)
dwj19830118的专栏
02-24 1837
42.Which three statements are true regarding views? (Choose three.)
OCA Oracle Database 11g SQL Fundamentals I Exam Guide (Exam 1Z0-051).pdf
08-22
1 Oracle Server Technologies and the Relational Paradigm 2 Data Retrieval Using the SQL SELECT Statement 3 Restricting and Sorting Data 4 Single-Row Functions 5 Using Conversion Functions and ...
Oracle 19c OCP 082 试题带翻译-2022.5.2更新
05-16
Which two statements are true about space - saving features in an Oracle Database? A.An index created with the UNUSABLE attribute has no segment. B.Private Temporary Tables(PTTs)store metadata in ...
Oracle-SQL-statements-efficiency.rar_oracle
09-21
Oracle的SQL语句执行效率问题查找与解决方法。
Java SE 8 Programmer I Study Guide: Exam 1Z0-808
02-02
Title: OCA: Oracle Certified Associate Java SE 8 Programmer I Study Guide: Exam 1Z0-808 Author: Jeanne Boyarsky, Scott Selikoff Length: 432 pages Edition: 1 Language: English Publisher: Sybex ...
2018 OCP 1z0-071 最新题库
11-09
2018 OCP 1z0-071 最新题库(培训机构）2018 OCP 1z0-071 最新题库(培训机构）
OCP-1Z0-052-V8.02-26题
热门推荐
一抹曦阳-Oracle
10-03 1万+
26. Which two statements are true regarding undo tablespaces? (Choose two.) A.The database can have more than one undo tablespace. B.The UNDO_TABLESPACE parameter is valid in both automatic and
oracle11g OCP 认证 1Z0-053考试笔记2
wlbzy的专栏
11-24 9714
102.Examine the following values of the initialization parameters in the database having the SID ORCL: BACKGROUND_DUMP_DEST=/u01/app/oracle/product/11.1.0/db_1/bdump USER_DUMP_DEST=/u01/app/oracle/p
Which three statements are true regarding the functioning of the Autotask Background Process (ABP)?
陈英锋的专栏
04-24 1654
Which three statements are true regarding the functioning of the Autotask Background Process (ABP)? (Choose three.) 关于自动任务后台进程（ABP）的功能哪三种说法是真实的？ A. It creates jobs without considering the priorities
OCP-1Z0-053-V13.02-111题
一抹曦阳-Oracle
02-17 6632
111.Which three statements are true regarding persistent lightweight jobs? (Choose three.) A. Persistent lightweight jobs modify several tables in the data dictionary to generate a lot of redo. B. T
OCP-1Z0-新051-61题版本-46
一抹曦阳-Oracle
12-30 3246
QUESTION NO: 46 Which three statements are true regarding the data types in Oracle Database 10g/11g? (Choose three.) A. The BLOB data type column is used to store binary data in an operating system
OCP-1Z0-052-V8.02-27题
一抹曦阳-Oracle
10-03 1万+
27. Which two statements are true regarding transactions in an Oracle database? (Choose two.) A.Multiple transactions can use the same undo segment. B.A transaction is assigned an undo segment w
135.Which three statements are true regarding subqueries? (Choose three.)
dwj19830118的专栏
03-08 2261
135.Which three statements are true regarding subqueries? (Choose three.)
117.Which statements are true regarding the WHERE and HAVING clauses in a SELECT statement?
dwj19830118的专栏
03-07 2682
117.Which statements are true regarding the WHERE and HAVING clauses in a SELECT statement?
Q21: Which of the following is a valid user-defined output stream manipulator header? a. ostream& tab( ostream& output ) b. ostream tab( ostream output ) c. istream& tab( istream output ) d. void tab( ostream& output ) Q22: What will be output by the following statement? cout << showpoint << setprecision(4) << 11.0 << endl; a. 11 b. 11.0 c. 11.00 d. 11.000 Q23: Which of the following stream manipulators causes an outputted number’s sign to be left justified, its magnitude to be right justified and the center space to be filled with fill characters? a. left b. right c. internal d. showpos Q24: Which of the following statements restores the default fill character? a. cout.defaultFill(); b. cout.fill(); c. cout.fill( 0 ); d. cout.fill( ' ' ); Q25: When the showbase flag is set: a. The base of a number precedes it in brackets. b. Decimal numbers are not output any differently. c. "oct" or "hex" will be displayed in the output stream. d. Octal numbers can appear in one of two ways. Q26: What will be output by the following statements? double x = .0012345; cout << fixed << x << endl; cout << scientific << x << endl; a. 1.234500e-003 0.001235 b. 1.23450e-003 0.00123450 c. .001235 1.234500e-003 d. 0.00123450 1.23450e-003 Q27: Which of the following outputs does not guarantee that the uppercase flag has been set? a. All hexadecimal numbers appear in the form 0X87. b. All numbers written in scientific notation appear the form 6.45E+010. c. All text outputs appear in the form SAMPLE OUTPUT. d. All hexadecimal numbers appear in the form AF6. Q28: Which of the following is not true about bool values and how they're output with the output stream? a. The old style of representing true/false values used -1 to indicate false and 1 to indicate true. b. A bool value outputs as 0 or 1 by default. c. Stream manipulator boolalpha sets the output stream to display bool values as the strings "true" and "false". d. Both boolalpha and noboolalpha are “sticky” settings.
最新发布
05-24
The old style of representing true/false values used -1 to indicate false and 1 to indicate true is not true. False is represented by 0 and true is represented by any non-zero value.

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值