DB Architecture Interview Questions, Answers for Freshers and Experienced asked in various Company Job Interviews

DB Architecture Interview Questions

Questions Answers Views Company eMail

What is Weak Entity set?

742

What is "transparent DBMS"?

824

What is Relationship set?

816

What are the different phases of transaction?

790

Explain about recursive stored procedures?

754

Explain about the implementation of business logic in stored procedures?

691

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

715

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

825

Explain about the return statement?

835

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

799

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

796

Where the procedures are stored in database?

805

Explain about the implementation of stored procedures?

835

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

1081

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

687

Post New DB Architecture Questions

Un-Answered Questions { DB Architecture }

What is durability in DBMS?

864

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

687

What is the meaning of 3 tier?

754

What is a view? How it is related to data independence?

847

When is a functional dependency F said to be minimal?

728

What is model database? : sql server architect

837

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

749

What is a query?

824

How one call ddl statement using stored procedures in oracle?

758

Which is super key?

773

What are page splits? : sql server architect

844

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

840

Illustrate physical database architecture in brief? : sql server architect

728

What is 2 tier 3 tier architecture?

820

Name the buffer in which all the commands that are typed in are stored

769

For More Un-Answered { DB Architecture } Questions Click Here