DB Architecture interview questions – page 14

Which is better among connected lookup and unconnected lookup transformations in informatica or any other ETL tool?

What is merge ?and how to use merge?

What is a spanning Tree?

Describe a primary key in Database?

What do you mean by a Database Lock ?

What do you mean by a Composite Key in Database?

What are the type of Database locks?

Explain a database transaction?

What do you mean by a Table in a database ?

What are the different type of normalization?

What are the advantages and disadvantages of views in a database?

What do you mean by a materialized view?

Define a Foreign Key ?

Explain a Unique Key?

Define a Composite Primary Key ?