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?

732

What is "transparent DBMS"?

813

What is Relationship set?

798

What are the different phases of transaction?

774

Explain about recursive stored procedures?

741

Explain about the implementation of business logic in stored procedures?

684

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

704

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

813

Explain about the return statement?

822

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

793

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

785

Where the procedures are stored in database?

795

Explain about the implementation of stored procedures?

823

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

1069

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

677

Post New DB Architecture Questions

Un-Answered Questions { DB Architecture }

What is Weak Entity set?

732

What is DDL (Data Definition Language)?

826

What do you mean by atomicity and aggregation?

823

What do you mean by Correlated subquery?

806

How can we call stored procedures inside store procedures?

768

Are the resulting relations of PRODUCT and JOIN operation the same?

780

How do you communicate with an RDBMS?

857

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

833

What does n tier mean?

683

What is a Database system?

804

What are the the Advantages of DBMS?

796

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

793

Explain about the implementation of business logic in stored procedures?

684

Illustrate physical database architecture in brief? : sql server architect

718

What is BCNF (Boyce-Codd Normal Form)?

812

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