DB Architecture Interview Questions
Questions Answers Views Company eMail

What is Weak Entity set?

596

What is "transparent DBMS"?

670

What is Relationship set?

649

What are the different phases of transaction?

621

Explain about recursive stored procedures?

591

Explain about the implementation of business logic in stored procedures?

558

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

553

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

656

Explain about the return statement?

676

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

656

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

622

Where the procedures are stored in database?

636

Explain about the implementation of stored procedures?

679

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

937

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

539


Post New DB Architecture Questions

Un-Answered Questions { DB Architecture }

What is SDL (Storage Definition Language)?

636


How do you communicate with an RDBMS?

663


What is durability in DBMS?

717


Illustrate physical database architecture in brief? : sql server architect

566


Not only RDBMS takes care of locating data it also

590


What is Weak Entity set?

596


What does n tier mean?

543


What do you mean by flat file database?

649


What is n tier architecture with example?

557


What is difference between two tier and three tier?

579


Explain logical database components? : sql server architect

574


What is Multivalued dependency?

593


Explain what are the restrictions that views have to follow? : sql server architect

603


What do data architects do?

607


Define the "integrity rules"?

631