Travelo1 Architect Interview Questions and Answers

Normalization in database is the process of organizing data in a database to reduce redundancy and improve data integrity.

• Normalization involves breaking down a database into smaller, more manageable tables.

• It helps in reducing data redundancy by storing data in a structured manner.

• Normalization ensures data integrity by minimizing data anomalies.

• There are different normal forms such as 1NF, 2NF, 3NF, BCNF, and 4NF.

• For...read more

A trigger is a special kind of stored procedure that is automatically executed when certain events occur in a database.

• Triggers are used to maintain referential integrity, enforce business rules, and automate actions in response to data changes.

• They can be defined to execute before or after an INSERT, UPDATE, or DELETE operation on a table.

• For example, a trigger can be set up to automatically update a timestamp column

A view is a sight or prospect, typically of attractive natural scenery.

• A view refers to what can be seen from a particular location or vantage point

• Views can include landscapes, cityscapes, seascapes, or any other visually appealing scenes

• Architects often design buildings to take advantage of specific views, such as positioning windows to frame a picturesque landscape

• Views can greatly enhance the overall experience and

Technologies and assessment are key components in architecture.

• Technologies refer to the tools and software used in the design and construction process.

• Assessment involves evaluating the feasibility, sustainability, and safety of a project.

• Examples of technologies include Building Information Modeling (BIM) and Virtual Reality (VR) software.

• Assessment may involve analyzing environmental impact, structural integrity, an...read more