Trainee Database Administrator Interview Questions and Answers

DB is a collection of data stored in an organized manner. RDBMS is a software used to manage relational databases. Normalization is a process of organizing data to minimize redundancy. Users and roles are used to manage access to the database.

• DB - collection of data stored in an organized manner

• RDBMS - software used to manage relational databases (e.g. MySQL, Oracle)

• Normalization - process of organizing data to minimize redundancy

• Users and roles - used to manage access to the...read more

There are three types of relationships between datasets in a database: one-to-one, one-to-many, and many-to-many.

• One-to-one: each record in one dataset is related to only one record in another dataset.

• One-to-many: each record in one dataset is related to one or more records in another dataset.

• Many-to-many: multiple records in one dataset are related to multiple records in another dataset.

• Examples: one-to-one - employee and social security number; one-to-many - customer and or...read more