Custom Search

 

 

 

 
 

 

Database Interview Questions - Part 2


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?
When is the incremental integration approach appropriate?
When is the parallel integration approach appropriate?
What is an integration strategy?
When does a form depend on another form?
What criteria can you use to decide how to group views in an integration strategy?
What is a synonym in view integration?
What is a homonym in view integration?
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 do synonyms and homonyms occur when designing a database?
How can using forms in database design help you to detect synomyms and homonyms?
Why is the student application process not considered in the conceptual design phase?
Why is the incremental integration approach used to analyze the requirements?
What is the difference between batch and on-line processing of loan origination forms? Why is batch processing feasible for loan origination forms?
How can batch processing reduce the impact of maintaining indexes?
Why is it difficult to use operational databases for management decision making?
How must operational databases be transformed for management decision making?
What are the phases of the information life cycle?
What does it mean to integrate information life cycles?
What data quality dimension is important for management decision making but not for operational decision making?
How does knowledge management differ from information resource management?
What are the three pillars of knowledge management?
What kind of position is the data administrator?
What kind of position is the database administrator?
Which position (data administrator versus database administrator) takes a broader view of information resources?
What is an enterprise data model?
For what reasons is an enterprise data model developed?
What kinds of specialization are possible in large organizations for data administrators and database administrators?
What is discretionary access control?
What is mandatory access control?
What kind of database requires mandatory access control?
What are the purposes of the GRANT and REVOKE statements in SQL?
Why should authorization rules reference roles instead of individual users?
Why do authorization rules typically use views rather than tables or columns?
What are the uses of the GRANT statement in SQL?
What are the responsibilities of database administrators for transaction processing?
What are the responsibilities of database administrators for managing data warehouses?
What are the responsibilities of database administrators for managing databases in distributed environments?
What are the responsibilities of database administrators for managing object databases?
What are the responsibilities of data administrators for transaction processing?
What are the responsibilities of data administrators for managing data warehouses?
What are the responsibilities of data administrators for managing databases in distributed environments?
What are the responsibilities of data administrators for managing object databases?
What are the characteristics of a good benchmark?
What does it mean to say that a transaction is a user-defined concept? Why is it important that transactions are user defined?
What is the purpose of the SQL statements START TRANSACTION, COMMIT, and ROLLBACK? How do these statements vary across DBMSs?

 

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