Custom Search

 

 

 

 
 

 

Database Interview Questions - Part 7

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?
How do views provide data independence?
How can views simplify queries written by users?
How is a view like a macro in a spreadsheet?
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?
Why do synonyms and homonyms occur when designing a database?
What is logged change data?
What is queryable change data?
What is snapshot change data?
What are the phases of data warehouse maintenance?
What are common data quality problems that should be resolved by the preparation and
integration phases?
What is the benefit of using ETL tools in data warehouse maintenance?
What is valid time lag?
What is load time lag?
What is the primary objective in managing the refresh process for a data warehouse?
When should you use a SELECT statement as part of an INSERT statement when adding objects to
a typed table?
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?
Why should a DBA cautiously use the WITH ADMIN clause in the CREATE ROLE statement and the
WITH GRANT OPTION clause in the GRANT statement?
What is the difference between system privileges and object privileges in Oracle?
What other disciplines does computer security involve?
What is the purpose of the CREATE DOMAIN statement?
What additional capabilities does SQL:1999 add for user-defined types as compared to
domains?
What is the purpose of assertions in SQL?
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?
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 does it mean to say that an assertion is deferrable?
What are alternatives to SQL assertions? Why would you use an alternative to an assertion?
What are the coding issues about which a DBA should be concerned?
How does a stored procedure or trigger depend on other database objects?
What are the responsibilities for a DBA for managing dependencies?
What is the difference between timestamp and signature dependency maintenance?
What are three ways that a DBA can control trigger interactions?
What kind of metadata does a data dictionary contain?
What are catalog tables? What kind of catalog tables are managed by DBMS?
What is the difference between the Information_Schema and the Definition_Schema in SQL:1999?
What is necessary to learn the catalog tables of a specific DBMS?
How does a DBA access catalog tables?
What is the purpose of an information resource dictionary?
What functions does an information resource dictionary system perform?
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?
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 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?

 

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