Database Architect helps a Software Architect in designing a database structure. This job is in huge demand nowadays with each and every industry.

If you are planning to enter this industry then you should prepare yourself to answer following question:

1. What is your professional experience?
I have 5 years of experience in designing and implementing database solutions. I have experience of working on Microsoft SQL Server, Oracle and DB2. My experience has given me ample knowledge of working with large database and data warehouses. I am capable of working with application developers to validate database changes.

2. What are the unique skills which you possess?
I have excellent problem solving, interpersonal, and communicational skills. I can work well with customers and understand their need.

3. What is SGA? Where it is located? Why the system performance will be slow after loading the oracle?
The System Global Area (SGA) is a shared memory region allocated by Oracle that contains data and control information for one Oracle instance.  SGA is located in oracle instance which itself consist of two parts. When you install an oracle in your machine, system will become slow because of the unstructured SGA configuration.

4. What is a tablespace?
A database is divided into logical storage unit called tablespaces. A tablespace is used to grouped related logical structures together.

5. What are Schema Objects? Can objects of the same schema reside in different tablespaces?
Schema objects are the logical structures that directly refer to the database’s data. Schema objects include tables, views, sequences, synonyms, indexes, clusters, database triggers, procedures, functions packages and database links. Yes objects of the same can schema reside in different tablespaces.

6. What’s the difference between a primary key and a unique key?
A primary key creates a clustered index on the column whereas unique key creates a non clustered index by default. Primary key will not accept null value but unique key will accept null value. There is only one primary key in a table but there can be more than 1 unique key in a table.

7. What is your greatest strength and weakness?
I am too much of a perfectionist and headstrong. I really like to be challenged in my job. My biggest strength is my good communication skills and my weakness is I am too focused on my work and I need to find more time to relax.

I hope now you have got an idea of the various types of questions which are frequently asked in an interview.