Worksheetsinfoman
Total questions: 23
Worksheet time: 12mins
In Module 1, which term is defined as organized collection of logically related data?
Data
Information
Database
DBMS
Which limitation of file processing is explicitly mentioned as a cause of inconsistencies across systems?
Program-data independence
Data redundancy
Better decision support
Ease of data access
According to the SDLC phases listed, which phase includes programming, testing, training, installation, and documentation?
Planning
Physical Design
Implementation
Maintenance
In the Three-Schema Architecture, which schema represents the logical structure of the entire database?
External schema
Conceptual schema
Internal schema
Physical schema
Which identifier type is described as a potential identifier that satisfies uniqueness and non-null requirements?
Primary Key
Foreign Key
Candidate Key
Composite Key
What is the cardinality constraint defined as in the relationships section?
A link between entities
Number of instances that can/must participate
A collection of entities with shared properties
Specific link between entity instances
When is an associative entity created according to the notes?
When two entities are unary
When a relationship has attributes or needs a unique identifier
When an entity has a multivalued attribute
When supertypes inherit attributes
In Module 3, what is the attribute called that determines subtype membership?
Subtype Key
Subtype Discriminator
Attribute Inheritance
Supertype Identifier
In the relational model, what is a relation defined as?
A hierarchical tree of nodes
A named, two-dimensional table of data
An unstructured collection of documents
A graph of connected entities
Which property is required for all relations according to the properties listed?
Every attribute value may be multivalued
Order of rows and columns determines meaning
Every row must be unique
Attributes can share the same name
What is the role of a foreign key as defined in the content?
Uniquely identifies each row within its own relation
Refers to a primary key in another relation
Is a key made up of two or more attributes
Could serve as a primary key within the same relation
Under referential integrity, which action sets the foreign key to null when the parent is deleted?
Restrict
Cascade
Set-to-Null
Enforce
According to normalization rules presented, which statement best describes Second Normal Form (2NF)?
1NF with no partial dependencies
1NF with no transitive dependencies
No multivalued attributes; atomic values
All attributes are functionally dependent on a surrogate key
Which anomaly occurs when deleting one row removes needed data, as described under 'Anomalies (Why Normalization Matters)'?
Insertion anomaly
Deletion anomaly
Modification anomaly
Projection anomaly
For a one-to-many binary relationship, where should the foreign key be placed according to the transformation guidelines?
On the "one" side
On both sides
On the "many" side
In a separate associative relation only
In a supertype/subtype relationship, what becomes the primary key of a subtype?
A new composite key formed from subtype attributes
A surrogate key generated during transformation
The supertype’s primary key
A foreign key from an unrelated relation
According to the SQL Overview, which statement correctly matches each term to its definition?
SQL is software used to manage databases; DBMS is the language standard for relational databases.
SQL is the language standard for relational databases; DBMS is software used to manage databases.
RDBMS is a software tool used to design hardware; SQL is used only for NoSQL databases.
DBMS manages data as tables with relationships; RDBMS is the overall software suite.
Which set lists the SQL command type categories exactly as shown under SQL Command Types?
DDL, DML, DCL, TCL
DQL, DDL, DML, DTL
DDL, DML, DCL, Transaction Control
Data Control, Table Control, Row Control, Query Control
Under Table Structure, what is the naming rule for a table as stated?
It may begin with any character, must be under 64 characters, and can use reserved words.
It must begin with a letter, maximum 30 characters, and cannot use reserved words.
It must begin with a digit, maximum 128 characters, reserved words allowed with quotes.
It must be unique across all databases and contain at least one underscore.
Which constraint specifically ensures that each row in a table can be uniquely identified?
NOT NULL
UNIQUE
PRIMARY KEY
FOREIGN KEY
Referential Integrity in the content ensures which of the following?
Every column must have a value or be NULL.
Foreign key values match primary key values or are NULL.
Duplicate values are prevented across all columns.
Only numeric foreign keys are allowed.
Which DML command combination is correctly paired with its action as listed?
INSERT removes rows; DELETE adds new rows; MERGE modifies existing rows.
INSERT adds new rows; UPDATE modifies existing rows; DELETE removes rows.
UPDATE adds new rows; MERGE removes rows; INSERT modifies existing rows.
MERGE only deletes and inserts but cannot update.
In Transaction Control, which statement matches the action to the command exactly as described?
COMMIT undoes changes; ROLLBACK saves changes; SAVEPOINT deletes a table.
COMMIT saves changes; ROLLBACK undoes changes; SAVEPOINT sets rollback marker.
COMMIT sets rollback marker; ROLLBACK saves changes; SAVEPOINT undoes changes.
COMMIT and ROLLBACK both save changes; SAVEPOINT ignores changes.
