Custom Search

 

 

 

 
 

 

Database Interview Questions - Part 5

What is the purpose of an information resource dictionary?
What functions does an information resource dictionary system perform?
What are the purposes of information systems planning?
Why is the enterprise data model developed before the process model?
Why is the selection and evaluation process important for DBMS?
What are some complexities in the selection and evaluation process for a complex product like a DBMS?
What are the steps in the selection and evaluation process?
How is the Analytic Hierarchy Process used in the selection and evaluation process?
What responsibilities does the database administrator have in the selection and evaluation process?
What responsibilities does the data administrator have in the selection and evaluation process?
What is the meaning of the ACID properties? How do concurrency control and recovery management support the ACID properties?
What is the meaning of transparency as it relates to computer processing? Why is transparency important for concurrency control and recovery management?
What costs are associated with concurrency control and recovery management? In what role, database administrator or database programmer, would you assess these costs?
What is a transaction boundary? Why can an inappropriate choice for transaction boundary lead to poor performance?
What criteria should be used in selecting a transaction boundary?
Why must constraints such as the debit–credit constraint be enforced as part of a transaction rather than between transactions?
What is the difference between system-independent and system-dependent hot spots? Why is it useful to identify hot spots?
What are the three choices for transaction boundary of a hierarchical form?
How can deadlock possibility be influenced by the choice of a transaction boundary?
What is the purpose of the SQL isolation levels?
How do the isolation levels achieve more concurrent access?
What isolation level can be dangerous and why?
What SQL statements and clauses involve constraint timing specification?
What is the role of the DBA in specifying of constraint timing?
What is the role of the transaction designer in specifying of constraint timing?
What is the purpose of a save point?
What is a workflow and how is it related to database transactions?
What are the differences between human-oriented and computer-oriented workflows?
What role does transaction management play in workflow management?
What are limitations of transaction management to support workflows?
Why are operational databases not particularly suited for decision support applications?
How is a data warehouse different from a data mart?
When is the three-tier data warehouse architecture more appropriate than the two-tier data warehouse architecture?
What are three alternatives for preserving historical integrity in a data warehouse?
What is the role of clients and servers in distributed processing?
What are the terms flexibility, interoperability, and scalability? How does distributed processing support interoperability, flexibility, and scalability?
What are some of the pitfalls of developing client–server systems?
How can a distributed database improve data control?
How can a distributed database reduce communication costs and improve performance?
What are some of the pitfalls when developing distributed databases?
Why distributed processing is more mature and more widely implemented than distributed databases?
Why are division of processing and process management important in client–server architectures?
Why are there two standard languages for object DBMS?
What are the components of a user-defined type in SQL:1999?
What are the differences between SQL:1999 methods, functions, and procedures?
How are SQL:1999 user-defined types used in table definitions and expressions?
What is a row type? How are row types used in SQL:1999 table definitions?
What are the encapsulation differences for user-defined types versus tables in SQL:1999?
What is a typed table?
How do you define a subtable?
What is the relationship of subtable families and set inclusion?
What side effects occur when a row is inserted in a subtable?
What side effects occur when a subtable row is updated?
What side effects occur when a subtable row is deleted?
What is the difference between a foreign key and a reference?
Is it preferable to write many smaller triggers or fewer larger triggers?
What is a trigger execution procedure?
What is the order of execution for various kinds of triggers?
What is an overlapping trigger? What is the execution order of overlapping triggers?
What situations lead to recursive execution of the trigger execution procedure?
What are two ways to reduce the complexity of a collection of triggers?
What situations lead to recursive execution of the trigger execution procedure?
How are mutating table errors avoided?
What are typical uses of BEFORE ROW triggers?
What are typical uses of AFTER ROW triggers?What factors influence the size of a conceptual schema?
How does the view design and integration process help to manage the complexity of large database design efforts?
What is the goal of form analysis?
What are node keys in a form structure?
How do nodes in a form structure correspond to main forms and subforms?
What is the form entity type?
Why does the ERD for a form often have a different structure than the form?
Why is it recommended to place the form entity type in the center of the ERD?
How many integration steps are necessary to perform incremental integration with 10 views?
How many view design steps are necessary to perform parallel integration with 10 views?
In the incremental integration approach, why are view design and integration performed together?

 

Related

Database Interview Questions - Part 1

Database Interview Questions - Part 2

Database Interview Questions - Part 3

Database Interview Questions - Part 4

Database Interview Questions - Part 5

Database Interview Questions - Part 6

Database Interview Questions - Part 7

Database Interview Questions - Part 8

 

Disclaimer: Pak/ed and the contributors are not responsible for any errors contained and are not liable for any damages resulting from the use of this material.  Disclaimer


Tags: Database, Interview Questions, DBMS, Computer Science, Job, Database Administrator, Database Development, SQL, Triggers, Data Warehouse, Business Databases

                        

 

 

 

Custom Search
 

Home      Disclaimer      Advertise      Contact      Privacy Policy     

Copyright © 2004-15 Paked.com. All rights reserved.

Note: Site best viewed at 1024 x 768 or higher screen resolution