2025年学历类自考互联网数据库-英语（二）参考题库含答案解析.docxVIP

2025年学历类自考互联网数据库-英语（二）参考题库含答案解析

一、单项选择题

下列各题只有一个正确答案，请选出最恰当的选项（共30题）

1、WhichSQLcommandisusedtomodifythestructureofatable?

A.SELECT

B.INSERT

C.ALTER

D.DELETE

2、Whatistheprimarypurposeofadatabaseindex?

A.Toencryptsensitivedata

B.Toimprovequeryperformance

C.Toreducestoragespace

D.Tomanageuserpermissions

3、Whichdatamodelrepresentsdataasanetworkofparent-childrelationships?

A.Hierarchical

B.Relational

C.Network

D.Object-oriented

4、Whichtermdescribesasetofoperationsthatmustbeperformedatomically?

A.Transaction

B.Query

C.Index

D.Backup

5、WhatisthedefaultstorageengineforMySQLdatabases?

A.InnoDB

B.MyISAM

C.Oracle

D.PostgreSQL

6、WhichclauseisusedtofilterrecordsinaSQLquery?

A.JOIN

B.WHERE

C.GROUPBY

D.ORDERBY

7、Whatisthedifferencebetweenaprimarykeyandaforeignkey?

A.Primarykeysarefortables,foreignkeysforcolumns

B.Primarykeysuniquelyidentifyrecords,foreignkeyslinktables

C.Primarykeysallowduplicates,foreignkeyscannot

D.Primarykeysarecase-sensitive

8、Whichmethodensuresthatdatabasechangesarereversible?

A.Backup

B.Rollback

C.Commit

D.Indexoptimization

9、WhatisthepurposeoftheACIDpropertyindatabasetransactions?

A.Atomicity,Consistency,Isolation,Durability

B.Accuracy,Confidentiality,Integrity,Efficiency

C.Availability,Consistency,Isolation,Security

D.Alloftheabove

10、Whichcommandisusedtoretrieveallcolumnsfromatable?

A.SELECT*FROMtable

B.SELECTtableFROMdatabase

C.SELECTFROMtableWHERE1=1

D.SELECT*FROMtableWHERENULL

11、Whichofthefollowingisnotatypeofdatabaseconstraint?

A.Primarykey

B.Defaultvalue

C.Checkconstraint

D.Normalizationconstraint

A.主键约束

B.默认值约束

C.检查约束

D.正则化约束

12、Whichisolationlevelensuresthatatransactioncanreaduncommitteddata?

A.REPEATABLEREAD

B.READCOMMITT