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

DB Architecture Interview Questions

Questions Answers Views Company eMail

How can we call stored procedures inside store procedures?

768

State about the security aspects of stored procedures?

926

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

882

How one call ddl statement using stored procedures in oracle?

747

State the different extensions for stored procedures?

740

How many types of stored procedure?

789

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

743

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

818

Illustrate physical database architecture in brief? : sql server architect

718

Explain what are the database objects? : sql server architect

843

Explain the truncate command? : sql server architect

774

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

742

What is model database? : sql server architect

826

What are page splits? : sql server architect

837

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

832

Post New DB Architecture Questions

Un-Answered Questions { DB Architecture }

What is an Entity type?

808

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

704

What is DDL (Data Definition Language)?

826

what is the difference between LENGTH AND SIZE?

2426

What is meant by query optimization?

809

What is n tier architecture with example?

699

What is Query evaluation engine?

866

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

961

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

721

How can we call stored procedures inside store procedures?

768

Not only RDBMS takes care of locating data it also

730

What is BCNF (Boyce-Codd Normal Form)?

812

What are the three tiers in a 3 tier architecture?

716

Explain about the return statement?

822

What is Data Model?

906

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