INFO90002 · Quiz 1

Week 1–4 交互式模拟题库

153 choice · 45 short

Week 1 · Database foundations

DBMS · client-server · relations · lifecycle

提交后显示正确答案、考察知识点、解析和拓展。Multiple choice 必须选中完整正确集合才得分，不设部分分。

Single choiceData and information

1 / 29

Which statement best distinguishes data from information?

AData is always numeric, whereas information is always textual.BData consists of raw facts; information is data interpreted in context.CData is stored in tables, whereas information cannot be stored.DData and information are identical terms in database modelling.

Single choiceData categories

2 / 29

Which example is most clearly semi-structured data?

AA relation with fixed columns and declared domainsBA scanned handwritten letter with no machine-readable structureCAn XML document whose elements may vary between recordsDA MySQL table constrained by a primary key

Single choiceData categories

3 / 29

A spreadsheet has different columns on different sheets and no enforced schema. Which classification is safest?

AIt is automatically structured because it has cells.BIt may be semi-structured because its organisation is not governed by one stable schema.CIt is always unstructured because it is not stored by a DBMS.DIt is relational because rows are visible.

Single choiceDatabase systems

4 / 29

Which statement about a database and a DBMS is correct?

AA database is the organised data; a DBMS is the software that manages it.BA DBMS is the stored data; a database is the software interface.CA database and a DBMS are always the same physical file.DA DBMS is only a diagram used during conceptual design.

Single choiceData independence

5 / 29

A new attribute is added to the logical schema without requiring every application to be rewritten. Which property is demonstrated?

AConcurrent accessBPhysical data independenceCLogical data independenceDReferential integrity

Single choiceData independence

6 / 29

The database files move from a local disk to cloud storage while the logical schema stays unchanged. What does this illustrate?

ALogical data independenceBPhysical data independenceCEntity integrityDData normalisation

Single choiceClient-server

7 / 29

What is the role of MySQL Workbench in the course environment?

AIt is the database being managed.BIt replaces the MySQL Server process.CIt is a physical storage device for table files.DIt is a client and administration tool that sends requests to MySQL Server.

Single choiceRelational model

8 / 29

Which property belongs to a relation?

AThe physical order of rows carries business meaning.BTwo attributes in the same relation may have the same name.CEach cell contains one value for one attribute.DEvery relation must contain exactly one foreign key.

Single choiceRelational terminology

9 / 29

A relation currently has 12 tuples and 5 attributes. What are its cardinality and degree?

ACardinality 5; degree 12BCardinality 12; degree 5CCardinality 17; degree 1DBoth are 12 because tuples determine the schema.

Single choiceDatabase languages

10 / 29

Which command is an example of DDL?

AINSERT INTO Customer ...BGRANT SELECT ON Customer ...CALTER TABLE Customer ADD Email VARCHAR(80)DUPDATE Customer SET ...

Single choiceDatabase languages

11 / 29

Which operation is DML?

ADELETE FROM Booking WHERE BookingID = 8BDROP TABLE BookingCREVOKE UPDATE ON Booking FROM user1DCREATE INDEX BookingDateIndex ON Booking(Date)

Single choiceDatabase languages

12 / 29

Which statement belongs to DCL?

ASELECT * FROM StaffBCREATE TABLE Staff (...)CALTER TABLE Staff ADD Phone VARCHAR(20)DGRANT SELECT ON Staff TO analyst

Single choiceCRUD and SQL

13 / 29

In CRUD terminology, the Create operation for an existing table usually maps to which SQL action?

ACREATE TABLEBINSERTCALTERDGRANT

Single choiceDatabase lifecycle

14 / 29

During which lifecycle stage are DBMS-specific data types and indexes primarily selected?

ARequirements definition and analysisBConceptual designCLogical designDPhysical design

Multiple choiceDBMS benefits

15 / 29

Which are typical benefits provided by a DBMS? Select all that apply.

AControlled concurrent accessBIntegrity and security mechanismsCA guarantee that every business requirement has been discoveredDBackup and recovery support

Multiple choiceRelational model

16 / 29

Which statements describe relations? Select all that apply.

AAttribute names are unique within a relation.BTuple order is part of the relation's meaning.CEach tuple must be distinguishable from every other tuple.DEach cell contains a single value for its attribute.

Multiple choiceDatabase lifecycle

17 / 29

Which activities belong before implementation in the database development lifecycle? Select all that apply.

ARequirements analysisBConceptual designCLogical and physical designDLoading live rows before constraints are defined

Multiple choiceData independence

18 / 29

Which changes are primarily physical rather than logical? Select all that apply.

AMoving files to a different storage deviceBAdding a new entity type to the schemaCChanging file organisation or compressionDReplacing CustomerName with FirstName and Surname in the logical schema

Single choiceDBMS benefits

19 / 29

Compared with separate flat files, which DBMS feature most directly reduces inconsistent copies of the same fact?

ALarger monitor resolutionBLonger attribute namesCCentralised control of shared data and constraintsDManual duplication across applications

Single choiceClient-server

20 / 29

In a client-server database system, which component normally executes requests and manages the shared database?

AThe presentation documentBThe DBMS running on the database serverCEvery client spreadsheet independentlyDThe network cable itself

Single choiceRelational constraints

21 / 29

Which rule is an example of a database integrity constraint?

ADisplay the enrolment page with a blue heading.BPrint a weekly management report.CSort students alphabetically for one query.DStudentType must be either PG or UG.

Single choiceTable structure

22 / 29

Which operation changes the structure of an existing table without deleting it?

AALTERBSELECTCINSERTDGRANT

Single choiceTable structure

23 / 29

Which operation removes an entire table definition and its stored rows?

ADELETE one rowBRENAMECDROPDUPDATE

Single choiceDatabase lifecycle

24 / 29

Which lifecycle activity defines the scope, users, major user views and system boundaries?

AOperational maintenanceBSystems definitionCData loadingDQuery execution

Single choiceDatabase lifecycle

25 / 29

Which activity transfers data from an old system into the new database?

AConceptual modellingBSystems definitionCApplication designDData conversion and loading

Single choiceDatabase lifecycle

26 / 29

Monitoring performance and responding to changed requirements after commissioning belongs to:

Aoperational maintenanceBrequirements analysisCconceptual designDinitial data modelling only

Multiple choiceDatabase lifecycle

27 / 29

Which concerns may be examined during database testing? Select all that apply.

ACorrectness and errorsBPerformanceCRecoverabilityDSecurity

Multiple choiceRDBMS

28 / 29

Which statements about an RDBMS are correct? Select all that apply.

AIt manages data represented as relations.BIt requires row order to carry business meaning.CIt supports operations that create, read, update and delete table data.DIt can enforce constraints derived from business rules.

Multiple choiceDesign levels

29 / 29

Which statements correctly distinguish database design levels? Select all that apply.

AConceptual design captures high-level entities and connections and may retain M:M relationships.BLogical design defines relations, columns and keys but remains independent of a specific vendor.CPhysical design avoids data types and indexes.DPhysical design implements the logical model for a particular DBMS.

已作答 0 / 29；未答题也可交卷