DB Architecture Interview Questions
Questions Answers Views Company eMail

What is Weak Entity set?

461

What is "transparent DBMS"?

523

What is Relationship set?

474

What are the different phases of transaction?

493

Explain about recursive stored procedures?

463

Explain about the implementation of business logic in stored procedures?

425

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

442

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

500

Explain about the return statement?

494

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

519

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

486

Where the procedures are stored in database?

489

Explain about the implementation of stored procedures?

523

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

818

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

421


Post New DB Architecture Questions

Un-Answered Questions { DB Architecture }

What is 5NF?

500


What is 1 NF (Normal Form)?

501


How can we call stored procedures inside store procedures?

497


What are the 3 levels of data abstraction?

489


What is the difference between 3 tier and 3 layer architecture?

452






What is extension and intension?

544


What do you mean by Correlated subquery?

505


What is system catalog or catalog relation? How is better known as?

504


What are pages and extents? : sql server architect

483


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

518


What is model database? : sql server architect

469


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

444


What are the the Advantages of DBMS?

499


What is an Entity type?

512


Explain the benefits of running stored procedure on a database engine?

582