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

最新推荐文章于 2019-02-25 19:23:32 发布
原创 最新推荐文章于 2019-02-25 19:23:32 发布 · 164 阅读 · 0 ·
本内容遵循CC 4.0 BY-SA版权协议
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文详细解析了SQL中的区间类型，包括MONTH、YEARTOMONTH和HOURTOSECOND的使用方法及输出格式，通过具体实例展示了如何正确理解和应用这些区间类型。
               

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天）

 


 

           

再分享一下我老师大神的人工智能教程吧。零基础！通俗易懂！风趣幽默！还带黄段子！希望你也加入到我们人工智能的队伍中来！https://blog.csdn.net/jiangjunshow

宝宝2355
关注
OCP-1Z0-051 第2题 视图的WITH CHECK OPTION选项
Oracle
04-14 9732
View the Exhibit to examine the description for the SALES table. Which views can have all DML operations performed on it? (Choose all that apply.)   A. CREATE VIEW v3 AS SELECT * FROM SALES WHERE
OCP-1Z0-051-V9 02-96题
qq_43679940的博客
02-25 334
OCP-1Z0-051-V9 02-96题
OCP-1Z0-051-V9.02-19题
一抹曦阳-Oracle
10-22 1万+
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?
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:
ocp—051试题答案解析
mickeyty的博客
05-19 1万+
1Z0-051 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 th
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.
OCP-1Z0-051-V9.02-14题
一抹曦阳-Oracle
09-02 9957
14. Using the CUSTOMERS table,  you need to generate a report that shows 50% of each   credit amount in each income level. The report should NOT show any repeated credit amounts in each income l
Oracle INTERVAL YEAR TO MONTH 和INTERVAL DAY TO SECOND 数据类型
cuici65440的专栏
03-15 293
...
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
AxureRP8 一直报错，各种报错求解决方案
weixin_42496941的博客
01-17 2万+
打开网页浏览报错， 保存报错，打开其它页面也报错 就连拖拉图片都报错甚是无语！ 求解决方案~~~~~~~~~
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-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-152题
sdfsdkk的博客
01-27 531
OCP-1Z0-051-V9 02-152题
OCP-1Z0-051-V9.02-157题
一抹曦阳-Oracle
10-20 7625
157. View the Exhibit and examine the structure of the ORDERS and CUSTOMERS tables. Evaluate the following SQL command: SQL> SELECT o.order_id, c.cust_name, o.order_total, c.credit_limit FROM order
OCP-1Z0-051-V9.02-148题
一抹曦阳-Oracle
09-25 7703
148. View the Exhibit and examine the structure of the PRODUCTS tables. You want to generate a report that displays the average list price of product categories where the average list price is l
OCP-1Z0-051-V9.02-2题
一抹曦阳-Oracle
10-21 1万+
2. View the Exhibit to examine the description for the SALES table. Which views can have all DML operations performed on it? (Choose all that apply.)  A. CREATE VIEW v3 AS SELECT * FROM SALES  
OCP-1Z0-051-V9.02-82题
一抹曦阳-Oracle
10-18 9401
82. Examine the data in the CUST_NAME column of the CUSTOMERS table. CUST_NAME Renske Ladwig Jason Mallin Samuel McCain Allan MCEwen Irene Mikkilineni Julia Nayer You need to display customers
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值