Font size
WorksheetsQuiz finals (IT IM01)
Total questions: 25
Worksheet time: 17mins
Multiple Choice. Select the best answer based on the given statement.
It is more specific subgrouping that shares attribute with the supertype.
Supertype
General Entity
Subtype
Parent entity
Multiple Choice. Select the best answer based on the given statement.
It is a general entity type that may be related to a single or more subtype.
Supertype
Entity
Subtype
Child Entity
Multiple Choice. Select the best answer based on the given statement.
It is the process of determining entities with common attributes to form a more general entity type and is also known as a supertype entity.
Specialization
Aggregation
Generalization
Association
Multiple Choice. Select the best answer based on the given statement.
It is the process of determining one or more subtype from the supertype to create a supertype or a subtype relationship.
Specialization
Aggregation
Generalization
Association
Multiple Choice. Select the best answer based on the given statement.
It is also known as a special or restricted aggregation where in the existence of one entity is dependent on the existence of another.
Specialization
Composition
Generalization
Association
Multiple Choice. Select the best answer based on the given statement.
It specifies that an entity instance can simultaneously be a member of two (or more) subtypes.
Disjoint Rule
Total Specialization Rule
Partial Specialization Rule
Overlap Rule
Multiple Choice. Select the best answer based on the given statement.
Specifies that an entity instance of the supertype is allowed not to belong to any subtype.
Disjoint Rule
Total Specialization Rule
Partial Specialization Rule
Overlap Rule
Multiple Choice. Select the best answer based on the given statement.
It denotes an “either or” scenario wherein the supertype can belong to one of the subtypes but cannot belong to others. A letter “d” inside a circle denotes disjointness.
Disjoint Rule
Total Specialization Rule
Partial Specialization Rule
Overlap Rule
Multiple Choice. Select the best answer based on the given statement.
Listed below are the logical operators except
and
not
or
is null
Multiple Choice. Select the best answer based on the given statement.
it is an outcome of an ER model being extended and incorporated with the new modeling constructs.
Entity Relationship Model
Normalization
Partial Specialization Rule
Enhanced ER Model
Multiple Choice. Select the best answer based on the given statement.
It is the process of identifying and structuring the attributes in order to minimize or avoid data redundancies and anomalies.
Entity Relationship Model
Normalization
Partial Specialization Rule
Enhanced ER Model
Multiple Choice. Select the best answer based on the given statement.
Listed below are the anomalies in normalization, except
Insertion Anomaly
Deletion Anomaly
Update Anomaly
Creation Anomaly
Multiple Choice. Select the best answer based on the given statement.
This type of normal form has a characteristic of no multi-valued attribute.
2NF
1NF
3NF
4NF
Multiple Choice. Select the best answer based on the given statement.
This type of normal form has a characteristic of no partial dependencies.
2NF
1NF
3NF
4NF
Multiple Choice. Select the best answer based on the given statement.
This type of normal form has a characteristic of no transitive dependencies.
2NF
1NF
3NF
4NF
Multiple Choice. Select the best answer based on the given statement.
This type of normal form has a characteristic of no repeating groups.
2NF
1NF
3NF
4NF
Fill in the blank. Complete the correct SQL syntax.
Creating a database.
CREATE (a) DATABASE_NAME;
Fill in the blank. Complete the correct SQL syntax.
Switch/activate the database.
(a) DATABASE_NAME;
Fill in the blank. Complete the correct SQL syntax.
Creating the database table.
CREATE (a) TABLE_NAME (
COLUMN_NAME DATA TYPE(SIZE) PRIMARY KEY);
Fill in the blank. Complete the correct SQL syntax.
Displaying specific column.
SELECT COLUMN_NAME (a) TABLE_NAME;
Fill in the blank. Complete the correct SQL syntax.
Adding record to a table.
INSERT (a) TABLE_NAME VALUES
('VALUE TO BE INSERTED';
Fill in the blank. Complete the correct SQL syntax.
Adding column to a table.
(a) TABLE TABLE_NAME ADD COLUMN
NEW_COLUMN_NAME DATATYPE (SIZE);
Fill in the blank. Complete the correct SQL syntax.
Updating record to a table.
UPDATE TABLE_NAME (a) COLUMN_NAME = NEW_VALUE
WHERE COLUMN_NAME = VALUE;
Fill in the blank. Complete the correct SQL syntax.
Displaying all records from a table.
SELECT (a) FROM TABLE_NAME;
Fill in the blank. Complete the correct SQL syntax.
Delete column from a table.
(a) TABLE TABLE_NAME DROP COLUMN COUMN_NAME;
