3i Infotech Papers: Sample Questions 539 - 540 of 1245

Examrace Placement Series prepares you for the toughest placement exams to top companies.

Question number: 539

» Database » MySQL

Essay Question▾

Describe in Detail

What is Authorization and Integrity manager?

Explanation

Define Authorization and Integrity manager

Define Authorization and Integrity Manager

Define Authorization and Integrity manager

Authorization Manager:

  • Provides flexible framework for integrating role-based access control into applications.

  • Enables administrators who use those applications to provide access through assigned user roles that relate to job functions.

Integrity Manager:

  • Ensure accuracy and consistency of data in a relational database.

  • Data integrity is handled in a relational database through the concept of referential integrity.

  • Many types of integrity constraints play a role in referential integrity

Question number: 540

» Database » Oracle

MCQ▾

Question

What file is read by ODBC to load drivers?

Choices

Choice (4) Response

a.

ODBC. DLL

b.

ODBCDRV. INI

c.

ODBC. INI

d.

All of the above

Answer

c.

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.