DB Architecture Interview Questions
Questions Answers Views Company eMail

What is Weak Entity set?

454

What is "transparent DBMS"?

515

What is Relationship set?

468

What are the different phases of transaction?

485

Explain about recursive stored procedures?

457

Explain about the implementation of business logic in stored procedures?

418

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

434

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

489

Explain about the return statement?

486

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

512

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

480

Where the procedures are stored in database?

485

Explain about the implementation of stored procedures?

518

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

812

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

415


Post New DB Architecture Questions

Un-Answered Questions { DB Architecture }

Which part of the RDBMS takes care of the data dictionary? How

642


What is "transparent DBMS"?

515


What is extension and intension?

533


What is end user data?

459


Describe the three levels of data abstraction?

525






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

463


Explain about the return statement?

486


What is hypermedia database?

452


What is DDL (Data Definition Language)?

525


What do you mean by flat file database?

493


What do you mean by atomicity and aggregation?

508


What is an Entity set?

544


Not only RDBMS takes care of locating data it also

451


What are the three levels of database architecture?

421


Explain about the implementation of business logic in stored procedures?

418