OCP-1Z0-051-V9.02-19题

最新推荐文章于 2019-02-21 20:36:29 发布
原创 最新推荐文章于 2019-02-21 20:36:29 发布 · 1w 阅读 · 0 ·
本内容遵循CC 4.0 BY-SA版权协议
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文通过一个具体的SQL查询示例，展示了如何使用INTERVAL类型来表示时间跨度，并解释了不同时间单位之间的转换方式。通过实验验证，明确了指定的时间间隔如何被正确地解析和展示。

19. Evaluate the following query:

SELECT INTERVAL '300' MONTH, 

INTERVAL '54-2' YEAR TO MONTH,

INTERVAL '11:12:10.1234567' HOUR TO SECOND

FROM dual;

What is the correct output of the above query?

A. +25-00 , +54-02, +00 11:12:10.123457 

B. +00-300, +54-02, +00 11:12:10.123457

C. +25-00 , +00-650, +00 11:12:10.123457

D. +00-300 , +00-650, +00 11:12:10.123457

Answer: A

答案解析：

实验验证：

sys@TEST0924> SELECT INTERVAL '300' MONTH, INTERVAL '54-2' YEAR TO MONTH,INTERVAL '11:12:10.1234567' HOUR TO SECOND FROM dual;


INTERVAL'300'MONTH

---------------------------------------------------------------------------

INTERVAL'54-2'YEARTOMONTH

---------------------------------------------------------------------------

INTERVAL'11:12:10.1234567'HOURTOSECOND

---------------------------------------------------------------------------

+25-00

+54-02

+00 11:12:10.123457



INTERVAL '300' MONTH：300个月为+25-00（25年-0个月，即25*12+0）
INTERVAL '54-2' YEAR TO MONTH：+54-02
INTERVAL '11:12:10.1234567' HOUR TO SECOND: +00 11:12:10.123457（+00表示0天）

 


 

OCP-1Z0-051-V9 02-96题
qq_43679940的博客
02-25 334
OCP-1Z0-051-V9 02-96题
OCP-1Z0-051 第19题 INTERVAL用法
Oracle
04-14 5959
一、原题 Evaluate the following query: SELECT INTERVAL '300' MONTH, INTERVAL '54-2' YEAR TO MONTH, INTERVAL '11:12:10.1234567' HOUR TO SECOND FROM dual; What is the correct output of the above query
OCP-1Z0-051-题目解析-第19题
wangjx的专栏
06-28 1856
19. Evaluate the following query:  SELECT INTERVAL '300' MONTH, INTERVAL '54-2' YEAR TO MONTH, INTERVAL '11:12:10.1234567' HOUR TO SECOND FROM dual; What is the correct output of the above query
19.Evaluate the following query:
dwj19830118的专栏
01-20 1325
19.Evaluate the following query:
INTERVAL 用法
Oracle
04-14 4万+
oracle 10g以后，出现 INTERVAL YEAR TO MONTH INTERVAL DAY TO SECOND Interval year(precision) to month   precision是这个时限的年部分所要求的最大位数。 默认为2，范围为0~9 Interval day(d_precision) to second(s_precision)   d_p
OCP-1Z0-053-V12.02-62题
一抹曦阳-Oracle
11-04 8037
62.You want to convert your existing non-ASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task? A. Data Pump Export and Import B. conventional
OCP-1Z0-051-V9 02-19题
sdfsdkk的博客
02-09 164
OCP-1Z0-051-V9 02-19题
OCP-1Z0-051-V9 02-32题
sdfsdkk的博客
02-21 370
OCP-1Z0-051-V9 02-32题
OCP-1Z0-051-V9.02-1题
一抹曦阳-Oracle
09-30 1万+
1. View the Exhibit and examine the structure of the SALES, CUSTOMERS, PRODUCTS, and TIMES tables. The PROD_ID column is the foreign key in the SALES table, which references the PRODUCTS table.
SQL解惑1——interval关键字用法 .
热门推荐
arenzhj的专栏
11-23 5万+
做个例子描述吧，也许更易于理解。 准备： 1.建表 create table INTERVAL_TEST (   t_id     INTEGER not null,  --纯id   t_date   VARCHAR2(40) not null,--时间，如果此处类型为date最好，不过现在很多应用都喜欢把时间建成varchar2   t_flagCHAR(40)  --没什么业务
OCP-1Z0-051 补充题库 第6题 SELECT查询语句
Oracle
05-29 2681
一、原题 See the Exhibit and examine the structure of the CUSTOMERS table: Using the CUSTOMERS table, you need to generate a report that shown the average credit limit for customers in WASHINGTON and N
ocp-300
jiayue's BLOG
10-11 1333
QUESTION NO: 300 Which of the following is not an advantage of block media recovery (BMR)?A. Reduced MTTR.( mean time to recover) B. Datafiles remain offline while corrupt blocks are repaired.C. Data
Oracle中INTERVAL YEAR TO MONTH 和 INTERVAL DAY TO SECOND数据类型
听雪楼主
05-24 1897
INTERVAL YEAR TO MONTH数据类型Oracle语法:INTERVAL 'integer [- integer]' {YEAR | MONTH} [(precision)][TO {YEAR | MONTH}]该数据类型常用来表示一段时间差, 注意时间差只精确到年和月. precision为年或月的精确域, 有效范围是0到9, 默认值为2.eg:INTERVAL '123-2' Y...
AxureRP8 一直报错，各种报错求解决方案
weixin_42496941的博客
01-17 2万+
打开网页浏览报错， 保存报错，打开其它页面也报错 就连拖拉图片都报错甚是无语！ 求解决方案~~~~~~~~~
INTERVAL '1' MONTH TO MONTH
TongYu2009的专栏
12-19 7422
INTERVAL 'integer [- integer]' {YEAR | MONTH} [(precision)][TO {YEAR | MONTH}] 该数据类型常用来表示一段时间差, 注意时间差只精确到年和月. precision为年或月的精确域, 有效范围是0到9, 默认值为2.   SELECT TRUNC(V.XF_TXDATE, 'MM') TXMONTH, V.XF_P
【SQL】INTERVAL YEAR TO MONTH 和 INTERVAL DAY TO SECOND
Just Do IT
03-08 3359
INTERVAL YEAR TO MONTH： 作为年和月的时间间隔存储 INTERVAL DAY TO SECOND: 作为天、小时、分和秒的时间间隔存储（DAY,HOUR,MINUTE,SECOND） 1） 创建以上两种数据类型的表 SQL> create table t1(id number(2),x interval year to month,y interval day to s
OCP-1Z0-051-题目解析-第13题
weixin_30562507的博客
06-26 2206
13. View the Exhibit and examine the structure of the PRODUCTS table. You need to generate a report in the following format:CATEGORIES5MP Digital Photo Camera's category is PhotoY Box's category is E...
16.Evaluate the following query: SQL> SELECT promo_name||q'{'s start date was }'||promo_begin_date A
dwj19830118的专栏
01-20 1870
16.Evaluate the following query: SQL> SELECT promo_name||q'{'s start date was }'||promo_begin_date AS "Promotion Launches" FROM promotions;
Oracle INTERVAL YEAR TO MONTH 和INTERVAL DAY TO SECOND 数据类型
cuici65440的专栏
03-15 293
...
20151217 OCP047 新题库 1-30
gumengkai的博客
12-17 705
2.evaluate the following create table command; create table order_item( order_id number(3), item_id number(2), aty number(4), constraint ord_itm_id_pk primary key (order_id,item_id) using index(
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值