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?

788

What is "transparent DBMS"?

864

What is Relationship set?

858

What are the different phases of transaction?

827

Explain about recursive stored procedures?

806

Explain about the implementation of business logic in stored procedures?

729

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

748

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

870

Explain about the return statement?

882

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

849

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

847

Where the procedures are stored in database?

845

Explain about the implementation of stored procedures?

878

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

1119

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

725

Post New DB Architecture Questions

Un-Answered Questions { DB Architecture }

What is an Entity set?

920

What are the 3 levels of data abstraction?

846

What is tier in database?

806

What is single tier architecture?

803

What is the difference between "is" and "as" while creating procedure?

814

What do you mean by atomicity and aggregation?

899

What is Domain-Key Normal Form?

829

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

909

What is Multivalued dependency?

790

What is 1 NF (Normal Form)?

850

What is n tier architecture with example?

764

Define the "integrity rules"?

832

What is Set-at-a-time or Set-oriented?

901

What is an Entity?

856

What is one tier architecture?

770

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