DB Architecture Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB Architecture Interview Questions

Questions Answers Views Company eMail

What is Weak Entity set?

770

What is "transparent DBMS"?

856

What is Relationship set?

847

What are the different phases of transaction?

816

Explain about recursive stored procedures?

792

Explain about the implementation of business logic in stored procedures?

723

Explain about the process which takes place to execute a stored routine?

742

What is the difference between a user defined function and a stored procedure?

862

Explain about the return statement?

870

Can we use commit inside the trigger? If not then how can we save the transaction made by the trigger?

835

What are external procedures ? Why and when they are used?

835

Where the procedures are stored in database?

838

Explain about the implementation of stored procedures?

872

Does storing of data in stored procedures increase the access time? Explain?

1109

Explain about the difficulties faced by the database developer in implementing pre compiled statements?

713

Post New DB Architecture Questions

Un-Answered Questions { DB Architecture }

What is a view? How it is related to data independence?

898

What is one tier architecture?

758

What is 3NF?

858

What is msdb database? : sql server architect

968

What is a checkpoint and When does it occur?

761

What is the difference between layer and tier?

876

What is System R? What are its two major subsystems?

805

Name the sub-systems of a RDBMS?

814

What is the difference between stored procedures and stored functions in oracle?

900

What is difference between two tier and three tier?

853

What is Domain-Key Normal Form?

821

Explain about the return statement?

870

What is Fully Functional dependency?

942

Explain about the process which takes place to execute a stored routine?

742

Illustrate physical database architecture in brief? : sql server architect

751

For More Un-Answered { DB Architecture } Questions Click Here