Database Design & Development 2
Authored by Nicole Donnelly
Computers
University
Used 4+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
20 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In a relational database, which normal form ensures that there are no transitive dependencies?
1NF
2NF
3NF
BCNF
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
What is the primary purpose of an index in a database?
To enforce referential integrity
To optimise query performance
To store large binary objects
To maintain database schemas
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which of the following is a disadvantage of de-normalisation?
Improved query performance
Increased redundancy
Reduced data integrity
Simplified querying
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which SQL command is used to remove a table from a database?
DELETE
DROP
TRUNCATE
REMOVE
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In database design, what does the term 'cardinality' refer to?
The uniqueness of data values
The number of rows in a table
The number of relationships between tables
The number of attributes in a table
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Which type of join returns all rows when there is a match in either table?
INNER JOIN
LEFT JOIN
RIGHT JOIN
FULL OUTER JOIN
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
In an ER diagram, what does a diamond shape represent?
Entity
Attribute
Relationship
Primary Key
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Microsoft
or continue with
%20(1).png)
Apple
Others
By signing up, you agree to our Terms of Service & Privacy Policy
Already have an account?
