NEW
Font size
Worksheetsseatwork RDBMS
Total questions: 15
Worksheet time: 10mins
Which of the following is the full form of RDBMS?
Relational Data Management System
Relational Database Management System
Relative Database Management System
Regional Data Management System
What is an RDBMS?
Database that stores data elements that are not linked
Database that stores data elements that are not linked
Database that stores and allows access to data elements that are linked
None of the mentioned
What is a relation in RDBMS?
Key
Table
Row
Data Types
Which of the following constraints RDBS doesn’t check before creating the tables
Not null
Primary keys
Data Structure
Data integrity
The following are stages in RDBMS except for one
Define relations/attributes
Define primary keys
Define relationships
Define Index
Which relationship represents if the two entity types are 'Customer' and 'Account,' each 'Customer' can have many 'Accounts,' but each 'Account' can only be owned by one 'Customer.
One -to -Many
Many -to -Many
One -to -One
One -to -none
It is a link between the information in two tables, where each record in each table only appears once.
One-to- one
One-to- many
Null
Many-to- many
It exists when one or more items in one table can have a relationship to one or more items in another table.
Many-to-Many
One-to-One
One-to-Many
The image represents what relationship?
One-to-one
Many-to-one
One-to-Many
none of the choices
Which Integrity Rules represents the primary key cannot contain NULL. Otherwise, it cannot uniquely identify the row
Referential Integrity Rule
Differential Integrity Rule
Entity Integrity Rule
Business logic Integrity
In this Normalization form every cell contains a single value, not a list of values. This property is known as atomic.
First Normal Form (1NF)
Second Normal Form (2NF)
Third Normal Form (3NF)
Higher Normal Form
In this Normalization form the table is in it if it is 2NF and the non-key columns are independent of each other. In other words, the non-key columns are dependent on primary key, only on the primary key and nothing else.
Third Normal Form (3NF)
Second Normal Form (2NF)
First Normal Form (1NF):
Higher Normal Form
In this integrity Rule Each foreign key value must be matched to a primary key value in the table referenced (or parent table).
Referential Integrity Rule
Entity Integrity Rule
Business logic Integrity
Differential Integrity Rule
True or False. You could create an index on the selected column(s) to facilitate data searching and retrieval.
True
False
True or False. Relational databases is the same from other databases in their approach to organizing data and performing transactions.
True
False
