Start Discovering Solved Questions and Course Assignments
TextBooks Included
Active Tutors
Asked Questions
Answered Questions
What are to objectives of OLE DB?
What demerits of ODBC does OLE DB overcome?
Describe the three types of data sources which are used with ODBC?
Describe the relationship of OLE DB, ADO, and ODBC?
Name the triggers which support SQL Server 2000?
Describe the difference between SQL Server 2000 clustered indexes and non clustered indexes?
Describe the difference between the bulk-logged recovery models, full, and SQL Server 2000 simple?
Describe the meaning of each of the transaction stages supported by SQL Server?
Describe the difference between differential backups and SQL Server 2000 complete?
What are the kinds of files employed in Oracle recovery?
Describe the main three stages of transaction isolation supported by Oracle?
Under what conditions should indexes are employed?
What are sequences, and what are the possible problems when employing them to make surrogate keys?
What are the techniques in which an Oracle database can be created?
What do you understand by the term ACID transaction in DBMS? Describe briefly?
Describe the main characteristic of the database administrator?
What do you understand by the term deadlock in DBMS? How can it be avoided? How can it be solved once it happens?
Describe briefly the difference between pessimistic locking and optimistic locking?
Describe briefly the difference between a shared lock and an exclusive lock?
You have two tables, STUDENT and COMPUTER which are in a one-to-one relationship. The foreign key is StudNumber in COMPUTER that references StudNumber as the primary key of STUDENT. Describe what must
Describe how we can add a NOT NULL column to a table?
What do you understand by the termed dependency graph in DBMS?
Describe the difference between a regular sub query and a correlated sub query?
Describe any two reasons which show the necessity of database redesign?
Illustrate the main merits of employing stored procedures?