Brie's Bonus Bonanza Quiz
Brie's Bonus Bonanza Quiz
Test your knowledge of relational databases and data models with Brie's Bonus Bonanza Quiz! This engaging and informative quiz is designed for anyone interested in understanding the fundamentals of databases, including key concepts such as relationships, anomalies, and attributes.
Join in to enhance your learning experience and see how much you know about:
- Relational databases
- Data relationships
- Database anomalies
- Entity-Relationship Models
The relational model expresses the data and relationship among the data in the form of tables.
True
False
How many attributes are shown in the table?
7
21
3
5
A relation can have 2+ attributes of the same name.
True
False
Tuples in a relation do not have to follow a significant order as the relation is not order-sensitive.
True
False
What are the advantages of relational databases?
A. It is the simplest and easy to use, data model.
B. It hides the physical storage details from the database developers and database users.
C. It is scalable as you can keep adding records and attributes to records in a database.
D. All of the above
The relational model is also termed as a/n ______ model.
Grouped
Record-Based
Table-Based
Entity
What is this?
An SQL Query
A list
A comma delimited file
A spreadsheet
Microsoft Excel is an example of a flat form database.
True
False
What is this?
A comma delimited file
A spreadsheet
A silent cry for help
Disadvantages of Flat File databases are:
A. Difficult to query and find information
B. Data redundancy – information is repeated and can be inconsistent
C. Difficult to compare data across files
D. All of the above
Which of the follow is NOT correct about Hierarchical Databases
A. Hierarchical databases are organized in a tree-like structure.
B. Provides no data redundancy
C. One parent table can have many child tables but no child table can have more than one parent.
C. They are easy to navigate and fast to process
When a primary key is repeated in another table, it is then known as a foreign key
True
False
When creating a database project, understanding the scope of the project is one of the top priorities.
True
False
What can we tell about Attribute1?
It's access
It's datatype
It's relationship to other entities
That it is is required
A table with a primary key is often referred to as the ____ table
Child
Parent
Entity
Attribute
The arrow is pointing to the _____
Child table
Parent table
What kind of relationship is depicted here?
The building can have 0 or many rooms
The room can have 0 or many buildings
A room must have a building
Conventionally, entities and tables are named with single nouns.
True
False
This is a ______ relationship
Zero or one
Exactly One
One to zero or many
At least one or many
This is a _____ relationship
Zero or one
Exactly one
One to zero or many
At least one or many
This is a _____ relationship
One to zero or many
At least one or many
Zero or one
Exactly one
This is a ______ relationship
One to zero or many
At least one or many
Zero or one
Exactly one
This is a completely valid relationship.
True
False
This is an example of a _____ relationship
Many-to-Many
One-to-Many
Many-to-One
One-to-One
Many-to-many relationships must be resolved into two one-to-many relationships.
True
False
Insertion Anomalies occur _____
A. When you can’t enter a record because some data is missing.
B. When the same data is stored in more than one place.
C. When deleting a record accidentally causes other data to be lost.
D. When you can't crank that Soulja boy
Deletion Anomalies occur when ______
A. When you can’t enter a record because some data is missing.
B. When the same data is stored in more than one place.
C. When deleting a record accidentally causes other data to be lost.
D. Idk lol
Update anomalies occur ________
A. When you can’t enter a record because some data is missing.
B. When the same data is stored in more than one place.
C. When deleting a record accidentally causes other data to be lost.
D. You didn't get the new update patch to the matrix
LocalStorage only stores data while the browser is open
True
False
Where is localStorage stored?
In an SQLite file in a subfolder of the user's profile
In a local .txt file in a subfolder of the user's profile
In an external .txt file on the server
An internal .js file
The method key()
Adds a key to localStorage
Passes a number to retrieve the key of a localStorage
Removes the key from localStorage
Passes a string to retrieve the key value from localStorage
LocalStorage can only store strings.
True
False
To convert an array or object to a string to be stored in localStorage, you would use:
JSON.parse()
JSON.string()
JSON.stringify()
JSON.text()
How many parameters can getItem() take?
1
2
3
As many as you need
To convert a string to an object, you would use:
JSON.parse()
JSON.string()
JSON.stringify()
JSON.object()
LocalStorage is a server based database
True
False
How do we pre-populate a form input field with some text?
You can't
By typing it in
Don't know, don't care
By giving the input tag a value attribute with whatever text you want pre-populated.
Which statement is NOT correct about HTML Forms?
An HTML Form is created using the < Input > element.
A form is a container for various data entry elements like edit boxes, checkboxes, radio buttons, drop-down lists, multiline edit boxes, labels, buttons, and more.
The data entered in form elements is sent to the server for processing when the user clicks the submit button.
HTML Forms in web pages allow the user to enter data.
Which statement is NOT correct about the 'GET' method in HTML Forms?
It is the default used when the method attribute is omitted from the form element.
Data from the form is appended to the action URL in the form of name/value pairs upon submission and is visible in the address field of the browser.
It is useful if you want to allow the user to bookmark the result of the form submission.
It is a good choice to send sensitive data to the server.
Which attribute is used to specify that an input field must be filled out?
Validate
Form validate
Placeholder
Required
Which HTML attribute would be used to span a table cell over more than one row?
Row
Rowspan
Span
Colspan
{"name":"Brie's Bonus Bonanza Quiz", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Test your knowledge of relational databases and data models with Brie's Bonus Bonanza Quiz! This engaging and informative quiz is designed for anyone interested in understanding the fundamentals of databases, including key concepts such as relationships, anomalies, and attributes.Join in to enhance your learning experience and see how much you know about:Relational databasesData relationshipsDatabase anomaliesEntity-Relationship Models","img":"https:/images/course2.png"}
More Quizzes
Database SQL Quiz8
1586
DBMS-DIAGNOSTIC TEST -1
1050
Database Design Mastery Quiz
6327
IM101
7035149
Database SQL Quiz1
1586
Database Design Quiz
10517
DATABSE SYSTEM CONCEPTS QUIZ
361829
Sustav za upravljanje bazom podataka (34. - 70.)
371866
Database Normalization
84421
DB SEQ
84420
Database SQL Quiz2
1586
Introduction to database concept
1050