DB Architecture Interview Questions
Questions Answers Views Company eMail

How can we call stored procedures inside store procedures?

636

State about the security aspects of stored procedures?

746

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

749

How one call ddl statement using stored procedures in oracle?

613

State the different extensions for stored procedures?

614

How many types of stored procedure?

646

What is the difference between "is" and "as" while creating procedure?

601

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

646

Illustrate physical database architecture in brief? : sql server architect

579

Explain what are the database objects? : sql server architect

630

Explain the truncate command? : sql server architect

611

Do you know what the restrictions applicable while creating views are? : sql server architect

601

What is model database? : sql server architect

657

What are page splits? : sql server architect

689

What is raid and what are different types of raid configurations? : sql server architect

608


Post New DB Architecture Questions

Un-Answered Questions { DB Architecture }

What is Multivalued dependency?

609


Which is super key?

632


What is app tier?

661


What are the different phases of transaction?

637


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

659


Illustrate physical database architecture in brief? : sql server architect

579


What are the 3 levels of data abstraction?

661


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

638


What is extension and intension?

715


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

609


What is degree of Relationship type?

671


What is a two tier wage system?

645


What is msdb database? : sql server architect

770


What is a Phantom Deadlock?

688


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

581