● 某银行信贷额度关系 credit-in(C_no, C_name, limit, Credit_balance)中的四个属性分别表示用
● 某银行信贷额度关系 credit-in(C_no, C_name, limit, Credit_balance)中的四个属性分别表示用户号、用户姓名、信贷额度和累计消费额。该关系的 (60) 属性可以作为主键。下表为关系 credit-in 的一个具体实例。查询累计消费额大于 3000 的用户姓名以及剩余消费额的 SQL 语句应为:Select (61)From credit-inWhere (62) ;(60)A. C_noB. C_nameC. Credit_balanceD. limit(61)A. C_name,Credit_balance - limitB. C_name,limit - Credit_balanceC. C_name,limit,Credit_balanceD. C_name,Credit_balance(62)A. limit>3000B. Credit_balance>3000C. limit - Credit_balance>3000D. Credit_balance - limit>3000
查询累计消费额大于 3000 的用户姓名以及剩余消费额的 SQL 语句应为:Select (61)From credit-inWhere (62) ;(60)A. C_noB. C_nameC. Credit_balanceD. limit(61)A. C_name,Credit_balance - limitB. C_name,limit - Credit_balanceC. C_name,limit,Credit_balanceD. C_name,Credit_balance(62)A. limit>3000B. Credit_balance>3000C. limit - Credit_balance>3000D. Credit_balance - limit>3000
查询累计消费额大于 3000 的用户姓名以及剩余消费额的 SQL 语句应为:Select (61)From credit-inWhere (62) ;(60)A. C_noB. C_nameC. Credit_balanceD. limit(61)A. C_name,Credit_balance - limitB. C_name,limit - Credit_balanceC. C_name,limit,Credit_balanceD. C_name,Credit_balance(62)A. limit>3000B. Credit_balance>3000C. limit - Credit_balance>3000D. Credit_balance - limit>3000
Select (61)From credit-inWhere (62) ;(60)A. C_noB. C_nameC. Credit_balanceD. limit(61)A. C_name,Credit_balance - limitB. C_name,limit - Credit_balanceC. C_name,limit,Credit_balanceD. C_name,Credit_balance(62)A. limit>3000B. Credit_balance>3000C. limit - Credit_balance>3000D. Credit_balance - limit>3000
From credit-inWhere (62) ;(60)A. C_noB. C_nameC. Credit_balanceD. limit(61)A. C_name,Credit_balance - limitB. C_name,limit - Credit_balanceC. C_name,limit,Credit_balanceD. C_name,Credit_balance(62)A. limit>3000B. Credit_balance>3000C. limit - Credit_balance>3000D. Credit_balance - limit>3000
Where (62) ;(60)A. C_noB. C_nameC. Credit_balanceD. limit(61)A. C_name,Credit_balance - limitB. C_name,limit - Credit_balanceC. C_name,limit,Credit_balanceD. C_name,Credit_balance(62)A. limit>3000B. Credit_balance>3000C. limit - Credit_balance>3000D. Credit_balance - limit>3000
(60)A. C_noB. C_nameC. Credit_balanceD. limit(61)A. C_name,Credit_balance - limitB. C_name,limit - Credit_balanceC. C_name,limit,Credit_balanceD. C_name,Credit_balance(62)A. limit>3000B. Credit_balance>3000C. limit - Credit_balance>3000D. Credit_balance - limit>3000
A. C_noB. C_nameC. Credit_balanceD. limit(61)A. C_name,Credit_balance - limitB. C_name,limit - Credit_balanceC. C_name,limit,Credit_balanceD. C_name,Credit_balance(62)A. limit>3000B. Credit_balance>3000C. limit - Credit_balance>3000D. Credit_balance - limit>3000
B. C_nameC. Credit_balanceD. limit(61)A. C_name,Credit_balance - limitB. C_name,limit - Credit_balanceC. C_name,limit,Credit_balanceD. C_name,Credit_balance(62)A. limit>3000B. Credit_balance>3000C. limit - Credit_balance>3000D. Credit_balance - limit>3000
C. Credit_balanceD. limit(61)A. C_name,Credit_balance - limitB. C_name,limit - Credit_balanceC. C_name,limit,Credit_balanceD. C_name,Credit_balance(62)A. limit>3000B. Credit_balance>3000C. limit - Credit_balance>3000D. Credit_balance - limit>3000
D. limit(61)A. C_name,Credit_balance - limitB. C_name,limit - Credit_balanceC. C_name,limit,Credit_balanceD. C_name,Credit_balance(62)A. limit>3000B. Credit_balance>3000C. limit - Credit_balance>3000D. Credit_balance - limit>3000
(61)A. C_name,Credit_balance - limitB. C_name,limit - Credit_balanceC. C_name,limit,Credit_balanceD. C_name,Credit_balance(62)A. limit>3000B. Credit_balance>3000C. limit - Credit_balance>3000D. Credit_balance - limit>3000
A. C_name,Credit_balance - limitB. C_name,limit - Credit_balanceC. C_name,limit,Credit_balanceD. C_name,Credit_balance(62)A. limit>3000B. Credit_balance>3000C. limit - Credit_balance>3000D. Credit_balance - limit>3000
B. C_name,limit - Credit_balanceC. C_name,limit,Credit_balanceD. C_name,Credit_balance(62)A. limit>3000B. Credit_balance>3000C. limit - Credit_balance>3000D. Credit_balance - limit>3000
C. C_name,limit,Credit_balanceD. C_name,Credit_balance(62)A. limit>3000B. Credit_balance>3000C. limit - Credit_balance>3000D. Credit_balance - limit>3000
D. C_name,Credit_balance(62)A. limit>3000B. Credit_balance>3000C. limit - Credit_balance>3000D. Credit_balance - limit>3000
(62)A. limit>3000B. Credit_balance>3000C. limit - Credit_balance>3000D. Credit_balance - limit>3000
A. limit>3000B. Credit_balance>3000C. limit - Credit_balance>3000D. Credit_balance - limit>3000
B. Credit_balance>3000C. limit - Credit_balance>3000D. Credit_balance - limit>3000
C. limit - Credit_balance>3000D. Credit_balance - limit>3000
D. Credit_balance - limit>3000
点击查看答案