What element in an ER diagram describes the properties or characteristics of an entity?
Cardinality
Relationship
Entity
Attribute
What does the 'ON DELETE CASCADE' constraint do?
It has no impact on the child table when a record in the parent table is deleted.
It sets the foreign key values in the child table to NULL when a record in the parent table is deleted.
It prevents deletion of records in the parent table if there are matching records in the child table.
It automatically deletes matching records in the child table when a record in the parent table is deleted.
In a Star Schema, what is the central table called that contains the key performance indicators (KPIs)?
Dimension Table
Fact Table
Entity Table
Lookup Table
You have a table with columns for StudentID, StudentName, CourseID, and CourseName. StudentID determines StudentName, and CourseID determines CourseName. What normal form is this table in?
First Normal Form (1NF)
Second Normal Form (2NF)
None of the above
Third Normal Form (3NF)
What issue does Third Normal Form (3NF) primarily address?
Lack of a primary key
Repeating groups of data
Partial dependencies on the primary key
Transitive dependencies between non-key attributes
Which of these is crucial to consider when choosing data types for columns?
The kind of data the column will store and its expected size.
The color scheme of the user interface.
The type of storage device used by the database server.
The username of the person creating the table.
What SQL statement is used to add a new column to an existing table?
UPDATE TABLE
ALTER TABLE
ADD COLUMN
MODIFY TABLE
Which of the following is NOT a common SQL data type?
BOOLEAN
VARCHAR
INTEGER
ARRAY
How is a one-to-many relationship represented in an ER diagram?
Two lines connecting two entities
A diamond connecting two entities
A single line connecting two entities
A line with a crow's foot symbol on one end and a single line on the other
What is the key difference between a database and a schema?
A database is a broader concept encompassing one or more schemas, each defining a logical structure within the database.
A database stores the actual data, while a schema defines the rules for accessing that data.
There is no difference; the terms are interchangeable.
A database is a collection of tables, while a schema defines the structure of a single table.