Custom Search

 

 

 

 
 

 

Database Interview Questions - Part 3

What is the objective of concurrency control? How is the measure used in the objective related to waiting time?
What is a hot spot? How are hot spots related to interference problems?
What are the consequences of each kind of interference problem? Which problem seems to be the most serious?
What is a lock? Briefly explain the differences between shared (S) and exclusive (X) locks?
What operations are performed by the lock manager?
What is a deadlock and how do most DBMSs handle deadlocks?
What is locking granularity? What are the trade-offs of holding locks at a finer level versus a coarser level of granularity?
What is an intent lock? Why are intent locks used on items of coarse granularity?
Why is the third condition of 2PL typically simplified so that locks are released at the end of a transaction?
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 the components of an enterprise data model?
What are some causes for failures in data warehouse projects?
Does a bottom-up data warehouse architecture use an enterprise data model?
What is an oper mart?
What are the advantages of multidimensional representation over relational representation for data used for decision support?
Why a dimension may have multiple hierarchies?
What are the advantages of using time-series data in a cell instead of time as a dimension?
How is slicing a data cube different from dicing?
What are the differences between drilling down a data cube and slicing or dicing it?
How is a pivot operation useful for multidimensional databases?
What is the significance of sparsity in a data cube?
What is a star schema?
What are the differences between fact tables and dimension tables?
How does a snowflake schema differ from a star schema?
What is a constellation schema?
What is the purpose of the Oracle CREATE DIMENSION statement?
What is the purpose of the SQL CUBE operator?
What is the purpose of the SQL ROLLUP operator?
What is the purpose of the SQL GROUPING SETS operator?
What are some of the variations of the CUBE, ROLLUP, and GROUPING SETS operators?
Why are materialized views important for data warehouses but not important for operational databases?
What materialization properties does Oracle 9i provide for materialized views?
What is the significance of indexing fact and dimension tables in a data warehouse?
What are the pros and cons of a MOLAP storage engine?
What are the pros and cons of a ROLAP storage engine?
What are the pros and cons of a HOLAP storage engine?
What are some storage and optimization techniques used in ROLAP engines?
What is cooperative change data?
What is logged change data?
What is queryable change data?
How three-tier architectures address division of processing and process management?
How multiple-tier architectures address division of processing and process management?
What is a thin client? How does a thin client relate to division of processing in client–server architectures?
What are some reasons for choosing a two-tier architecture?
What are some reasons for choosing a three-tier architecture?
What are some reasons for choosing a multiple-tier architecture?
What is a software bus? How does a software bus differ from other kinds of middleware such as a transaction-processing monitor and message-oriented middleware?
Is a Web server middleware?
Why was XML developed?
What is the relationship of XML to the XML Schema Language and the eXtensible Style Language (XSL)?
Why is customization an important motivation for database programming languages?
How do database programming languages support customization?
Why is batch processing an important motivation for database programming languages?
Why is support for complex operations an important motivation for database programming languages?
Why is efficiency a secondary motivation for database programming languages, not a primary motivation?
Why is portability a secondary motivation for database programming languages, not a primary motivation?
What is a statement level interface?
What is a call level interface?
What is binding for a database programming language?
What is the difference between static and dynamic binding?
What is the relationship between language style and binding?
What SQL:1999 statements and procedures support explicit database connections?
What differences must be resolved to process the results of an SQL statement in a computer program?
What is a cursor?
What statements and procedures does SQL:1999 provide for cursor processing?
Why study PL/SQL?
What is case sensitivity in PL/SQL? Why are most parts of PL/SQL case insensitive?
What is an anchored variable declaration?
What is a logical expression?
What conditional statements are provided by PL/SQL?
What iteration statements are provided by PL/SQL?
Why use an anonymous block?
Why should a DBMS manage procedures rather than a programming language environment?
What are the three usages of a parameter?
What is the restriction on the data type in a parameter specification?
Why use predefined exceptions and user-defined exceptions?
Why use the OTHERS exception?

 

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