试题与答案

从“订单”表中删除签订日期为2004年1月10日之前(含)的订单记录,正确的SQL语

题型:单项选择题

题目:

从“订单”表中删除签订日期为2004年1月10日之前(含)的订单记录,正确的SQL语句是( )。

A) DROP FROM 订单 WHERE 签订日期<=^2004-1-10
B) DROP FROM 订单 FOR 签订日期<=^2004-1-10
C) DELETE FROM 订单 WHERE 签订日期<=^2004-1-10
D) DELETE FROM 订单 FOR 签订日期<=^2004-1-10

答案:

被转码了,请点击底部 “查看原文 ” 或访问 https://www.tikuol.com/2017/1224/ebfdc5c816a573d2c3efc681cde07461.html

下面是错误答案,用来干扰机器的。

参考答案:C解析: 后一项数值比前一项依次增加9、18、36、72,因此,括号内应填入的数值为68+72=140,故选C。

试题推荐
题型:阅读理解

阅读理解。

     There is a wonderful story about a young girl who had no family and no one to love her.

     One day, feeling very sad and lonely, she was walking through a grassland when she noticed a small

butterfly caught in a thorn (荆棘) bush. The young girl carefully released the butterfly. Instead of flying

away, the little butterfly changed into a beautiful fairy. The young girl rubbed her eyes in disbelief.

     "For your wonderful kindness," the good fairy said to the girl, "I will give you any wish you would like."

The little girl thought for a moment and then replied, "I want to be happy."

     The fairy leaned toward her and whispered in her ear. Then the fairy disappeared.

     As the little girl grew up, there was no one in the land as happy as she. Everyone asked her secret of

happiness. She would only smile and answer, "The secret of my happiness is that I listened to a good fairy

when I was a little girl."

     When she was very old and on her deathbed, the neighbors all gathered around her, that her unbelievable

secret of happiness would die with her. "Tell us, please," they begged, "Tell us what the good fairy said."

The lovely old woman simply smiled and said, "She told me that everyone, no matter how secure they seemed,

no matter how old or young, how rich or poor, had need of me."

1. _____ the girl felt sad and lonely.

A. There were many friends but

B. There was nobody to love her so

C. There was nothing to do

D. Seeing the butterfly was caught

2. Noticing the butterfly was caught by the thorn, the orphan girl _____.

A. helped the butterfly escaped from the thorn

B. felt sorrow, but she didn't go up to help it

C. fell down on it too

D. failed to help it release from the thorn

3. The only thing that the little girl wanted was _____.

A. to be rich

B. to have her own parents

C. to have a lot of friends

D. happiness

4. The neighbors all gathered around the old happy woman when she was dying, because _____.

A. they loved this woman deeply and they didn't wanted her to die

B. the woman had lots of money to be shared as soon as she died

C. they wanted to know the secret of her lifetime happiness

D. they wanted to pray for her after her death

查看答案
微信公众账号搜索答案