NEW
Font size
WorksheetsRDBMS Fundamentals & Schema Design
Total questions: 70
Worksheet time: 35mins
What does RDBMS stand for?
Relational Database Management System
Random Database Management System
Relational Data Modeling Software
Remote Database Management System
In an RDBMS, data is primarily stored in the form of:
Files
Tables
Objects
Trees
A table in an RDBMS consists of:
Rows only
Columns only
Rows and columns
Keys only
What is a tuple in an RDBMS?
column
A row
A table
A database
What is an attribute in a database table?
A row
A column
A record
A constraint
Which key uniquely identifies each record in a table?
Foreign key
Candidate key
Primary key
Composite key
A primary key can contain:
Duplicate values
NULL values
Both duplicate and NULL values
Neither duplicate nor NULL values
Which key is used to establish a relationship between two tables?
Primary key
Candidate key
Foreign key
Alternate key
What is a candidate key?
A key chosen as primary key
Any key that can uniquely identify a record
A key used for indexing
A composite key
A table can have how many primary keys?
None
One
Two
Multiple
Which of the following ensures referential integrity?
Primary key
Foreign key
Index
View
What is schema in a database?
Actual data stored
Logical structure of database objects
Backup of database
User interface
In Oracle, a schema is owned by:
Table
Database
User
Index
Which constraint ensures that column values are not NULL?
UNIQUE
CHECK
NOT NULL
DEFAULT
Which constraint ensures uniqueness of column values?
A. PRIMARY KEY
B.
C.
D.
PRIMARY KEY
UNIQUE
CHECK
FOREIGN KEY
A composite key is a:
Key with NULL values
Key formed using multiple columns
Foreign key
Candidate key
What is normalization?
Process of data duplication
Process of organizing data to reduce redundancy
Process of indexing
Process of encryption
Which normal form removes partial dependency?
First Normal Form
Second Normal Form
Third Normal Form
Boyce-Codd Normal Form
Which normal form removes transitive dependency?
1NF
2NF
3NF
4NF
First Normal Form (1NF) requires:
No NULL values
Atomic values in columns
No duplicate rows
Primary key
Denormalization is used mainly to:
Increase redundancy
Improve query performance
Reduce storage
Improve security
What is an entity in ER modeling?
Attribute
Relationship
Real-world object
Constraint
An ER diagram is used for:
Physical database storage
Logical database design
Query execution
Backup planning
What does cardinality represent in ER modeling?
Number of attributes
Relationship strength
Number of entity instances in a relationship
Key type
One-to-many relationship means:
One record relates to one record
Many records relate to many records
One record relates to many records
Many records relate to one record only
Which of the following is a weak entity?
Entity with primary key
Entity dependent on another entity
Entity with many attributes
Independent entity
What is data integrity?
Data encryption
Accuracy and consistency of data
Data compression
Data indexing
Which integrity rule states that primary key cannot be NULL?
Referential integrity
Domain integrity
Entity integrity
Transaction integrity
Which database object stores the structure but not the data?
Table
View
Index
Sequence
In banking systems, proper schema design is critical mainly for:
Faster UI design
Data consistency, security, and scalability
Graphics handling
File management
Which of the following best defines a relation in RDBMS?
A database
A table
A column
A row
In a relational table, each row is also known as:
Attribute
Tuple
Domain
Schema
Which key is selected from candidate keys to uniquely identify records?
Composite key
Foreign key
Primary key
Alternate key
How many candidate keys can a table have?
Only one
Two only
Multiple
None
An alternate key is:
A key used for indexing
A candidate key not chosen as primary key
A foreign key
A composite key
Domain of an attribute refers to:
Column name
Data type and allowed values
Table size
Index type
Which constraint restricts values based on a condition?
NOT NULL
UNIQUE
CHECK
FOREIGN KEY
Referential integrity means:
No duplicate records
No NULL values
Foreign key must match primary key
Data must be encrypted
Which normal form eliminates repeating groups?
1NF
2NF
3NF
BCNF
A table is in 2NF if it is in 1NF and:
Has no transitive dependency
Has no partial dependency
Has no multivalued dependency
Has no candidate keys
Which normal form is stronger than 3NF?
4NF
5NF
BCNF
DKNF
In ER modeling, a relationship is represented by:
Rectangle
Ellipse
Diamond
Line
Which attribute uniquely identifies an entity?
Simple attribute
Composite attribute
Key attribute
Derived attribute
A weak entity is identified using:
Its own primary key
Composite key only
Partial key and owner entity
Foreign key only
Which relationship requires a junction table during schema design?
One-to-one
One-to-many
Many-to-many
Unary
What is the main purpose of normalization in banking databases?
Reduce disk usage
Improve UI performance
Eliminate redundancy and anomalies
Increase data duplication
Which anomaly occurs due to poor schema design?
Update anomaly
Insert anomaly
Delete anomaly
All of the above
Which design step converts ER model into tables?
Conceptual design
Logical design
Physical design
Database tuning
In Oracle, which object generates unique numeric values?
Trigger
Index
Sequence
View
Which database object improves query performance but does not store data?
Table
Index
View
Schema
A relation in RDBMS must satisfy which property?
All rows must be sorted
Each cell must contain atomic values
Duplicate columns are allowed
NULL values are mandatory
If a table has no candidate key, then the table is:
Not in 1NF
Not a relation
Not in BCNF
Invalid in RDBMS
Which of the following keys can accept NULL values?
Primary key
Candidate key
Foreign key
Super key
In a well-designed banking database, account number should be:
A.
B.
C.
D.
Foreign key
Candidate key
Composite key
Primary key
Consider a table with attributes (A, B, C, D). If A → B and B → C, then which dependency exists?
Partial dependency
Multivalued dependency
Transitive dependency
Functional dependency
A table is in Third Normal Form (3NF) if:
It has no partial dependency
It has no transitive dependency
It has atomic values
It has a primary key
Which normal form is violated if a non-key attribute depends on another non-key attribute?
1NF
2NF
3NF
BCNF
In ER diagrams, double rectangles represent:
Multivalued attributes
Weak entities
Derived attributes
Composite attributes
Which relationship type is most commonly used to model customer–account mapping in banks?
One-to-one
One-to-many
Many-to-many
Recursive
Which integrity constraint ensures that referenced data always exists?
Entity integrity
Domain integrity
Referential integrity
Transaction integrity
A foreign key always references:
Candidate key
Alternate key
Primary key
Super key
Which of the following anomalies is avoided by normalization?
Insertion anomaly
Deletion anomaly
Update anomaly
All of the above
In schema design, denormalization is sometimes preferred to:
Reduce redundancy
Improve performance
Improve security
Reduce keys
Which attribute can be derived from another attribute?
Composite attribute
Simple attribute
Derived attribute
Key attribute
In ER modeling, cardinality defines:
Number of attributes
Degree of relationship
Number of entity instances involved
Strength of entity
Which of the following is NOT a benefit of good schema design in banking systems?
Data consistency
Reduced redundancy
Faster transaction processing
Increased data duplication
A table with composite primary key must be checked for:
Transitive dependency
Partial dependency
Multivalued dependency
Domain violation
Which database object logically represents stored query results?
Table
Index
View
Sequence
In Oracle, schema objects are logically grouped under:
Tablespace
Instance
User
Database link
Which rule states that no part of a primary key can be NULL?
Domain integrity
Referential integrity
Entity integrity
Functional dependency
