Custom Search

 

 

 

 
 

 

Database Interview Questions - Part 1

  • 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?

  • How do views provide data independence?

  • How can views simplify queries written by users?

  • How is a view like a macro in a spreadsheet?

  • What is view materialization?

  • What is view modification?

  • 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 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 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 a database programming language?

  • 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 is a database programming language?

  • 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 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?

  • 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 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?

  • 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?

  • What situations lead to recursive execution of the trigger execution procedure?

  • What are two ways to reduce the complexity of a collection of triggers?

  • What situations lead to recursive execution of the trigger execution procedure?

  • How are mutating table errors avoided?

  • What are typical uses of BEFORE ROW triggers?

  • What are typical uses of AFTER ROW triggers?What factors influence the size of a conceptual schema?

  • How are triggers tested?

  • Is it preferable to write many smaller triggers or fewer larger triggers?

  • What is a trigger execution procedure?

  • What is the order of execution for various kinds of triggers?

  • What is an overlapping trigger? What is the execution order of overlapping triggers?
     

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