[单选题]

信贷额度关系credit-in(C_name,limit,Credit balance)中的三个属性分别表示用户姓名、信贷额度和到目前为止的花费。下表为关系credit-in-的一个具体实例。若要查询每个用户还能花费多少,相应的SQL语句应为:Select(58)From credit-in

A.C_name,Credit_balance-limit

B.C_name,limit-Credit_balance

C.C_name, limit, Credit_balance

D.C_name,Credit_balance

参考答案与解析:

相关试题

某银行信贷额度关系credit£­in(C_no,C_name,limit,Cr

[单选题]某银行信贷额度关系credit-in(C_no,C_name,limit,Credit_balance)中的4个属性分别表示用户号、用户姓名、信贷额度和累计消费额。该关系的 (60) 属性可以作为主键。下表为关系credit-in的一个具体实例。查询累计消费额大于3000的用户姓名以及剩余消费额的SQL语句应为:Select (61)F.rom credit-inWhere (62);A.C noB.C nameC.Credit balanceD.limit

  • 查看答案
  • 某银行信贷额度关系 credit£­in(C_no, C_name, lim

    [试题] 某银行信贷额度关系 credit-in(C_no, C_name, limit, Credit_balance)中的四个属性分别表示用户号、用户姓名、信贷额度和累计消费额。该关系的 (60) 属性可以作为主键。下表为关系 credit-in 的一个具体实例。查询累计消费额大于 3000 的用户姓名以及剩余消费额的 SQL 语句应为:Select (61)F.rom credit-inWhere (62) ;(60)A. C_noB. C_nameC. Credit_balanceD. limit

  • 查看答案
  • 某银行数据库中,信贷额度关系模式为Credit£­in(用户账号,信贷额度,已

    [单选题]某银行数据库中,信贷额度关系模式为Credit-in(用户账号,信贷额度,已用 金额,信誉指数),用户关系模式为User(用户账号,用户姓名,地址,电话) a.查询每个用户还能使用的剩余金额的SQL语句为: SELECT用户账号,用户姓名, (58) FROM Credit-in, User WHERE(59);(58)A.“信贷额度一已用金额”as剩余金额B.信贷额度一已用金额as剩余金额C.“信贷额度一已用金额”at剩余金额D.信贷额度一已用金额at剩余金额(59)A."Credit-in

  • 查看答案
  • Unless otherwise stipulated in the letter of credit,the name of the insured is generally the( )of le

    [单选题]Unless otherwise stipulated in the letter of credit,the name of the insured

  • 查看答案
  • Unless otherwise stipulated in the letter of credit,the name of the insured is generally the( )of le

    [单选题]Unless otherwise stipulated in the letter of credit,the name of the insured

  • 查看答案
  • L/C(Letter of Credit)

    [名词解释] L/C(Letter of Credit)

  • 查看答案
  • Meshack Bradovic, CFA, was recently hired as a credit analyst at a credit rating agency whose major

    [单选题]Meshack Bradovic, CFA, was recently hired as a credit analyst at a credit r

  • 查看答案
  • Credit analysts are likely to consider a company's credit quality to be improving if the compan

    [单选题]Credit analysts are likely to consider a company's credit quality to be imp

  • 查看答案
  • Credit spreads tend to widen as:

    [单选题]Credit spreads tend to widen as:A.The credit cycle improves.B.Economic cond

  • 查看答案
  • Which of the following is not a credit i

    [单选题]Which of the following is not a credit instrument?()A . CheckB . promissory noteC . draftD . coin

  • 查看答案