Database Interview Questions - Part 7
What is the
difference in notation between combining tables that are linked by a foreign
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
What is the importance of object features in Oracle 9i that are not part of
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
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
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
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
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
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
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
What is the purpose of assertions in SQL?
How can using forms in database design help you to detect synomyms and
Why is the student application process not considered in the conceptual design
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
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
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
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
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
What are the responsibilities of data administrators for managing data
What are the responsibilities of data administrators for managing databases in
What are the responsibilities of data administrators for managing object
What are the characteristics of a good benchmark?
What does it mean to say that a transaction is a user-defined concept? Why is
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
management support the ACID properties?
What is the meaning of transparency as it relates to computer processing? Why
transparency important for concurrency control and recovery management?
What costs are associated with concurrency control and recovery management? In
database administrator or database programmer, would you assess these costs?
What is the objective of concurrency control? How is the measure used in the
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
versus a coarser level of granularity?
What is an intent lock? Why are intent locks used on items of coarse
Why is the third condition of 2PL typically simplified so that locks are
released at the end
of a transaction?
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
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
Interview Questions, DBMS, Computer Science, Job, Database Administrator,
Database Development, SQL, Triggers, Data Warehouse, Business Databases