SQL Indexes and Sequences

What are sequences and indexes in database tables? When to use sequence and when to use index?

Database Design

1. How are recursive relationships handled? 2. Discuss surrogate keys. 3. Describe the six default referential integrity actions. 4. How are N:M relationships implemented? 5. Why are null values ambiguous?

Structured Query Language (SQL) Preliminaries

1. Discuss what SQL is and its importance. 2. Name and describe the SQL statements used for data modification. 3. Compare the join and the SQL subquery. 4. Name and briefly describe the five SQL built-in functions. 5. Write the SELECT statement to display all the columns of the STUDENT table but only t ...continues

Structured Query Language (SQL) in Practice

1. Briefly explain the use of views. 2. Explain the paradigm mismatch between SQL and programs. 3. Name four applications for triggers. 4. Discuss stored procedures. 5. What are the advantages of using stored procedures?

Database Re-Engineering and Redesign

1. Explain why database re-engineering and redesign is necessary. 2. What is the difference between a correlated subquery and a regular subquery? 3. Explain what is done when a NOT NULL column is added to a table. 4. What is a dependency graph? 5. Explain what should be done when addi ...continues

Multi-User Databases Management

1. Explain the difference between an exclusive lock and a shared lock. 2. Explain the difference between optimistic locking and pessimistic locking. 3. What is deadlock? How can it be avoided? How can it be resolved once it occurs? 4. What are the major functions of the database administrator? 5. E ...continues

Oracle 9i Database Management

1. What are the ways in which an Oracle database can be created? 2. Discuss sequences. 3. Under what conditions should indexes be used? 4. Explain the three levels of transaction isolation supported by Oracle. 5. What are the types of files used in Oracle recovery?

SQL Server 2000 Databases Management

1. What is the difference between complete and differential backups? 2. Explain the meaning of each of the transaction levels supported by SQL Server. 3. Explain the difference among the simple, full, and bulk-logged recovery models. 4. What is the difference between clustered and nonclustered indexes? ...continues

SQL- Row Function

Some data are calculated as functions. When would you store data in database and when would you use functions? What is the advantage of storing data in database?

Database Programming

How large programming teams make sure that they use the same naming conventions and that their programs work together even though they are created independently?