Database [3i Infotech Placement]: Sample Questions 181 - 182 of 294

Glide to success with Doorsteptutor material for competitive exams : get questions, notes, tests, video lectures and more- for all subjects of your exam.

Question 181

Database

Question

MCQ▾

What file is read by ODBC to load drivers?

Choices

Choice (4)

a.

ODBC. DLL

b.

ODBC. INI

c.

ODBCDRV. INI

d.

All of the above

Answer

b.

Explanation

  • ODBC. INI is used to load drivers.
  • Data source names for data sources in a database is in the odbc. ini file.
  • Open database provides a standard interface that allows one application to access many different data sources.
  • The application՚s source code does not have to be recompiled for each data source.
  • A database driver links the application to a specific data source.

Loading drivers:

  • Accessing device that is associated with a device driver- load drivers.
  • We can use modload command to load the driver into memory.
  • Modload does not call any routines.
  • This method opens the device.

The ODBC interface defines the following:

  • A library of ODBC function calls that allows an application to connect to a data source, execute structured query language statements, and retrieve results.
  • A standard set of error codes.
  • A standard way to connect to and log in to a data source.
  • A standard representation for data types.

Question 182

Database
Edit

Write in Short

Short Answer▾

What is Relationship?

Explanation

  • A relationship is an association between several entities.
  • A relationship, in the context of databases, is a situation that exists between two relational database tables when one table has a foreign key that references the primary key of the other table.
  • Relationships allow relational databases to split and store data in different tables, while linking disparate data items.

Developed by: