Custom Search

 

 

 

 
 

 

Database Interview Questions - Part 4

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?
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 appeal of optimistic concurrency control approaches? Why might optimistic concurrency control approaches not be used even if they provide better expected performance?
What is the difference between volatile and nonvolatile storage?
What are the effects of local, system, and device failures on active and past transactions?
Why is force writing the most fundamental tool of recovery management?
What kind of redundant data is stored in a log? Why is management of the log critical to recovery?
What is the checkpoint interval? What is the trade-off in determining the checkpoint interval?
What processing occurs at checkpoint time?
What restart work is necessary for a media failure?
What restart work is necessary for local and system failures under the immediate update approach?
What restart work is necessary for local and system failures under the deferred update approach?
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 some reasons to use a middleware server for Web database connectivity instead of an extended Web server?
How does client-side connectivity enhance server-side processing for database connectivity?
What is a global request?
How does the integration level of the distributed DBMS affect the component architecture?
When is a tightly integrated distributed DBMS appropriate? When is a loosely integrated distributed DBMS appropriate?
What are the differences in the schema architecture for tightly and loosely integrated distributed DBMS?
How is distributed database transparency related to data independence?
Is a higher level of distribution transparency always preferred?
What is a derived horizontal fragment and why is it useful? What is the relationship of the semi-join operator and derived horizontal fragmentation?
What is the larger difference in query formulation: (1) fragmentation transparency to location transparency or (2) location transparency to local mapping transparency?
Why is fragment design and allocation a complex task?
Why is global query optimization important?
What are differences between global and local optimization in distributed query processing?
Why are there multiple objectives in distributed query processing? Which objective seems to be more important?
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 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?
How does a function differ from a procedure?
What are the two kinds of cursor declaration in PL/SQL?
What is the difference between a static and a dynamic cursor in PL/SQL?
What is a cursor attribute?
How are cursor attributes referenced?
What is the purpose of a PL/SQL package?
Why separate the interface from the implementation in a PL/SQL package?
What does a package interface contain?
What does a package implementation contain?
What is an alternative name for a trigger?
What are typical uses for triggers?
How does SQL:1999 classify triggers?
Why do most trigger implementations differ from the SQL:1999 specification?
How are compound events specified in a trigger?
How are triggers tested?

 

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