Custom Search

 

 

 

 
 

 

Database Interview Questions - Part 6

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 is view materialization?
What is view modification?
Why do most DBMS use modification rather than materialization to process view queries?
What is an updatable view?
Why are some views read-only?
What are the rules for single-table updatable views?
What are the rules for multiple-table updatable views?
What is the purpose of the WITH CHECK clause?
What is a hierarchical form?
What is the difference between a main form and a subform?
What is the purpose of linking columns in hierarchical forms?
Why should you write updatable queries for a main form and a subform?
Why are tables used in a hierarchical form even when the tables cannot be changed as a result of using the form?
What is the first step of the query formulation process for hierarchical forms?
What is the second step of the query formulation process for hierarchical forms?
What is the third step of the query formulation process for hierarchical forms?
What is the fourth step of the query formulation process for hierarchical forms?
What is the fifth step of the query formulation process for hierarchical forms?
What is the business reason that determines the read-only status of the hierarchical form?
What is a hierarchical report?
What is a grouping column in a hierarchical report?
How do you identify grouping columns in a report?
What is a detail line in a hierarchical report?
What is the relationship of grouping columns in a report to sorting columns?
Why is it often easier to write a query for a hierarchical report than for a hierarchical form?
What does it mean that a query should produce data for the detail line of a hierarchical report?
What is the relationship of XML to the XML Schema Language and the eXtensible Style Language
(XSL)?
Why do most major DBMSs support XML?
Why is there widespread interest in database connectivity over the Internet and intranets?
What is the Common Gateway Interface (CGI) and how is it used for Web database connectivity?
What are some reasons to use an extended Web server for Web database
connectivity?
What are the components of performance measures for distributed query processing? What
factors influence how these components can be combined into a performance measure?
How does two phase locking for distributed databases differ from two phase locking for
centralized databases?
Why is the primary copy protocol widely used?
What kinds of additional failures occur in a distributed database environment? How can these
failures be detected?
What is the difference between the voting and the decision phases of the two phase commit
protocol?
What is the trade-offs between centralized and distributed coordination in distributed
concurrency control and recovery?
How does the use of complex data drive the need for object database technology?
What problems are caused by mismatches between the types provided by a DBMS and a
programming language?
What is encapsulation? How does encapsulation support the goal of data independence?
How do object DBMS relax encapsulation? Why is encapsulation relaxed?
What is inheritance? What are the benefits of inheritance?
What is polymorphism? What are the benefits of polymorphism?
What is strong type checking? Why is strong type checking important?
What is the difference between static and dynamic binding?
Which implementation of object-oriented principles occurred first: object-oriented
programming languages or object DBMS?
What are the reasons that multiple object DBMS architectures have been developed?
What are the benefits and limitations of storing large objects in the database? Why is
external software needed when large objects are stored in a database?
What are the benefits and the limitations of using specialized media servers?
What are the benefits and the limitations of using object database middleware? Why does
object database middleware support the broadest range of complex data?
What are the benefits and the limitations of using an object relational DBMS? What changes
are made to the query processor of a relational DBMS to convert it into an object relational
DBMS?
What is the difference in notation between combining tables that are linked by a foreign key
versus a column with a reference type?
What is a path expression? When do you use a path expression?
When do you need to use the dereference operator (?) in an expression?
What is the purpose of the ONLY keyword in a SQL:1999 SELECT statement?
What are criteria for overriding a method in Oracle 9i?
What is the most significant limitation for object databases in Oracle 9i as compared to
SQL:1999?
What is the importance of object features in Oracle 9i that are not part of SQL:1999?
What is minimal conformance for SQL:1999?
What is enhanced conformance for SQL:1999?
What is the state of conformance testing for SQL:1999?
What are the benefits and the limitations of using an object-oriented DBMS? How does an
object-oriented DBMS differ from an object-relational DBMS?
Why have object-oriented DBMS occupied a market niche compared to relational DBMS?
Which object DBMS architecture do you think will dominate in five years?
What is a persistent object? What is the difference between a persistent object and a
temporary object?
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?
When should you use a SELECT statement as part of an INSERT statement when adding objects to
a typed table?

 

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