DB Architecture Interview Questions
Questions Answers Views Company eMail

What is an Entity type?

512

What is a Relation Schema and a Relation?

507

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

528

When is a functional dependency F said to be minimal?

464

What is 5NF?

500

What is Data Storage - Definition Language?

475

What is an Extension of entity type?

496

What is Relational Algebra?

521

What is DDL Interpreter?

537

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

504

What do you mean by atomicity and aggregation?

517

What is meant by query optimization?

532

How does Tuple-oriented relational calculus differ from domain-oriented relational calculus

472

What is an Entity set?

552

What do you mean by Correlated subquery?

505


Post New DB Architecture Questions

Un-Answered Questions { DB Architecture }

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

442


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

519


What is a Phantom Deadlock?

531


What is hypermedia database?

460


What is a Relation Schema and a Relation?

507






What is VDL (View Definition Language)?

646


What is the meaning of 3 tier?

458


What is an Extension of entity type?

496


Explain about the return statement?

494


What is difference between two tier and three tier?

430


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

452


What is the job of the information stored in data-dictionary?

493


What is Query evaluation engine?

511


What is Fully Functional dependency?

566


What is the difference between cube operator and roll up operator? : sql server architect

489