Category Archives: DBMS Interview Questions

In OLE DB, what is the difference between an interface and an implementation? | DBMS Questions

An OLE DB interface is specified by a set of objects, and the properties and methods that they expose, and OLE DB defines standardized interfaces. An object need not expose all of its properties and methods in a given interface. … Continue reading

Posted in DBMS Interview Questions | Leave a comment

What are to goals of OLE DB? | DBMS Questions

The major goals of OLE DB are to: (1) Create object interfaces for DBMS functionality pieces; (2) Increase flexibility for developers and users; (3) provide an object interface over any type of data; and (4) do not force data to … Continue reading

Posted in DBMS Interview Questions | Leave a comment

What disadvantage of ODBC does OLE DB overcome? | DBMS Questions

By breaking the features and the functions of a DBMS into COM objects, OLE DB characteristic overcomes a major disadvantage of ODBC. With ODBC, a vendor must create an ODBC driver for almost all DBMS features and functions in order … Continue reading

Posted in DBMS Interview Questions | Leave a comment

What are the three types of data sources used with ODBC? | DBMS Questions

An ODBC file data source is a file that can be shared among database users. A ODBC system data source is one that is local to a single computer. A ODBC user data source is only available to the user … Continue reading

Posted in DBMS Interview Questions | Leave a comment

What is the relationship of ODBC, OLE DB, and ADO? | DBMS Questions

Developed first, the ODBC standard is for relational databases; while the OLE DB standard provides functionality for both relational and other databases. Finally, ADO was developed to provide easier access to OLE DB data for the non-object-oriented programmer.

Posted in DBMS Interview Questions | Leave a comment

What are the advantages of using stored procedures? | DBMS Questions

The advantages of stored procedures are (1) greater security, (2) decreased network traffic, (3) the fact that SQL can be optimized and (4) code sharing which leads to less work, standardized processing, and specialization among developers.

Posted in DBMS Interview Questions | Leave a comment

What are stored procedures, and how do they differ from triggers? | DBMS Questions

A stored procedure is a program that is stored within the database and is compiled when used. They can receive input parameters and they can return results. Unlike triggers, their scope is database-wide; they can be used by any process … Continue reading

Posted in DBMS Interview Questions | Leave a comment

Name four applications for triggers. | DBMS Questions

(1) providing default values, (2) enforcing data constraints, (3) updating views and (4) enforcing referential integrity

Posted in DBMS Interview Questions | Leave a comment

Explain the “paradigm mismatch” between SQL and application programming languages. | DBMS Questions

SQL statements return a set of rows, while an application program works on one row at a time. To resolve this mismatch the results of SQL statements are processed as pseudofiles, using a cursor or pointer to specify which row … Continue reading

Posted in DBMS Interview Questions | Leave a comment

What is a SQL view? Briefly explain the use of views. | DBMS Questions

A SQL view is a virtual table built from other tables or views. Views are used to (1) hide columns or rows, (2) show the results of computed columns, (3) hide complicated SQL syntax, (4) layer built-in functions, (5) provide … Continue reading

Posted in DBMS Interview Questions | Leave a comment