高频精选：银行sql笔试题及答案.docVIP

高频精选：银行sql笔试题及答案

单项选择题（每题2分，共10题）

1.要查询名为“customers”表中所有记录，以下哪个语句正确？

A.SELECTFROMcustomers;

B.SELECTallFROMcustomers;

C.SELECTeverythingFROMcustomers;

D.SELECTeveryFROMcustomers;

2.若要对“orders”表中“quantity”字段求和，用哪个函数？

A.SUM(quantity)

B.ADD(quantity)

C.TOTAL(quantity)

D.COUNT(quantity)

3.从“employees”表中查询“department”为“HR”的员工姓名，语句是？

A.SELECTnameFROMemployeesWHEREdepartment=HR;

B.SELECTemployee_nameFROMemployeesWHEREdepartment=HR;

C.SELECTfirst_nameFROMemployeesWHEREdepartment=HR;

D.SELECTlast_nameFROMemployeesWHEREdepartment=HR;

4.哪个语句用于更新“products”表中“price”字段值？

A.UPDATEpriceINproducts;

B.UPDATEproductsSETprice=new_price;

C.CHANGEproductspricenew_price;

D.MODIFYproductspricenew_price;

5.要删除“customers”表中“customer_id”为100的记录，用？

A.DELETEFROMcustomersWHEREcustomer_id=100;

B.REMOVEFROMcustomersWHEREcustomer_id=100;

C.ERASEFROMcustomersWHEREcustomer_id=100;

D.CANCELFROMcustomersWHEREcustomer_id=100;

6.从“transactions”表中查询交易金额大于1000的记录，条件表达式是？

A.WHEREamount1000

B.WHEREamount=1000

C.WHEREamount1000

D.WHEREamount=1000

7.对“accounts”表按“balance”字段升序排序，语句是？

A.ORDERBYbalanceASC;

B.ORDERBYbalanceDESC;

C.SORTBYbalanceASC;

D.SORTBYbalanceDESC;

8.要查询“customers”表中姓“Smith”的客户，语句是？

A.SELECTFROMcustomersWHERElast_name=Smith;

B.SELECTFROMcustomersWHEREfirst_name=Smith;

C.SELECTFROMcustomersWHEREname=Smith;

D.SELECTFROMcustomersWHEREfull_name=Smith;

9.哪个语句用于在“departments”表中插入新记录？

A.INSERTINTOdepartmentsVALUES(value1,value2,...);

B.ADDINTOdepartmentsVALUES(value1,value2,...);

C.CREATEINTOdepartmentsVALUES(value1,value2,...);

D.MAKEINTOdepartmentsVALUES(value1,value2,...);

10.从“loans”表中查询贷款期限在12到24个月之间（含12和24）的记录，条件是？

A.WHEREterm=12ANDterm=24

B.WHEREterm12ANDterm24

C.WHEREterm=12ORterm=24

D.WHEREtermIN(12,24)

答案：1.A2.A3.B4.B5.A6.A7.A8.A